Course Overview
This beginner-level course is designed to introduce you to the fundamentals of Microsoft Excel 2016. You’ll learn how to create and manage basic spreadsheets, enter and format data, apply simple formulas, and present your information clearly using charts and print settings. Whether for study, work, or personal use, this hands-on course gives you practical skills to get started with confidence.
Ideal for students or anyone needing to perform basic data tasks in Excel, the course provides a solid foundation in spreadsheet use for everyday needs.
By the end of the course, you’ll be able to:
- Find Your Way Around Excel: Get familiar with the interface, workbook structure, and key tools like the Ribbon and Quick Access Toolbar.
- Work with Data: Enter and edit text, numbers, and dates in a worksheet; save and open files using appropriate formats.
- Use Formulas and Functions: Perform basic calculations and use built-in functions like SUM, AVERAGE, MIN, MAX, and COUNT.
- Format Your Workbook: Apply cell formatting such as fonts, colours, alignment, number styles, and conditional formatting to improve readability.
- Manage Lists and Tables: Sort and filter data, apply data validation, and remove duplicates.
- Create Visuals: Build and customise simple charts to display your data clearly and professionally.
- Prepare to Print and Share: Set up pages, adjust print settings, and share your spreadsheets via email or cloud services.
- Explore Advanced Features (Intro Level): Get a taste of more advanced tools like PivotTables, basic macros, and formulas such as IF and VLOOKUP.
- Save Time and Work Smarter: Learn handy keyboard shortcuts, understand common errors, and personalise your Excel experience.
Curriculum
- 1 Section
- 4 Lessons
- 1 Day
Expand all sectionsCollapse all sections
- Module 1: Introduction to ExcelOverview of Excel: What is Excel, its uses, and benefits.4
- 1.1Excel Interface: Understanding the Ribbon, Quick Access Toolbar, and Workbook views.
- 1.2Navigating Worksheets: Moving around cells, rows, columns, and worksheets.
- 1.3Basic Data Entry: Entering text, numbers, and dates into cells.
- 1.4Saving and Opening Workbooks: File formats, saving locations, and version compatibility.
Instructor
