Excel

The spreadsheet every office runs on: formulas, functions, lookups, formatting, charts and PivotTables. 18 modules of 10 minutes each, with questions that check your answers in the browser.

Start the track

Foundations

• 1. Excel basics: workbooks, cells, ranges and syntaxFree
  What a spreadsheet is, how Excel names every cell, how to type values and your first formula, and how ranges like B2:C6 select a block of cells.
• 2. Filling, moving, adding and deleting cellsFree
  Copy a formula down a whole column with the fill handle, build number series, move and insert cells without breaking formulas, and recognise the #REF! error when you delete too much.
• 3. Formulas, arithmetic operators and parenthesesFree
  Add, subtract, multiply, divide, raise to a power and take percentages; learn the order Excel calculates in, use parentheses to change it, and recognise #DIV/0! and #VALUE!.
• 4. Relative and absolute referencesFree
  Understand why filled formulas shift, lock a reference with $ so it always points at the same cell, and use mixed references like $A2 and B$1 to fill a whole table from one formula.
• 5. Your first functions: SUM, AVERAGE, MIN, MAX and COUNTFree
  How functions work, the five you'll use every day (SUM, AVERAGE, MIN, MAX, COUNT), their cousins COUNTA and COUNTBLANK, and how they treat empty cells and text.

Intermediate

• 6. Logic: IF, IFS, AND, OR, XOR and IFERRORFree
  Ask Excel yes/no questions, make a formula pick one answer or another with IF, handle several cases with IFS, mix conditions with AND, OR, XOR and NOT, and swap expected errors for something nicer with IFERROR.
• 7. Conditional totals: COUNTIF, SUMIF, AVERAGEIF and their S versionsFree
  Count, add and average only the rows that match a condition, write criteria like ">=10", "<>Food" and "Kopi*", and combine several conditions with COUNTIFS, SUMIFS and AVERAGEIFS.
• 8. Text functions: LEFT, MID, TRIM, CONCAT and moreFree
  Cut text apart with LEFT, RIGHT, MID and LEN, clean it with TRIM, PROPER, UPPER, LOWER and SUBSTITUTE, and glue it together with &, CONCAT and TEXTJOIN.
• 9. Formatting: fonts, colours, borders and number formatsPro
  Make a sheet readable with fonts, fill colours, borders and the Format Painter; show numbers as currency, percentages and dates with number formats; and use TEXT to format numbers inside text.
• 10. Lookups: VLOOKUP, XLOOKUP, INDEX and MATCHPro
  Fetch a value from another table by its key with VLOOKUP and HLOOKUP, do it more safely with XLOOKUP, use approximate matches for price bands, and combine INDEX and MATCH for lookups in any direction.

Advanced

• 11. Sorting, filtering and tablesPro
  Sort by one or several columns, filter rows with AutoFilter, turn a range into an Excel Table with banded rows, a total row and structured references, and remove duplicate rows.
• 12. Dynamic arrays: SORT, FILTER and UNIQUEPro
  Write one formula that returns a whole list which spills into the cells below, with UNIQUE, SORT, SORTBY and FILTER; refer to a spilled list with the # sign; and fix the #SPILL! error.
• 13. Conditional formattingPro
  Colour cells automatically by their values with Highlight Cell Rules, Top/Bottom rules, Data Bars, Colour Scales and Icon Sets; write your own rules with formulas; and manage the order of rules.
• 14. ChartsPro
  Pick the right chart for the question (column, bar, stacked, line, pie, radar), insert one from a range, customise titles, labels, axes and colours, and prepare clean chart data with formulas.
• 15. PivotTablesPro
  Summarise thousands of rows in seconds with a PivotTable: drag fields into Rows, Columns, Values and Filters, change Sum to Count or % of total, group dates, add calculated fields and PivotCharts, and rebuild the same summary with formulas.

Expert

• 16. Statistics and maths: MEDIAN, MODE, STDEV, ROUND and SUMPRODUCTPro
  Describe a column of numbers with MEDIAN, MODE and the standard deviation (STDEV.S vs STDEV.P), round properly with ROUND, ROUNDUP and ROUNDDOWN, multiply-and-add with SUMPRODUCT, and generate random numbers with RAND.
• 17. Dates, times and money: DATEDIF, NETWORKDAYS and NPVPro
  Work with dates and times as the numbers they really are; use TODAY, DATE, DATEDIF and NETWORKDAYS; calculate hours worked and convert times to seconds; and judge an investment with NPV.
• 18. Case study: a store report from raw dataPro
  Turn a raw order export and a price list into a finished one-page report: look up prices and categories, compute line totals, build KPIs and a category summary, find the best seller, and style it for readers.

Track project

• Excel Project: Toko Kita's stock sheetPro
  Four graded tasks on one real stock sheet. Work out stock value and margins, flag what needs reordering, build a lookup box the team can type into, and summarise every category with formulas that update themselves.

Pro modules unlock with one payment of Rp 149.000, yours to keep.