Course description
If you already have experience using Excel in your day-to-day activities and are eager to advance your skills for more efficient use and to create more sophisticated, advanced Excel spreadsheets, then this course is perfect for you.
Throughout this advanced Excel course, you'll gain both theoretical knowledge and practical skills that you can immediately apply to your own projects, boosting your proficiency with confidence.
In addition to comprehensive training, you'll learn valuable shortcuts, hints, and tips to help you use advanced Excel features more efficiently.
This course is designed for users of Excel 2010/2013/2016/2019 & 365.
Upcoming start dates
Suitability - Who should attend?
This course is ideal for those who are already using Excel at work, have a solid understanding of basic data manipulations and formulas, and are looking to build on these skills.
You'll come into the course with prior knowledge of Excel basics and feel confident working within Excel.
If you feel your foundational Excel knowledge needs strengthening, we recommend exploring our Beginners / Intermediate Excel Course
Outcome / Qualification etc.
Over the course of one day, which has earned a five-star rating, you'll engage in practical exercises that demonstrate how to use advanced Excel tools like formulas, pivot tables, and macros to efficiently create complex and powerful spreadsheets and reports.
Beyond data manipulation, we'll explore advanced formatting tools that enable you to present data clearly and create user-friendly forms.
Upon completion, you'll receive course notes as a helpful reference for your continued advanced Excel development.
Training Course Content
Below is a summary of the topics covered on the 1-day Intermediate to Advanced Excel course.
- Cell Styles, Tables & Conditional Formatting
- Protecting cells and workbooks
- Controlling user permissions
- When to use templates
- Creating and editing templates
- Control data that can be entered
- Create drop-down lists
- Creating and using Lookups
- Creating and using Pivot tables
- What are Macros
- Creating and using Macros
Course delivery details
Our 5-star rated Advanced Excel courses are highly practical, with small class sizes—limited to a maximum of six participants—ensuring plenty of time for interaction with the trainer and opportunities to ask questions.
These courses are available as in-person classroom sessions or live, online courses via Zoom. Each course runs from 9:30 am to 4:30 pm, with regular breaks throughout the day.
Scheduled Advanced Excel Courses
We offer scheduled public Advanced Excel Courses in Manchester, Birmingham, Leeds, and online. You can find the upcoming dates below, and venue details are available on the Timing & Venue Info tab.
Private / Bespoke Advanced Courses
We also provide private one-on-one and group Advanced Excel Courses at our training centres or at a location of your choice anywhere in the UK. These can also be conducted online.
For more details, check the Private Course tab further down the page.
Request info
M Training and Consultancy Ltd
M Training offers intensive, one and two day courses designed to equip professionals with essential business skills. Our courses cover a wide range of topics, including Digital Marketing, Marketing Strategy, Leadership and Management, Excel, Microsoft applications, and other essential business...