Microsoft Excel Introduction: In Person Training with Trainers

Unlock the full potential of Excel with our tailored, on-site Introduction course. Our expert Microsoft-certified instructors will come to your office and provide a one-day training session designed to equip your team with the essential skills needed to effectively use Excel.

You'll gain hands-on experience in formatting and manipulating worksheets, including techniques like freezing panes, explore chart creation and formatting. By the end of the course, all attendees will have a solid foundation in Excel and be able to confidently design basic formulas and charts that streamline your team's workflows.

Certificate of completion

Hard copy certificate - Included

By the end of this one-day course, participants will have the knowledge and confidence to navigate around Excel. They will master many of the useful features and understand how to implement them within their roles.

Instructor-led

Keys Training® courses are taught by our experienced Microsoft Certified Trainers. They will ensure that skills and techniques are at the correct pace for the attendees and will show how Excel features can be applied in their roles.

Customisation available

For all our on-site excel courses, we include in our service reasonable course customisation, to ensure the participants learn the skills and features that will most benefit them in their roles within the workplace.

Outcomes

• Understand the terminology used in Excel
• Open, close, save and print Excel worksheets
• Enter, edit and format data
• Use formulas and functions to calculate in Excel
• Create and format a simple chart

Training Course Content

Excel Basics

• Exploring the Excel window
• Spreadsheet terminology
• Opening and Closing workbooks
• Navigating around a worksheet
• Keyboard Shortcuts and Menu Items

Entering and Editing Data

• Creating a new Excel workbook
• Entering and editing labels and values
• Selecting cells and data ranges
• Moving and copying data
• Linking worksheets in a workbook
• Saving and updating a workbook

Formulas and Functions

• Creating new formulas
• Using SUM function
• Using AVERAGE, MIN, MAX and COUNT
• Copying formulas and functions
• Understanding Absolute and Relative references
• Editing formulas and functions

Printing

• Preparing to print
• Page set up options

Formatting and Manipulating Worksheets

• Formatting text
• Formatting rows and columns
• Formatting numbers
• Inserting rows and columns
• Deleting rows and columns
• Freezing panes
• Splitting the screen

Charts

• Creating a simple chart using Chart Wizard
• Formatting a chart

This Excel introduction course is a great course for a group of individuals that are self-taught using the basics but would benefit from learning useful features to work more effectively.

This training course is recommended for teams that are looking to improve their knowledge and skill level when using Excel. The skills learned will help the delegates be more effective and efficient in their roles.

We recommend that all those who attend are able to:

• Participants will need to be familiar with using personal computers and should have experience using a keyboard and mouse.
• We would expect participants to know how to open and close applications.