Overview
This Excel course provides participants with the essential skills needed to work confidently and efficiently with spreadsheets. The course focuses on improving productivity through the effective use of formulas, formatting tools, keyboard shortcuts, and data management techniques.
Participants will learn how to navigate Excel with ease, understand key terminology, and make full use of the Ribbon, worksheets, and workbooks. The course also covers best practices for organising, analysing, and presenting data to support informed decision-making and professional reporting.
Excel is one of today's most essential business tools. By the end of this course, delegates will be able to work more efficiently, manage data with confidence, and apply practical Excel skills to improve productivity and accuracy in the workplace. Why Should an Individual Attend?
-
Boost Data Confidence: Gain skills to navigate, organize, and analyze data for reporting and decision-making.
-
Master Key Spreadsheet Functions: Use formulas, formatting, shortcuts, and layout tools for daily efficiency.
-
Speak Excel Fluently: Understand ribbons, tabs, worksheets, and more to use the platform with ease.
-
Enable Cross-Functional Excel Proficiency: Harness Excel’s capabilities to streamline data handling across technical, managerial, and support roles.
-
Secure and Showcase Your Data: Ensure data integrity and enhance readability with clean formatting and themed design.
-
Stay ahead with Excel proficiency: An essential tool in today’s tech-driven workplace.
Outcomes
By the end of this course, delegates will be able to:
-
Understand Excel Terminology: Understand the key terms and concepts used in Excel.
-
Work Faster with Shortcuts: Use keyboard shortcuts to improve efficiency and productivity.
-
Navigate Excel with Ease: Edit, format, and navigate spreadsheets with confidence.
-
Master the Ribbon: Quickly locate and use Excel's tools and features.
-
Build an Excel Foundation: Understand workbooks, worksheets, and spreadsheet layouts.
-
Use Essential Excel Tools: Apply core functions such as Copy, Cut, and Paste effectively.
-
Understand Excel's Structure: Recognise how Excel is organised for efficient data management.
Program Outline
Getting Started with Microsoft Office Excel 2019
-
Navigate the Excel User Interface
-
Use Excel Commands
-
Create and Save a Basic Workbook
-
Enter Cell Data
-
Use Excel Help
Performing Calculations
-
Create Worksheet Formulas
-
Insert Functions
-
Reuse Formulas and Functions
Modifying a Worksheet
-
Insert, Delete, and Adjust Cells, Columns, and Rows
-
Search for and Replace Data
-
Use Proofing and Research Tools
Formatting a Worksheet
-
Apply Text Formats
-
Apply Number Formats
-
Align Cell Contents
-
Apply Styles and Themes
-
Apply Basic Conditional Formatting
-
Create and Use Templates
Printing Workbooks
-
Preview and Print a Workbook
-
Set Up the Page Layout
-
Configure Headers and Footers
Managing Workbooks
-
Manage Worksheets
-
Manage Workbook and Worksheet Views
-
Manage Workbook Properties
Customising Excel
-
Use and apply the Quick Access toolbar
-
Understand how to set the option via the “Back Stage “view
Who Should Attend?
-
Engineers
-
Architects
-
Project / Construction Managers
-
Quantity Surveyors
-
Construction Health and Safety
-
Contractors / Sub Contractors
-
Financial Managers and Assistants
-
Executives / Senior Management
-
Middle Management
-
Secretaries and PAs
-
Office Managers
-
Administrative Officers
|
