iCompetent Logo
Classroom · Instructor-ledIT & SoftwareBeginnerCertificate

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. 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. 2

    Foundations

    • Structure and References
    • Essential Functions
    • Absolute and Mixed References Step by Step
    • Counting, Summing and Deciding with Conditions
  3. 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. 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. 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. 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.

Code
Type
Classroom
Modules
6
Skill Level
Beginner
Language
EN
Max Students
20
Certificate
Yes
Assessment
No

Prefer to learn at your own pace?

The same subject as an online course you can start today.

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
Image for the book now section

Get a quote