Microsoft Excel Essentials
Our range of Power BI training is suitable for beginners and advanced users alike.
We deliver tutor-led Power BI courses at our training centre in Peterborough. We can
also organise Power BI training courses on-site, anywhere in the UK. Our Microsoft
business intelligence courses could help to transform your career and your
organization’s data.
Excel Introduction Excel Intermediate Excel Advanced
(1 day) (1 day) (1 day)
Overview Overview Overview
This course is designed for
beginners and covers all of the
essential features of the program,
including all of the key principles
involved when working with
formulas and functions. This course is suitable for those
with prior experience and delves
deeper into the different categories
of Excel functions. The course also
introduces powerful techniques
for manipulating tabular data,
principles which are very useful in
data analysis. Our Excel Advanced course
covers complex formulas using
nested functions; techniques for
summarizing data and performing
what-if data analysis; and the
essentials of working with macros.
Audience
Designed for users who are fairly
new to Excel, have used the
program very little or have only
used workbooks prepared by other
people.
Key Topics Covered
Audience
This course assumes a basic
familiarity with Excel, whether
obtained through usage or basic
training.
Audience
Aimed at experienced Excel users
looking for guidance on the more
challenging aspects of the program.
Key Topics Covered
• Lookup and Reference Functions
• Advanced Number-Crunching
• Excel Basics Key Topics Covered • Working With Data • Working With Tables • Array Formulas
• Editing A Worksheet • Working With Charts • Auditing Worksheet Functions
• Formatting A Worksheet • Working With Graphics • Working With Macros
• Page Setup And Printing • Workgroup Collaboration • Summarizing Data
• Formulas And Functions • Financial & Logical Functions • What-If Data Analysis
• Modifying Workbooks • Date And Time Functions
Functions
• Managing Workbooks
“ Informative, well delivered, confidence building. Good examples and explanations. Instructor
very patient and helpful.. ”
Kathy Murphy Glass
Office Manager, Our Lady and St Joseph Primary School
- 6 -
G Com Solutions Limited
0800 998 9248
www.gcomsolutions.co.uk