Harnessing the Power of Formulas and Functions in Excel (2016)


Course introduction

One of Excel’s key strengths is its power of formulas and functions where it is able to display data in a format that is suitable for reporting

Course Benefits

This course takes the Excel user to a realm where he/she will be introduced to cell manipulation as well as discover techniques of fine-tuning formulas and the introduction of some Advanced Excel functions relating to text, logical and information that assist in providing the necessary information or changing the representation of how data is presented.

Target Audience

Those needing to extract information from their worksheet models as well as how to tidy up their data in a format that is acceptable for reporting are especially encouraged to attend.

Course Outline

Module 1: Cell Manipulation in Excel

  • Applying Conditional Formatting to a Range
  • Filling a Range by using the Fill Handle & Flash-filling a range
  • Creating a Series using Excel Series command
  • Using the Go To Special Dialog Box
  • Displaying Worksheet Formulas using Ribbon command & using a function
  • Printing Worksheet Formulas
  • Converting a Formula to a Value
  • Apply Paste Special Function
Module 2: Building Basic Formulas and Functions in Excel
  • Understanding Excel Formulas
  • Creating an Excel Formula
  • Understanding Relative, Absolute and Mixed Cell Referencing
  • Using Relative, Absolute and Mixed Cell Referencing in Formulas
  • Understanding Excel Functions
  • Creating an Excel Function through various methods
  • Using the AutoSum
  • Using some common Excel Functions
  • Understanding Excel’s Formula-Related Errors
  • Apply Automatic Checking for Possible Errors in Formula Usage
Module 3: Working with some Advanced Excel Functions
  • Logical and Information Functions
  • Applying a Logical Function in Excel
  • Getting Data with Information Functions
  • Text Functions
  • Working with Characters and Codes
  • Converting Text
  • Formatting Text
  • Removing Unwanted Characters from a String
  • Extracting a Substring
  • Searching for Substrings
  • Substituting One Substring for Another

Available Course Sessions

Please click here to stay updated on upcoming sessions.

Trainer Profile

Microsoft Certified Trainer

All of our Associate Trainers offer our high level of service therefore are subject to regular peer assessments and interview prior to joining our Institute. They must all be qualified and have relevant experience to an agreed level and are subjected to continual audit and evaluation. Strict internal assessment is implemented as an integral part of our quality control mechanism.