Basic and Advance Microsoft Excel 2013/2016/2019/2021/Office 365

Module 1: Advance Functions
 Statistical Functions
 Database Functions
 Lookup and references Functions
 Database Functions
 Date Functions
 Text Functions
 Logical Functions

Module 2: Working with Lookup functions
 Limitation of VLookup/Hlookup functions and alternatives for same.
 Match function.
 Index function.
 Xlookup

Module 3: Sorting and Filtering Data and Subtotal
 Sorting and filtering lists
 Sorting data according to color
 Using multiple-level sorting
 Subtotal and Multi level Subtotal.
 Filters and its Drawback
 Advance Filter.

Module 4: What-If Analysis
 Using goal seek
 Using data tables
 Creating and editing scenarios

Module 5: Formula Auditing
 Evaluating Formula
 Tracing Precedents
 Tracing Dependents
 Error Checking

Module 6: Working with External Data
 Importing files from different sources
 Refreshing data

Module 7: Working with Pivot Reports/Charts
 Simple Report.
 Cross tab Report.
 Changing Data Range
 Formatting and making dynamic Report
 Use of Slicers

Module 8: Data Validation
 Data Validation for Invalid Values
 Data Validation for List/Dynamic List with named range
 Data Validation for Protecting Formula

Module 9: Text To Column/External Data
 Convert data from text to tabular format.
 Getting data from external sources to Excel

Module 10: Using Macros – (Basic only, no coding)
 Recording and executing macros
 Understanding different types of references in macros
 Assigning macros to toolbars or menu items
 Editing macros using VBA Editor

Module 11: Security and Protecting Excel Workbook
 Password-Protection Workbook
 Password-Protection Worksheet
 Hiding Formula etc

Module 12: New features 2021/Office 365
 i. Dynamic Arrays
 FILTER
 SORT
 SORTBY
 UNIQUE
 SEQUENCE
 RANDARRAY
 Ii. LET Function
 iii. LAMBDA Function