Microsoft Excel Excel 2013:  Frequently Used Formulas & Functions

Excel 2013: Frequently Used Formulas & Functions

10.00 10.00
$10.00
PRICE PER USER
$
X
USERS


=
SUBTOTAL
$
  • Course Delivery: On Demand
  • Duration: 1 
  • Language: English
  • Difficulty: Beginner
  • Audience: Microsoft Excel users

Chat Live | Contact Us | Toll Free: (888) 360-8764

 

Description

In this series of online training tutorials, we'll cover how to set-up formulas to ensure you're using all the features Microsoft® Excel® 2013 has to offer. From using common formulas such as SUM, AVERAGE and IF, to more complicated formulas such as NESTED IF functions, you'll learn common uses for a variety of formulas in Excel. Additionally, we'll cover how to alter formulas and check for errors.

 

Topics Covered

Getting Started
  • What you'll learn in this training

Formulas
  • Using the Sum function
  • Using the Average function
  • Using the Count function
  • Using the Date and Now functions
  • Using the Days function
  • Using the Match function
  • Using the Transpose function
  • Using the Round function
  • Using the And function
  • Using the Or function
  • Using the If function
  • Using a Nested If function
  • Using the Count If function
  • Using the Sum If function
  • Using the VLookup function
  • Using the HLookup function
  • Using the Concatenate
  • Using text to columns

Linking and Consolidating Worksheets
  • Creating a link formula within the same workbook
  • Creaking a link formula to another workbook
  • Consolidating worksheets using formulas
  • Using the Consolidate command
  • Opening a workbook with external reference formulas
  • Breaking links to external references

Auditing and Error Checking
  • Displaying formulas
  • Identifying precedent cells
  • Identifying dependent cells
  • Checking for errors
  • Evaluating a formula

Knowledge Assessments
  • Formulas
  • Linking and Consolidating Worksheets
  • Auditing and Error Checking

Got questions? Contact us below or call 877-881-2235

Why Choose 360training.com?

  • Fast and easy courses completion
  • Get an education faster than at traditional colleges!
  • 100% online - No classroom attendance required.
  • Unlimited 24x7 online customer support
  • Over 500,000+ certified nationwide.