Data Manipulation and Business Analysis using Spreadsheets

79 ratings
Offered By
Coursera Project Network
3,263 already enrolled
In this Free Guided Project, you will:

Manipulate text data using some functions and tools such as MID, RIGHT, LEFT, CONCATENATE, FIND, and SUBSTITUTE.

Analyze data professionally using pivot tables and VLOOKUP to summarize large datasets and lookup values.

Showcase this hands-on experience in an interview

Clock1 hour
CloudNo download needed
VideoSplit-screen video
Comment DotsEnglish
LaptopDesktop only

In this 1-hour long project-based course, you will learn how to manipulate data by formulas and apply the functions to extract the words from the text. Moreover, you will be able to identify and manage your string data. Finally, you will be able to create pivot tables and lookup functions to summarize and analyze your data sets. This project will show you how to Manipulate text and how to analyze it to present it professionally in different ways. This guided project is for people in the field of business and data analysis. It provides you with important steps to be a data analyst. Moreover, it equips you with the knowledge in spreadsheets related to business analysis and how to manipulate data by functions. Note: This project works best for learners who are based in the North America region. We’re currently working on providing the same experience in other regions.


Familiarity with google sheets.

If you do not have a Gmail account navigate to to set up your account.

Skills you will develop

SpreadsheetData AnalysisMathematicsPivot TableLookup Table

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:

  1. Manipulate data and replace old words with new ones using the SUBSTITUTE function.

  2. Apply the functions to extract words from texts and concatenate words using some functions such as MID, RIGHT, LEFT, CONCATENATE, FIND, and SUBSTITUTE.

  3. Apply VLOOKUP functions to analyze data and lookup values.

  4. Create a pivot table and summarise, sort, reorganize, group, count total, or average data stored in a table.

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


Frequently asked questions

Frequently Asked Questions

More questions? Visit the Learner Help Center.