Basic Microsoft Excel

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.

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

  • Identifying the elements of the Excel interface
  • Navigate and select cells in worksheets
  • Customise the Excel interface
  • Create a basic worksheet
  • Opening and saving
  • Creating Formulas in a worksheet 
  • Insert functions in a worksheet 
  • Copying and pasting formulas
  •  Calculate formulas over multiple sheets 
 
  • Edit worksheet data 
  • Find and replace data
  • Copy, cut, paste and BODMAS (Brackets over Division, Multiplication, Addition and Subtraction)
  • Automatic fill
  • 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
  • Managing worksheets
  • View worksheets and workbooks
  • Define the page layout
  • Print a workbook
  • Printing the same row on each page
  • Printing area
  • Using comments
  • Spelling
  • Automatic word corrections
  • Google sheets
  • Non-accredited: Short course only  
  • Duration: 1h 55m
  • Delivery: Classroom/Online/Blended
  • Access Period: 12 Months 
SpecCon Short Course
Scroll to Top