Using Basic Formulas and Functions in Microsoft Excel

4.6
stars

387 ratings

Offered By

22,155 already enrolled

In this Free Guided Project, you will:
2 hours
Beginner-friendly
No download needed
Split-screen video
English
Desktop only

Have you started using spreadsheets like Excel and want to learn how to write formulas and functions to perform simple data analysis? In this project, you will learn about the general format for writing formulas and functions in Excel to perform analysis on the sales data from a sample company. In this analysis, you will calculate total sums of profits, you will learn how to use functions to analyze the popularity of the items sold and you will also learn how to calculate averages and percentages of monthly profits. Throughout the project, you will work through some examples that will show you how to apply the formulas and functions you have learned.

Requirements

Skills you will develop

  • Data Analysis

  • Numbers (Spreadsheet)

  • Calculations in spreadsheets

Learn step-by-step

In a video that plays in a split-screen with your work area, your instructor will walk you through these steps:

How Guided Projects work

Your workspace is a cloud desktop right in your browser, no download required

In a split-screen video, your instructor guides you step-by-step

Reviews

TOP REVIEWS FROM USING BASIC FORMULAS AND FUNCTIONS IN MICROSOFT EXCEL

View all reviews

Frequently Asked Questions