Create an account in Microsoft Office 365 and upload a file to open with Excel
Write formulas to perform simple calculations like addition, subtraction, multiplication and division
Use the SUM and SUMIF functions to analyze data on the sales of a sample company as well as calculate averages and percentages
Have you used Excel or other spreadsheet programs and are interested in learning how to create formulas and functions for basic data analysis? To be able to analyze the sales data of the sample company, in this task you will learn how to develop the formulas and functions of the general model in Excel. In this study, you will calculate total profit amounts, learn how to use functions to estimate product sales popularity, and calculate monthly profit averages and percentages. You’ll go through some examples throughout the project to show how you can use the functions and formulas you’ve learned.