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