Select Page

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.

Microsoft Advanced Excel Formulas & Functions - Fort Collins, Denver & online
Class Performance Based Objectives - Digital Workshop Center

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 - Digital Workshop Center

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 Information - Digital Wiorkshop Center

General Info:

  • Target student: Beginner to Intermediate
  • Coursework may be assigned outside of class
  • Computer & software provided in class
  • Class size limited
Class Pre Requisites - Digital Workshop Center

Pre-requisites:

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


Dates/Times Information
Mon 5-07-2018
   1:30pm - 5:00pm
Wed 5-09-2018
   1:30pm - 5:00pm

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
Mon 6-25-2018
   9:00am - 12:30pm
Wed 6-27-2018
   9:00am - 12:30pm

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
Mon 8-20-2018
   1:30pm - 5:00pm
Wed 8-22-2018
   1:30pm - 5:00pm

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: