Microsoft Excel: Advanced Excel Formulas & Functions
Learning how to use formulas and functions in Microsoft Excel is crucial to success in the program. 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 will teach you how to manipulate text data, use dates in formulas, calculate complex statistical problems, include conditional logic and much more. You will leave our classes confident in creating advanced functions for any Excel scenario.
Class Objective: You will learn many types of advanced Excel formulas and functions, including Text, Date, Financial, Logical, and Lookup functions.
Target Student: This course is designed for students who desire to build advanced formulas in their spreadsheets.
Performance-Based Objectives
Upon successful completion of this course, 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
Pre-requisite: 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.
Course Includes
- Professional Textbook
- Download materials with practice examples
- 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
Class Info
- Classroom equipped with computers and software
- 7 hours of training
- Breaks are taken throughout each session
- Class size limited
- Target Audience: Advanced
Financial Aid
Click here to learn more about financial aid options including DWC’s 6-month payment plan, WIOA Workforce Funding, and more.
Terms and Conditions
Please read our Terms and Conditions before you register.
Available Classes
| Dates/Times | InformationONLINE | ||
|---|---|---|---|
|
Price: $239.00 Space Available: 15 seat(s) Course Closing Date: 6-28-2017 Location: Online Instructor(s): Jonathan Bodell |
| Dates/Times | Information | ||
|---|---|---|---|
|
Price: $229.00 Space Available: 16 seat(s) Course Closing Date: 7-03-2017 Location: Digital Workshop Center - Ft. Collins - View Map Classroom: Classroom Instructor(s): Jonathan Bodell |
| Dates/Times | InformationONLINE | ||
|---|---|---|---|
|
Price: $239.00 Space Available: 16 seat(s) Course Closing Date: 7-18-2017 Location: Online Instructor(s): Jonathan Bodell |
| Dates/Times | Information | ||
|---|---|---|---|
|
Price: $229.00 Space Available: 15 seat(s) Course Closing Date: 7-23-2017 Location: Digital Workshop Center - Ft. Collins - View Map Classroom: Classroom Instructor(s): Jonathan Bodell |
| Dates/Times | InformationONLINE | ||
|---|---|---|---|
|
Price: $239.00 Space Available: 16 seat(s) Course Closing Date: 8-21-2017 Location: Online Instructor(s): Jonathan Bodell |
| Dates/Times | Information | ||
|---|---|---|---|
|
Price: $229.00 Space Available: 16 seat(s) Course Closing Date: 8-26-2017 Location: Digital Workshop Center - Ft. Collins - View Map Classroom: Classroom Instructor(s): Jonathan Bodell |
Other 1-ON-1 and Group Training Options
Private Class - Contact us for pricing and scheduling
Custom, Hourly Training - Submit a Consulting RequestDWC & Adobe
Digital Workshop Center is the ONLY Adobe Authorized Training Center in Northern Colorado and second in the state.
Online Classes
This class is available for online training! The Digital Workshop is now offering many of our courses online in a webinar-style format. Our classes are always taught by a live instructor as we aim to keep the human element of a traditional classroom alive in an online format.
Click here to request more information and register for our courses online.
Technical Support
