Everyday Excel

"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. This course is the first 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 1), you will: 1) learn how to effectively navigate around the Excel environment; 2) edit and format Excel worksheets; 3) implement basic to advanced Excel functions (including financial, logical, and text functions); 4) learn how to manage data sets (filter, remove duplicates, consolidate data, sort data, and validate data); and 5) learn how to effectively visualize data through scatterplots, column charts, and pie charts. New to Excel? That is entirely fine! This course is meant to be fun, thought-provoking, and appeal to a wide audience. No prior knowledge in programming nor advanced math skills are necessary. The course is organized into 5 Weeks (modules). To pass each module, you'll need to pass a mastery quiz and complete a problem solving assignment. This course is unique in that the weekly assignments are completed in-application (i.e., on your own computer in Excel), providing you with valuable hands-on training.

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