Basic Microsoft Excel - Online Short Course
This course forms part of foundational digital skills training essential for workplace readiness and productivity. Whether you’re a student, job seeker, or working professional, this course is designed to equip you with practical spreadsheet skills for everyday business use. It supports career development and improves efficiency in roles that involve data entry, calculations, reporting, and administrative tasks.
Unlock the power of spreadsheets with hands-on training in Microsoft Excel. This beginner-friendly course teaches you how to navigate Excel, create and format worksheets, use formulas and functions, and organize data with charts and tables. Whether you’re managing budgets, tracking performance, or analyzing basic data, this course gives you the foundational skills to get started confidently.
Perfect for anyone looking to boost productivity, improve job readiness, or gain a valuable digital skill used in nearly every office and business environment.
What is Basic Microsoft Excel?
Microsoft Excel is a powerful spreadsheet program used to store, organize, and analyze data. In this course, you’ll learn:
Excel interface and ribbon navigation
Entering and formatting data in cells
Creating basic formulas and using common functions (SUM, AVERAGE, COUNT)
Sorting and filtering data
Inserting charts and tables
Saving, printing, and sharing Excel documents
You’ll also explore practical use cases for budgeting, tracking expenses, and building simple reports that can be used in personal, academic, or professional settings.
Who Should Take This Course?
This course is ideal for:
Students and job seekers needing digital skills
Office workers and admin staff
Small business owners and freelancers
Teachers, educators, and trainers
Anyone new to Microsoft Excel or self-taught users looking to fill knowledge gaps
By the end of this course you’ll be able to use Excel confidently for daily tasks, improve your digital literacy, and build a strong foundation for advanced Excel topics like pivot tables, macros, and data analysis. This is the perfect first step toward becoming proficient in one of the world’s most in-demand office tools.
Description
Alternatively referred to as a worksheet, a spreadsheet is a file that consists of rows and columns to help sort data, arrange data easily, and calculate numerical data. What makes a spreadsheet software program unique is its ability to calculate values using mathematical formulas by applying them to the data in cells. A good example of how a spreadsheet may be utilised is by creating an overview of your bank balance. Excel allows you to store, organise, and analyse information quickly and efficiently. In this lesson, you will learn how to find your way around the Excel 2010 environment, including the new Backstage view, replacing the Microsoft button menu version of 2007. In addition, you will learn how to use and modify the Ribbon and the Quick Access Toolbar and how to create new as well as open existing workbooks.
Course Content
Unit 1: Getting started
- Identifying the elements of the Excel interface
- Navigate and select cells in worksheets
- Customise the Excel interface
- Create a basic worksheet
- Opening and saving
Unit 2: Performing calculations in an excel worksheet
- Creating Formulas in a worksheet
- Insert functions in a worksheet
- Copying and pasting formulas
- Calculate formulas over multiple sheets
Unit 3: Modifying an excel worksheet
- Edit worksheet data
- Find and replace data
- Copy, cut, paste and BODMAS (Brackets over Division, Multiplication, Addition and Subtraction)
- Automatic fill
Unit 4: Modifying the appearance of a worksheet
- Apply font properties
- Add borders and colours to cells
- Align content in a cell
- Apply number formatting
- Apply cell styles
- Adjust the row height and column width
- Insert and delete rows and columns
Unit 5: Managing an excel workbook
- Managing worksheets
- View worksheets and workbooks
Unit 6: Printing excel workbooks
- Define the page layout
- Print a workbook
- Printing the same row on each page
- Printing area
Unit 7: Other functions
- Using comments
- Spelling
- Automatic word corrections
Unit 8: Google sheets
- Google sheets
Accreditation
- Non-accredited: Short course only
- Duration: 1h 55m
- Delivery: Classroom/Online/Blended
- Access Period: 12 Months
