Microsoft Basic Excel (Based on AdventureWorks)

You are the analyst at AdventureWorks, a bicycle manufacturer selling through stores all over the world. Every week the sales team logs thousands of orders, and the raw numbers are piling up across seven worksheets - Customer, Date, Product, Reseller, Sales, SalesOrder and SalesTerritory. Your mission is to turn those 121,000+ rows of raw sales data into clear, decision-ready information: format it as a proper table, sort and filter it, add up the sales, classify every sale, chart the results and summarise everything in a PivotTable. This beginner Excel course covers the Excel screen, worksheet structure, formatting, sorting and filtering, formulas and functions, the IF function, charts, and an introduction to PivotTables.