Courses
Contact Us

Red & White Skill Education    

Contact Us

1 – Excel – Introduction

Course Content
Introduction, Shortcuts, Data Editing
0/14
Introduction to Course
02:06
1 – Excel – Introduction
03:10
2 – Excel – Exploring
My First Workbook
3 – Excel – Understanding Ribbon
4 – Excel – Shortcuts
5 – Excel – Help
6 – Excel – Wroking with Template
7 – Excel – Workbook and Worksheet
8 – Excel – Saving and Recovery
9 – Excel – Editing Data
10 – Navigation and Selection
10.1 – Excel – Exercise 1
Sample_Store_Sales
Formuls, Calculations, Filtering
0/18
11 – Excel – Formulas and Functions
12 – Excel – Calculations
13 – Excel – Counting Values and Blanks
14 – Excel – Filtering Average
15 – Excel – Working with Min and Max
16 – Excel – Error Handling
17 – Excel – ABsolute and Relative Reference
18 – Excel – AutoSum and AutoFill
19 – Excel – Exercise 2
Absolute vs Relative Referencing
Autosum and Autofill
Calculating with the SUM function
Counting Values with the COUNT function
Error Handling
Finding Averages
Flash Fill
Formulas and Functions Explained
Using MIN and MAX
FlashFill, Managing, Calculation
0/9
20 – Excel – FlashFill
21 – Excel – Named Ranges
22 – Excel – Create Named Ranges
23 – Excel – Managing Named Ranges
24 – Excel – Using Named Ranges in Calculation
25 – Excel – Exercise 3
Creating Named Ranges
Using Named Ranges in Calculations
What are Named Ranges
Number Formatting, Time Formatting, Format Painter
0/9
26 – Excel – Number Formatting
27 – Excel – Date and Time Formatting
28 – Excel – Formatting Cells
29 – Excel – Using Format Painter
30 – Excel – Exercise 4
Date and Time Formats
Format Painter
Formatting Cells Rows and Columns
Number Formatting
Clearing Data, Aligning Text, Applying Themes
0/9
31 – Excel – Working with Rows and Columns
32 – Excel – Deleting and Clearing Data
33 – Excel – Aligning Text and Numbers
34 – Excel – Applying Themes and Styles
35 – Excel – Exercise 5
Aligning Text and Numbers
Applying Themes and Styles
Clearing Cells
Working with Rows and Columns
Structure Data, Custom Sorting, Filtaring
0/8
36 – Excel – How to Structure Data
37 – Excel – Single Level Sorting
38 – Excel – Multi Level Sorting
39 – Excel – Custom Sorting
40 – Excel – Auto Filtering
41 – Excel – Format as a Table
42 – Excel – Subtotal
43 – Excel – Exercise 6
Clipboard, Workbooks, Hyperlinks
0/7
44 – Excel – Cut and Copy
45 – Excel – Paste Options
46 – Excel – Pasting form the Clipboard
47 – Excel – Linking Worksheets and Workbooks
48 – Excel – 3D Referencing
49 – Excel – Inserting Hyperlinks
50 – Excel – Exercise 7
VLOOKUP Introduction, Handling Functions, Making Decision with IF
0/15
51 – Excel – VLOOKUP Introduction
52 – Excel – VLOOKUP – Approximate Match
53 – Excel – Error Handling Functions
54 – Excel – Logical Functions IF, AND, OR
55 – Excel – Making Decision with IF
56 – Excel – Text Functions
57 – Excel – Time and Date Functions
58 – Excel – Exercise 8
Creating Subtotals
Custom Sort
Format as a Table
Multi Level Sorting
Single Level Sorting
The Structure of Lists
Using Autofilter
Chart Types, Data withChart
0/10
59 – Excel – Chart Types
60 – Excel – Data withChart
61 – Excel – Chart Formatting
62 – Excel – Exercise 9
3D Referencing
Cut and Copy
Hyperlink to Worksheets
Linking to Other Worksheets and Workbooks
Paste Options
Pasting from the Clipboard
Data Bars, Highlighting Cell Values, Icons Set
0/12
63 – Excel – Data Bars
64 – Excel – Highlighting Cell Values
65 – Excel – Color Scales
66 – Excel – Icons Set
67 – Excel – Exercise 10
Cleaning Data with Text Functions
Error Handling Functions
Linking to Other Worksheets and Workbooks 2
Logical Functions
Time and Date Functions
VLOOKUP - Films Master List
VLOOKUP Approx Match
Inserting Shapes and Text, Icons and 3D Models, Diagrams and SmartArt
0/10
68 – Excel – Inserting Pictures
69 – Excel – Inserting Shapes and Text
70 – Excel – Icons and 3D Models
71 – Excel – Diagrams and SmartArt
72 – Excel – Screenshots
73 – Excel – Comments
74 – Excel – Exercise 11
Formatting Charts
Presenting Data with Charts
Selecting a Chart Type
Workbook Views, Arranging Workbooks, Freezing Panes
0/9
75 – Excel – Wprkbook Views
76 – Excel – Using Zoom
77 – Excel – Arranging Workbooks
78 – Excel – Freezing Panes
79 – Excel – Exercise 12
Color Scales
Data Bars
Highlight Cell Values
Icon Sets
Orientations, Headers and Footers, Printing Options
0/13
80 – Excel – Setting Margins and Orientations
81 – Excel – Print Area
82 – Excel – Page Breaks
83 – Excel – Print Titles
84 – Excel – Headers and Footers
85 – Excel – Printing Options
86 – Excel – Exercise 13
Inserting Comments
Inserting Icons and 3D Models
Inserting Pictures
Inserting Screenshots
Inserting Shapes and Text Boxes
Inserting SmartArt
Spell Checking, Imspecting Workbook, Saving and Export
0/9
87 – Excel – Protecting Wroksheet and Workbook
88 – Excel – Spell Checking
89 – Excel – Imspecting Workbook
90 – Excel – Saving and Export
91 – Excel – Share Document
92 – Excel – Exercise 14
Freezing Panes
Using Zoom
Workbook Views
Excel Mastery Program (Beginner to Advanced)
Previous
Next
0% Complete

Red & White Skill Education is shaping India’s youth with next-gen skills in Design, IT, Management, and AI.
We believe in one thing, Practical Learning that Leads to Employment.

Contact With Us

Student Terms & Conditions

SORT By Rating
SORT By Order
SORT By Author
SORT By Price
SORT By Category