Search This Blog

Thursday, July 8, 2010

Lynda – Excel 2010 Essential Training




Lynda.com
AVC1 960×540
MP3 128 Kbps
413 MB

Product Description
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 Smart Art diagrams
  • Creating charts and Pivot Tables
  • Recording macros
  • Sharing workbooks

No comments: