Excel Advanced 2: Advanced Formulas

❝ Thank you for providing such a great first session! I thought the flow and how you explained functionality was perfect – very detailed, thorough, and easy to understand. I’m already getting feedback from some of the team that they loved the training.
- Heidi Hartwig, Director, National Field Sales Operations, Ultra Mobile

Upcoming Dates

Friday, December 20, 2024

12:00 PM - 3:00 PM Pacific Time
Trainer: Tim

Register

Cost

Price per person: $149
Length of class:three hours
Version covered:for Office 365
Delivery format:live over Zoom


Description

In this three-hour session for Windows and Mac users, you will learn how to write complex formulas using Excel's advanced built-in functions. You will expand your library of functions to include lookup and reference functions, conditional logic, and dynamic array functions. You will also become expert at using mixed references to make copying formulas horizontally and vertically work the way it should.


Prerequisites

This class is ideally suited for those who have attended the Excel Beginning 2: Simple Formulas class or who are already comfortable creating basic formulas like SUM, AVERAGE, COUNT, LEFT, MID, RIGHT and PMT.


Outline

Lookup and Reference Functions
- VLOOKUP and HLOOKUP to fetch values from a list
- nesting functions inside functions
- absolute references and mixed references
- conditional formatting
- lookups in tables, and structured references
- range lookups
- range names
- INDEX and MATCH for more versatile lookups
- creating in-cell drop-down menus
- XLOOKUP function

Logical Functions
- IF function to construct conditional logic
- AND and OR functions for multiple conditions
- IFS function
- IFERROR function
- COUNTIF, COUNTIFS, SUMIF, SUMIFS

Dynamic Array Formulas
- SEQUENCE function
- SORT and FILTER functions
- UNIQUE function


Printable Course Description


More quotes from our Excel students

  • The class was amazing, and I was able to learn in detail the meaning behind each formula used, thanks to your guidance and patience. Look forward to taking another course with Accelerate soon!
    Silvia Wang, Senior Product Developer
  • Some people are meant to be trainers and you are one of them – you are very clear, thorough, keep a good pace and retain everyone's attention, which is very hard for such a long session. Thanks again for everything!
    - Heidi Hartwig, Director, National Field Sales Operations, Ultra Mobile
  • I wanted to check in to tell you that Sue was amazing! I learned so much in the (Excel PivotTables) course. She was knowledgeable, thorough and patient. I learned many new things that I can take back into my role and apply real world! Sue even counseled on future courses, so I’ll likely be back soon. She was also incredibly complimentary of you, the organization, the textbook and approach. I just wanted to reach out to say thank you to you and thank you to Sue!
    - T. Adams
  • I just received a message from an attendee saying it was the most informative class he'd ever taken. You and your team are really great. Thank you so much for sharing your deep knowledge of Excel with us in such an accessible way! We will definitely want to have you (or any of your staff) back again.
    - Jocelyn, Caltech Library
  • I did a ton of research and comparison before I enrolled to take my classes with you, by far you're the best in Long Beach and the South Bay.

    In my professional life I have encountered a number of corporate trainers, management, business owners, and entrepreneurs, you and your staff really do represent what training and education should be. Everyone is welcoming and knowledgeable, along with kind and understanding. Those attributes are something that really needs to be out there, so that other consumers can make the right choice for education and come to you first.
    - Melissa H.
  • I truly enjoyed your training and feel your classes are amazing and informative. The time and patience you take to teach your students is exemplary. I've been to a few trainings in my 38 years of service to the county and found you are the best I've attended.
    - Sandy Contreras Rodriguez, LA County Hall of Records
  • I wanted to write back to say thank you and Sue for providing a great training day on 10/15. I think that, for the fact that I took two classes in a row but some of the information was a 'refresher' for my memory, the info was just enough for my brain. Though I know there were so few of us students that day, even if the classroom were full, I would still appreciate knowing that it's small enough so that everyone gets enough attention. And I could see that Sue was very attentive toward us and truly wanted to make sure we were understanding the lessons. I encouraged my colleagues to sign up with Accelerate should any of them want or require offsite computer training.
    - Kimberly D., American Honda Motor Company
  • I wanted to thank you for your terrific work with our team last week. Our attendees are universal in their praise for Accelerate, the Excel classes, and your personal work as trainer with our team. The material covered and class tempo satisfied all in attendance. Even the more advanced of our participants experienced “aha!” moments during your class. All attendees have expressed that they expect these classes will have a direct, positive impact on their day-to-day performance. We will look forward to working with you again soon!
    - Tim Nekuza, Dental Health Services
  • Use Sue Smith as an instructor always. She is great and has a great method of teaching, the best personality, an amazingly knowledgeable instructor. My best class ever from any class taken.
    - Accelerate student
  • It has been a few months since my class and I am still applying the information that I learned to everyday work. Tim Jones is a wonderful instructor who makes learning enjoyable.
    - Accelerate student
  • Tim is a very good tutor. Extremely easy to understand and moves the class at a steady pace. I came to this class feeling I had very little knowledge of Excel, but am learning. I learned much more than I thought I would. I now feel more confident with Excel. I look forward to taking the Advanced Excel class if Tim is the instructor.
    - Accelerate student
  • The Intermediate Excel seminar put on by Accelerate Computer Training was one of the best seminars I have attended. The instructor was an expert in her field and was able to cover the material in a way that was easy to understand. I learned so much during the course that I will use constantly in my position at Broadcom. Thank you so much for putting together a great training! I will definitely recommend ACT to all of my peers!
    - Jordan G., Broadcom Corp.