Skip to content

Non-accredited short course

Microsoft Excel 365 Intermediate

Excel users comfortable with data entry, formatting and basic formulas.

Programme information

Microsoft Excel 365 Intermediate

Short course · Digital skills and AI

Entry Requirements

Recommended: Excel 365 Basic or equivalent skills in data entry, formatting and simple formulas. Use Microsoft Excel 365 for practice.

Course Outline and Delivery

Practical outcome. Build a monthly sales report with formulas, a PivotTable and a chart.

On-site, live online or blended · 2 training days Self-paced online · 16 study hours

What you’ll learn

  1. Relative and absolute references
  2. Conditional formulas and lookups
  3. Tables, sorting and filtering
  4. Data validation and conditional formatting
  5. PivotTables and charts

Assessment and Completion

Practise relative and absolute references, conditional formulas, lookups and PivotTables. Check the accuracy of your calculations and summaries before sharing your workbook.

Practical task. Analyse monthly sales in an editable workbook and create a PivotTable and chart to explain the results.

Completion and recognition

Submit the monthly sales workbook with working formulas, a PivotTable and chart, and explain two findings. Finweb issues a Certificate of Attendance to learners who meet the attendance requirements.

Start typing to search the site.
↑ ↓ to move · Enter to open · Esc to closeSee all results →

Necessary Cookies — Always Active

On

These support essential website functions and cannot be switched off here.

Optional analytics is not enabled. There are no optional analytics cookies to accept.

You can change your choices later using Cookie Settings in the footer.