Start learning with our library of video tutorials taught by experts. Get started
Viewers: in countries Watching now:
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.
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 going to have to explore this a little bit. Maybe for it to make sense to our situation--change the Bank name. A lot of formulas are built-in, we might be looking at different terms, different rates.
This is enough to get you started many, many times. Furthermore, it gives you some insight into how, perhaps, certain formulas work in Excel, how certain formatting capabilities exist. We also see some nice charts in this option, so don't overlook this possibility. Again, going to that File Tab, choose "New"; explore some of the many options that are here. Furthermore, at the bottom of this list, you will see reference here, to the fact that you can use the search box at the top to find more templates.
If the recipe template that you saw here wasn't quite what you wanted, you can, for example, go to "Lists" here, possibly find some other options here and here we see a huge category of possibilities. This is almost an endless list of, possible built-in, templates that you might want to use to get a workbook started very quickly in Excel.
There are currently no FAQs about Excel 2013 Essential Training.
Access exercise files from a button right under the course name.
Search within course videos and transcripts, and jump right to the results.
Remove icons showing you already watched videos if you want to start over.
Make the video wide, narrow, full-screen, or pop the player out of the page into its own window.
Click on text in the transcript to jump to that spot in the video. As the video plays, the relevant spot in the transcript will be highlighted.