Creating new files

If you like to create a brand-new workbook and you're simply thinking of a blank…slate, you can press Ctrl+N--that's the letter N--and suddenly, we see on the…screen a new workbook.…Now, that's going to be called Book2, Book3--depending upon what other workbooks…you might have open--…that's its temporary name, but you should not overlook the fact that Excel has a…number of built-in templates that might get you started much, much faster.…Suppose for example, you're interested in creating a Budget or a Personnel list…or a Phone list, you can go to the File Tab in the Ribbon and choose "New", now it…does give us the choice for a Blank workbook or possibly a Mortgage Refinance…Calculator; Financial Portfolio.…

Take a look at some of these that are built-in.…What you get here in all cases is an attractively designed worksheet with…built-in formulas that might just be enough of a kick-start to get you…going pretty fast here.…Maybe you're considering some Home Loan options.…Choose "Home Loan Comparison" here, "Create" and here we are started; and we're…

Resume Transcript Auto-Scroll

Author

Released

1/29/2013

Whether you're a novice or an expert wanting to refresh your skillset with Microsoft Excel, this course covers all the basics you need to start entering your data and building organized workbooks. Author Dennis Taylor teaches you how to enter and organize data, perform calculations with simple functions, work with multiple worksheets, format the appearance of your data, and build charts and PivotTables. Other lessons cover the powerful IF, VLOOKUP, and COUNTIF family of functions; the Goal Seek, Solver, and other data analysis tools; and how to automate many of these tasks with macros.