Excel Formulas: Advanced
CLASS DATE(s):
5/19/2020
6/23/2020

COURSE LENGTH: 1 Day

COURSE COST: $295.00

COURSE TIMES: 9:00am - 4:30pm

Printable version of this course
print
Register for this course
register

COURSE OVERVIEW

This 1-day course covers the advanced excel formulas, functions and types of financial analysis. This Advanced Excel training course builds on the knowledge that the user is already proficient and/or has taken the Excel Formulas Basic course and looking to take their skills to an advanced level. Course topics will include:


1) finding the perfect, most suitable function
2) methods of function entry
3) functions using relative, absolute, and named references
4) reusing functions (copy, autofill, drag and more!)
5) Functions by type
- Multiple and cross sheet functions
- Date functions
- Text(String) functions
- Logical functions
- Lookup functions
- Aggregate functions
- Rounding Functions

AUDIENCE AND PREREQUISITES

This course is intended for experienced excel users with a basic understanding of functions and forumas

Excel Formulas Basic or proficient user of Excel Formulas.

PREREQUISITE COURSES  

*Course cost listed does not include the cost of courseware. Please contact us at learn@vtec.org or 207-775-0244 for additional pricing information, or if you have any questions.
Course to run is subject to a minimum enrollment. Course may run as a virtual instructor led course if the minimum enrollment has not been met

COURSE TOPICS:


Review
Functions wizard
Absolute/relative references
Named ranges
Duplicating

Multiple and cross sheet functions
Referring to other sheets
Functions accross sheets (3D fuctions)

Date functions
Year, month, day
Hour, minute, second
Date/Time arithmatic
Formatting
Date/Time formatting (decimal hours)

Text(string) Functions
Left, right mid, len
Text, value
Find, search
Upper, lower, proper
Replace, substitute

Logical
id
And, or, not
Sumif, sumifs, countif, countifs
iserror

Lookup and aggregate functions
Choose, vlookup, hlookup
Match, index
Row, column

Aggregate functions
Sumproduct
Array formulas

Rounding Functions
int, abs
Round, Roundup, Rounddown, ceiling, floor
Odd, even, mround, fixed, trunc

Text(string) functions
Financial - pmt
Math
Rand, randbetween, roman, bahttext