Microsoft Excel LogoMicrosoft Excel Intermediate – 2 days

This is an intermediate Excel course that will build on your existing Excel skills.  Following this course, you will work smarter in Excel, helping you to better organise and present your data. You will Learn to use some of Excel’s more powerful functions such as If’s, features like sorting and filtering data.  Conditional Formatting along with improvements to charts will allow you to feel much more confident in creating effective presentation of your data.  This is a hands-on course and includes plenty of chances to try out what you are being taught and ask questions.

Content:

  • Revision Exercise
  • Complex Formulas
  • Scoping Formulas
  • Logical Functions
  • IF, AND, OR, NOT
  • Number Formatting
  • Conditional Formatting
  • Data Bars, Icon Sets, Colour Scales
  • Applying Borders
  • Working with a Worksheet
  • Adv Find and Replace
  • Page Setup
  • Print Titles
  • Creating Sparklines
  • Sorting Data
  • Filtering Data
  • Understanding Chart Elements
  • Chart Object Formatting

Learning Outcomes:

At the completion of the program Excel Intermediate participants should be able to:

  • Create If Functions to analyse data
  • Format Spreadsheets according to their values
  • Analyse Data using Sorting and Filtering
  • Apply Borders
  • Create Advanced charts.

Duration:  Two days

Previous Course: Microsoft Excel Essentials – 1 day

Next course: Microsoft Excel Advanced – 2 days