Microsoft Excel for Work: Formulas, Tables and Reports

What you will be able to do

By the end of this course you will be able to:

Enter, format and organise data properly
Write formulas with relative and absolute references
Use IF, COUNTIF, SUMIF and their multi-criteria versions
Look up values with XLOOKUP and VLOOKUP
Summarise data with Excel Tables and PivotTables
Present results with clear charts

Course content

3 sections · 11 lessons · 2 h 42 min total · lessons open when you enrol

Excel basics2 lessons · 18 min

Welcome and a tour of the workbook 8 min

Entering and formatting data the right way 10 min

Formulas and functions4 lessons · 44 min

Formulas and cell references 12 min

IF, COUNTIF and SUMIF 12 min

Looking up values: XLOOKUP and VLOOKUP 12 min

Quiz: formulas 8 min

Analysing and presenting5 lessons · 1 h 40 min

Excel Tables, sorting and filtering 10 min

PivotTables 14 min

Charts that communicate 10 min

Quiz: analysis 6 min

Final task: build a monthly sales report 60 min

About this course

Excel is still the most widely used data tool in offices, NGOs, schools and businesses. This course focuses on the skills that save the most time at work: reliable formulas, lookups, tables, PivotTables and clear charts.

You will practise on a sales and inventory workbook and finish by building a monthly report. Everything works in Excel 2016 or later, Microsoft 365, and most of it in Google Sheets.

Requirements

Microsoft Excel (2016 or later / Microsoft 365) or Google Sheets
Basic computer skills

Who this course is for

Office administrators and secretaries
Small business owners
Students preparing for work

Your instructor

JL

Joseph M. Lamin

Software developer and health-informatics researcher based in Bo, Sierra Leone. Teaches and supervises research at Njala University School of Public Health and builds health, school and business information systems.

Learner reviews

No reviews yet. Learners can review a course once they have started it.