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.

Topics include:

    * 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

More information
http://www.lynda.com/home/DisplayCourse.aspx?lpk2=61219