Menu
Show Content List

Advanced Practical Excel for Professionals - Introduction

Advanced Practical Excel for Professionals - Introduction

Introduction

This content is a property of the teacher, downloading and circulating the content is strictly prohibited.

ABOUT YOUR INSTRUCTOR

ABOUT YOUR INSTRUCTOR

Instructor's Qualification & Experience

This content is a property of the teacher, downloading and circulating the content is strictly prohibited.

TARGET AUDIENCE

TARGET AUDIENCE

TARGET AUDIENCE

Office Staff & Professionals

Finance Professionals (Accountants)

Sales & Marketing Professionals

Logistics Professionals

HR Professionals

Job Seekers

Other professionals who use Excel

Ready to migrate

This content is a property of the teacher, downloading and circulating the content is strictly prohibited.

Benefits

Benefits

Benefits

This content is a property of the teacher, downloading and circulating the content is strictly prohibited.

Reviews

Reviews

This content is a property of the teacher, downloading and circulating the content is strictly prohibited.

Module 12

Download Excel Workbook -Module 12-Module 22
Module 12: Date Functions – Part 1

What does the EDATE function in Excel do?

Module 13

Module 13: Date Functions - Part 2

What does the NETWORKDAYS.INTL function in Excel do?

Module 14

Module 14: Date Functions - Part 3

What does the DATEDIF function in Excel do?

Module 15

Module 15: Conditional Formatting

What does Conditional Formatting allow you to do in Excel?

Module 16

Module 16: Data Validation

What is the purpose of Data Validation in Excel?

Module 17

Module 17: Removing Duplicates

What does the "Remove Duplicates" feature in Excel allow you to do?

Module 18

Module 18: Freezing and Unfreezing Panes

What does the "Freeze Panes" feature in Excel allow you to do?

Module 19

Module 19.1-A: Filtering and Sorting
Module 19.1-B: Filtering and Sorting

What does the "Filter" function in Excel allow you to do?

Module 20

Module 20: Text to Columns

What does the "Text to Columns" feature in Excel allow you to do?

Module 21

Module 21-A: INDEX Functions
Module 21-B: MATCH Functions

What does the INDEX function in Excel do?

What does the MATCH function in Excel do?

Module 22

Module 22: Pivot Tables with Slicers

What is the purpose of using Slicers in conjunction with Pivot Tables in Excel?

Module 23

Download Excel Workbook -Module 23-Module 33
Module 23-A : PMT Function
Module 23-B: PMT Function-Loan Amortization Schedule

What does the PMT function in Excel calculate?

How can the PMT function be used in conjunction with an Excel spreadsheet to create a loan amortization schedule?

Module 24

Module 24: Solver as What if Analysis -Goal Seek |Scenario Manager | Data Table

What does the Goal Seek feature in Excel's What-If Analysis allow you to do?

What is the primary purpose of the Scenario Manager in Excel's What-If Analysis?

What is the primary purpose of the Scenario Manager in Excel's What-If Analysis?

What is the primary purpose of a Data Table in Excel's What-If Analysis?

Module 25

Module 25: Automating Geographical Data Entry

Module 26

Module 26-A: Charts - Column Chart
Module 26-B : Column Charts -Deeply
Module 26-C: Charts (Column Chart | pie Chart | Bar Chart | Line Chart )
Module 26-D: Charts ( X-Y Scatter Chart | Spark Line formatting )

What type of data visualization does a column chart represent in Excel?

When is it appropriate to use a pie chart in Excel?

What type of relationship between two variables is best represented using a scatter chart in Excel?

Module 27

Module 27: Transferring Screenshot Data into Excel

Module 29

Module 29: Creating Folders Directly from Excel

Module 30

Module 30-A: Picture Filter and Lookup

Module 31

Module 31: Creating Dynamic Calendars

Module 32

Module 32: Text Split

Module 33

Module 33: Unique Function

Module 34

Q&A Live Lesson
Telegram