Have a Question? Call 0800 689 3038 or Click here to email us.
Cart 0
Excel 2013 – Frequently Used Formulas & Functions

Excel 2013 – Frequently Used Formulas & Functions

[ TTEX2013FF ]

£48.00

Seen this product cheaper elsewhere?
We'll beat any like-for-like training quote!
CLICK HERE


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.

Course Description
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.





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



PACKAGE INCLUDES:
Length of Subscription: 12 Months Online On-Demand Access
Running Time: 1 hrs 11 min
Platform:  Windows
Level: Beginner to Advance
Project Files: Included

Learn anytime, anywhere, at home or on the go.

Stream your training via the internet, or download to your computer and supported mobile device, including iPad, iPhone, iPod Touch and most Android devices.


More from this collection