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

MDIS


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


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
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
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.



 

Top