• Introduction to MS Excel, Quick review on MS Excel Options, Ribbon, Sheets
• Saving Excel File as PDF, CSV and Older versions
• Using Excel Shortcuts with Full List of Shortcuts
• Copy, Cut, Paste, Hide, Unhide, and Link the Data in Rows, Columns and Sheet
• Using Paste Special Options
• Formatting Cells, Rows, Columns and Sheets
• Protecting Sheets with or without Password
• Lookup and Reference Functions: VLOOKUP, HLOOKUP, INDEX, MATCH, TRANSPOSE etc
• Logical Function: IF / ELSE, AND, OR, NOT, TRUE, NESTED IF/ELSE etc
• Math and Trigonometry Functions: ROUND, CEILING, FLOOR, INT, SUMIF, SUMIFS etc.
• Statistical Functions: AVERAGE, AVERAGEIF, COUNT, COUNTBLANK, COUNTIF, MAX, MIN, STDEVA etc.
• Text Functions: LEFT, RIGHT, TRIM, MID, REPLACE, TRIM, CONCATENATE, etc.
• Using Conditional Formatting
• Using Conditional Formatting with Multiple Cell Rules
• Creating New Rules and Managing Existing Rules
• Sorting Data A-Z and Z-A
• Using Filters to Sort Data
• Advance Filtering Options
• Creating Pivot Tables
• Using Pivot Table Options
• Changing and Updating Data Range
• Formatting Pivot Table and Making Dynamic Pivot Tables
• Introduction to VBA Macro
• Recording Macro & Understanding Code Behind
• Editing, Writing VBA Code and Saving as Macro or Add-In
• VBA Programming Concept
• Decisions Making with Operators
• Repeating Actions with a Loops
• Functions