arrow_back
Course Content
Section Materials
How to unzip course material
Excel Material
Introduction
1.1 MS Excel Introduction
1.2 User Interface
1.3 Create Write & Save File
Working With Cells
2.1 Enter & Edit Data In Cells
2.2 Cut, Copy & Paste In Cells
2.3 Clip Board In Cells
Quiz
Working With Cells
Formatting Cells
3.1 Bold, Italic & Underline
3.2 Background & Font Color
3.3 Increase & Decrease Font Size
3.4 Font Type & Size
3.5 Borders
3.6 Advanced Font Options
Quiz
Formatting Cells
Alignment
4.1 Merge & Unmerge
4.2 Alignment Of Text
4.3 Text Direction
4.4 Indentation
4.5 Wrap Text
4.6 Advanced Alignment Options
Quiz
Alignment
Number Formatting
5.1 Number Format
5.2 Currency Format
5.3 Percent Format
5.4 Date Format
5.5 Custom Format Date
5.6 Custom Format Number
5.7 Usage Of Format Painter
Quiz
Number Formatting
Conditional Formatting
6.1 Highlight Cell Rules-Numbers
6.2 Highlight Cell Rules-Text
6.3 Highlight Cell Rules-Dates
6.4 Highlight Cell Rules-Duplicate Values
6.5 Data Bars
6.6 Color Scale
6.7 Icon Sets
6.8 Top & Bottom Rules
Quiz
Conditional Formatting
Cell Group
7.1 Insert & Delete Rows
7.2 Insert & Delete Columns
7.3 Row Height & Column Width
7.4 Autofit Column Width
7.5 Insert, Delete & Copy Sheet
7.6 Sheet Rename & Color
7.7 Hide & Unhide Sheets
7.8 Hide & Unhide, Column & Rows
Quiz
Cell Group
Editing Group
8.1 Fill
8.2.0 Fill Series
8.2.1 Fill Series
8.3 Custom list
8.4 Functions
8.5 Clear
8.6 Find & Replace
8.7 Go To
Quiz
Editing Group
Tricks and Tips
9.1 Speak Cells
9.2 Backend Settings
9.3 Ribbon & QAT
9.4 Ctrl & Shift Keys
9.5 Shortcuts
9.6 Find Your Exact Age
9.7 Format Multiple Sheets
Quiz
Tips & Tricks
Sort and Filter
10.1 Basic Sorting
10.2 Multilayer Sorting
10.3 Sorting By Color
10.4 Custom Sorting
10.5 Basic Filter
10.6 Filter By Color
10.7 Advanced Filter
10.8 Advanced Filter With AND & OR Criteria
Quiz
Sort & Filter
Table
11.1 Creating A Table
11.2 Table Style & Table Option
11.3 Total Row In Tables
11.4 Remove Duplicates
11.5 Resize & Rename Table
11.6 Slicers
11.7 Convert To Range
Quiz
Tables
Hyperlink
12.1 Hyperlink
12.2 Link To WebPage
12.3 Link Within Same File
12.4 Create A New Hyperlink
12.5 Screen Tip
12.6 Hyperlink To Object
Quiz
Hyperlink
Protection & Hiding Techniques
13.1 Sheet Protection
13.2 Protect Structure Of Workbook
13.3 Protect A File
13.4 Cell Protection
13.5 Protect & Hide Formula
13.6 Settings While Protection
Quiz
Protection & Hiding Techniques
Working with Functions
14.1 Formula vs Function
14.2 Function Help
Working with Functions
Maths Function
15.1 Basic Maths
15.2 Count, Counta & CountBlank
15.3 Round Function
15.4 Round Up & Round Down
15.5 Ceiling & Floor
Quiz
Maths Function
Text Functions
16.1 Upper, Lower & Proper Case
16.2 Left, Right & Trim
16.3 Substitute & Replace
16.4 Find & Search
16.5 Concatenate Function
Quiz
Text Functions
Date Functions
17.1 Day, Month, Quarter & Year
17.2 Add & Subtract Days
17.3 Add & Subtract Years & Months
17.4 Weekday & Weeknum Function
17.5 Today & Now Function
Quiz
Date Functions
Flash Fill
18.1 Flash Fill Text
18.2 Flash Fill Date
18.3 Flash Fill Numbers
18.4 Flash Fill Text To Columns
Quiz
Flash Fill
Logical Functions
19.1 IF Function
19.2 IF With AND Function Part - 1
19.3 IF With Or Function
19.4 Nested IF Function
19.5 IF With AND Part - 2
19.6 IF Error Function
Quiz
Logical Functions
Name Manager
20.1 Name Range
20.2 Name Range In Function
20.3 Create Name Range To Multiple Columns
Quiz
Name Manager
Statistical Function
21.1 Sum, SumIf & SumIfs
21.2 Count, CountIf & CountIfs
21.3 Average, AverageIf & AverageIfs
21.4 Min, MinIf & MinIfs
21.5 Max, MaxIf & MaxIfs
21.6 Small & Large Function
Quiz
Statistical Functions
Data Validation
22.1 Data Validation Basics
22.2 Drop Down List
22.3 Name Range
22.4 Input Message & Error Alert
22.5 Dependent Drop Down
Quiz
Data validation
Absolute & Relative Reference
23.2 Absolute Referencing
23.1 Relative Reference
23.3 Mixed Cell References
Quiz
Absolute & Relative Reference
Lookup Functions
24.1 VLookup Basics
24.2 Vlookup Approximation
24.3 Vlookup Rule
24.4 Data Validation
24.5 Hlookup Function
24.6 Vlookup With Trim
24.7 Match Function
24.8 Index Function
24.9 Index & Match Function
24.10 Full Record
Quiz
LookUp Functions
Charts & Graphs
25.1 Column Charts All
25.2 Chart Design
25.3 Adding Chart Elements
25.4 Column Chart
25.5 Bar Chart
25.6 Stacked Column Chart
25.7 Pie Chart & Donut Chart
25.8 Line & Area Chart
25.9 Line Vs Column Chart
25.10 Tree Map
25.11 Sunburst Chart
25.12 Maps
25.13 Scattered Plot
Quiz
Charts & Graphs
Subtotal & Groups
26.1 Group Rows
26.2 Group Columns
26.3 Subtotal
26.4 Without Sort
Quiz
Subtotal & Groups
Pivot Tables
27. 1 Introduction To Pivot Table
27.2 Sort & Filter In Pivot Table
27.3 Conditional Formating In Pivot Table
27.4 Aggregation In Pivot Table
27.5 Hierarchy In Pivot Table
27.6 Grouping Of Text, Dates & Numbers In Pivot Table
27.7 Style & Style Options In Pivot Table
27.8 Layout Of Pivot Table
27.9 Create Report Filter Pages In Pivot Table
27. 10 Add Slicers & Timeline In Pivot Table
27. 11 Pivot Table Settings
Quiz
Pivot Table
Pivot Chart
28. 1 Introduction To Pivot Charts
28. 2 Formatting A Pivot Chart
28. 3 Slicers & Timeline In Pivot Chart
28. 4 Changing Chart Type In Pivot Chart
Quiz
Pivot Chart
Insert Objects
29. 1 Insert Images
29. 2 Format Images
29. 3 Insert Shape
29. 4 Format Shapes
29. 5 Insert Video
29. 6 Insert PPT & PDF
29. 7 Insert Sparklines
Quiz
Insert Objects
Sheet Formatting
30.1 Split
30. 2 Freeze Panes
30. 3 Hide & Unhide Sheet
30. 4 Comments
30. 5 Custom Views
30. 6 Zoom
Quiz
Sheet Formatting