Excel is still where most business analysis happens. Learn to work with real datasets: sort and filter, write the formulas analysts use every day, clean messy data, summarise with pivot tables and present results with clear charts.
About 9 hours
11 modules
1 badge
Final project
Optional verified certificate
Curriculum
01Excel for AnalystsWhy Excel is still where most analysis happens, the parts of the screen you'll use, and the shortcuts that save hours.20 min
02Working with DataImport a CSV safely, check data types, and add your first calculated column to a Table.20 min
03Sorting and FilteringSort by one or several columns, filter by values, numbers, dates and text, total only the visible rows with SUBTOTAL, and build live filtered lists with FILTER and SORTBY.25 min
04Formulas and FunctionsWrite formulas, lock references with $, and use SUM, AVERAGE, MEDIAN, COUNT, ROUND, date functions and UNIQUE, step by step, with every error value explained.30 min
05IF, SUMIF, COUNTIFMake decisions with IF, AND, OR and IFS, then count, total and average only the rows you want with COUNTIFS, SUMIFS, AVERAGEIFS and MAXIFS, step by step.30 min
06XLOOKUPBring details from one table into another with XLOOKUP, put values into bands, spot why a lookup fails, and read VLOOKUP and INDEX/MATCH in older files.20 min
07Data CleaningFind and fix messy data step by step: TRIM, CLEAN, PROPER, SUBSTITUTE, VALUE, LEFT and RIGHT, mapping tables, Remove Duplicates and day-first dates.30 min
08Pivot TablesSummarise thousands of rows in seconds with pivot tables: the four areas, sum, count and average, percentages and growth, date grouping, top N, slicers and refreshing.30 min
09Charts and VisualizationChoose the right chart for the question, build line, bar, stacked and combo charts and PivotCharts, fix Excel's defaults, and make tables readable with conditional formatting and sparklines.20 min
10Building an AnalysisOrganise a workbook someone else can trust - raw data, calculations, checks and a one-page summary - and compare periods properly.15 min
11Mini ProjectA guided analysis of Kolanut's discounts from question to recommendation, using everything in the course.15 min
Final assessmentPass it (60% or more) to earn the Excel for Data Analysis course completion badge.