Useful Formulas and Functions (Microsoft Excel 2007/2010)

Overview Schedule Dates Course Content Faqs

Course Overview

Get a head start in acquiring the knowledge of using Formulas in your daily work as well as expand your Microsoft Excel knowledge. This one-day course will empower you to have answers to Excel questions at your fingertip. There a numerous and varied new tips you will learn irrespective of the Excel version used. This course will serve as a refresher as well as a reference. The course is for users at all levels, from beginners through intermediate and advanced

Learning Outcomes

Apply Formula and Functions Basic
Statistical and Logical Functions
Lookup and Reference Formulas
Text Formulas
Date and Time Formulas
Array and Database Functions
Efficiency Tips

Learning Options

Online Instructor Led

Learn from the comforts of your home/office with our expert trainers via online platforms.

Classroom Training

Face-to-face physical classroom training with max interactions at our 5* training venues.

Onsite Training

Learn in your own environment from our expert trainers for maximum impact.

Overseas Training

Choose your desired country for learning with our expert trainers.

Target Audiance

The meticulous accountant, eager to streamline financial reporting.
The ambitious project manager, aiming to master data analysis for efficient planning.
The diligent administrative assistant, seeking to automate routine tasks for increased productivity.
The detail-oriented HR professional, aiming to optimize employee data management.

Schedule Dates

Useful Formulas and Functions (Microsoft Excel 2007/2010)

19 November 2024

Useful Formulas and Functions (Microsoft Excel 2007/2010)

19 February 2025

Useful Formulas and Functions (Microsoft Excel 2007/2010)

19 May 2025

Useful Formulas and Functions (Microsoft Excel 2007/2010)

19 August 2025

Course Content

Formula basics
Copy formula without changing cell reference
Using cell references
Transpose formula
Using nested functions

Understand and apply formula basics
Transpose formula using paste special
Using cell references
Copying formula without changing cell reference
Using nested functions

Perform calculation using CountIF
Perform calculation using SumIF
Perform calculation using AverageA
Using IF function to prevent division by zero
Using IsError function to avoid error display
Creating multiple conditions using nested IF
Using logical function OR, And

Perform calculation using CountIf, SumIf, AverageA
Using If function to prevent division by zero
Using IsError function to avoid error display
Create multiple conditions using nested IF
Using logical function OR, AND

Using Vlookup to find specific data
Using Hlookup to find values in rows
Using Match and Index to retrieve data

Changing case of text
Append text and numerical value
Convert imported text format into numbers
Break imported date field into individual columns

Changing case of text using Upper, Lower or Proper formula
Append text and numerical value
Convert imported text format into numbers
Break imported date field into individual columns

FAQs

The course typically spans over two days, with each session lasting around four hours.

While basic familiarity with Excel is beneficial, this course is designed to accommodate beginners as well as those looking to enhance their skills.

The course covers a wide range of topics including but not limited to basic arithmetic functions, logical functions, lookup and reference functions, text functions, and date & time functions.

Absolutely! The course is structured to gradually introduce participants to increasingly complex formulas and functions, ensuring comprehension at every step.

No prerequisites are necessary. However, participants should have access to a laptop with Microsoft Excel 2007 or later installed.