Microsoft Office Excel 2010: Intermediate

  • Course provided by Udemy
  • Study type: Online
  • Starts: Anytime
  • Price: See latest price on Udemy
Udemy

Course Description

The Microsoft Excel 2010 L2 course is the second course in a three course series on Microsoft Office Excel 2010 that covers the intermediate-level topics regarding Microsoft Excel 2010. The course builds on the concepts learnt in the L1 course and covers the more advanced concepts like 3D formulas, advanced formatting, using trend lines, worksheet auditing and protection. The course also provides a smooth transition opportunity to students to upgrade to Microsoft Office Excel 2010.

Microsoft Office Excel 2010 is an essential application for students, office workers, executives, accountants and financial analysts. This course helps the candidates to get started with the latest version of Microsoft Office Excel. The course enables the candidates to acquire the necessary knowledge to efficiently use the features of Microsoft Office Excel 2010 to achieve excellence in the daily routine tasks.

Expected Outcomes

  1. Use multiple worksheets and workbooks
  2. Use special number formats
  3. Outline and consolidate data
  4. Define cell and range names
  5. Sort and filter data in tables
  6. Save workbooks as webpages
  7. Learn advanced chart formatting
  8. Perform worksheet audit
  9. Insert comments in cells and workbooks
  10. Use built-in templates
  11. Learn about PivotTables and PivotCharts