Microsoft Excel Advanced Formulas & Functions
Level 3 | Target Audience: Advanced | 7 hours
Our Microsoft Excel Advanced Formulas & Functions class is focused on solving complex problems through analyzing your data more closely. Expert instructors will take you from basic formula creation to advanced logical and look-up functions. Throughout this advanced training, learn productivity tricks and best practices using specialized functions in Excel. This advanced Excel training will help you add valuable skills to your resume and help you become a power Excel user.
Microsoft Excel Advanced Formulas & Functions Classes
No classes to show
Not finding what you want? Contact us for more info
Overview
When you learn to utilize advanced Excel functions, you can write your own custom, complex formulas and manipulate your data in creative ways. In this advanced Excel class, you will become confident in manipulating text data, using dates in formulas, calculating complex statistical problems, and adding logic to your spreadsheets. More importantly, you can edit, calculate, or manipulate your data to find answers to complex problems.
As you work through the sessions of Microsoft Excel Advanced Formulas & Functions, each class will be a hands-on and intensive workshop, designed to help make difficult topics easier to understand. Your instructor, a Microsoft expert, will work with you closely to make sure that you avoid common mistakes in Excel and apply best practices when possible.
Class Objectives
Upon successful completion of the Microsoft Excel Advanced 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
Pre-requisites
- Basic digital literacy including file management is required.
- Microsoft Excel Beginners (Level 1) or equivalent knowledge is required.
- It is required you install the latest Microsoft Office software before starting class.
Talk to a student advisor to ensure you have the right pre-requisites for each class or program.
Alumni Spotlight
Inside Our Curriculum
Focus on Real-World Skills
Each of our stand-alone classes is designed to teach how to improve your skills in a real-world setting. DWC's experiential learning style ensures you will be guided by an expert instructor will performing all of the tasks to help you learn.
The challenges you face in class will mimic what you will need to land a job and improve your daily productivity.
Related Certificate Programs
Explore related full length programs including:
Support & Mentoring
All Microsoft Excel classes are offered in an accelerated workshop format.
Your instructor will provide hands-on, experiential style classroom learning for you to learn best practices of applying tech skills in the real-world.
Each class may be eligible credit towards a certification program, which includes career counseling and portfolio projects.
Flexible scheduling options allow you to choose what works best for your time.
Why Digital Workshop Center?
81%
of program graduates last year from unemployed to employed.
2.9
months avg to find employment after graduation
$12k
average increase in salary of certificate program students
1-on-1
Always Live | Hands-On | Small Class Sizes | Expert Instructors | Streaming Online
*program statistics compiled from DWC enrollment report (2019-2021)
FAQs
When can I start?
Classes are offered on a rolling enrollment basis multiple times throughout the year, typically once per trimester.
Who teaches these classes?
All classes are taught by industry professionals with 10+ years experience in their field. Check the specific class offering to learn more about the assigned instructor for each class.
You may also learn more about our team here.
What format are these classes?
Stand-alone classes at DWC are focused skills workshops that teach in a specific area of a high demand career field.
Often described as a "short course" format, these accelerated workshops can be attended as stand-alone or can be taken as part of a larger certificate program.
Certificate programs offer more comprehensive training to help lead you to empoyment, support & mentoring, portfolio building, and career coaching.
To find out more about DWC's style of training, talk to a student advisor today.
What if the listed schedule doesn't work for me?
Click to request more information on a private class or contact us to discuss your training options.
What's included?
Certificate Programs & Bootcamps
Each Certificate Program & Bootcamp is comprised of several stand-alone classes, plus additional classes specific to your career field, portfolio building with a comprehensive Capstone Project, and career coaching workshops.
Support and mentoring a huge part of all of our full length programs.
Attend an upcoming info session to speak to a student advisor and learn more details of the programs and get your questions answered.
Stand-Alone Classes
Every stand-alone class at DWC includes support and mentoring throughout.
Stand-alone classes within your program also include:
- Professional Textbook(s) or Reference Packet(s)
- Lesson files
- One year for a free re-take (for attended students of public classes only)
- 30 days of technical support
- Certificate of Completion
If you have questions on stand-alone classes for professional development, contact us or attend an upcoming info session to speak to a student advisor and learn more details of the programs and get your questions answered.
What career services or internships do you offer?
For full length programs, support and mentoring is included and you will be eligible to work one-on-one with a career counselor.
Workshops for job search and resume writing are included in the cost of your program. Our expert career advisors will help you prepare for the next steps of your career path. Your success is our success.
Click here to learn more about career counseling
DWC partners with Parker-Dewey to offer micro-internships to our students. These project-based internships are a great way for students to build real-world experience. Learn more
Attend an upcoming info session to speak to a student advisor and discuss career coaching & internship options today.
Payment & financial aid options
DWC offers several flexible financial aid options to help you finance your education. None of our financial aid tools will require a federal student loan or add severe interest penalties. We have several flexible payment plan options that fit your monthly budget.
If you are interested in scholarship or financial aid opportunities, attend an upcoming info session to speak to a student advisor and learn more.
Click here to learn more about financial aid options and get started.
Terms & conditions
Please read our Terms and Conditions before you register.
Still curious?
If you have more questions, view the full FAQ page or contact us today.
Upcoming Microsoft Excel Classes
No classes to show