What’s Included in Our Basic Microsoft Excel Course?
- 7 days ago
- 2 min read
Excel is one of the most widely used workplace tools across council services, administration, finance, HR, and project management.
Our Basic Excel Course is designed for complete beginners or anyone who uses Excel but has never had formal training.
This course builds strong foundations so you can work confidently, accurately, and efficiently in Excel.
Who Is This Course For?
This course is ideal if:
You are new to Excel
You only use Excel for simple typing
You rely on others to create formulas for you
You feel unsure about formatting or calculations
You want to improve your workplace confidence
If you already use formulas, PivotTables, or lookups regularly, you may be better suited for our Intermediate course.
What You Will Learn
Below is a full overview of the syllabus so you can assess your current level.
1️⃣ Introduction to Excel & Understanding the Interface
What a workbook and worksheet are
Navigating rows, columns, and cells
Understanding the Ribbon and key tools
Moving around a spreadsheet efficiently
2️⃣ Entering and Editing Data
Inputting text, numbers, and dates
Editing existing data
Using AutoFill
Copying and pasting correctly
3️⃣ Formatting Spreadsheets Professionally
Adjusting column widths and row heights
Formatting numbers (currency, percentages, dates)
Using bold, borders, and shading
Creating clear, readable tables
4️⃣ Basic Formulas
Understanding cell references
Creating simple calculations
Adding, subtracting, multiplying, and dividing
Understanding how Excel updates automatically
5️⃣ Essential Functions
SUM
AVERAGE
MIN
MAX
You will learn when and why to use each one.
6️⃣ Sorting and Filtering Data
Sorting data alphabetically or numerically
Filtering data to show specific information
Converting data into a Table
7️⃣ Creating Simple Charts
Creating column and pie charts
Editing chart titles
Presenting data visually
8️⃣ Saving, Printing & Best Practice
Saving correctly
Naming files professionally
Print preview and page setup
Preparing spreadsheets for sharing
What You Will Be Able To Do After This Course
By the end of the course, you will be able to:
✔ Create a structured spreadsheet from scratch
✔ Perform basic calculations confidently
✔ Format data professionally
✔ Create simple charts
✔ Organise data using sorting and filtering
✔ Prepare a spreadsheet for printing or sharing
💡 Do You Need This Course?
You likely need this course if:
You don’t feel confident creating formulas
You avoid using Excel where possible
You manually calculate totals instead of using formulas
Your spreadsheets often look unstructured
If you already know and confidently use everything listed above, you may be ready for the Intermediate Excel Course instead.
Comments