Course description
On this course, you will learn how to set up, navigate and effectively use Excel spreadsheets. This course is recommended for professionals from all backgrounds and sectors who wish to obtain an understanding of Excel from the very beginning.
This course is designed to introduce the basics of Excel. It will acquaint students with multiple Excel shortcuts to allow them to learn or enhance the Excel skills necessary to their jobs. The training is delivered on-demand in a Online learning platform, allowing delegates to take the four modules that the course is broken down into in their own time.
Upon completion of this course, students will be able to:
- Navigate through the Excel interface
- Write simple formulas and perform statistical functions in Excel
- Efficiently use keyboard shortcuts
- Formation and modifying worksheet
- Navigate and clean large datasets
- Save, share, protect and print workbooks
Included in the Course
- A Bayfield Training Certificate & 6 CPD Hours
- 12 Months Access to the Digital Platform
- Online Learning Platform access - Further Learning Resources (Reading, Files and Videos)
Upcoming start dates
Suitability - Who should attend?
- Professionals who utilise Microsoft Excel
- Customer Service Employees
- Junior employees
- Graduates
Training Course Content
Module One: Exploring the basic use of Excel
- Using Quick Access Toolbar and ribbon menu
- Introduction to workbooks and worksheets
- How to enter and edit data
- Use AutoFill
- Frequently used shortcuts keys
Module Two: Formatting and modifying worksheets
- Introduction to font styles and effects
- How to adjust row heights and column widths
- How to insert, delete, hide and unhide rows and columns
- Working with large data sets
Module Three: Using simple formulas and functions
- How to create a formula
- How to use functions in Excel
- Function Library
- Introduction to auditing formulas
Module Four: Save, share and print workbooks
- How to save a workbook in your device
- Protect and share your workbooks
- Print your worksheets
Why choose Bayfield Training
Over 25 years in business
Original Content, Unique Delivery
+90% courses review rating from past delegates
Customer Outreach Award 2019
We believe that it should be easy for you to find and compare training courses.
Our Customer Outreach Award is presented to trusted providers who are excellent at responding to enquiries, making your search quicker, more efficient and easier, too.
Reviews
Average rating 5
A good course. Was good to refresh on what I've forgotten.
I am a beginner in terms of using Excel and I have found this course to be very well designed. I am so happy that I have gained knowledge and understanding in using Excel. The c...
Expenses
Online: £100 +VAT
Number of days: 4-6 Hours
Course type: Microsoft Excel Fundamentals
Pre-requisite: None
Request info
Bayfield Training - Real Estate Executive Education
Bayfield Training is a prominent global supplier of investment grade Real Estate executive education. Having begun 25 years ago as pioneers in the field of Real Estate Financial Modelling, today Bayfield has a huge extended network of experts, specialists and...
Very clear and in-depth training, there were lots of training exercises to do, multiple informational documents, tips/tricks, shortcuts, and visual videos. The course was even c...