Level 2 · Intermediate
Excel PowerUp
Intermediate Excel skills
Move from basic to confident. Logic, dates, modern lookups, dynamic arrays, your first query and your first PivotTable.
Log in to open this level
Students log in to see their lessons and progress.
What is inside
1Smarter data entry0/5
- P-1-1Data validation rulesComing soon
- P-1-2Drop-down lists and dependent listsComing soon
- P-1-3Input messages and error alertsComing soon
- P-1-4Validation with formulasComing soon
- P-1-5Named rangesComing soon
2Logic and text0/5
- P-2-1IF, AND, OR and NOTComing soon
- P-2-2IFS, SWITCH and IFERRORComing soon
- P-2-3Cleaning text with TRIM, CLEAN and SUBSTITUTEComing soon
- P-2-4Splitting and joining textComing soon
- P-2-5Text to Columns and Flash FillComing soon
3Dates and times0/5
- P-3-1How Excel stores datesComing soon
- P-3-2TODAY, NOW, DATE, YEAR, MONTH and DAYComing soon
- P-3-3DATEDIF and age calculationsComing soon
- P-3-4WORKDAY, NETWORKDAYS and EOMONTHComing soon
- P-3-5Working with timeComing soon
4Lookups0/5
- P-4-1XLOOKUPComing soon
- P-4-2XMATCH, INDEX and MATCHComing soon
- P-4-3VLOOKUP and HLOOKUP in older filesComing soon
- P-4-4Approximate matches and lookup tablesComing soon
- P-4-5Fixing lookup errorsComing soon
5Conditional summaries0/5
- P-5-1SUMIF and SUMIFSComing soon
- P-5-2COUNTIF and COUNTIFSComing soon
- P-5-3AVERAGEIFS, MAXIFS and MINIFSComing soon
- P-5-4Wildcards and flexible criteriaComing soon
- P-5-5Subtotals and groupingComing soon
6Dynamic arrays0/5
- P-6-1How spilled formulas workComing soon
- P-6-2FILTERComing soon
- P-6-3SORT and SORTBYComing soon
- P-6-4UNIQUE and SEQUENCEComing soon
- P-6-5Combining dynamic array functionsComing soon
7Bringing in data0/5
- P-7-1Importing CSV and text filesComing soon
- P-7-2Get and Transform: your first queryComing soon
- P-7-3Linking to other workbooksComing soon
- P-7-4Refreshing and exporting dataComing soon
- P-7-5Consolidating data from several sheetsComing soon
8PivotTables and quick analysis0/5
- P-8-1Your first PivotTableComing soon
- P-8-2Rows, columns, values and filtersComing soon
- P-8-3Grouping dates and numbersComing soon
- P-8-4Summary statistics: MEDIAN, STDEV and PERCENTILEComing soon
- P-8-5Project: a sales trackerComing soon