Foundational Excel skills are essential in any digital workplace. This course introduces participants to core spreadsheet functions, enabling them to manage data, apply essential formula, and operate confidently in Excel 365.
Learning Outcomes:
Navigate Excel's interface and use spreadsheet tools efficiently
Perform calculations using basic formulas and functions
Create and format tables and charts to present data
Organise and edit workbook content effectively
Key Topics:
Cell referencing and basic arithmetic functions
Table creation and formatting techniques
Workbook saving, printing, and sharing options
Module 1. Basic Workbook Skills
- Using Tell Me feature
- Using GoTo
- Entering Text
- Entering Numbers
- Saving the Workbook
- Creating a Workbook
- Shortcuts for Data Entry
- Editing Data
- Copying and Pasting Data
- Use Undo and Redo
- Spell Check
- Insert Comment
- Practice - Basic Workbook Skills
Module 2. Selection
- Selecting a cell
- Selecting a range of contiguous cells
- Selecting a range of non-contiguous cells
- Selecting the entire worksheet
- Selecting a row
- Selecting a range of contiguous rows
- Selecting a range of non- contiguous rows
- Selecting an entire column
- Selecting a range of columns
- Selecting a range of non- contiguous columns
- Practice – Selection
Module 3. Working with Columns and Rows
- Adjusting the Column Width
- Adjusting the Row Height
- Automatically Adjusting Columns
- Hiding and Un-hiding Rows and Columns
- Inserting Columns and Rows
- Deleting Columns and Rows
- Freezing and Unfreezing Columns and Rows
- Practice - Working with Columns and Rows
Module 4. Number Formatting
- About Number Formats
- Accounting Number Style
- Percent Style
- Comma Style
- Decimal Places
- Practice – Number Formatting
Module 5. Text Formatting
- Formatting Text
- Changing the Font
- Changing Font Size
- Bold and Italic
- Underlining Text
- Font Color
- Rotating Text
- Text Wrapping
- Shrinking Text
- Cell Alignment
- Indenting Text
- Practice – Text Formatting
Module 6. Cell Formatting
- Merging Cells
- Vertical Alignment
- Splitting Cells
- Adding Borders
- Adding Fill Color to Cells
- Pasting Formats
- Format Painter
- Copying Formats using Auto Fill
- Clearing Formats
- Practice – Cell Formatting
Module 7. Basic Formulas
- Using Basic Formulas
- Entering Formulas
- Basic Functions
- Using the AutoSum Button
- Using the AutoSum List
- Editing Functions
- Using Auto Calculate
- Filling Cells
- Practice – Basic Formulas
Module 8. Using Page Setup & Printing
- Worksheet margins
- Worksheet orientation
- Worksheet page size
- Headers and Footers
- Repeating Row and Column Labels
- Changing Page Breaks
- Setting/Removing a Print Area
- Changing Sheet Options
- Print Preview
- Printing the Current Worksheet
- Printing a Selected Range
- Printing a Page Range
- Printing Multiple Copies
- Practice – Page Setup & Printing
