ExcelReady
CourseFunction guides
0
0

Spreadsheet basics

  • 1Cells, rows and columns
  • 2Select ranges with ShiftFree with account
  • 3Move around the sheetPremium
  • 4Edit, clear and undoPremium
  • 5Your first formulasPremium
  • 6Jump to the edge of your dataPremium
  • 7Fill Down and Fill RightPremium
  • 8Copy, cut and pastePremium
  • 9Formatting shortcutsPremium
  • 10More formattingPremium
  • 11Skill check: basicsPremium

Math & aggregation

  • 12SUM and AutoSumPremium
  • 13AVERAGE, MIN and MAXPremium
  • 14MEDIAN and MODEPremium
  • 15LARGE and SMALLPremium
  • 16COUNT, COUNTA and COUNTBLANKPremium
  • 17ROUND, ROUNDUP and ROUNDDOWNPremium
  • 18Percentages and % changePremium
  • 19Relative vs absolute references ($)Premium
  • 20Debugging SUMPremium
  • 21Practice: department budgetPremium

Logic

  • 22TRUE, FALSE and comparisonsPremium
  • 23The IF functionPremium
  • 24AND, OR and NOTPremium
  • 25Nested IF and IFSPremium
  • 26IS functions and SWITCHPremium
  • 27IFERRORPremium

Conditional math

  • 28COUNTIFPremium
  • 29SUMIFPremium
  • 30COUNTIFS and SUMIFSPremium
  • 31AVERAGEIF, MAXIFS and MINIFSPremium
  • 32Wildcards and cell-based criteriaPremium
  • 33Practice and skill check: summary gridsPremium

Lookups

  • 34VLOOKUP exact matchPremium
  • 35VLOOKUP approximate matchPremium
  • 36VLOOKUP practicePremium
  • 37HLOOKUP for horizontal tablesPremium
  • 38INDEX and MATCHPremium
  • 39INDEX/MATCH skill checkPremium
  • 40XLOOKUPPremium
  • 41XLOOKUP wildcards and match modesPremium
  • 42Fixing lookup errorsPremium

Text

  • 43LEFT, RIGHT, MID and LENPremium
  • 44FIND and SEARCHPremium
  • 45Joining text: &, CONCAT and TEXTJOINPremium
  • 46TEXT and VALUE: numbers to text and backPremium
  • 47Cleaning messy textPremium
  • 48TEXTBEFORE and TEXTAFTERPremium
  • 49Text skill summary: clean a contact listPremium

Dates

  • 50How Excel stores dates: DATE, YEAR, MONTH, DAYPremium
  • 51Days between dates: DAYS, DATEDIF and TODAYPremium
  • 52Renewals and month-ends: EDATE, EOMONTH, WEEKDAYPremium
  • 53Dates in criteria: totals by date range and monthPremium
  • 54Workdays: NETWORKDAYS and WORKDAYPremium
  • 55Date skill summary: gym membershipsPremium

Dynamic arrays

  • 56UNIQUE: list and count distinct valuesPremium
  • 57FILTER: pull matching rows with a formulaPremium
  • 58SORT: order data with a formulaPremium
  • 59Modern Excel: XMATCH, SORTBY, TEXTSPLIT and spill references (A2#)Premium
  • 60Pivot-style summary with formulasPremium

Data tools

  • 61Worksheets and cross-sheet referencesPremium
  • 62Filter a tablePremium
  • 63Conditional formattingPremium
  • 64Pivot tables 1Premium
  • 65Pivot tables 2Premium

Interview drills

  • 66Interview drill: HR rosterPremium
  • 67Interview drill: sales reportPremium
  • 68Case study: real estate listingsPremium
  • 69Case study: hospital admissionsPremium

69 lessons