Training Brochure - Flipbook - Page 23
Course Bene昀椀ts.
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
work昀氀ows, and present data in a clear and
impactful manner.
Key Topics.
THE
Trainer
»
Master the summerising creation, 昀椀ltering,
grouping, and formatting of data using
advanced PivotTables.
»
Learn the creation of scenarios, working with
data tables, consolidating data, and utilising
Goal Seek for effective data analysis.
Tim Price is an accomplished Microsoft Certi昀椀ed Trainer
with over 40 years in the IT industry. He has vast experience
in training businesses in Microsoft Applications like Of昀椀ce
365, Power BI, SharePoint, and more. A Microsoft Master &
Expert, Tim offers a relaxed, approachable and enjoyable
learning environment.
»
Master importing data and Power Query, a
powerful data connection and transformation
tool that shapes and transforms data into
streamlined datasets.
Assessment & Accreditation.
»
Explore advanced Excel functions that offer
enhanced capabilities for ef昀椀cient 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 work昀氀ow.
Instructor-led with hands-on exercises, case studies,
Q&A, and personalized assistance. Certi昀椀cation is
awarded upon successful completion.
DURATION - 1 DAY
LUNCH PRICE - Members £180+VAT
Non-Members £220+VAT
23.
