08:11
Replace and Substitute Text Manipulation
04:10
Lower Case, Upper Case, Title Case
03:13
Concatenate and Left Function in Text Manipulation
04:58
Find and Mid Text Manipulation
09:32
Trim and LEN Functions
01:56
Adding Custom Views to Ribbon
02:31
Editing Custom Views
03:51
Auto Outlines and Custom Views
03:18
Custom Views
02:20
Scenario Summary
03:01
Merge and Delete Function in Scenario Manager
03:13
Scenario Manager Tips
01:44
Using The Scenario Manager
07:07
Scenario Manager
04:54
Editing Outlines
01:46
Manual Outling
03:22
Auto Outlines
03:40
34 131 Loan Elements Calculations Rate, Nper, PV
05:05
Loans and Savings Calculations
05:46
The RAND Function
05:03
MOD and INT Functions
03:27
The Rounding Function in Excel
04:45
Excel Time and Date Functions
04:35
Time Calculation in Excel
06:06
Time in Excel
01:32
Removing Sparklines
02:42
Comparing Sparlines in a Sparkline Group
01:16
Sparklines and Empty Cells
01:40
Sparkline Tool
03:41
Sparklines
06:42
Managing Lookup Tables
06:11
Dealing with Errors in Lookup Syntax
02:51
Near Match lookup with Vlookup
06:18
Hlookup in real life
10:51
Vlookup in real life
04:36
Vlookup Syntax
02:47
FormulaText
07:36
Not Operator within AND and OR Statements
05:56
OR Operator with the IF Syntax
10:47
AND Operator with If Syntax
03:02
Nested If Syntax
11:55
IF Syntax
04:28
Area and Volume calculations
08:13
Multiple criteria CountIFS, SumIFS, AverageIFS
05:00
More AverageIf Functions
03:48
More CountIF Functions
04:58
More SUMIF Functions
04:22
MODE, MEDIAN, MEAN AVERAGE Functions
03:47
SUM, COUNT, MIN, MAX Functions
02:00
Microsoft Account
01:54
Managing Rules
04:29
New Formatting Rule
02:31
Top Bottom Rules
03:14
Data Bars, Color Scales, Icon Sets
02:47
Cell Conditional Formatting
03:28
Rank Function
06:32
SumIF, CountIF,AverageIF Functions
03:23
Text Function to Format Numbers
03:20
Using the datedif Function
06:02
Using the IF Function to hide Error Messages
X
About
Tags