Course description
Microsoft Excel Introduction - In Company
Unlock the power of Microsoft Excel with our in-company course designed for beginners. This comprehensive introduction to Excel equips your team with essential skills to navigate spreadsheets, input data, and create basic formulas. Our expert trainers ensure an enjoyable learning journey.
Experience the advantages of our on-site Microsoft Excel training. Our dedicated trainer will journey to your offices, providing a full day of immersive learning tailored to your team's needs.
Excel Training | 1 Day Excel Courses | Instructor-led | Group Training
Our Excel Introduction course is perfect for both beginners and those who are self-taught in Microsoft Excel and looking to learn skills that will transform how they work.
Our experienced trainers will guide you through hands-on exercises and real-world examples, so you'll be able to apply what you've learned immediately in the workplace.
After attending this group training, your team will be able to:
- Understand the terminology used in Excel
- Have the knowledge and confidence to navigate around 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
Instructor-led Excel Training Course
- 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.
- 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.
Upcoming start dates
Suitability - Who should attend?
- Our Excel Introduction course is perfect for both beginners and those who are self-taught in Microsoft Excel and looking to learn skills that will transform how they work.
- The purpose of this course is to help staff understand useful features of Excel and become confident with working in and creating spreadsheets.
Prerequisites
- 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.
Outcome / Qualification etc.
By the end of this course, each attendee will: be able to create, modify and format Excel spreadsheets, including designing basic formulas and charts.
- Understand the terminology used in Excel
- Be able to 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
Course delivery details
This Microsoft Excel training is a one-day Instructor-led, on-site course.
Our experienced and friendly trainers are Microsoft Certified with over 10 years of experience. We ensure that the skills are not just taught but are learnt and throughout the day participants will be practicing the skills so they become habits in the workplace.
- All attendees will leave the training feeling much more confident when using the software and have the skills to become much more effective when using Excel.
- Course
Why choose Keys Training
Over 25 years’ experience of delivering quality Microsoft & Business Skills training.
All Trainers are Microsoft Certified or equivalent.
Scheduled Public and Tailored In-house training throughout the UK.
Expenses
£595.00 plus vat (maximum 8 attendees)
As this is an in-house course we include our service of reasonable tailoring of the topics to best meet your needs.
We provide all attendees with:
-
A course completion certificate for their training records
-
Quality reference material for future use and recapping of topics practiced during the training day (PDF document)
Request info
Keys Training
Keys Training® provides a Business Skills Training Service throughout the UK. We specialise in delivering one-day instructor-led courses that cover Microsoft Office and Personal Development Skills. Our training courses can be delivered on your site, at one of our venues...