Mastering Microsoft Excel

Current Status

Not Enrolled

Price

500 EGP (32$)

Get Started

Take this Course

Course Content

Expand All

PART #1 : Excel Core

LESSON 1: OVERVIEW 3 Topics Sample Lesson

Expand

Lesson Content

0% Complete 0/3 Steps

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

Expand

Lesson Content

0% Complete 0/4 Steps

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

Expand

Lesson Content

0% Complete 0/3 Steps

8-Printing with Backstage

9- Changing the Excel Environment

10-Accessing and Using Excel Templates

LESSON 4: USING BASIC FORMULAS 4 Topics

Expand

Lesson Content

0% Complete 0/4 Steps

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

Expand

Lesson Content

0% Complete 0/1 Steps

15-Summarizing Data with Functions

LESSON 6 : FORMATTING CELLS AND RANGES 7 Topics

Expand

Lesson Content

0% Complete 0/7 Steps

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

Expand

Lesson Content

0% Complete 0/4 Steps

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

Expand

Lesson Content

0% Complete 0/3 Steps

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

Expand

Lesson Content

0% Complete 0/5 Steps

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

Expand

Lesson Content

0% Complete 0/1 Steps

35-Securing Workbooks

LESSON 11: SECURING AND SHARING WORKBOOKS 1 Topic

Expand

Lesson Content

0% Complete 0/1 Steps

36-Creating Charts in Excel

LESSON 12: CREATING CHARTS 1 Topic

Expand

Lesson Content

0% Complete 0/1 Steps

37-Adding Pictures and Shapes to a Worksheet

LESSON 13: ADDING PICTURES AND SHAPES TO A WORKSHEET 2 Topics

Expand

Lesson Content

0% Complete 0/2 Steps

38-Using Formulas to Conditionally Summarize Data

39-Adding Conditional Logic Functions to Formulas

PART # 2 : Excel Advanced

Excel Formulas and Functions 13 Topics

Expand

Lesson Content

0% Complete 0/13 Steps

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

Expand

Lesson Content

0% Complete 0/5 Steps

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

Ratings and Reviews

0.0

Avg. Rating

0 Ratings

What's your experience? We'd love to know!

No Reviews Found!

Show more reviews

What's your experience? We'd love to know!