Type and hit enter to Search
×

Useful Formulas and Functions (Microsoft Excel 2007/2010)

  • 4.9(45,580 Rating)

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

About This Course

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

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)
22 July 2024
Useful Formulas and Functions (Microsoft Excel 2007/2010)
22 October 2024
Useful Formulas and Functions (Microsoft Excel 2007/2010)
22 January 2025
Useful Formulas and Functions (Microsoft Excel 2007/2010)
22 April 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.

Start learning with 15.8k students around the world.
  • 3.3k
    Courses
  • 100+
    Certified Instructors
  • 99.9%
    Success Rate
Open chat
Hello
How Can We Help You?