FreeBeginner

Excel for Data Analysis

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 lessons
Final project
Certificate of completion

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.30 min
03Sorting and FilteringFind the rows that matter with multi-level sorts, filters, SUBTOTAL and the FILTER function.25 min
04Formulas and FunctionsHow formulas work, relative and absolute references, the core functions, and how to read Excel's error messages.35 min
05IF, SUMIF, COUNTIFMake decisions inside formulas with IF, and total or count only the rows that meet conditions with SUMIFS and COUNTIFS.35 min
06XLOOKUPBring columns from one table into another with XLOOKUP, and recognise VLOOKUP and INDEX/MATCH in older files.35 min
07Data CleaningClean a real messy export with TRIM, PROPER, SUBSTITUTE, VALUE, Remove Duplicates, a mapping table and Power Query's locale-aware dates.45 min
08Pivot TablesSummarise thousands of rows in seconds - by region, month, channel or rep - with pivot tables, grouping, percentages and slicers.40 min
09Charts and VisualizationBuild clear line, bar and combo charts from pivot tables, and use conditional formatting and sparklines to make tables readable.35 min
10Building an AnalysisOrganise a workbook someone else can trust - raw data, calculations, checks and a one-page summary - and compare periods properly.40 min
11Mini ProjectA guided analysis of Kolanut's discounts from question to recommendation, using everything in the course.45 min

Loading…