Microsoft Excel: The Basics
This short course takes you from a blank workbook to a well-organised spreadsheet with working formulas, sorted and filtered data, a simple chart and a sensible print layout. It focuses on habits that keep your figures accurate and easy for colleagues to follow. Independent training; not affiliated with or endorsed by Microsoft.
- Modules
- 3
- Duration
- About 25 minutes
- Pass mark
- 80%
- Assessment
- 8 questions from a bank of 12
Learning outcomes
- ✓Describe how workbooks, worksheets, cells, rows and columns fit together
- ✓Enter and format data so that it is clear and consistent
- ✓Write formulas using cell references and common functions such as SUM, AVERAGE, COUNT, MIN and MAX
- ✓Explain the difference between relative and absolute cell references
- ✓Sort and filter data, create a simple chart and freeze panes
- ✓Prepare a spreadsheet for printing and sharing, and check it for formula errors
Course contents
-
Module 1: Finding Your Way Around
Video (4 scenes) · 1 lessons · 2 practice questions
-
Module 2: Formulas and Functions
Video (4 scenes) · 2 lessons · 2 practice questions
-
Module 3: Organising, Presenting and Sharing
Video (4 scenes) · 2 lessons · 2 practice questions
-
Final assessment & certificate