Course Content
Logical Function
0/7
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
0/7
Apply “Logical Functions” in real life (a)
08:31
Apply “Logical Functions” in real life (b)
13:45
Apply “Logical Functions” in real life (c)
12:43
Create “Payroll” using Nested If function (i)
03:55
Create “Payroll” using Nested If function (ii)
07:20
Create “Payroll” using Nested If function (iii)
03:18
Test on Logical Functions
SUMIF, SUMIFS, COUNTIF, COUNTIFS, AVERAGEIF, AVERAGEIFS
0/2
How to use SUMIF and SUMIFS Formulas
11:36
How to use SUMIFS and COUNTIFS Formulas
11:07
VLOOKUP in Excel
0/3
How use VLOOKUP Function in Excel
15:53
Create VLookup Table and Values
07:09
How to fix formula errors using IFERROR function in Excel
09:52
Date/Day and Time Functions
0/9
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
0/13
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
0/2
Insert header, footer, date, time, logo
10:00
Repeat Rows
05:30
Advanced Excel Course

Previous
Next
0% Complete