Introduction to Data Analysis using Microsoft Excel

4.6

746 個評分

提供方

33,012 人已註冊

在此免費指導項目中,您將:
2 hours
中級
無需下載
分屏視頻
英語(English)
僅限桌面

In this project, you will learn the foundation of data analysis with Microsoft Excel using sales data from a sample company. You will learn how to use sorting and filtering tools to reorganize your data and access specific information about your data. You will also learn about the use of functions like IF and VLOOKUP functions to create new data and relate data from different tables. Finally, you will learn how to create PivotTables to summarize and look at comparisons within your data. These skills will help you efficiently perform data analysis on many different types of data and give you the foundation to expand your toolbox as you explore other strategies for data analysis.

必備條件

您要培養的技能

  • Formulas and Functions in Spreadsheets

  • Data Analysis

  • Data Calculations

分步進行學習

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

指導項目工作原理

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

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

審閱

來自INTRODUCTION TO DATA ANALYSIS USING MICROSOFT EXCEL的熱門評論

查看所有評論

常見問題