learning@counselltrain.com
CounselTrain
Contact usEnquire now
Call usEnquire now

Useful Formulas and Functions (Microsoft Excel 2007/2010)

4.9(45,580 Ratings)
Duration
1 Day
Upcoming Batch
19 November 2026
Batch Options
4 hours & 8 hours
Language
English/ Arabic

Useful Formulas and Functions (Microsoft Excel 2007/2010)

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 Audience

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

Course Content

7 modules · 33 topics
01Making Data Work For You5 topics
  • Formula basics
  • Copy formula without changing cell reference
  • Using cell references
  • Transpose formula
  • Using nested functions
02Making Data Work For You5 topics
  • Understand and apply formula basics
  • Transpose formula using paste special
  • Using cell references
  • Copying formula without changing cell reference
  • Using nested functions
03Statistical and Logical Functions7 topics
  • 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
04Statistical and Logical Functions5 topics
  • 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
05Lookup and Reference Formulas3 topics
  • Using Vlookup to find specific data
  • Using Hlookup to find values in rows
  • Using Match and Index to retrieve data
06Text Formulas4 topics
  • Changing case of text
  • Append text and numerical value
  • Convert imported text format into numbers
  • Break imported date field into individual columns
07Text Formulas4 topics
  • 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

Schedule Dates

4 upcoming batches
Session Type
Physical sessions run at our training facility.
Useful Formulas and Functions (Microsoft Excel 2007/2010)
Batch DatesDurationBatch OptionsLanguageAction
19 November 2026Next1 Day4 hours & 8 hoursEnglish/ Arabic
19 February 20271 Day4 hours & 8 hoursEnglish/ Arabic
19 May 20271 Day4 hours & 8 hoursEnglish/ Arabic
19 August 20271 Day4 hours & 8 hoursEnglish/ Arabic

Can’t find a suitable date? Request a schedule that fits your team.

Request More Information

FAQs

What is the duration of the Excel Formulas and Functions course?

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

Do I need prior Excel knowledge to enroll in this course?

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

What topics are covered in the Excel Formulas and Functions course?

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.

Will I learn how to create complex formulas during the course?

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

Are there any prerequisites for attending this course?

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

How We Deliver

Flexible Training Options to Meet Your Needs

Choose how you learn — live online, in-classroom, at your workplace, or internationally. CounselTrain delivers certified IT training across the UAE in the format that fits your team.

Select the method that best suits your needs.

Online Instructor-Led Training

Learn from the comfort of your workplace or at home through live virtual sessions led by expert trainers.

Learn more

Highlights

Live SessionsRecorded AccessGlobal

Related Courses

Other courses in the same category that might interest you.

View All
Upcoming Batch
19 November 2026