Microsoft Excel Advanced
Thu 16th May @ 9:30 am - 4:30 pm BST
Who should attend?
This advanced Microsoft Excel course is tailored for individuals aiming to enhance their data retrieval and analysis skills, especially those dealing with diverse data source types. Whether you’re a data analyst, business professional, or anyone seeking proficiency in Excel, this training equips you with the knowledge to become a competent Excel user and adept report creator. This course is also suitable for participants who have completed the Microsoft Excel Intermediate Course
Course Benefits
This course will enable you to master advanced features in Excel, focusing on retrieving and analysing data from various sources. The training covers the creation and manipulation of PivotTables and PivotCharts, as well as organising information into comprehensive Dashboards. By learning these advanced Excel features, you will enhance your analytical capabilities, and data manipulation skills allowing you to streamline workflows, and present data in a clear and impactful manner.
Key Topics
- Master the summarising creation, filtering, grouping, and formatting of data using advanced PivotTables
- Learn the creation of scenarios, working with data tables, consolidation data, and utilising Goal Seek for effective data analysis
- Master importing data and Power Query, a powerful data connection and transformation tool that shapes and transforms data into streamlined datasets
- Explore advanced Excel functions that offer enhanced capabilities for efficient data lookup, including XLOOKUP(), Dynamic Arrays such as SORT(), FILTER(), UNIQUE(), as well as HSTACK() and VSTACK()
- Tailor your Excel experience by customising the ribbon and Quick Access toolbar, and adjusting Excel’s default options to optimise your workflow
Assessment & Accreditation
Instructor-led with hands-on exercises, case studies, Q&A, and personalised assistance. Certification is awarded upon successful completion
Chamber Members: £180.00 + VAT
Non-Chamber Members: £220.00 + VAT
*Group bookings of 3 or more delegates booking for the same course will receive a 10% discount
