Mastering Basics of Excel
  • Download Practice Files for Excel Basic Level Topics
  • Introduction to Excel and Basic Excel Shortcut Part 1
  • Excel Shortcuts - Speed Booster - Part 2
  • Excel Shortcuts - Speed Booster - Part 3
  • Excel Basic Formulas Part 1
  • Excel Basic Formulas Part 2
  • Excel Basic Formulas Part 3
  • Excel Basic Formulas Part 4
  • Excel Challenge Exercise
  • Sorting (Arranging Data in Proper Order)
  • Filtering Data
  • Adding Comment in Cell
  • SubTotal (Creating Basic Summary Report)
  • Conditional Formatting (Coloring Data on the basic of Conditions)
  • PageSetup
  • Text to Column
  • Left Right & Mid Formulas
  • Freeze UnFreeze Row and Column
Conditional Formatting (Highlight / Color data on the basis of Criteria)
  • Conditional Formatting (Part 1) Formatting data on the basis of Criteria
  • Conditional Formatting (Part 2)
  • Advanced Conditional Formatting using Formula (Highlight Entire Row)
  • Download Practice File for Conditional Formatting
Magical Fill in Excel
  • Flash Fill (Hours of Work in Seconds)
Dynamic Table
  • Creating Dynamic Chart Range
  • Automatic Drags Formula till end of the data
  • Inserting Formula and adding Extra Rows
  • Using Beautiful Slicer (You should learn this)
  • Freeze Top Row with Table
  • Convert Table into Normal Data
  • Download Practice Files
Deleting Blank Rows from huge database (3 Methods)
  • 3 Methods of Deleting Blank Rows from your Sheet
Sorting & Filtering
  • Sorting (Arranging data in proper order)
  • Filter data according to your requirement
  • Download Practice File for Sorting & Filtering
Creating Beautiful Charts
  • Create Column Chart
  • Creating Dynamic Chart & Line Chart
  • Pie and Sales vs Target Line Chart
  • Thermometer Chart and Linking Chart to PowerPoint
  • Creating Combination Chart
  • Secondary Axis Chart
  • Sparkline (Mini Charts in Cell)
  • Download Chart Practice File
PIVOT Table - Creating Dashboard - Summary Report with Pivot Table
  • Creating 1st Interactive Report with Pivot Table
  • Creating Yearly and Quarterly Report with Pivot
  • Creating Summary Report (All Reports on 1 Sheet)
  • Creating Interactive Dashboard with Charts
  • Download Practice File for Pivot Table
Adding $ Sign in Formula
  • Adding $ Sign in Formula
  • Download Practice File for adding $ Sign
Paste Special
  • Convert Formulas into value
  • Practice File
Validation
  • Create Drop Down in cells & Restrict invalid values in cell
  • Setting Error Alert in Validation
  • Data Validation on Numbers
  • Download Practice File for Data Validation
Macros Recording and Running
  • Automate your regular activities with Macro recording
  • Download Practice Files
Sub total & Text to Column (To Seperate First Name & Last Name)
  • Create Subtotal of Huge data
  • Separate First & Last Name
  • Download Practice Files
Hyperlink
  • Hyperlink Part 1 Linking to other Sheet
  • Hyperlink Part 2 Linking in Same Sheet
  • Hyperlink Part 3 Linking other file
  • Download Practice file for Hyperlink
Protecting Data
  • 1) File Level Protection
  • 2) Sheet Level Protection
  • 3) Workbook Level Protection
  • 4) Cell Level Protection
  • Download Practice File for Protecting Data
Basic Formulas
  • Sum and Sub Total Formula
  • Find Minimum, Maximum and Average from Data
Count IF and SumIF Function
  • COUNTIF Function
  • SumIF Formula
  • CountIF & SumIF from other Sheet
  • Download Practice Files for Practicing CountIF & SumIF
Counting & Summing on Multiple Conditions
  • COUNTIFS
  • SUMIFS
  • Practice File for CountIFs & SumIFs
IF Condition
  • IF Condition
  • Writing Multiple IFs / Nested IFs
  • Using AND & OR Condition in IF