- 提示:
- 透過本站連結購買Udemy課程,本站將獲得推廣佣金,有助未來提供更多實用進修課程資訊給讀者。
課程資料
- 可獲發
- (證書的發放與分配,依課程提供者的政策及安排而定。)
課程簡介
Using formula, charts, pivot tables , what-if analysis and Solver add-in to understand complex data
This course on "Data Analysis Using Excel" is a beginner level course in Excel that helps in dealing with large amount of data and drawing meaningful conclusions from the data.
The course begins with the use of functions and formulae so that you can transform the raw input into meaningful data. You learn how to visually represent data using different techniques like charts, pivot charts and sparklines. These techniques will let you choose the best method available as per your specific requirement. To slice and dice large data sets and to understand hierarchical relationships between data, you will learn the use of pivot tables. You will learn to give a professional touch to your reports by the use of header and footer. You will learn different tools which aid in decision making - like the goal seek or the scenario manager. You will learn how to let Excel solve complex optimization problems for you using he Solver add-in.
By the end of this course, you will be able to transform raw data into meaningful reports, identify trends, test scenarios, and make informed decisions. Whether you are a student, professional, or business user, this course will help you harness the full potential of Excel for smarter and faster data analysis.
課程章節
- 8 個章節
- 58 堂課
- 第 1 章 Introduction
- 第 2 章 Module1: Using Formulae
- 第 3 章 Module2: Data Visualization Using Charts
- 第 4 章 Module 3: Pivot Tables and Pivot Charts
- 第 5 章 Module 4: Adding Sparklines, Headers and Footers
- 第 6 章 Module 5: Problem Solving Using Excel
- 第 7 章 Module 6: Interactive Dashboard using Excel
- 第 8 章 Recap
課程內容
- Learn how to create formulae and identify the right formula for a use case. Troubleshoot and debugging of formulae
- Add visualization techniques i.e. charts, pivot charts and sparklines to tables and format the charts
- Analyse the data using pivot tables. Understand the different options available in pivot tables
- Use Excel for forecasting, what-if analysis and optimization technique using the Solver add-in
- Building interactive dashboards using Excel
此課程所涵蓋的技能
評價
-
BBexxa
I was looking for a solid Excel course, and this one delivered. The instructor is very knowledgeable, and the course is packed with useful content. I feel like I’ve gained real skills that I can use in my work. Highly recommend!
-
CCharlotte
I was looking for a course that would help me improve my Excel skills, and this one did the job perfectly. The content is comprehensive, and the instructor is very engaging. Highly recommend!
-
LLucas
This course is a fantastic introduction to data analysis with Excel. The instructor is very patient, and the lessons are easy to follow. I'm very happy with my purchase!
-
TTashiya
I had no prior experience with Excel, but this course helped me get started with data analysis in no time. The instructor is very encouraging, and the content is exactly what I needed.