Add to Wishlist
Microsoft Excel – Excel from Beginner to Advanced

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