Everyday Excel Specialization
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).