Advanced Excel Course for Development and finance professionals

About Course

In the second course of our Excel series, students will build on the knowledge acquired in the introductory and intermediate courses and expand their functional expertise. Students will be introduced to functions, learn how to construct advanced Excel formulas, and construct databases utilizing advanced VLOOKUP skills to automate tasks.

Learn how to THINK like Excel pro, and write powerful and dynamic Excel formulas from scratch.
Write advanced conditional, text, date, and lookup functions, including VLOOKUP, IF functions & more.
Automate, streamline, and revolutionize your workflow with Excel using advanced functions.
Master unique tips & techniques delivered in your own language
Explore fun, interactive, and highly effective demos from experienced Excel instructor.

Course Content

Logical Function

Introduction to logic

07:31
Testing Logic

09:50
Introducing “IF” function into the logic

04:35
More “IF” Examples and Introducing “AND” function

11:23
Using “IF” and “AND” Functions

13:24
Named Ranges

10:00
Continue Named Ranges

10:00

Applying Logical functions (IF, AND, OR) in real life

SUMIF, SUMIFS, COUNTIF, COUNTIFS, AVERAGEIF, AVERAGEIFS

VLOOKUP in Excel

Date/Day and Time Functions

Today, Now, Year and Month Functions

09:30
How to use “Today” Function in real Life

04:00
Day, Hour, Minutes and Second Functions

07:00
DATEVALUE

02:27
TIMEVALUE Function

01:26
EDATE Function

05:23
EOMONTH Function

03:53
WORKDAY function

08:30
WORKDAY INTERNATIONAL Function

07:03

Printing Excel File

Introduction and overview

00:00
Print Preview

03:30
How to enable Print preview in Quick access Toolbar

01:30
How to enable print Preview through File Menu

01:00
Checking for printing problem before printing your Document

01:40
Choosing print setting of your choice

01:15
Changing Print Orientation and paper type

01:30
Selecting right margins for printing

02:30
Overview of the steps one more time

03:00
Custom Margins

02:00
Scaling Options

06:00
Use Page breaks to determine number of rows per Page

08:00
Let’s review our steps one more time

10:44

Other Addons

Add this certificate to your resume to demonstrate your skills & increase your chances of getting noticed.

Student Ratings & Reviews

5.0

Total 1 Rating

1 Rating

0 Rating

Asho Aden

1 year ago

This is great course. Thanks

About Course

What Will You Learn?

Course Content

Logical Function

Introduction to logic

Testing Logic

Introducing “IF” function into the logic

More “IF” Examples and Introducing “AND” function

Using “IF” and “AND” Functions

Named Ranges

Continue Named Ranges

Applying Logical functions (IF, AND, OR) in real life

Apply “Logical Functions” in real life (a)

Apply “Logical Functions” in real life (b)

Apply “Logical Functions” in real life (c)

Create “Payroll” using Nested If function (i)

Create “Payroll” using Nested If function (ii)

Create “Payroll” using Nested If function (iii)

Test on Logical Functions

SUMIF, SUMIFS, COUNTIF, COUNTIFS, AVERAGEIF, AVERAGEIFS

How to use SUMIF and SUMIFS Formulas

How to use SUMIFS and COUNTIFS Formulas

VLOOKUP in Excel

How use VLOOKUP Function in Excel

Create VLookup Table and Values

How to fix formula errors using IFERROR function in Excel

Date/Day and Time Functions

Today, Now, Year and Month Functions

How to use “Today” Function in real Life

Day, Hour, Minutes and Second Functions

DATEVALUE

TIMEVALUE Function

EDATE Function

EOMONTH Function

WORKDAY function

WORKDAY INTERNATIONAL Function

Printing Excel File

Introduction and overview

Print Preview

How to enable Print preview in Quick access Toolbar

How to enable print Preview through File Menu

Checking for printing problem before printing your Document

Choosing print setting of your choice

Changing Print Orientation and paper type

Selecting right margins for printing

Overview of the steps one more time

Custom Margins

Scaling Options

Use Page breaks to determine number of rows per Page

Let’s review our steps one more time

Other Addons

Insert header, footer, date, time, logo

Repeat Rows

Earn A Certificate

Student Ratings & Reviews