Chevron Left
返回到 Everyday Excel, Part 2

学生对 University of Colorado Boulder 提供的 Everyday Excel, Part 2 的评价和反馈

4.7
星
572 个评分

课程概述

"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!"...

热门审阅

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.

筛选依据：

101 - Everyday Excel, Part 2 的 125 个评论（共 148 个）

创建者 Archisha B

•

Sep 19, 2020

Challenging but worth it.

创建者 Deleted A

•

May 30, 2020

Challenging Nice course!

创建者 Shariff A K J 2

•

Jan 23, 2023

this course was nice

创建者 SRIKANTH C V

•

Jan 26, 2022

nice and easy course

创建者 Karla F

•

Dec 19, 2020

it is a must learn!

创建者 Aritta S

•

Feb 19, 2022

Very useful course

创建者 John M O

•

Jan 20, 2021

Amazing instructor

创建者 Jatin D

•

Jul 25, 2020

Excellent Course!

创建者 Mallela H 2

•

Jan 1, 2023

Very Nice Course

创建者 Syed F I Z

•

Dec 7, 2021

Excellent course

创建者 Jeffrey A P P

•

Aug 31, 2020

Great course! A+

创建者 Nteboheleng L L

•

Aug 17, 2020

very well taught

创建者 CHETLAPALLI R S Y V

•

Jan 29, 2022

nice learning

创建者 David Y

•

Nov 5, 2021

So enriching!

创建者 Giuseppe L R

•

Jan 19, 2025

Very USeful

创建者 bounphet t

•

Apr 21, 2023

good course

创建者 Mohamed S P V

•

Jan 15, 2021

good course

创建者 aboya g k b

•

Nov 4, 2021

thanks you

创建者 Nicole P

•

Oct 1, 2025

Excelente

创建者 Marce C

•

Jun 29, 2023

Excellent

创建者 VENKATA S A T B

•

Jan 25, 2022

excellent

创建者 Diego A R

•

Jul 25, 2021

fantastic

创建者 Franc V

•

Feb 16, 2024

GREAT!!

创建者 Joao V C S

•

Jan 9, 2021

Great!!

创建者 Rami I

•

Apr 5, 2024

Great