Excel 2016 for PC - Frequently Used Formulas and Functions

Rapid Skillz

Course

Online

£ 47.42 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 2016 for PC – Frequently Used Formulas & Functions training, we’ll cover how to set up formulas to ensure you’re using all the features Microsoft® Excel® 2016 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, this Excel 2016 for PC – Frequently Used Formulas & Functions series presented by Dan Fanella, PhD, will teach you the common uses for a variety of formulas in Excel. Additionally, we’ll cover how to alter formulas and check for errors.

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
  • PC training
  • PC
  • Excel
  • Auditing
  • Conditional Formatting
  • Data tables
  • Pivot tables
  • Evaluating
  • Advanced Charting
  • Pivot Reporting
  • VBA & Macros
  • Simulations & Solver
  • Consolidating Worksheets

Teachers and trainers (1)

Name Name

Name Name

Teacher

Course programme

A. Getting Started & What’s New
  • What you’ll learn
  • TEXTJOIN
  • IFS
  • MAXIFS and MINIFS
B. Formulas
  • SUM function
  • AVERAGE function
  • COUNT function
  • DATE and NOW functions
  • DAYS function
  • MATCH function
  • TRANSPOSE function
  • ROUND function
  • AND function
  • OR function
  • IF function
  • NESTED function
  • COUNTIF function
  • SUMIF function
  • VLOOKUP function
  • HLOOKUP function
  • CONCATENATE (CONCAT) function
  • Text to columns
C. Linking and Consolidating Worksheets
  • Create a link formula within the same workbook
  • Create a link formula to another workbook
  • Consolidate values from multiple workbooks
  • Consolidate worksheet values within a function
  • Absolute links vs. relative links
  • Consolidate command with multiple sheets
  • Consolidate command with multiple workbooks
  • Open a workbook with external reference formulas
  • Break links to external references
D. Auditing & Error Checking
  • Display formulas
  • Identify precedent cells
  • Identify dependent cells
  • Check for errors
  • Evaluate a formula

Additional information

LENGTH

1 hr 24 min

See related categories

Excel 2016 for PC - Frequently Used Formulas and Functions

£ 47.42 VAT inc.

*Indicative price

Original amount in USD:

$ 59

The best Excel courses

See all

See all