What you’ll learn

  • Microsoft Excel – From Intro to Advanced Pro Knowledge
  • Financial Modeling in Excel
  • 100+ Navigation Shortcuts and Formatting Tips In Excel
  • Over 100+ Formula and Functions In Excel
  • Charts and Graphs In Excel
  • Create Beautiful Dashboards Including Sales Funnels
  • Pivot Tables and Slicers in Excel
  • Macros In Excel
  • All of our lessons include real life examples so you’ll know how to apply the formula, functions, charts, graphs, pivot tables, macros and more!

NAVIGATION AND FORMATTING TIPS IN EXCEL


Introduction and Course Overview
Common Excel Errors
Copy Vs. Cut
Precedents And Dependents
Group And Ungroup Rows And Columns
Protect Ranges & Worksheets
Screenshots In Excel
Sorting Data
Remove Duplicate Values
Text To Columns
Conditional Formatting

 

FUNCTIONS IN EXCEL


Goal Seek
Data Validation
Scenario Manager
Name Manager
Advanced Filter
Dependable Drop Down Lists
Indirect
Fuzzy Lookup

FORMULA IN EXCEL


UPPER, LOWER, PROPER FORMULA
TRANSPOSE FORMULA
SUMIF FORMULA
COUNTIF FORMULA
AVERAGEIF FORMULA
SUMIFS FORMULA
COUNTIFS FORMULA
AVERAGEIFS FORMULA
SUMPRODUCT FORMULA
INDEX FORMULA
MATCH FORMULA
SUMIF WITH INDEX(MATCH) FORMULA
INDEX(MATCH) and DGET FORMULA
TEXTJOIN FORMULA
MIN, MAX, MEDIAN FORMULA
MINIFS, MAXIFS FORMULA
IF FORMULA
IF(AND) FORMULA
IF(OR) FORMULA
ABSOLUTE FORMULA
ROUND FORMULA
NPV FORMULA
IRR FORMULA
NPV VS. IRR FORMULA
PMT FORMULA
PRINCIPAL PAYMENT (PPMT) FORMULA
APPLICATION OF PMT, IPMT & PPMT FORMULA
IPMT FORMULA
EFFECT FORMULA
DEPRECIATION FORMULA
RATE FORMULA
PV FORMULA
FUTURE VALUE (FV) FORMULA
SLOPE FORMULA
VLOOKUP FORMULA
HLOOKUP FORMULA
OFFSET FORMULA
LEFT, RIGHT FORMULA
COLUMN FORMULA
ROW FORMULA
COLUMNS FORMULA
ROWS FORMULA
FORMULA TEXT FORMULA
COUNTBLANK FORMULA
DMIN FORMULA
DMAX FORMULA
FIXED FORMULA
FIND FORMULA
RAND FORMULA
RANDBETWEEN FORMULA
TRIM FORMULA
RANK FORMULA
CHOOSE FORMULA
CORREL FORMULA
FORECAST FORMULA
FREQUENCY FORMULA
ISNUMBER FORMULA
CONVERT COLUMN TO NUMBER FORMULA
STRIP NON-NUMERIC CHARACTERS FORMULA
SUM OF BOTTON N VALUES FORMULA
CHARTS AND GRAPHS IN EXCEL9 lectures • 2hr 9min
Line Chart
Column Chart
Bar Chart
Timeline Chart
Timeline Gantt Chart
Win/Loss Sparklines Chart
Sales Funnel Chart
Geo Heat Map
Dashboards

 

PIVOT TABLES IN EXCEL


Pivot Tables
Slicers
Pivot Tables – Combining Data From Multiple Sheets
Pivot Tables – Create Report Filter Pages

 

MACROS IN EXCEL


Table Of Contents With Macro
Automate Database Reports (Formula Method)
Automate Database Reports (Record Macro)
Remove Foreign Language Characters
Combine Multiple Workbooks Into A Single Workbook

Leave a Reply

Your email address will not be published.