Data Manipulation and Business Analysis using Spreadsheets

4.2
79 個評分
提供方
Coursera Project Network
3,222 人已註冊
在此免費的指導 項目中,您將:

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.

在面試中展現此實踐經驗

Clock1 hour
Intermediate中級
Cloud無需下載
Video分屏視頻
Comment Dots英語(English)
Laptop僅限桌面

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 https://www.google.com/gmail/ to set up your account.

您要培養的技能

SpreadsheetData AnalysisMathematicsPivot TableLookup Table

分步進行學習

在與您的工作區一起在分屏中播放的視頻中,您的授課教師將指導您完成每個步驟:

  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.

指導項目工作原理

您的工作空間就是瀏覽器中的雲桌面,無需下載

在分屏視頻中,您的授課教師會為您提供分步指導

講師

常見問題

常見問題

還有其他問題嗎?請訪問 學生幫助中心