Basic Microsoft Excel Online Short Course

Overview

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.

In this Basic Microsoft Excel online course, you will learn the essentials of navigating Excel, including organizing and sorting data, using formulas, and performing calculations. Discover how to use Excel’s powerful features to manage and analyze data efficiently. This course covers the basics of the Excel 2010 environment, the updated Backstage view, the Ribbon, and the Quick Access Toolbar. You will also learn how to create new workbooks and open existing ones, providing a solid foundation to boost your productivity and data management skills.

Whether you’re new to Excel or need to refresh your skills, this course will guide you through key concepts, helping you build confidence in using Excel for both personal and professional tasks. By the end, you’ll be equipped to tackle everyday data management tasks with ease.

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 
Scroll to Top