Complete Excel Course

S No.ModuleTopic
1Excel InterfaceGoing through
2Worksheet BasicsAdd/ Remove/ Delete/ Color a Worksheet, Copy & Move, Hide
3Excel Basics BeginningFont, Text Color, Background Color, Size, Bold, Italic, Underline, Merge, Wrap, Alignment, Comment, Hyperlink
  Cut, Copy, Paste, Format Painter
  
Borders, Add/ Remove rows & columns
  Sort, Filter
4Paste SpecialAs Values
  As Link
  As Formula
  As Transpose
5Data Cleaning TechniquesFind/ Find All
  Replace/ Replace All
  Format
  Group/ Ungroup
  Custom Filter
  Remove Duplicates
6Named RangeNamed Range
7Maths FunctionsCount, Sum, Average, Max, Min, Large, Small
8Text FunctionsLen, Left, Right
9File TabOverview
10Quiz (20 MCQs)Test Your Knowledge
11FunctionsExcel Functions
  Text Functions
  Date & Time Functions
  If Function, AND & OR Operators
  Informational Functions
12Go To SpecialData Fixing
13Relative, Mixed & Absolute ReferencingRelative, Mixed & Absolute
14Data 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
15Goal SeekTwo Examples
16SUMIF, IFS, COUNTIF, IFSSUMIF, IFS, COUNTIF, IFS
17TableFormat as Table & Add on Capabilities
18ArrayArray with Sum & Max Functions
19Conditional FormattingInbuilt Conditional Formatting
  Custom Conditional Formatting
  Dynamic Search & Highlight
  Partial Match
20Auto-fill, Flash Fill & Custom ListsAuto Fill
  Flash Fill
  Custom Lists
21Vlookup/ 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
22Offset FunctionOffset - Basic
  Offset with Sum - Horizontal
  Offset with Sum - Vertical
  Offset with Match
  Offset with Average
  Offset with Countif
23Index & 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
24Pivot 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
25Power PivotIntroduction: How Is Power Pivot Different From Pivot Table
  Avoid Vlookup Using Data Model
26Designing DashboardCreate Your Dashboard
27Power QueryIntroduction: Why Power Query
  Data From Web
  
Combine Files From Folder In 1 click
28ProtectionProtect Sheet
  Protect Workbook
  Make Your Workbook Read Only
29Test Your Knowledge40 MCQs
30New Functions of Excel 2019Concat
  TEXTJOIN Function
  MINIFS And MAXIFS Function
  IFS Function
  SWITCH Function
31New 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)