Microsoft Excel: Advanced Excel Formulas & Functions Class
Categories: Microsoft Office Classes | Microsoft Excel Classes
To edit or manipulate your spreadsheets, you need Advanced Excel Formulas & Functions
Class Description
If you are a daily user of Microsoft Excel, then learning how to use formulas and functions is crucial to success. Advanced Excel Formulas & Functions focuses solely on solving complex problems with your data. We will walk you all the way through the basics of formula creation to advanced logical and look-up functions. Our hands-on training in this Advanced Excel Formulas & Functions class will teach you how to manipulate text data, use dates in formulas, calculate complex statistical problems, include conditional logic and much more. All of our Excel classes are taught by industry experts who bring their real world experience into the classroom You will leave Advanced Excel Formulas & Functions feeling confident in creating advanced functions for any data analysis scenario.
Class Objectives
Upon successful completion of the Advanced Excel Formulas & Functions class, students will be able to:
- Understand the Excel tools to assist in building formulas
- Create basic formulas and functions
- Manipulate text with Text functions
- Calculate dates and numbers in creative ways
- Add intelligence to your spreadsheets using Logical functions
- Find data easier with Lookup functions
- Use advanced function techniques to save you time
Class Includes:
- 7 hours of training
- Professional Textbook
- Download materials with practice data files
- Free access to CoWorking space on class days (FC Only)
- One month of technical support
- One year for a free re-take (for attended students of public classes only)
- Certificate of Completion
General Info:
- Target student: Beginner to Intermediate
- Coursework may be assigned outside of class
- Computer & software provided in class
- Class size limited
Pre-requisites:
- Microsoft Excel Level 1 or basic understanding of Excel formulas and functions.
Training Type
Certificate Programs
Financial Aid
Terms & Conditions
Available Public Classes
| Dates/Times | Information | ||
|---|---|---|---|
|
Live Classes Price: $249.00 Space Available: 16 seat(s) Location: Digital Workshop Center - Ft. Collins - View Map Classroom: Classroom Course Closing Date: 5-05-2018 Instructor(s): Troy Namath Live Online classes Price: $259.00 Space Available(Online): 16 seat(s) Location: Online |
||
| Choose Location: Digital Workshop Center - Ft. Collins - Online | |||
| Dates/Times | Information | ||
|---|---|---|---|
|
Live Classes Price: $249.00 Space Available: 16 seat(s) Location: Digital Workshop Center - Ft. Collins - View Map Classroom: Classroom Course Closing Date: 6-23-2018 Instructor(s): Troy Namath Live Online classes Price: $259.00 Space Available(Online): 16 seat(s) Location: Online |
||
| Choose Location: Digital Workshop Center - Ft. Collins - Online | |||
| Dates/Times | Information | ||
|---|---|---|---|
|
Live Classes Price: $249.00 Space Available: 16 seat(s) Location: Digital Workshop Center - Ft. Collins - View Map Classroom: Classroom Course Closing Date: 8-18-2018 Instructor(s): Troy Namath Live Online classes Price: $259.00 Space Available(Online): 16 seat(s) Location: Online |
||
| Choose Location: Digital Workshop Center - Ft. Collins - Online | |||
Available Private Training
Digital Workshop Center offers each class in a private, one-on-one format. Private training may be scheduled around your availability and customized to your specific needs.
Consulting allows you to work one on one with your instructor, but does not follow a class curriculum.
If the public class schedule above is not ideal, please choose from the following options: