stylus

productivity through technology

Microsoft Excel

This page aims to organise and group all the Microsoft Excel-related posts on the blog and additional resources for learning Excel.

  1. Terminology
  2. Functions
  3. By menu ribbons
  4. By tags
  5. Extra resources

1. Terminology

Start by learning all the terminology: it will be far easier to learn Excel if you know:

2. Functions

Once you are comfortable using the interface, you are ready to learn Excel’s many functions: Mastering Excel functions.

Here are lists of the functions students must tackle for:

3. By menu ribbons

  • File
  • Home
  • Insert
  • Page Layout
  • Formulas
  • Data
  • Review
  • View
  • Automate
  • Developer
  • Help

4. By tags

AVERAGE()COUNT()COUNTA()COUNTBLANK()COUNTIF()COUNTIFS()ExcelExcel 2016Excel ChartExcel tutorialIFMicrosoft ExcelMODE()nested IFVBA for Excel

5. Extra resources

5.1 Cambridge International AS Level

If you are working from Hodder Education’s Information Technology textbook, the files are available here: Cambridge International Extras for Primary to A-Level (hoddereducation.com).