Microsoft (MS) Excel – Intermediate

This 1-day course is a Microsoft (MS) Excel Intermediate course aimed at existing Excel users who need to create and manipulate more complex models. Participants should be existing users of MS Excel. They should be able to create, edit and manipulate spreadsheets containing formulae and basic functions. Ideally participants will have completed the Excel Introduction course.

Course Content

The content of the Course is outlined:

Module 1: - Review of Excel Functions
  • Review of Basic Features and Tips
  • Review Basic Formulae &Functions (Sum, Count, Average)
  • Apply Relative & Absolute cell addressing
  • Auto Fill Options
  • Print and Page Layouts
Module 3: - Linking Spreadsheets and Pivot Tables
  • Link worksheets and workbooks via formulae
  • Manipulate Data – Sorting, Filtering, Validation, Subtotals
  • Create Pivot Tables for Analysing Data
Module 2: - Using Spreadsheets and Functions
  • Formatting the Spreadsheet
  • Create and use Range Names
  • Use more complex Excel functions: Sumif, Sumifs, Countif, Countifs, IF, Lookups, IFERROR
  • Date Functions: Datedif, Networkdays, Now, Today, EOMonth etc.
  • Text Functions: Concatenate, Text, Trim, Upper / Lower etc.
Module 4: - Presenting your Workbook with Charts
  • Create a Chart
  • Format Charts
  • Create Sparkline charts for quick visual analysis
  • Audit a workbook
  • Apply Conditional Formatting
  • Protecting the Sheet & the Workbook
  • Sharing Workbooks

Upcoming Courses

No Events

If this course is not scheduled here then just complete this form, and we can arrange a custom date for you

  • Contact Permission

  • Agreement for us to contact you in the future

    We'd love to send you information and offers from Turlon by email, SMS, phone and other electronic means. We'll always treat your personal details with the utmost care and will never sell them to other companies for marketing purposes.

X