In the second module, you’ll explore formulas and functions and their importance to data analysis. You’ll begin the module with a lesson on using formulas in Excel to perform calculations. You’ll learn what the concept of a formula is, discover the syntax for different types of calculations, and complete a calculation-based exercise. In the next lesson, you’ll learn how to use common formulas and functions in a worksheet. Both of this week’s lessons also end with exercises that test your new skills.

In the third module, you’ll learn how to prepare data for analysis using functions. You’ll begin with a lesson on using functions to clean or standardize text to prepare text data for effective analysis. You’ll then explore the use of date and time functions in Excel so that you can complete actions like creating timeline information in a spreadsheet. In the final lesson of this week, you’ll review the use of logical functions like IF and IFS. And you’ll learn how to use these logical functions to generate content like data columns. Each lesson concludes with an exercise where you'll practice your new skills by completing assigned tasks in Excel.

In the fourth week, you’ll undertake an assessment of the key skills that you covered in the course. You’ll begin with a course recap in which you’ll review the important lessons you learned. You’ll also be able to apply the knowledge you've gained in the previous weeks by completing a scenario-based project. You’ll then undertake the course quiz, which tests your knowledge of the concepts and techniques you've explored. You’ll complete the course by reflecting on what you’ve learned with your peers in a discussion. Finally, you’ll explore the next steps in this Professional Certificate.