- 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 (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
- Flash Fill (Hours of Work in Seconds)
- 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
- 3 Methods of Deleting Blank Rows from your Sheet
- Sorting (Arranging data in proper order)
- Filter data according to your requirement
- Download Practice File for Sorting & Filtering
- 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
- 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
- Download Practice File for adding $ Sign
- Convert Formulas into value
- Practice File
- 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
- Automate your regular activities with Macro recording
- Download Practice Files
- Create Subtotal of Huge data
- Separate First & Last Name
- Download Practice Files
- 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
- 1) File Level Protection
- 2) Sheet Level Protection
- 3) Workbook Level Protection
- 4) Cell Level Protection
- Download Practice File for Protecting Data
- Sum and Sub Total Formula
- Find Minimum, Maximum and Average from Data
- COUNTIF Function
- SumIF Formula
- CountIF & SumIF from other Sheet
- Download Practice Files for Practicing CountIF & SumIF
- COUNTIFS
- SUMIFS
- Practice File for CountIFs & SumIFs
- IF Condition
- Writing Multiple IFs / Nested IFs
- Using AND & OR Condition in IF