Learn basics of Excel

There are numbers of spreadsheet programs but from all of them, Microsoft Excel is the most widely used application. The best part about Excel is, it can apply to many tasks, including statistics, finance, data management, forecasting, analysis, inventory, billing, and business intelligence.

At the completion of this course, you will have mastered the most popular Excel tools and come out with confidence to complete any Excel tasks with efficiency and grace. Below are just a few of the topics that you will master:

• Creating effective spreadsheets
• Managing large sets of data
• Mastering the use of some of Excel’s most popular and highly sought after functions (SUM, VLOOKUP, IF, AVERAGE, INDEX/MATCH and many more…)
• Create a dynamic report with Excel Pivot Tables and graphs
• Unlock the power and versatility of Microsoft Excel’s AddIn, PowerPivot
• Audit Excel Worksheet formulas to ensure clean formulas
• Automate your day to day Excel tasks by mastering the power of Macros and VBA