As data becomes the modern currency, so the ability to analyse the data quickly and accurately has become of paramount importance. Excel with its extraordinarily broad range of features and capabilities is one of the most widely used programs for doing this. In the first course of our Excel Skills for Data Analysis and Visualization Specialization, you will learn the fundamentals of Excel for data analysis. When you have completed the course, you will be able to use a range of Excel tools and functions to clean and prepare data for analysis; automate data analysis with the help of Named Ranges and Tables; and use logical and lookup functions to transform, link and categorise data.
このコースについて
貴社では、従業員に需要のあるスキルを訓練させることによって利益を得ることができるでしょうか?
Coursera for Businessを試す学習内容
Use Excel tools and functions to clean and prepare data for analysis.
Use Named Ranges and Tables to automate your analysis.
Understand the different types of data in Excel and use appropriate functions to work with them.
Use logical and lookup functions to transform, link and categorise data.
習得するスキル
- Data Analysis
- Microsoft Excel
- Data Cleansing
貴社では、従業員に需要のあるスキルを訓練させることによって利益を得ることができるでしょうか?
Coursera for Businessを試す修士号の取得を目指しましょう
MasterTrack認定は、オンラインモジュールに分割された修士課程の一部です。そのため高品質の大学発行のキャリア資格を画期的な価格で柔軟かつインタラクティブな形式で取得できます。プログラムに登録すると、コースワークはMasterTrack認定に向けてカウントされます。
シラバス - 本コースの学習内容
Welcome and critical information
Cleaning and manipulating text
Working with numbers and dates
Defined Names for working more effectively with data
Tables for automating data manipulation
レビュー
- 5 stars81.89%
- 4 stars15.84%
- 3 stars1.51%
- 2 stars0.23%
- 1 star0.50%
EXCEL FUNDAMENTALS FOR DATA ANALYSIS からの人気レビュー
Thank you for this course! It was a lot of fun and easy to follow. I loved the assignements when not only that weeks knowledge was tested but also something randomly from previous weeks.
Short and thorough course on sorting out data which also helps you to understand how to combine Tables and Named Ranges as well as using a combination of nested intermediate level formulas.
Super fun and and intellectual course. Real need of hour to excel in Excel :) . This course helped a lot, in improving skills in excel analytics.
special thanks to both the instructors !!!!!!!
Very comprehensive and clearly laid out course with loads of content. Great videos, well explained and loads of practice exercises. I feel as if I've learned a great deal, Very Valuable, thank you
Excel Skills for Data Analytics and Visualization専門講座について

よくある質問
いつ講座や課題にアクセスできるようになりますか?
この専門講座をサブスクライブすると何を行うことができるようになりますか?
学資援助はありますか?
さらに質問がある場合は、受講者ヘルプセンターにアクセスしてください。