MyExcelAcademy

FOLLOWING TOPICS WILL BE COVERED IN THE  EXCEL COURSE:

PLEASE GO THROUGH THE OUTLINE BELOW:

BASICS TO INTERMEDIATE MODULES WILL COVER THE FOLLOWING

1) Fundamentals of Excel,working with different Excel versions
2) Cut, Copy, Insert, Delete, Paste Special, using Auto Fill
3) Custom Formatting, Undo, Redo, Excel shortcuts to boost productivity
4) Excel Formulas - basic every day use formulas
5) Useful functions for summing totals
​6) Calculations,Comments,Drawing toolbar,Edit,Replace,Delete,Clear
7) Essential Printing
8) Data Sorting, Hiding rows & columns, AutoFormats
9) Sheet Protection, Basic Charts, Basic Formatting
10) IF Formulas ,using Auto Filter, and using Subtotals
11) Specific Worksheet Formulas
12) Working with Absolute and Relative references

ADVANCED MODULES WILL COVER ALL THE ABOVE AND BELOW:

 TO GO THROUGH THE ADVANCED MODULES, ONE MUST HAVE A THOROUGH UNDERSTANDING ON THE BASICS OF EXCEL

13) Formula building , and Advanced formulas , Nesting formulas
14) Debugging formulas using various techniques
15) Data Extracting Techniques and Data Mining techniques
16) Data Validation and linking with formulas
17) Advanced Filters, AutoFilters, Named Ranges
18) Using Tables , Using Subtotals, Vlookups & Hlookups
19) Pivot tables and Pivot charts ,using GETPIVOT
20) Advanced Charts and Dynamic Charts, Automatic updating Charts
21) Basic Macros & VBA understanding
22) Protection, Shared Workbooks, Track Changes, Merging Workbooks
23) Goal Seek and Data Tables
24) Custom Views, Freez panes, Watch Window, Using Save workspace
25) Using Hyperlinks, Comments, Using Pictures in Comments
26) Advanced VLOOKUP, Advanced use of Index & Match
27) Advanced use of INDEX, OFFSET, INDIRECT
28) Advanced use of IF STATEMENS
29) Using Dates and Time Functions, Using Find and Replace
30) Introduction to Excel Dashboards and reporting for Managers
31) Learning Keyboard Shortcuts to speed up.......
32) Conditional Formatting
33) Using the New sparklines features and Slicers in Excel 2013
34) Using Themes & cell styles
35) Data Consolidation and Merging workbooks

This course is a one of a kind and you will not find it in any Institutes.....you can see the course before joining....