Coursepedia
Microsoft Excel – Excel from Beginner to Advanced
Back to Dashboard

Hey there, great course, right? Do you like this course?

All of the most interesting lessons further. In order to continue you just need to purchase it

Buy Course Now

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

HOW TO MOTIVATE YOURSELF

Lesson is locked. Please Buy course to proceed.