课程概述
热门审阅
LM
Jun 15, 2022
Very content with skills I learnt. However, some sections are not well explained and it seemed like the instructor was just going through them. For instance when teaching about "Flash Fill".
AE
Jul 29, 2025
Many of the commands explained in the videos or on the exercises are outdated, especially in the pivots section. I struggled to find its equivalent in Excel 365. Please update whatever is needed.
1701 - Excel Basics for Data Analysis 的 1725 个评论(共 2,178 个)
创建者 JAVIER M A B
•Nov 14, 2022
ok
创建者 Jaka P
•Nov 14, 2022
ok
创建者 ashveen k a
•Jul 3, 2022
..
创建者 Rohit S
•Apr 11, 2022
no
创建者 Rúben D M S
•Nov 20, 2021
w
创建者 Amenesh A M
•Apr 4, 2025
.
创建者 Ibrahim A S
•Dec 13, 2024
H
创建者 Abdullah - S
•Aug 23, 2023
o
创建者 Anita S
•Aug 23, 2023
创建者 Thomas P
•Jun 23, 2023
✕
创建者 Archana R
•May 10, 2023
5
创建者 Suleman M A
•Jan 11, 2023
n
创建者 JORGE V N A
•Nov 5, 2022
.
创建者 Tareq A
•Sep 28, 2022
m
创建者 Theerthesha
•Aug 27, 2022
C
创建者 vanam c b
•Jun 6, 2022
.
创建者 Taher E
•Mar 8, 2022
创建者 ghaith a
•Nov 8, 2021
♥
创建者 Evelyn S
•Aug 27, 2021
.
创建者 Kenny D
•Jun 15, 2021
创建者 Jill F
•Mar 3, 2023
I'm an experienced Excel user, but this course introduced me to some new tricks, such as the use of Flash Fill and the SUMIF function that will be helpful. If you're relatively new to Excel, you should find this course very satisfying.
A few things such as VLOOKUP are touched on too briefly. The pivot table segment is a good intro, but more detail is needed to explain WHY you might want to construct your table in a particular way. Complementary reference materials would be helpful.
The course is oriented toward data analysis in the business sector. Wish there was more consideration of Excel use in research contexts.
The lab activities allow you to try out the features covered in the course, and help familiarize you with concepts, but more depth would be needed to develop proficiency.
I'd love to see this course provide examples of how to document the "data cleaning and wrangling" steps in Excel. This seems like an important omission to address.
The assignments and grading process are straightforward and relatively easy to complete. It would be great to offer optional assignments for folks like me who are eager for more advanced exercises.
创建者 Stace S
•Aug 6, 2024
The course is broadly good. However, some of the differences between expected behaviors between some basic Excel functions like the age old File>Save or Save As and some of the newer MS 365 "rename" vs the need to download your work from the cloud in order to then upload it again for grading can be less than intuitive. This problem is compounded by the fact that such differences are characterized as minor in the course lectures. While that might be the case, the differences between the modern MS 365 functionality is deviating rapidly enough from those of older, local Office installation versions shown for lecture examples that the course appears to need an overhaul to keep things consistent. I did learn quite a bit, particularly in the area of pivot tables which I had thought to be more complex than they actually are.
创建者 jean j
•Mar 31, 2025
Eu diria que é parcialmente bom, falo isso como alguém que tem dificuldade com esse tipo de conteúdo, dentre as questões que podem melhorar estão: *Funções e fórmulas não traduzidas nas legendas * Erros de sintaxe e tradução em algumas provas (módulo 3 e 4) * Ao final do módulo 4 seria interessante fornecer os dados em um doc. excel que são apresentados na planilhas das aulas, para assim o aluno poder realizar os exercícios simultâneo a aula, isso fez falta na parte das tabelas dinâmicas. O Fator do exercício vir depois das instruções faz o aluno ter que retroceder para aulas já assistidas, o que poderia ser evitado se fosse orientado aos exercícios de forma simultânea em relação a tarefa ou documento fornecido.
创建者 Cathy R
•Jul 30, 2025
Good orientation and re-introduction to Excel for data analysis. For those who don't have Excel, the Excel on the web is undoubtedly useful. But twice the service was down (not the course's fault) and so I used Excel from my 365 subscription. As acknowledged in the course, there are differences between "canned" Excel and Excel by subscription. Add to that the differences between PC and Mac versions of Excel. There really should be a cheat sheet for shortcuts for PC and Mac on BOTH Excel on the web and Excel 365 subscription. Would save time spent hunting for the right keys and key combos. Thanks to the instructors!
创建者 Daniel J N C
•Jul 27, 2021
An informative and practical course. I have enjoyed it. One big negative is the peer review as some people don't take the time to properly assess your work and you get marked down when you shouldn't. There are also a few flaws with the marking rubic examples which confuse people. I'd love the opportunity to discuss these with the course providers but I can't find any way of contacting them. If you come across the same problem, try resubmitting your work, it will be reviewed again by someone new and hopefully by someone who understands the marking scheme properly. It worked for me.