Skip to content
Excel (Basic)
Module 1: Getting Started with Excel
Collapse
Module 1: Getting Started with Excel
4 Topics
Lesson 1: What is Excel and How is it Used
Lesson 2: Exploring the Excel Interface
Lesson 3: Creating, Saving, and Naming a Workbook
Lesson 4: Navigating and Managing Worksheets
Module 2: Entering and Editing Data
Expand
Module 2: Entering and Editing Data
5 Topics
Lesson 1: Typing and Organising Data in Cells
Lesson 2: Editing, Deleting, and Replacing Data
Lesson 3: Formatting Data for Clarity and Consistency
Lesson 4: Undo, Redo, and Basic Shortcuts
Lesson 5: Using AutoFill and Flash Fill
Module 3: Formatting for Readability
Expand
Module 3: Formatting for Readability
4 Topics
Lesson 1: Formatting Text, Numbers, and Currency
Lesson 2: Aligning Content and Adjusting Cell Size
Lesson 3: Adding Borders, Shading, and Styles
Lesson 4: Clearing Formatting and Starting Fresh
Module 4: Working with Formulas and Functions
Expand
Module 4: Working with Formulas and Functions
4 Topics
Lesson 1: Writing Basic Formulas (Add, Subtract, Multiply, Divide)
Lesson 2: Using Built-in Functions (SUM, AVERAGE, MIN, MAX)
Lesson 3: Copying and Extending Formulas with AutoFill
Lesson 4: Understanding Cell References (Relative and Absolute)
Module 5: Charts, Sorting, and Printing
Expand
Module 5: Charts, Sorting, and Printing
4 Topics
Lesson 1: Sorting and Filtering Data for Clarity
Lesson 2: Creating Simple Charts from Your Data
Lesson 3: Customising and Formatting Charts
Lesson 4: Page Setup, Printing, and Exporting Your Workbook
Activity Workbook
Additional Resource
Final Assessment
Previous Topic
Next Topic
Lesson 3: Creating, Saving, and Naming a Workbook
Excel (Basic)
Module 1: Getting Started with Excel
Lesson 3: Creating, Saving, and Naming a Workbook
Watch the Video Below
Overview
In this lesson, you have learn how to create a new Excel file (called a workbook), give it a name, and save it to avoid losing your work. Understanding how to manage your files is one of the first steps toward becoming confident in Excel.
Key Things Learned
How to open a new blank workbook
How to name and save your file
Where to find Save and Save As options
Tips on keeping your work backed up and organised
Refer to the Image Below
Previous Topic
Back to Lesson
Next Topic