Skip to content
ictcLogo
  • About
  • Training
  • Learning Paths
  • Training Center
  • News
  • Contact
Menu
  • About
  • Training
  • Learning Paths
  • Training Center
  • News
  • Contact
Microsoft

Course 50449-B: Useful Formulas & Functions (Microsoft Excel 2007 & 2010)

  • Duration: 1 days
  • Job Role: Developer

Course 50449-B: Useful Formulas & Functions (Microsoft Excel 2007 & 2010)

Share This Learning Path

Need more info? Contact us

This 1 day course provides students with the knowledge and skills to the usage of useful formulas and functions in Microsoft Excel 2007 and Microsoft Excel 2010.

Audience Profile

This course is intended for users of Microsoft Office Excel who want to learn about useful formulas and functions.

Prerequisites

  • A basic working knowledge of Microsoft Office Excel.

Course outline

Module 1: Making Data Work For You

Module Overview

This module explains how to understand and apply Excel basic formulas and functions.

Lessons

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

Lab Sessions

Not available for this module

Lab Lessons

Lab lessons not available

After completing this module, students will be able to:

Understand and apply formula basics.
Use cell references.
Copy formula without changing cell reference.
Transpose formula using paste special.
Use nested functions.

Module 2: Statistical and Logical Functions

Module Overview

This module explains how to use logical functions including CountIf, Sumif, If, IsError.

Lessons

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

Lab Sessions

Not available for this module

Lab Lessons

Lab lessons not available

After completing this module, students will be able to:

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

Module 3: Lookup and Reference Formulas

Module Overview

This module explains how to apply and use lookup formulas including vlookup, hlookup, match and index.

Lessons

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

Lab Sessions

Not available for this module

Lab Lessons

Lab lessons not available

After completing this module, students will be able to:

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

Module 4: Text Formulas

Module Overview

This module explains how to apply Text formula to help change casing of text, append text and numerical value in excel spreadsheet.

Lessons

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

Lab Sessions

Not available for this module

Lab Lessons

Lab lessons not available

After completing this module, students will be able to:

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

Module 5: Date and Time Formulas

Module Overview

This module explains how to make use of calculate the difference of two given Date fields and to perform calculation with Time fields.

Lessons

Perform addition to Date fields
Calculate difference between two Dates
Perform calculations with Time fields

Lab Sessions

Not available for this module

Lab Lessons

Lab lessons not available

After completing this module, students will be able to:

Perform addition and calculate difference between two dates.
Perform calculations with Time fields.

Module 6: Array and Database Functions

Module Overview

This module explains how to apply and use advance formula including Array, Frequency and Database functions.

Lessons

Using Array Formulas
Calculate the difference between Maximum and Minimum values
Using Frequency function to Count responses
Using Database functions DSum and DCount

Lab Sessions

Not available for this module

Lab Lessons

Lab lessons not available

After completing this module, students will be able to:

Use Array Formulas.
Calculate the difference between Maximum and Minimum values in an Array.
Use Frequency function to Count responses in tabulated data.
Use Database functions DSum and DCount.

Module 7: Efficiency Tips

Module Overview

This module discusses some useful Excel Tips including application of Data Validations and Auditing Tools.

Lessons

Shortening worksheets names
Protecting cells containing formulas
Using Data Validation
Displaying Formula syntax
Using Auditing Tools for errors checking
Tracing precedent and dependent
Adding comments to worksheet

Lab Sessions

Not available for this module

Lab Lessons

Lab lessons not available

After completing this module, students will be able to:

Understand the advantages of shortening worksheet names.
Protect cells from amendments by others.
Use Data validation to improve data entries.
Use Auditing Tools for checking errors.
Add useful notes by commenting worksheet.

Book Your Seat​

Find Learning Paths​

  • Search Paths

  • Vendors

Latest Learning Paths​

Microsoft

Course MB-920T00-A: Microsoft Dynamics 365 Fundamentals (ERP)

  • Dynamics-365
  • Beginner

Microsoft

Course PL-600T00-A: Power Platform Solution Architect

  • Power-Platform
  • Advanced

Microsoft

Course 20703-1-B: Administering System Center Configuration Manager

  • Windows
  • Advanced

Join our community of certified professionals

Sign Up to our newsletter, and stay always up to date with latest IT certifications

About Us

ICTC is the leader in technical certification courses and exams. Our labs consist of a latest tech PCs and our instructors are certified from each vendor

Facebook Linkedin

Learn

View all the provided certifications and there relevant courses. Book online for a certification exam.

Explore

Contact Us

  • +30 211 500 29 00
  • info@ictc.gr
  • Lagoumitzi 24, Kallithea
ictcLogo

International Computer Training Center

  • Copyright reserved to ICTC
  • Proudly Crafted by GTP Works

Copyright reserved to ICTC. Proudly Crafted by GTP Works

Choose how to get more info...

Give as a call

211 500 2 900

Let us, call you

Send us an email