Chevron Left
Back to Everyday Excel, Part 2

Learner Reviews & Feedback for Everyday Excel, Part 2 by University of Colorado Boulder

4.7
stars
572 ratings

About the Course

"Everyday Excel, Part 2" is a continuation of the popular "Everyday Excel, Part 1". Building on concepts learned in the first course, you will continue to expand your knowledge of Excel, particularly with respect to the new (as of 2020) dynamic array functions and formulas. Dynamic array formulas create the foundation for "modern" Excel. This course is aimed at intermediate users, but even advanced users will pick up new skills and tools in Excel. By the end of this course, you will have the skills and tools to take on the project-based "Everyday Excel, Part 3 (Projects)". This course is the second part of a three-part series and Specialization that focuses on teaching introductory through very advanced techniques and tools in Excel. In this course (Part 2), you will: 1) learn dynamic array functions and how to create dynamic array formulas to accomplish many productive tasks in Excel; 2) become affluent in a variety of lookups (two-way forward lookups, one-way reverse lookups, and two-way reverse lookups) and create Top 5/Bottom 5 lists; 3) learn numerous advanced data management techniques, including filtering for multiple criteria, conditional drop-down lists, reconciliation problems, creating repeating arrays of other arrays and sequences, and randomizing (with and without repetition); and 4) learn how to create professional dashboards using Pivot Tables, Pivot Charts, and Power Query. The course is organized into 5 Weeks (modules). To pass each module, you'll need to complete two programming assignments and a mastery quiz (the final module does not have programming assignments). Given the wide range in experience and abilities of learners, the goal of the course is to appeal to a wide audience. This course is meant to be fun and thought-provoking. I hope for you to at least several times in the course say to yourself, "Wow, I hadn't thought of that before!"...

Top reviews

BG

Aug 14, 2020

Charlie is an AMAZING instructor - I learned a lot, and I wouldn't have if it weren't for his teaching style!

TK

May 17, 2023

It's the best course for Excel and for beginners and I really enjoyed learning this whole and it was a great experience.

Filter by:

76 - 100 of 148 Reviews for Everyday Excel, Part 2

By Collin M

•

Nov 14, 2022

Excellent course content and instruction on tools essential for data analysis with Excel.

By Mehmet A P

•

Jan 29, 2021

It was very helpful to me even though the fact that I had no specific talents in excel!!!

By tapiwa z

•

Jun 26, 2021

Versatile course, finance, sensitivity, scenario analysis, modelling, statistics.

By PYLA S V

•

Feb 2, 2022

it really helped me a lot thank u so much for providing the wonderful sessions

By Durango P D

•

Mar 8, 2022

muy buen curso, con actividades que agregan mucha pràctica y conocimiento

By David R

•

Oct 1, 2022

Great course, quite challenging. Builds on skills learned in Part 1.

By Udita T

•

Nov 16, 2021

Fantastic instructor and great course. Learnt a lot!

By Ahmed A

•

Mar 13, 2021

I have got a lot of info from this course.

Thank You

By Dipti S

•

Jan 11, 2022

a very good course to sharpen your excel skills

By Ignacio A H G

•

Mar 7, 2021

A great course with a challenging assignments

By siuli m

•

May 12, 2023

One of the best courses in advance excel!

By Dardo C

•

Apr 16, 2022

Excellent course of Excel, recommendable

By Nelson E G C

•

Jan 9, 2022

Excellent, the instructor is the best ...

By ASWINI M

•

Aug 8, 2025

Great explanation. Very Interesting.

By Shubham B

•

Mar 16, 2022

Learnt a lot of new things. Thanks.

By Jeison G

•

Dec 15, 2025

asda edfsadfwescaefadasd sdfsdf

By EPEFANIO J N F

•

May 21, 2023

This will help me on my job :**

By Rajat U

•

Apr 17, 2025

Best excel course out there!!!

By Baricsa J

•

Jun 6, 2022

Great content and explanation.

By Juan P G H

•

Mar 4, 2024

muy bueno, facil de entender

By AFREEN B

•

Feb 20, 2022

It's really a helpful course

By Salvador d l R

•

Oct 30, 2020

Great and challenging course

By Vinamra P S

•

Nov 24, 2024

great course to learn excel

By Sharon K

•

Feb 2, 2022

great ! thank you so much