In Excel 2010 Essential Training, Bob Flisser demonstrates the core features and tools in Excel 2010. The course introduces key Excel skills, shows how to utilize these skills with in-depth tutorials on Excel functions and spreadsheet formatting. It also covers prepping documents for printing, working with large worksheets and workbooks, collaborating with others, using Excel as a database, analyzing data, charting, and automating and customizing Excel. Exercise files are included with the course.
* Copying and pasting techniques * Working with formulas and functions * Dealing with formula errors * Creating lookup tables * Naming cell ranges * Formatting data and worksheets * Finding and replacing data * Creating SmartArt diagrams * Creating charts and PivotTables * Recording macros * Sharing workbooks