Excel Formulas in 7 Lessons

£2.99

Excel Formulas in 7 Lessons

A calm, practical course that takes you from your first =SUM to confident XLOOKUPs, one small skill at a time. Each lesson has worked examples from small UK businesses, a clear action task and two workbook pages, and a ready-made sales log and price list lets you practise on realistic data. The lessons - Lesson 1: How Formulas Work - Lesson 2: SUM, AVERAGE and COUNT - Lesson 3: Copying Formulas Safely - Lesson 4: Decisions With IF - Lesson 5: Totals by Category - Lesson 6: Lookups With XLOOKUP - Lesson 7: Text, Dates and Errors Includes - 49 course slides as PowerPoint and PDF, with notes for every slide - 15-page fillable workbook (type into it or print it) - Excel tracker: Sales Log, Prices, Formula Practice - 30-day plan as a spreadsheet tab and a printable page By the end you will - Write formulas from scratch and read other people's - Total, average and count data with the right…

More like this