Using Functions & Formulas in MS Excel - TED Learning

Introduction

This course is for anyone who has a good basic working experience of Microsoft Excel who wants to dramatically improve their function and formula skills.

Formulas can manipulate both numbers and text. This course is therefore ideal for advanced spreadsheet builders who need the power of combined functions that will greatly enhance the manipulation of business data to produce dynamic and analytical spreadsheets.

Prerequisites

To ensure your success, we recommend that you have a good basic working knowledge of Excel. Knowledge of basic formulas is definitely recommended. Students can obtain this level of skill through our Excel Foundation, Intermediate and Advance courses.

Course Objectives

At the end of this course, participants should be able to:

1. Define function and formula in Excel.
2. Use the built-in financial functions.
3. Use the logical functions for conditional comparisons.
4. Use text category functions to manipulate text.
5. Use date and time functions to perform date related analysis.
6. Use lookup and reference category functions for productivity.
7. Use math and trig category functions for advance calculations.
8. Use statistical category functions for other data analysis activities.