Udemy

Office Fundamentals - PivotTables in Microsoft Excel

立即報名
  • 1,029 名學生
  • 更新於 3/2022
4.6
(245 個評分)
CTgoodjobs 嚴選優質課程,為職場人士提升競爭力。透過本站連結購買Udemy課程,本站將獲得推廣佣金,有助未來提供更多實用進修課程資訊給讀者。

課程資料

報名日期
全年招生
課程級別
學習模式
修業期
5 小時 44 分鐘
教學語言
英語
授課導師
Johannes Ruof, Timothy Meixner
評分
4.6
(245 個評分)
1次瀏覽

課程簡介

Office Fundamentals - PivotTables in Microsoft Excel

Learn everything about creating and using PivotTables in Excel to analyze data and plot with PivotCharts & dashboards

Pivot tables are a quick and easy way to organize, summarize, and analyze raw data.


In this course, you'll learn everything you need to know about pivot tables to work with them confidently in everyday life.


We start with the absolute basics and then build on that to learn more advanced and complex topics.


We'll talk about formatting, sorting, filtering, grouping, working with values, calculated fields, and pivot charts, and even build our own dashboard to visualize our data and manipulate and customize these charts live.


The course is designed to be hands-on. We will work with an extensive and practical example that will help you follow and understand the subject matter well. 


Our goal with this course is to make your daily work with Excel easier, and pivot tables are ideal for this.


Since pivot tables are a special sub-topic of Microsoft Excel, it is, of course, helpful if you are already familiar with the program. Ideally, you should already know the basics of Excel if you want to work with pivot tables.


We have already helped thousands of people to become office professionals in our courses, and I would be more than happy to welcome you to the course!


課程章節

  • 7 個章節
  • 58 堂課
  • 第 1 章 Einführung
  • 第 2 章 PivotTable Fundamentals - Learning the basics
  • 第 3 章 Formatting PivotTables
  • 第 4 章 Sorting, Filtering and Grouping with PivotTables
  • 第 5 章 Working with values in PivotTables
  • 第 6 章 Working with calculated fields in PivotTables
  • 第 7 章 Visualizing data analysis with PivotCharts & Dashboards

課程內容

  • Properly structure raw data for analysis with Pivot
  • Insert and create PivotTables
  • Editing PivotTable fields
  • Analysis and organization of data
  • Sort, filter, and group pivot data
  • Working with values in PivotTables
  • Calculations with calculated fields
  • Create visual representations with PivotCharts & Dashboards

此課程所涵蓋的技能


評價

  • G
    Godwin De Guzman
    5.0

    good so far

  • A
    Alimi-Yao Adam
    5.0

    great learning opportunity.

  • S
    Shefali Angrish
    5.0

    Amazing

  • A
    Alfredo Pedroza
    4.5

    I like the content, the examples used, and also the focus to a clean view of data in worksheets.

立即關注瀏覽更多

本網站使用Cookies來改善您的瀏覽體驗,請確定您同意及接受我們的私隱政策使用條款才繼續瀏覽。

我已閱讀及同意