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
  • Toggle Between Excel Files
  • Copy, Cut, Paste Special
  • Navigation Tips And Highlighting Data
  • Auto-Sum Adjacent Rows/Columns
  • Create Multiple Rows In A Cell
  • Insert, Delete, Hide, Move Columns
  • Insert, Delete, Hide, Move Rows
  • Datestamp And Timestamp
  • Show Formulas Shortcut
  • Quick Save Shortcut
  • Quick Undo Shortcut
  • Turn Off & On Formula Calculations
  • Hide Excel Sheets & Make Very Hidden
  • Change Window Size
  • Open Duplicate Window
  • Formatting Text
  • Formatting Cells
  • Copy Cell Above Shortcut
  • Find Keywords
  • Navigating Excel Sheet Tabs
  • Modify Multiple Tab Zoom Levels
  • Navigate To A Specific Cell
  • Show The Desktop Shortcut
  • Add & Remove Filters
  • 20+ Formatting Tips
  • 20+ Date Formula
  • Workday Formula
  • 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 EXCEL

  • 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.