Everyday tasks in Excel (part 2)

"Everyday Excel, Part 2" is a continuation of the popular course "Everyday Excel, Part 1". Building on the concepts learned in the first course, you will continue to expand your knowledge of Excel applications. This course is designed for intermediate users, but even advanced users will gain new skills and tools for working in Excel. By the end of this course, you will have the skills and tools necessary to work on the project "Everyday Excel, Part 3 (Projects)". This course is the second part of a three-part series and specialization that focuses on teaching beginner to very advanced techniques and tools in Excel. In this course (Part 2), you will: 1) Master advanced data management techniques; 2) Learn to perform financial calculations in Excel; 3) Use advanced Excel tools (Data Tables, Goal Seek, and Solver) to perform and solve what-if analysis problems; 4) Learn to create mathematical models of predictive regression using the Regression tool in Excel. This course is intended to be engaging and thought-provoking. I hope that at least a few times during the course you will say to yourself, "Wow, I never thought of that before!" Given the wide range of experience and abilities of the learners, the course aims to appeal to a broad audience. The course consists of 5 weeks (modules). To complete each module, you will need to pass a knowledge test and a problem-solving assignment. What makes this course unique is that the weekly assignments are completed in application mode (i.e. on your own computer in Excel), which provides you with valuable practical training.