Course description
Microsoft Excel Introduction - Classroom
Excel Training | 1 Day Excel Courses | Instructor-led
This Excel Introduction course is designed to teach the basic skills needed to use Microsoft Excel effectively in the workplace. Ensuring all attendees are confident using the useful features.
- 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.
- 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.
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.
Excel Introduction - Course Objectives:
- 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
Upcoming start dates
Suitability - Who should attend?
This training course has been created to help staff understand the features of excel and become familiar with key areas of this software.
This training is suitable for anyone who is looking to take their Excel skills to the next level. If they currently don't have a great understanding of the different features in this spreadsheet software, and how the features can save them time, then this course may be exactly what they are looking for!
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 training is a one-day Instructor-led, classroom based 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.
- Courses usually run from 9:30 am to 4:30 pm, with scheduled breaks throughout the day.
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.
Reviews
Average rating 5
Super helpful, explained everything in good detail and when we asked questions he was able to answer and solve each one
Christine was very knowledgeable on the subject
Expenses
£195.00 (per participant)
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)
Get Inspired! Watch the Video
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...
Good training as it was shaped to our needs