Discover what you can learn.

With video courses for work, study and leisure.

Microsoft Excel 2010 - Advanced

By eduCBA Global Online Training Experts

(2)

Learn Pivot Tables, Dynamic Graphs and Advanced Excel Formulas
This advanced online course on Microsoft Excel 2010 is ideal for those already having a good knowledge of Microsoft Excel 2010 basics and seeking to enhance their Excel 2010 knowledge. It goes deeper into the features and functions of the powerful excel spreadsheet. By the conclusion of this software tutorial, you will have mastered the advanced features and functions of Microsoft Excel 2010. Working files are included to allow you to follow along with the author.

The course starts with an explanation to show the differences between excel 2007 and excel 2010.
It continues explaining the following useful functions and advanced features:
  • Paste Special, IF and OR, countif etc.
  • Data functions: CHOOSE Function, VLOOKUP, HLOOKUP, OFFSET, FORECAST etc.
  • WHATIF ANALYSIS: One- & Two dimensional Data Tables, Solver, Goals Seek
  • Arrays, functions for working with text
  • Pivot tables
  • Auditing and trouble shooting formulas
  • Form controls
  • Important excel tools
  • Advanced charts
All functions are explained using detailed examples. The objective of this online course is to make you awesome in Advanced Excel 2010.

Details

  • Included lectures: 10
  • Duration: 6:07 h
  • Available documents: 4

These courses may be of interest to you


Authors of course Microsoft Excel 2010 - Advanced

 eduCBA Global Online Training Experts

eduCBA Global Online Training Experts

EduCorporateBridge is a globally recognized training firm, providing blend of instructor-led and online financial training programs in Excel, Advanced Excel, VBAs, Macros, Equity Research, Wealth Management, Technical Analysis Investment banking, Private Equity, Fundamental Analysis, Investment Research and Credit Research as well as preparatory courses like CFA Level I & II and FRM Level I & II, Campus Placement Trainings etc.

The Corporate Bridge Online training Learning Management System provides access to high end excel videos, valuation tutorials, online tests, downloadable templates and models that are prepared by Research Analysts & Investment Bankers.
www.educorporatebridge.com

Customer reviews

(2)

4,5 of 5 stars
5 Stars
1
4 Stars
1
3 Stars
0
2 Stars
0
1  Star
0