Microsoft Excel Course In-House - Beginner
Enquire
Get Quote
Course Details
Price: Quote
Duration: 1 day
Delegates: 4-10
Available: Online or South Wales
Microsoft Excel Beginner - Overview
On this one-day course, we will cover the basics of Microsoft Excel, including creating and formatting spreadsheets, using basic formulas and functions, and working with charts and graphs. You will learn how to use the software to create spreadsheets that are well-organised and easy to read.
By the end of the course, you will have a solid understanding of how to use Microsoft Excel to organise and analyse data effectively. You will have had the opportunity to practice these skills through hands-on exercises and projects. Whether you are a business professional, student, or anyone who needs to manage data, this course will provide you with the skills you need to use Microsoft Excel effectively. Join us for this practical and informative one-day course and take the first step towards becoming a proficient user of Microsoft Excel.
Microsoft Excel Beginner - Course Content
Learn to set up spreadsheets from new
Learn how to enter data, basic formulas and functions
Managing printing and spreadsheet layouts
Explore the various user interface elements
Getting going with formulas and functions
Use the Excel galleries
Customise the interface
Creating, opening and saving a workbook
Creating forms with Excel
Utilising Excel help
Replicate formulas & functions
Create an absolute reference
Range names and how they are applied
Setting up data for printing
Recording the current date and time on the printed spreadsheet
Turning your figures in to charts
Formatting charts
Who is this course for?
Designed for anyone who is new to spreadsheet software and needs to learn how to use Microsoft Excel. It is ideal for business professionals, students, or anyone who needs to manage data efficiently. No prior experience with Microsoft Excel is required, as we will cover the basics of the software from scratch. If you want to learn how to create and manage spreadsheets, use basic formulas and functions, and create simple charts and graphs, then this course is for you.
Microsoft Excel Course In-House - Intermediate
Enquire
Get Quote
Course Details
Price: Quote
Duration: 1 day
Delegates: 4-10
Available: Online or South Wales
Microsoft Excel Intermediate - Overview
On this one-day course, we will cover intermediate-level topics in Microsoft Excel, including working with complex formulas and functions, creating and modifying charts and graphs, using pivot tables, and automating tasks with macros. You will learn how to use the software to create spreadsheets that are well-organised, visually appealing, and easy to understand.
By the end of the course, you will have a solid understanding of how to use Microsoft Excel to manage and analyse data effectively. You will have had the opportunity to practice these skills through hands-on exercises and projects. Whether you are a business professional, analyst, or anyone who needs to manage and analyse complex data, this course will provide you with the skills you need to use Microsoft Excel effectively at an intermediate level. Join us for this practical and informative one-day course and take your Microsoft Excel skills to the next level.
Microsoft Excel Intermediate - Course Content
Absolute cell references
Naming cells and ranges
Referring to named cells and ranges in formulae
Editing named cells and ranges
Using VLOOKUP & HLOOKUP statements to retrieve data
Editing lookups and ensuring accuracy in returned data
Linking spreadsheets and workbooks together with formulas and functions
Analysing data with the all new conditional formatting features
Databases in Excel understanding fields and records
Sorting data numerically and alphabetically
Filtering data for range and precision analysis
Setting up data validation to ensure integrity of the data
Attaching security to a spreadsheet
Selective protection i.e. protecting formulas while allowing data entry
Setting up and utilising templates
Creating and formatting charts
Adding trend lines to the chart
Utilising custom chart types
Who is this course for?
This intermediate course is designed for users who have attended the beginner course or are already confident in the basic features of Microsoft Excel.
Our Customers
Recent Feedback
Feedback plays a pivotal part of our Learning Process, it ensures that we maintain the standards that we have set and continue to make improvements.
"I really enjoyed this course. The trainer allowed us to focus on the aspects of Excel that would be relevant to our work. My only regret is I didn't do it sooner!"
University of South Wales
"Good course. Challenging at times but was able to work through it with the instructor. Overall valuable experience."
Gwent Police
"Learnt lots which is going to save me so much time in work."
NHS
Have a Question?
If you have any questions regarding our training courses then please feel free to call us on 01656 737349 from Monday to Thursday from 9:00am to 4:00pm. Or complete the contact form.
Contact
In-House Training
Effortlessly upskill your teams with on-site expert training, saving time and promoting a comfortable learning environment.
Get Quote
Online Learning Available
Some of our courses can be delivered online with a live trainer. Checkout our guidance on online learning.
Online Training
Our Approach
Our training approach focuses on small groups led by friendly trainers, ensuring a non-judgemental and comfortable environment where everyone feels supported.
Training Brochure 2025
Download our latest training brochure for 2025. Includes our Wellbeing, Core Skills, ICT and Technical courses.
Download
