Spreadsheet Know How

Overview:

This is a foundational CPD course designed for anyone seeking to gain confidence in using Microsoft Excel. Whether you are new to spreadsheets or looking to polish your basic skills, this course covers the essential features of Excel—from navigating cells and applying data formats to saving workbooks, inserting formulas, and using basic functions like SUM and AVERAGE. Participants will also learn file handling, shortcut keys, cell referencing, and worksheet management. Ideal for students, professionals, and entrepreneurs, this course lays the groundwork for mastering more advanced spreadsheet tasks in future.

Course Content:

In this course, you will gain knowledge about the following topics:

• Introduction to Spreadsheet Structure
• Basic Formatting and Data Entry
• Excel Navigation and Shortcuts
• Workbook and File Management
• Worksheet Operations
• Adjusting Spreadsheet Layout
• Basic Formulas and Arithmetic
• Using Built-in Functions

Learning Objectives:

Upon completing this course, you should be able to:

• Understand the structure of Excel spreadsheets including cells, rows, columns, and worksheets
• Navigate Excel efficiently using mouse functions, keyboard shortcuts, and menu commands
• Apply different data formats such as numbers, text, and dates with appropriate formatting techniques
• Manage workbooks and worksheets including saving, renaming, version control, and file formats
• Use essential Excel functions including SUM, AVERAGE, and basic arithmetic operations
• Perform basic file operations including sharing, inserting rows/columns, adjusting widths/heights, and using undo/redo
• Create simple formulas and apply referencing to link cells and automate calculations
• Organise and format spreadsheets for professional appearance and functionality

Who Will Benefit:

• Beginners and New Users of Excel
• Administrative and Office Staff
• Entrepreneurs and Small Business Owners
• Anyone Seeking Practical, Hands-On Excel Skills
• Freshly Qualified Accountants