This course equips learners with the essential skills to create, format, and manage spreadsheets effectively. It covers key concepts and practical techniques for organizing data, performing calculations, and presenting information using charts and formulas—aligned with the ICDL (International Computer Driving Licence) certification standards.
Learning Outcomes:
Understand key spreadsheet concepts and interfaces
Apply formulas, functions, and cell references
Create and format charts and tables
Organise and analyse data using Excel tools
Key Topics:
Spreadsheet fundamentals and navigation
Functions: SUM, AVERAGE, IF, and more
Charts, filters, and conditional formatting
Data sorting, validation, and protection
ICDL Spreadsheets 365 syllabus alignment
Exam Details
This course is designed to build participants’ understanding of key concepts and domains covered in the ICDL Spreadsheet certification.
Participants will be prepared to attempt the ICDL Spreadsheet certification exam, which assesses foundational spreadsheet skills including formatting, formulas, data entry, and charting.
To maximise success, participants are strongly encouraged to complement the course with additional self-study, revision of course materials, and dedicated practice before attempting the exam.
Module 1. Exploring Microsoft Excel
- Starting Excel
- The User Interface
- The Backstage View
- Excel Options
- Creating a Workbook
- Opening a Workbook
- Saving the Workbook
- Closing the Workbook
- Working with Worksheets
- Using the Ribbon
- Hiding the Ribbon
- Using Zoom Tools
- Closing & Exiting Excel
- Practice - Exploring Microsoft Excel
Module 2. Getting Help
- Using Microsoft Excel Help and Resources
- Working with Excel Help
- Practice - Getting Help
Module 3. Basic Workbook Skills
- Using Keyboard for Selection
- Using GoTo
- Entering Text
- Entering Numbers
- Shortcuts for Data Entry
- Editing Data
- Spell Check
- Creating a New Folder When Saving
- Saving the Workbook with Another File Type
- Practice - Basic Workbook Skills
Module 4. Selection
- Selecting a cell
- Selecting a range of adjacent cells
- Selecting a range of non-adjacent cells
- Selecting the entire worksheet
- Selecting a row
- Selecting a range of adjacent rows
- Selecting a range of non-adjacent rows
- Selecting an entire column
- Selecting a range of columns
- Selecting a range of non- adjacent columns
- Practice – Selection
Module 5. 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 6. Number Formatting
- About Number Formats
- Accounting Number Style
- Percent Style
- Comma Style
- Decimal Places
- Practice – Number Formatting
Module 7. Text Formatting
- Formatting Text
- Changing the Font
- Changing Font Size
- Bold and Italic
- Underlining Text
- Font Color
- Rotating Text
- Text Wrapping
- Cell Alignment
- Apply Table Style
- Practice – Text Formatting
Module 8. Cell Formatting
- Merging Cells
- Vertical Alignment
- Unmerge Cells
- Adding Borders
- Drawing Borders
- Adding Fill Colors
- Format Painter
- Inserting Cut or Copied Cells
- Deleting Cells
- Practice – Cell Formatting
Module 9. Working with Tables
- Adding Table Rows and Columns
- Practice - Working with Tables
Module 10. Formulas
- Using Basic Formulas
- Entering Formulas
- Basic Functions
- Using the AutoSum Button
- Using the AutoSum List
- Using Formula AutoComplete
- Editing Functions
- Using Auto Calculate
- Modifying Formulas using the Range Border
- Error Checking
- Create Absolute Reference
- Using IF Function
- Practice – Basic Formulas
Module 11. Cut, Copy and Paste
- Copying and Pasting Data
- Cutting Data
- Copying Formulas
- Paste Options
- Paste List
- Filling Cells
- Drag-and-Drop Editing
- Undo and Redo
- Practice – Cut, Copy and Paste
Module 12. Data Management
- Sorting
- Finding Data
- Replacing Data
- Finding and Replacing Cell Format
- Practice – Data Management
Module 13. Creating Charts
- Inserting a chart
- Resizing a chart
- Deleting a chart
- Adding a Chart Title
- Changing the Chart Background
- Format chart legend, axis
- Changing a column, bar, line or pie slice colors
- Changing the chart type
- Adding a Data Table
- Changing the Chart Layout
- Moving charts
- Delete chart
- Practice - Creating Charts
Module 14. Using Page Setup
- Worksheet margins
- Worksheet orientation
- Worksheet page size
- Headers and Footers
- Header and footer fields
- Scaling your worksheet to fit a page(s)
- Repeating Row and Column Labels
- Changing Page Breaks
- Setting/Removing a Print Area
- Changing Sheet Options
- Practice - Using Page Setup
Module 15. Printing
- Print Preview
- Printing the Current Worksheet
- Printing a Selected Range
- Printing a Page Range
- Printing Multiple Copies
- Practice - Printing
.png?width=50&name=Artificial%20Intelligence%20(AI).png)
-1.png?width=360&name=Server%20(4)-1.png)
/AI%20(6)-1-1.png?width=360&name=AI%20(6)-1-1.png)
/AI%20(8)-1.png?width=360&name=AI%20(8)-1.png)
-1.png?width=360&name=Automation%20RPA%20(2)-1.png)
/AI%20(5)-1.png?width=360&name=AI%20(5)-1.png)
