Excel 2013 - Frequently Used Formulas and Functions

Rapid Skillz

Course

Online

£ 47.15 VAT inc.

*Indicative price

Original amount in USD:

$ 59

The best Excel courses

See all

See all

Description

  • Type

    Course

  • Level

    Intermediate

  • Methodology

    Online

  • Duration

    Flexible

  • Start date

    Different dates available

In this Excel 2013 – Frequently Used Formulas & Functions online training series, you’ll learn how to set-up formulas to ensure you’re using all the features Microsoft® Excel® 2013 has to offer.

Facilities

Location

Start date

Online

Start date

Different dates availableEnrolment now open

About this course

From using common formulas such as SUM, AVERAGE and IF, to more complicated formulas such as NESTED IF functions, presenter Dan Kuemmel will teach you common uses for a variety of formulas in Excel. Additionally, in Excel 2013 – Frequently Used Formulas & Functions you’ll learn how to alter formulas and check for errors.
This training course is for Microsoft Office Excel 2013 for Windows.

Questions & Answers

Add your question

Our advisors and other users will be able to reply to you

Who would you like to address this question to?

Fill in your details to get a reply

We will only publish your name and question

Reviews

Subjects

  • MS Excel
  • Excel
  • Conditional Formatting
  • Data tables
  • Pivot tables
  • Excel Functions
  • Advanced Formulas
  • Tables & Formatting
  • Advanced Charting
  • Pivot Reporting
  • VBA & Macros
  • Simulations & Solver

Teachers and trainers (1)

Name Name

Name Name

Teacher

Course programme

A. Getting Started
  • What you’ll learn in this training
B. 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 Concatenate pt. 1
  • Using Concatenate pt. 2
  • Using Text to Columns
C. Linking and Consolidating Worksheets
  • Consolidating worksheets using formulas pt. 1
  • Consolidating worksheets using formulas pt. 2
  • Consolidating worksheets using formulas pt. 3
  • Using the Consolidate command pt. 1
  • Using the Consolidate command pt. 2
  • Opening a workbook with external reference formulas
  • Breaking links to external references
D. Auditing and Error Checking
  • Displaying formulas
  • Identifying precedent cells
  • Identifying dependent cells
  • Checking for errors
  • Evaluating a formula

Additional information

LENGTH

1 hours 11 min

See related categories

Excel 2013 - Frequently Used Formulas and Functions

£ 47.15 VAT inc.

*Indicative price

Original amount in USD:

$ 59

The best Excel courses

See all

See all