Microsoft Excel – Excel from Beginner to Advanced
Back to Dashboard
Course sections
Section 1
SECTION 1: STARTING EXCEL
1
Course Overview
2 min 20 sec.
2
Microsoft Excel - Course Materials
3
Understanding Excel User Interface
16 minutes
4
Understanding Excel Workbook and Worksheets
11 minutes
5
Explaining the Ribbon
12 minutes
6
Saving an Excel File
05 minutes
Section 2
SECTION 2: ENTERING DATA INTO CELL
1
Combined what you can enter in a Cell
07 minutes
2
Entering Formula
04 minutes
Section 3
SECTION 3: SHEETS ROWS AND COLUMNS
1
Copy and Drag
23 minutes
2
Working with Rows and Columns
23 minutes
3
Working with Sheets
09 minutes
Section 4
SECTION 4: FUNCTIONS AND NAME RANGE
1
Using Name Range
08 minutes
2
Name Range with Formulas
10 minutes
3
Functions
10 minutes
4
SUM Functions
05 minutes
5
Copy and Drag Formula
04 minutes
6
More Basic Functions
05 minutes
Section 5
SECTION 5: FORMATTING AND CONDITIONAL FORMATTING
1
Font Formatting
06 minutes
2
Formatting Alignment
06 minutes
3
Formatting Borders
06 minutes
4
Formatting Numbers
07 minutes
Section 6
SECTION 6: PRINTING
1
Icons Shapes and Formatting
18 minutes
2
Printing Page Layout
16 minutes
3
Printing Headers and Footers
06 minutes
Section 7
SECTION 7: MANAGING TABLE
1
Sorting Data
08 minutes
2
Filtering Data
09 minutes
3
Tables
10 minutes
4
Grouping and Outline
07 minutes
5
Freeze Panes
04 minutes
Section 8
SECTION 8: MANAGING TEXT WORKING WITH FORMULAS AND FUNCTIONS
1
Using the IF Functions PT. I
18 minutes
2
Using the IF Functions PT. II
04 minutes
3
Using the CountIF
14 minutes
4
Using the SumIF
09 minutes
5
Using Left Right and Mid
06 minutes
6
Using the LEN Function
05 minutes
7
How to use VLOOKUP with Exact Match
14 minutes
8
VLOOKUP with Approximately Match
06 minutes
9
VLOOKUP with TRIM
09 minutes
Section 9
SECTION 9: CHARTS
1
The Charting Process
04 minutes
2
Choosing the right chart
08 minutes
3
Using the Recommended Charts
04 minutes
4
Creating a New Chart from Scratch
04 minutes
5
Creating a New Chart Sheet
02 minutes
6
Walking through all the chart options
08 minutes
7
How to change Chart Type
04 minutes
Section 10
SECTION 10: PIVOT TABLES
1
Pivot Table Example PT. I
25 minutes
2
Pivot Table Example PT. II
08 minutes
3
Pivot Table Example III
08 minutes
4
Pivot Table Grouping
06 minutes
5
Pivot Table Slicer
14 minutes
6
Pivot Table Timeline
09 minutes
7
Pivot Chart
06 minutes
SECTION 1: STARTING EXCEL
Course Overview
