Advanced Practical Excel for Professionals-Zero to Hero

Show Content List

Advanced Practical Excel for Professionals - Introduction

ABOUT YOUR INSTRUCTOR

TARGET AUDIENCE

Benefits

content

Reviews

Download Excel Workbook-Module 1-5.1

Download Excel Workbook -Module 1 -Module 5.1

How to Open Excel Sheet ,Rename & Save

Module 01-Introduction to Ms Excel

In Excel, which of the following refers to a vertical arrangement of cells?

Module 02 -Absolute & Relatives cell references

In Excel, which type of cell reference stays fixed when you copy a formula?

Module 03 -Name Range

In Excel, what is the purpose of assigning a range name to a group of cells?

Module 04 -Lookup Function

What does the LOOKUP function do in Excel?

Module 5.1 -Hlookup Function

Download Excel Workbook -Module 5.2-Module 11

What is the primary difference between VLOOKUP and HLOOKUP functions in Excel?

Initial Feedback

Module 5.2 - Vlookup Function

In Excel, what does the "V" in VLOOKUP stand for?

Module 6: Logical Functions (AND / OR)

What is the result of the Excel AND function if both conditions are true?

What is the result of the Excel OR function if at least one of the conditions is true

Module 7: IF Functions

What does the Excel IF function do?

Module 8: Nested IF

What is the purpose of using nested IF functions in Excel?

Module 9: COUNT Function

What does the COUNTIFS function in Excel do?

Module 10: Text Functions

What does the LEN function in Excel do?

Module 11: More on IF (OR AND)

Download Excel Workbook -Module 12-Module 22

Module 12: Date Functions – Part 1

What does the EDATE function in Excel do?

Module 13: Date Functions - Part 2

What does the NETWORKDAYS.INTL function in Excel do?

Module 14: Date Functions - Part 3

What does the DATEDIF function in Excel do?

Module 15: Conditional Formatting

What does Conditional Formatting allow you to do in Excel?

Module 16: Data Validation

What is the purpose of Data Validation in Excel?

Module 17: Removing Duplicates

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

Module 18: Freezing and Unfreezing Panes

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

Module 19: Filtering and Sorting

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: Text to Columns

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

Module 21-A: INDEX Functions

What does the INDEX function in Excel do?

Module 21-B: MATCH Functions

What does the MATCH function in Excel do?

Module 22: Pivot Tables with Slicers

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

Download Excel Workbook -Module 23-Module 33

Module 23-A : PMT Function

What does the PMT function in Excel calculate?

Module 23-B: PMT Function-Loan Amortization Schedule

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

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 a Data Table in Excel's What-If Analysis?

Module 25: Automating Geographical Data Entry

Module 26-A: Charts - Column Chart

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

Module 26-B : Column Charts -Deeply

Module 26-C: Charts (Column Chart | pie Chart | Bar Chart | Line Chart )

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

Module 26-D: Charts ( X-Y Scatter Chart | Spark Line formatting )

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

Vidura Chathuranga

1

1

Advanced Practical Excel for Professionals - Introduction

ABOUT YOUR INSTRUCTOR

ABOUT YOUR INSTRUCTOR

TARGET AUDIENCE

Benefits

content

content

Reviews

Reviews

Download Excel Workbook-Module 1-5.1

Download Excel Workbook -Module 1 -Module 5.1

Lesson Attachments

How to Open Excel Sheet ,Rename & Save

How to Open Excel Sheet ,Rename & Save

Module 01-Introduction to Ms Excel

Module 01-Introduction to Ms Excel

Module 02 -Absolute & Relatives cell references

Module 02 -Absolute & Relatives cell references

Module 03 -Name Range

Module 03 -Name Range

Module 04 -Lookup Function

Module 04 -Lookup Function

Module 5.1 -Hlookup Function

Module 5.1 -Hlookup Function

Module 5.2 - Vlookup Function

Module 6: Logical Functions (AND / OR)

Module 7: IF Functions

Module 8: Nested IF

Module 9: COUNT Function

Module 10: Text Functions

Module 11: More on IF (OR AND)

Module 12: Date Functions – Part 1

Module 13: Date Functions - Part 2

Module 14: Date Functions - Part 3

Module 15: Conditional Formatting

Module 16: Data Validation

Module 17: Removing Duplicates

Module 18: Freezing and Unfreezing Panes

Module 19: Filtering and Sorting

Module 20: Text to Columns

Module 21-A: INDEX Functions

Module 21-B: MATCH Functions

Module 22: Pivot Tables with Slicers

Module 23-A : PMT Function

Module 23-B: PMT Function-Loan Amortization Schedule

Module 25: Automating Geographical Data Entry

Module 27: Transferring Screenshot Data into Excel

Module 29: Creating Folders Directly from Excel

Module 30-A: Picture Filter and Lookup

Module 31: Creating Dynamic Calendars

Module 32: Text Split

Module 33: Unique Function