#Courses

Using Basic Formulas and Functions in Microsoft Excel

Using Basic Formulas and Functions in Microsoft Excel

Course Duration: 2 Hours

About Microsoft Excel Course that you Learn In this Course

  • 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

Skill you'll Practices

  • Category: Numbers (Spreadsheet)
  • Category: Calculations in spreadsheets

About Guided Project

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.

For More Update Join Available Links

red-arrow-down-icon-png-30

Leave a comment

Your email address will not be published. Required fields are marked *