Advanced Excel Class – Formulas & Functions
Categories: Microsoft Office Classes | Microsoft Excel Classes
Learn Excel to edit and manipulate your spreadsheets
Class Description
This Advanced Excel Class 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. Learn Excel with our hands-on training in this Advanced Excel class – Formulas & Functions. You will learn 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 this Advanced Excel Class – 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
Instructor led, group-paced, classroom-delivery learning model with structured hands-on activities. Available for Private or Group Sessions.
Certificate Programs
Learn more about our related Fundamental Business Administration Certificate, one of the DWC Certification Programs enrolling now.
Financial Aid
Click here to learn more about financial aid options including DWC’s 6-month payment plan, WIOA Workforce grant funding and more.
Terms & Conditions
Please read our Terms and Conditions before you register.
Available Public Classes
| Schedule/Cost | |||
|
Live Classes Price: $349.00 Space Available: 3 seat(s) Location: Digital Workshop Center - Ft. Collins - View Map Classroom: Flex Training Room Streaming Live Online Price: $359.00 Space Available(Online): 4 seat(s) Location: Online Course Closing Date: 3-14-2020 Instructor(s): Troy Namath |
||
| Choose Location: Digital Workshop Center - Ft. Collins - Online | |||
| Schedule/Cost | |||
|
Live Classes Price: $349.00 Space Available: 4 seat(s) Location: Digital Workshop Center - Ft. Collins - View Map Classroom: Community Room Streaming Live Online Price: $359.00 Space Available(Online): 4 seat(s) Location: Online Course Closing Date: 4-25-2020 Instructor(s): TBD |
||
| 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: