fbpx

Mastering Microsoft Excel

PART #1 : Excel Core
LESSON 1: OVERVIEW
3 Topics
1-Introduction to Excel Starter
2- Identifying Basic Parts of the Excel Window
3- How to change default view in Excel?
LESSON 2: WORKING WITH MICROSOFT EXCEL 2016
4 Topics
4-Creating Workbooks
5-Saving Workbooks
6- Entering and Editing Basic Data in a Worksheet
7-Using Fill Tool and Mange Data Types
LESSON 3: USING OFFICE BACKSTAGE
3 Topics
8-Printing with Backstage
9- Changing the Excel Environment
10-Accessing and Using Excel Templates
LESSON 4: USING BASIC FORMULAS
4 Topics
11-Understanding and Displaying Formulas
12-Using Cell References in Formulas
13-Using External Cell References
14-Using Cell Ranges in Formulas
LESSON 5: USING FUNCTIONS
1 Topic
15-Summarizing Data with Functions
LESSON 6 : FORMATTING CELLS AND RANGES
7 Topics
16-Inserting and Deleting Cells
17-Manually Formatting Cell Contents
18-Copying Cell Formatting with the Format Painter
19- Understanding Paste Special Options
20-Formatting Cells with Styles
21-Working with Hyperlinked Data
22-Applying Conditional Formatting to Cells
LESSON 7: FORMATTING WORKSHEETS
4 Topics
23-Working with Rows and Columns
24-Using Themes
25- Inserting Headers and Footers
26-Preparing a Document for Printing
LESSON 8: MANAGING WORKSHEETS
3 Topics
27-Organizing Worksheets
28-Using Zoom and Freeze to Change the Onscreen View
29-Finding and Replacing Data
LESSON 9: WORKING WITH DATA AND MACROS
5 Topics
30-Importing Data
31-Sorting Data
32-Filtering Data
33-Outlining and Subtotaling Data
34-Use Data Validation and Removing Duplicate
LESSON 10: USING ADVANCED FORMULAS
1 Topic
35-Securing Workbooks
LESSON 11: SECURING AND SHARING WORKBOOKS
1 Topic
36-Creating Charts in Excel
LESSON 12: CREATING CHARTS
1 Topic
37-Adding Pictures and Shapes to a Worksheet
LESSON 13: ADDING PICTURES AND SHAPES TO A WORKSHEET
2 Topics
38-Using Formulas to Conditionally Summarize Data
39-Adding Conditional Logic Functions to Formulas
PART # 2 : Excel Advanced
Excel Formulas and Functions
13 Topics
Nested IF in Excel – formula with multiple conditions
Sum Reference Errors IF Error
SUM, COUNT & AVERAGE functions in Excel – Part # 1
SUM, COUNT & AVERAGE functions in Excel – Part # 2
How to use the Excel XLOOKUP Function
Combine VLOOKUP and Data Validation
How to use the Excel HLOOKUP Function ?
Advanced Excel – Date & Time Functions
How to Create and Use Excel Named Ranges and other Objects
Using functions and nested functions in Excel formulas
Troubleshooting Formulas and Functions in Excel
Using Data Analysis and Business Intelligence Tools – Part # 1
Using Data Analysis and Business Intelligence Tools – Part # 2
Advanced Topics
5 Topics
Managing and Protecting Excel Workbooks – Part # 1
Managing and Protecting Excel Workbooks – Part # 2
Applying Custom Formats and Validating Data
Applying Conditional Formatting and Filtering
PivotTable and PivotChart
Previous Topic

3- How to change default view in Excel?

Mastering Microsoft Excel LESSON 1: OVERVIEW 3- How to change default view in Excel?
Previous Topic
Back to Lesson
error:
×