Training Brochure - Flipbook - Page 21
Course Bene昀椀ts.
This course is designed to help you gain
intermediate-level skills in Microsoft Excel, and to
enable you to become a pro昀椀cient and competent
user. You will develop essential Excel knowledge to
enable you to calculate data more ef昀椀ciently, utilise
additional functions and formulas, manipulate
worksheets, create charts, format cells and ranges,
use templates, and create named ranges.
Key Topics.
»
Acquire key skills in workbook management,
including, inserting/deleting worksheets,
splitting/freezing windows, setting print areas,
creating templates for work昀氀ow ef昀椀ciency,
and collaborating on workbooks.
»
Learn calculation techniques, manage
de昀椀ned names for clarity, display and trace
formulas for better understanding, and utilise
compatibility functions for seamless
integration.
»
Perform tasks such as sorting columns,
creating sorting lists, employing advanced
昀椀lter options, managing tables, implementing
data validation, summarising tables with
PivotTables, and converting tables to ranges.
»
»
Perfect your data visualization skills, covering
tasks like selecting source data, choosing
chart types, editing charts, adjusting layout,
managing labels, emphasising data, and
utilising Sparklines.
Master PivotTables to quickly produce reports
and analyse data.
THE
Trainer
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.
Assessment & Accreditation.
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
21.
