Microsoft Excel Introduction is the perfect course for beginners in Excel who are looking to build a strong foundation in data management and analysis. In today's fast-paced work environment, Excel proficiency is a must-have skill for professionals in every industry. Our one-day program is specifically tailored to empower beginners with the essential knowledge and expertise to confidently navigate Excel.

This program introduces good practice habits including formula construction, where participants will learn to build formulas in a clear and logical manner, avoiding common pitfalls that can lead to errors. Participants will also be introduced to time-saving shortcuts and tips that professionals rely on to work efficiently in Excel.

Through this course participants will develop the skills and knowledge to:

• Navigate the Excel interface, utilising menus, ribbons, and shortcuts to access and execute various functions and commands effectively
• Input, edit, and format data effectively within Excel worksheets, ensuring accuracy and clarity in data representation
• Create charts and graphs including selecting appropriate chart types and formatting charts
• Adopt good practice habits in Excel, demonstrating the capability to organise data logically and employ time-saving techniques to enhance productivity and accuracy in Excel workflows.

Introduction to Excel Basics

• Detailed look at Excel’s workspace including Ribbon, Quick Access Toolbar, and other interface elements
• 3 methods of moving around a worksheet
• 3 methods of entering data into a worksheet

Saving and Managing Excel Files

Basic Cell Operations

• Different methods of highlighting
• 3 methods of editing a cell
• Deleting the contents of a cell

Printing

• Using print preview
• Printing selected areas in a worksheet
• Changing the page orientation
• Margins
• Scaling

Cut, Copy and Paste

• Cut and paste
• Copy and paste

Formatting and Adjusting Cells

• Shortcut in increasing the column width
• Functions of formatting buttons in the ribbon
• Wrapping Text
• Angling Text

Worksheet Management

• Renaming worksheets
• Inserting worksheets
• Deleting worksheets
• Moving worksheets

Filling cells

• Autofill
• Sequential Fill
• Formatting the date

Creating Formulas

• Formulas
• Relative addressing
• Autosum

Functions

• Averages
• Maximums
• Minimums

Formatting a Worksheet

• Add a header and footer
• Manual page breaks

Creating a Chart

• Create a chart/graph
• Format a chart/graph
• Creating Pie Chart

Questions, Reflection and Actions

Costs and group size may vary.

Minimum group size: 10

Maximum group size: 16

N/A