MICROSOFT EXCEL

Excel Intermediate Level

Microsoft Excel Intermediate is designed to offer a concise review of the basics while introducing participants to intermediate-level features of Excel. It is targeted towards those already proficient in basic Excel and serves as a stepping stone to explore more advanced Excel functionalities, providing a solid preparation for further Excel courses.

3

1-Day Course

Max 15 Learners

Virtual, On-Site or Hybrid

Pre-requisites

Participants must have a good understanding and working knowledge of Excel’s Basic functionalities and skills.

Why Attend?

By the end of this course, you will have gained the skills necessary to enable you to improve your accuracy and productivity by utilising list management, handling large worksheets more effectively as well as enhancing the formatting of your spreadsheet data by using conditional formulas and will give you a better understanding of key features to enhance your efficiency.

 

What Will You Gain?

After this course, you will:

  1. Work with more complex formulas
  2. Make use of advanced formatting
  3. Prepare to print and page set-up
  4. Create and format more complex charts
  5. Using multiple worksheets and workbooks by linking
  6. Create and manage cell and range names
  7. Outline and consolidate data and create subtotals
  8. Work with tables by sorting and filtering data
  9. Document by tracking and inserting comments
  10. Audit by validating and protecting workbooks

What Learning Materials Are Included?

We supply the following for virtual and face to face training:

  1. Comprehensive learner manual
  2. Digital cue cards with quick tips and shortcut keys
  3. Highly practical, integrated and engaging learning experience

For all virtual sessions we provide an end-to-end service including:

  1. Scheduling and hosting of all Microsoft Teams sessions
  2. Delegate invitations and reminders
  3. All related training correspondence and IT support during workshops
CONNECT WITH OUR TEAM

Even with years of Excel experience, I learned a huge amount!

Thanks for a great and exciting learning experience. Excel has become more vibrant and useful. Even with years of Excel experience, I learned a huge amount. I enjoyed the shortcuts and tips in arranging data. You are brilliant Sharon.

Chene Bennette

Management, BASF SA

Taught me how to do things in a faster way!

This course was a good refresher and taught me how to do things in a faster way. Thank you for the opportunity to attend this workshop.

Lynette Swart

Account Manager, Ciba