Spreadsheets for Business
Practical spreadsheet skill for analysis and reporting, using Excel conventions that apply equally in Google Sheets and LibreOffice. Covers structure and references, the essential function set, lookups and logic, tables, pivot tables and charts, data cleaning, and building models that other people can trust and audit.
- Modules
- 6
- Max students
- 20
- Language
- EN
What it usually covers
- 1
Getting Started with Spreadsheets
- Finding Your Way Around a Workbook
- Entering and Editing Data
- Your First Formulas
- Selecting, Copying and Filling
- Saving Files, Formats and Versions
- 2
Foundations
- Structure and References
- Essential Functions
- Absolute and Mixed References Step by Step
- Counting, Summing and Deciding with Conditions
- 3
Sorting, Filtering and Formatting Data
- Sorting Data Safely
- Filtering to Find What You Need
- Number and Date Formats
- Conditional Formatting Basics
- Data Validation and Drop-Down Lists
- 4
Lookups, Tables and Analysis
- Lookups and Data Cleaning
- Tables, Pivot Tables and Charts
- Looking Up Values Step by Step
- Building Your First Pivot Table
- 5
Models, Quality and Sharing
- Building a Model
- Quality, Auditing and Sharing
- A Simple Budget Model, Built Step by Step
- Printing and Exporting a Sheet
- 6
Putting It Together
- Case: Cleaning and Summarising a Sales Export
- Case: A Team Expense Tracker
- Common Spreadsheet Mistakes and How to Fix Them
- Good Spreadsheet Habits and Next Steps
This page describes what the training usually covers. Each training provider may change the content, the length and the order to suit the group. Confirm the final content with the training provider before you book.
Prefer to learn at your own pace?
The same subject as an online course you can start today.

Spreadsheets for Business
3 h 59 min
More in IT & Software
Other courses with a trainer in the same subject area.
Reviews
What learners say about Spreadsheets for Business.
No reviews yet
Be the first to say what Spreadsheets for Business was like.
Sign in to write one. We check every review before it is shown.
Book Now
Is it what you were looking for?
Contact our team to check the course and seat availability in your preferred location
Book Now

