Previous Lecture
Complete and continue
Complete Guide to Excel
Excel Introduction
Rows and Columns, Formula Bar, Excel Add-ons
(06:45)
Cut, Copy, Paste
(11:37)
Special Paste
(09:13)
Format Painter
(05:07)
Wrap Text
(02:33)
Merge and Centre
(05:31)
Cell Size and Formats
(16:42)
Excel Basic Tools
Sort and Filter
(13:58)
Margins and Orientation
(07:23)
Page Size and Print Area
(08:40)
Cell Name
(05:14)
Trace Dependants and Precedants
(07:08)
Text to Columns
(08:44)
Adding Comments and Track Changes
(12:46)
Gridlines and Freeze Panes
(07:52)
Apply Custom Data Formats
Understanding Number Formats
(18:21)
Creating Custom Number Formats
(10:28)
Custom Number-format Codes
(12:44)
Excel Date Calculation
(08:54)
Use Advanced Fill Options
Fill Series Options
(10:16)
Types of Series
(13:19)
Creating a Custom Fill Sequence
(05:44)
Flash Fill
(12:50)
Apply Advanced Conditional Formatting and Filtering
Highlight Cell Rules
(16:07)
Top/Bottom Rules
(12:54)
Data Bars, Color Scales and Icon sets
(13:29)
Creating Custom Conditional Formats
(07:22)
Formatting as Table
(11:39)
Table Options
(11:41)
Creating Advanced Filters
(10:56)
Quick Analysis
(04:31)
Apply Custom Styles and Templates
Custom Styles and Templates
(07:37)
Create, Modify and using Custom Templates
(12:51)
Creating a Cell Style
(08:03)
Functions
Introduction to Functions, Parts of Functions
(07:19)
Understanding Arguments in Excel
(14:48)
Apply functions in formulas
Using the Sum, Average, and Percentage Functions
(22:01)
Using Rank, Roman, Max, Min, Product and Subtraction
(14:00)
Using formulas between sheets and Count Functions
(09:19)
Using the IF and Nested IF Function
(15:31)
Using the OR, AND and NOT Function
(15:41)
Count if and Count ifs
(13:44)
Using the SUMIF AND SUMIFS Function
(19:07)
Using Average If and Average Ifs
(14:26)
Mathematical Functions
Using the AVERAGE and MEAN Functions
(05:26)
MEDIAN and MODE function
(11:47)
Frequency Function
(08:42)
Using the Quartile Function
(08:37)
Rounding Decimal Places, MOD and INT Function
(16:16)
RANDOM and RANDBETWEEN Function
(06:06)
Financial functions
EMI Calculations
(25:11)
Loan Statement
(27:08)
Calculating Investments
(23:53)
Useful Data Functions
The CHOOSE Function
(03:58)
Using the MATCH Function
(05:12)
Using the INDEX Function
(07:42)
Using the MATCH and INDEX Functions Working Together
(11:07)
IFERROR, OFFSET, INDIRECT Function
IFERROR Function
(20:47)
OFFSET Function
(18:37)
INDIRECT Function
(25:00)
Look up data by using functions
Using LOOKUP and VLOOKUP Function
(16:40)
Using the HLOOKUP Function
(03:45)
VLOOKUP with multiple sheets
(14:51)
Nested Vlookup
(10:06)
X Lookup
(14:45)
Calculation Between Two Dates
Calculating dates and last working day
(08:58)
Calculating Holidays and Workdays
(10:55)
Preparing Staff Time Sheet
(21:22)
Functions for Manipulating Text
Join, Concatenate, Concat and Text
(10:11)
Length and Find
(06:45)
Left, Right and Mid
(13:40)
Upper, Lower, Substitute and Replace
(19:27)
Use What-If Analysis Tools
Goal Seek
(12:06)
Scenario Manager
(08:49)
Data Tables
(13:29)
Basic Excel Charts
Use of basic charts and recommended charts for analysis
(17:52)
PivotTables
Creating PivotTable
(12:07)
Pivot table Tools
(22:13)
Creating PivotChart
(11:50)
Power Map
(07:59)
Use Pivot Charts
Power Pivot
(15:45)
Work With Sparklines
What are Sparklines?
(08:27)
Manage Workbook Versions
Version Control
(10:22)
Protect Workbooks for Sharing
Password Protection
(16:23)
Connect To External Data
Power Query
(17:38)
Lecture content locked
If you're already enrolled,
you'll need to login.
Enroll in Course to Unlock
Log In
×
E-Mail Address
Password
Remember Me
Login
Forgot Your Password?