Intermediate/ Advanced Excel Course

S No.ModuleTopic
1FunctionsExcel Functions
  Text Functions
  Date & Time Functions
  If Function, AND & OR Operators
  Informational Functions
2Go To SpecialData Fixing
3Relative, Mixed & Absolute ReferencingRelative, Mixed & Absolute
4Data ValidationList
  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
5Goal SeekTwo Examples
6SUMIF, IFS, COUNTIF, IFSSUMIF, IFS, COUNTIF, IFS
7TableFormat as Table & Add on Capabilities
8ArrayArray with Sum & Max Functions
9Conditional FormattingInbuilt Conditional Formatting
  Custom Conditional Formatting
  Dynamic Search & Highlight
  Partial Match
10Auto-fill, Flash Fill & Custom ListsAuto Fill
  Flash Fill
  Custom Lists
11Vlookup/ Hlookup/ XlookupVlookup 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
12Offset FunctionOffset - Basic
  Offset with Sum - Horizontal
  Offset with Sum - Vertical
  Offset with Match
  Offset with Average
  Offset with Countif
13Index & Match FunctionIndex 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
14Pivot Table & ChartInterface
  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
15Power PivotIntroduction: How Is Power Pivot Different From Pivot Table
  Avoid Vlookup Using Data Model
16Designing DashboardCreate Your Dashboard
17Power QueryIntroduction: Why Power Query
  Data From Web
  Combine Files From Folder In 1 click
18ProtectionProtect Sheet
  Protect Workbook
  Make Your Workbook Read Only
19Test Your Knowledge40 MCQs
20New Functions of Excel 2019Concat
  TEXTJOIN Function
  MINIFS And MAXIFS Function
  IFS Function
  SWITCH Function
21New Functions of Excel 2020 - Dynamic Array FunctionsFilter
  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)