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.
WHAT YOU WILL LEARN
- In this specialization, you'll learn a variety of Excel tools, techniques, and functions, which you'll apply to real-world, "open-ended" projects.
- 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).
"Everyday Excel, Part 2" is a continuation of the popular "Everyday Excel, Parts 1 ". Building on concepts learned in the first course, you will continue to expand your knowledge of applications in Excel. This course is aimed at intermediate users, but even advanced users will [...]
"Everyday Excel, Part 3 (Projects)" is a continuation of "Everyday Excel, Parts 1 and Parts 2 ". It is a capstone, projects-based course in which you will apply what you've learned previously to more complex, somewhat open-ended projects (open-ended with respect to the fact [...]
"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.