25,000+ Courses Nationwide
0345 4506120

Microsoft Excel Formulas and Presenting Data

Please note that the duration of this course is 3 hours.

You will use more advanced formulas and work with various tools to present data such as Charts and Conditional Formatting.


This course is suitable for users of Microsoft Excel 2016 or 365 subscription editions. If you're attending at one of our training locations, the course will be delivered on Microsoft Excel 2016.

Select specific date to see price, venue and full details.

Learning Objectives

  • Calculate with advanced formulas
  • Create and modify Charts
  • Apply Conditional Formatting


  • Working knowledge of Excel
  • Create basic formulas
  • Perform basic formatting

Course Content

Calculating with Advanced Formulas

  • Overview of Relative and Absolute References
  • IF Functions
  • CountIF
  • SumIF



  • Creating and modifying charts
  • Working with Sparklines


Conditional Formatting

  • Applying standard rules
  • Creating and editing rules

Related Courses

Privacy Notice

In order to provide you with the service requested we will need to retain and use your contact information in accordance with our Privacy Notice. If you choose to provide us with this information you explicitly consent to us using the information as necessary to provide the requested service to you. If you do not agree please do not proceed to request the service from us.

Marketing Permissions

Would you like to receive our newsletter and other information on products and services which we think will be of interest to you by email. We will always treat your information with care and in accordance with our Privacy Notice. You are free to withdraw this permission at any time.


We work with the best