Advance Excel

Tags: MS-Office, Excel, popular

MS-Excel

Introduction to Excel, Basic Calculations, Basic Functions, Text Functions, Date and Time Functions, IF Condition, Lookup Functions, Mathematical Functions, PMT Functions, Conditional Formatting, Cell & Table Formats, Insertion and Deletion, Sorting and Filtering, Pivot Table and Pivot Chart, Slicer & Timeline, Cell Name Management, Formula Auditing, Calculations, Import & Export Data, Data Tools - Text To Column, Flash Fill, Remove Duplicates, Data Validation & Consolidate, What If Analysis - Scenario Manager, Goal Seek & Data Table, Group, Ungroup & Subtotal, Sheet & File Protection, Freeze Panes, Macros

Advance Excel

Math & Trigonometry functions, Advance Text Functions, Advance Date & Time Functions, Advance Lookup & References Functions, Advance Statistical Functions, Financial Functions, Array Functions, MIS Reports, Dashboard Making

Excel VBA

Basics of Excel VBA, Macro Recordings and Check Codes, Basic Syntax and Variables, If Condition, Loops, Procedures & Functions, Introduction to Excel Objects, Manipulate Cells & Ranges, Working with Worksheets and Workbooks, User Forms & Controls, Event Handling, Importing & Exporting Data, Create Dashboards with VBA, Working with Pivot Tables and Charts, Custom Classes & Objects, Array Handling