"Everyday Excel, Part 1" is aimed at learners who are seeking to learn Excel from the ground up. No experience with Excel is necessary. While this course is meant for beginners of Excel, advanced users will undoubtedly pick up new skills and tools.
Этот курс входит в специализацию ''Специализация Everyday Excel'
147 491 уже зарегистрированы
от партнера
Специализация Everyday ExcelКолорадский университет в БоулдереОб этом курсе
Недавно просмотрено: 629 629
Гибкие сроки
Назначьте сроки сдачи в соответствии со своим графиком.
Сертификат, ссылками на который можно делиться с другими людьми
Получите сертификат по завершении
100% онлайн
Начните сейчас и учитесь по собственному графику.
Курс 1 из 3 в программе
Начальный уровень
A knowledge of algebra will help for some of this course.
Прибл. 24 часа на выполнение
Английский
Субтитры: Арабский, Французский, Португальский (Европа), Итальянский, Вьетнамский, Немецкий, Русский, Английский, Испанский
Чему вы научитесь
Navigating Excel, editing the worksheet (including inserting/deleting cells, columns, and rows), and cell formatting.
Expression entry and common Excel formulas (including logical functions, text functions, and financial functions).
Data management (sorting, filtering, consolidating, removing duplicates, data validation, and one-way lookups).
Data visualization (scatter plots, column charts, pie charts, Slicers, Sparklines, and Pivot Tables).
Приобретаемые навыки
Data ManagementSpreadsheetMicrosoft ExcelProblem SolvingReal World
Гибкие сроки
Назначьте сроки сдачи в соответствии со своим графиком.
Сертификат, ссылками на который можно делиться с другими людьми
Получите сертификат по завершении
100% онлайн
Начните сейчас и учитесь по собственному графику.
Курс 1 из 3 в программе
Начальный уровень
A knowledge of algebra will help for some of this course.
Прибл. 24 часа на выполнение
Английский
Субтитры: Арабский, Французский, Португальский (Европа), Итальянский, Вьетнамский, Немецкий, Русский, Английский, Испанский
от партнера
Колорадский университет в Боулдере
CU-Boulder is a dynamic community of scholars and learners on one of the most spectacular college campuses in the country. As one of 34 U.S. public institutions in the prestigious Association of American Universities (AAU), we have a proud tradition of academic excellence, with five Nobel laureates and more than 50 members of prestigious academic academies.
Программа курса: что вы изучите
6 ч. на завершение
Navigating Excel
In Week 1, you will learn basic worksheet navigation, how to open and save Excel files, and all about worksheets and workbooks. You will learn the difference between cells, columns, and rows in Excel, as well as cell references. You will learn how to move around the worksheet effectively using shortcut key combinations, and you will learn how to edit the worksheet. You will also learn how to format cells, conditionally format cells, and how to change between number, text, date, currency, and other cell formatting options. There will be particular emphasis on relative vs. absolute cell addressing modes and you will learn how to name cells and cell ranges. You will be introduced to basic macro recording using VBA and you will learn how to set personal preferences in Excel. Week 1 will conclude with a required quiz and an on-computer, in-application assignment. When you successfully complete Assignment 1, you will be given a "completion code", which you can input into the Assignment 1 submission quiz to earn credit for the assignment. The Week 2 material will be released when you have successfully passed Quiz 1 and Assignment 1. Good luck!
6 ч. на завершение
21 видео ((всего 118 мин.)), 9 материалов для самостоятельного изучения, 3 тестов
5 ч. на завершение
Expression Entry and Common Excel Functions
In Week 2 you will learn about how to properly write Excel syntax. You will learn the order of operations, how to input mathematical formulas into Excel, and how to troubleshoot when things don't go as expected. You will be introduced to just a few of the thousands of built in functions in Excel. The functions that you will learn about in this module relate to summing, counting, averaging, how to round numbers and calculate remainders, random number generation, and combinations and permutations. Week 2 concludes with a quiz and an on-computer, in-application assignment. Upon successful completion of these items, the Week 3 material will be unlocked. Good luck and have fun!
5 ч. на завершение
12 видео ((всего 70 мин.)), 3 материалов для самостоятельного изучения, 2 тестов
5 ч. на завершение
More Excel functions
In Week 3, you will learn more advanced functions in Excel. These include logical functions (IF, AND, OR) and advanced logical functions (SUMIF, COUNTIF, AVERAGEIF). You will learn how to effectively use Auto Fill and Fill Series but then I explain how to use text functions, which overcome some of the limitations of the Auto Fill feature. You will be introduced to Excel's financial functions (many more financial functions will be covered in Part 2 of the course), and you will learn how to use array formulas in Excel. Finally, I show how you can create your own user-defined function in VBA. Week 3 concludes with a quiz and on-computer, in-application assignment. When completed successfully, the Week 4 material will be released. Good luck!
5 ч. на завершение
12 видео ((всего 77 мин.)), 3 материалов для самостоятельного изучения, 2 тестов
5 ч. на завершение
Managing Data
Week 4 really gets at the heart of why Excel is so great for managing data. You will learn how to apply a filter, how to create an Excel Table, and how to validate data (for example, by only allowing items in a drop-down list). You will learn how to sort data, how to clean up data prior to using, how to remove duplicates in your data, and how to consolidate data from multiple sources. Finally you will learn how to use one-way lookup functions in Excel (VLOOKUP and the INDEX/MATCH combination). Quiz 4 and the on-computer, in-application Assignment 4 will test your understanding of the material in Week 4. Once you've completed these assessments, the Week 5 material will be unlocked. Good luck and have fun!
5 ч. на завершение
15 видео ((всего 73 мин.)), 3 материалов для самостоятельного изучения, 2 тестов
Рецензии
Лучшие отзывы о курсе EVERYDAY EXCEL, PART 1
от партнера RS17 апр. 2021 г.
Really good course for absolute beginners. It helps a lot to learn and practice on my own with the assignments. And the course instructor is also nice to us. Thanks for this course. Wating for Part 2.
от партнера MH28 апр. 2021 г.
That was extremely helpful, I liked it so much, I liked everything about it from the breaking down of new subjects, literally someone with zero experience in excel can understand and use these things
от партнера GF7 апр. 2021 г.
Great course!. It covers very basis tools to more complex features like vlookups function. I have learned new things and definitely very useful for the workday task. Looking forward for the Part 2.
от партнера SM13 февр. 2021 г.
the last time I engaged a formal Excel class was around the turn of the century. this course helped me brush up and learn new functions. I highly recommend the course to anyone in my circumstance.
Специализация Everyday Excel: общие сведения
This Specialization is for learners wishing to learn Microsoft Excel from beginner level to expert level. The first two courses will teach learners the basics of Excel through the use of dozens of educational screencasts and a series of quizzes and in-application assignments. Finally, in Part 3 (Projects), learners will complete several "real world", somewhat open ended yet guided projects. In the Projects course, special emphasis is placed on dynamic array functions, which are new in Office 365 and have revolutionized the way that worksheet calculations are performed.
Часто задаваемые вопросы
Когда я получу доступ к лекциям и заданиям?
Что я получу, оформив подписку на специализацию?
Можно ли получить финансовую помощь?
Остались вопросы? Посетите Центр поддержки учащихся.
