Course Highlights
  • 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
Curriculum

5 Topics
Upload a document using the free online version of Microsoft Office 365.
Write functions in Excel to perform simple calculations like addition subtraction multiplication and division.
Use the SUM function and multiplication formula in Excel to perform analysis on sales data for a co
Use the SUMIF function in Excel to perform analysis on the popularity of the items sold from the company sales data
Use formulas to calculate averages and percentages in Excel to perform analysis on the monthly profits from the company sales data

  Write a Review

Using Basic Formulas and Functions in Microsoft Excel

Go to Free Course