|
|
Excel Intermediate
Classroom Training
1 Day Course £220 + VAT
What do I learn?
With the basics covered in our introduction to Excel course, our Excel
intermediate course builds on your existing Excel experience. Working with
more complex Excel Formulas and Functions, Multiple Worksheet & Workbooks,
Nested Functions, Data Functions, protecting your workbooks and sheets to
name a few
By the end of this course you will:
• Be able to use a variety of if statements to
enhance your spreadsheet
• Understand Naming Cell Ranges and its
benefits
• Know how to Link Sheets and Files
• Learn how to use
Conditional Functions
• Be familiar with posting bank and cash
transactions
• Learn how to save time by using Recurring Entries
•
Apply and Manage Conditional Formatting
• Understand how Basic Lookup
Functions work
• Be able to use a variety of if statements to enhance
your spreadsheet
• Be confident in creating Lists and their Management
• Understand Formulae Auditing
• Know how to use advanced Charts/Graphs
|
What's Next?
Take the next step with Excel
Advanced Course.
All classroom courses can also be delivered in your own office and
tailored to your individual needs
|
|
|
|
