Intermediate/ Advanced Excel Course

S No. Module Topic
1 Functions Excel Functions
    Text Functions
    Date & Time Functions
    If Function, AND & OR Operators
    Informational Functions
2 Go To Special Data Fixing
3 Relative, Mixed & Absolute Referencing Relative, Mixed & Absolute
4 Data Validation List
    Typed List
    Mobile Number Validation
    Employee Feedback Validation
    Only Text Values
    Only Upper Case Values
    Prevent Future Dates
    List with Named Range
    Restrict Text Length
    Dynamic List
    Dependent Drop Down List
5 Goal Seek Two Examples
6 SUMIF, IFS, COUNTIF, IFS SUMIF, IFS, COUNTIF, IFS
7 Table Format as Table & Add on Capabilities
8 Array Array with Sum & Max Functions
9 Conditional Formatting Inbuilt Conditional Formatting
    Custom Conditional Formatting
    Dynamic Search & Highlight
    Partial Match
10 Auto-fill, Flash Fill & Custom Lists Auto Fill
    Flash Fill
    Custom Lists
11 Vlookup/ Hlookup/ Xlookup Vlookup Basic
    Vlookup with Array
    Vlookup with Multiple Criteria
    Vlookup with Range
    Vlookup with Named Range & Benefits
    Vlookup with Match Function
    Vlookup with Column Reference
    Vlookup with Table
    Vlookup with Dropdown
    Two-Way Lookup
    Partial Vlookup
    Vlookup to the left side
    Case Sensitive Lookup
    Vlookup with Trim Function
    Vlookup if IFERROR
    Vlookup with Multiple Column Search
    Vlookup with Two Tables
    Vlookup with Duplicate Values
    Bonus: Hlookup & Xlookup
    Quiz - Test Your Knowledge - 20 MCQs
12 Offset Function Offset - Basic
    Offset with Sum - Horizontal
    Offset with Sum - Vertical
    Offset with Match
    Offset with Average
    Offset with Countif
13 Index & Match Function Index Function Basic
    Index Function with Area Number
    Match Function Basic
   
Index & Match Functions as a replacement to Vlookup Function
    Index & Match Functions with Drop Down
14 Pivot Table & Chart Interface
    Data Introduction: Super Store Data
    Create Your First Pivot Table
    How To Make Pivot Table Dynamic
    Slicer & Timeline
    Group & Ungroup Dates
    Conditional Formatting In Pivot
    Create Your First Chart
    How To Make Pivot Chart Dynamic
    Chart Gap
    Top 10 Customers
    Compare One sub-category Against Others
    Profit & Sales Correlation
15 Power Pivot Introduction: How Is Power Pivot Different From Pivot Table
    Avoid Vlookup Using Data Model
16 Designing Dashboard Create Your Dashboard
17 Power Query Introduction: Why Power Query
    Data From Web
    Combine Files From Folder In 1 click
18 Protection Protect Sheet
    Protect Workbook
    Make Your Workbook Read Only
19 Test Your Knowledge 40 MCQs
20 New Functions of Excel 2019 Concat
    TEXTJOIN Function
    MINIFS And MAXIFS Function
    IFS Function
    SWITCH Function
21 Dynamic Array Functions Filter
    Unique
    Sort
    Sortby
    Sequence
    Randarray

 

Practical Learning

Practice Sheets

Recording

Assignment

Evaluation & Certification by Edu4Sure

Any Payment Method (Please pay as per discussion with the team for the required course)

1) Net Banking

TestFormula Education Pvt. Ltd.        
Account Number: 33729473635            
State Bank of India, Delhi           
IFSC: SBIN0001573

2) Pay through Payment Gateway (International transactions acceptable)