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:

Financial aid now available for ALL classes

Testimonials – Microsoft

I was very satisfied with this course. The instructor listened and responded to our questions. This was a great learning experience and hopefully will be able to utilize the knowledge in my new career.

P. Hansen

Digital Workshop Center is an incredible resource for individuals and companies looking to expand and improve their skill sets. The small class sizes allow for an open dialogue between the students and instructors, which is ideal when the material is new and unfamiliar.

Melissa Matonis

Digital Workshop Center provides something unique in the Northern Colorado area: workshops that are hands-on, well-conducted and offered at a variety of times to suit busy schedules.

Karen Wheeler

Classes were well-structured, with adequate time for breaks and questions. The instructor’s willingness to stop the class to answer our many questions and run through multiple examples was extremely helpful, and I believe we learned more applicable skills in the smaller group setting than we ever could have in any high-dollar seminar.
As an added bonus, the setting provided a good learning and bonding time for our team, and the environment was one of positive learning. I was very happy to recommend their courses to other departments in our organization, and would gladly take courses with Digital Workshop Center again.

Jessica Titchener

Excel classes at Digital Workshop Center were some of the best classes I have ever taken. The class size and pace was perfect for me. Very useful and beneficial!

Karen Gallegos

Digital Workshop Center understands the balance between customized training and allocating time to get the training done. Their flexibility in assisting us here at Triple Crown Sports with our needs in technology training has been superb, along with their attention to detail in regards to the topics they offer and the custom topics we have requested.

Patty Harsch

This class was very informative and the instructor kept the class very interesting and made sure each of us understood what he was teaching us. I enjoyed this class and will definitely take another class to further my education on Microsoft classes.

P. Hansen

The instructor was extremely knowledgeable in Excel. I came in with a standard working knowledge from using Excel at IBM but, he showed me shortcuts to things and explained how to use certain functions that I didn’t know which was awesome. He was patient and answered all my questions. He made the class fun and enjoyable.

A. Ballard

The instructor was great – the most valuable part of the class was where he used real world examples and helped us think through our own processes.

Anonymous

Jonathan was very helpful in my Introduction to Windows class. He answered any and all questions that I had and was very patient with me learning everything. I had a great experience.

S. Haugen

DWC & Adobe

Digital Workshop Center is the ONLY Adobe Authorized Training Center in Northern Colorado and second in the state.

Related Microsoft Office Classes

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.