Show Content List

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

Instructor's Qualification & Experience

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

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

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

Reviews

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

Module 01

Download Excel Workbook -Module 1 -Module 5.1

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

How to Open Excel Sheet ,Rename & Save

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

Module 01-Introduction to Ms Excel

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

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

Module 02

Module 02 -Absolute & Relatives cell references

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

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

Module 03

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

Module 04

What does the LOOKUP function do in Excel?

Module 05

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

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

Module 06

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 07

What does the Excel IF function do?

Module 08

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

Module 09

What does the COUNTIFS function in Excel do?

Module 10

What does the LEN function in Excel do?

Telegram