課程資料
報名日期
全年招生
課程級別
學習模式
修業期
1 小時 56 分鐘
教學語言
英語
授課導師
John Miko
評分
1次瀏覽
課程簡介
Creating Excel Pivot Tables: It's not splitting the atom
Excel Pivot Tables are an incredibly powerful feature of Excel that allows users to glean insights and understanding quickly from massive data files. While Pivot Tables are often thought of as an advanced feature of Excel because of the "Wow Factor", they are really not that difficult at all when broken down into their features and functions as done in this course. In 19 lectures, in under 2 hours, this course steps student through the most useful and powerful aspects of Excel Pivot Tables.
Course Sections
Section 1: INTRODUCTION AND WELCOME TO THE COURSE
Section 2: EXCEL PIVOT TABLE BASICS and MAKING YOUR FIRST PIVOT TABLE
Section 3: OVERALL TABLE DESIGN
Section 4: FIELD SETTINGS AND DESCRIPTIVE MEASURES
Section 5: SORTING, FILTERING, AND REFRESHING
Section 6: GROUPING ITEMS, DATE FIELDS, AND CALCULATED FIELDS
Section 7: PIVOT CHARTS AND BUILDING A DASHBOARD
課程章節
- 7 個章節
- 19 堂課
- 第 1 章 Introduction and Welcome to the Course
- 第 2 章 EXCEL Pivot Table Basics: Let's Create our First Excel Pivot Table
- 第 3 章 Overall Table Design Elements and Clearing and Moving Tables
- 第 4 章 Field Settings: Other Descriptive Measures and Showing Value as a % of Totals
- 第 5 章 Sorting, Filtering, and Refreshing Pivot Tables
- 第 6 章 Grouping Items, DATE fields and Calculated Fields
- 第 7 章 Pivot Charts and Building a Dashboard
課程內容
- Excel Pivot Table Basics
- Filtering, Sorting, Grouping, and Pivoting
- Using Slicers and Timelines
- Working with Date fields
- Building a Data Dashboard
此課程所涵蓋的技能
評價
-
RRachel Lucas
This was a great course I learned so much!! Thank you!!
-
DDavid Farabaugh
This course helped my excel at my workplace
-
LLucia Cicalese
Everything makes sense and easy to follow!
-
AAllan Diaz
Yo, this course on pivot tables was awesome! Slicers, timelines, charts, Dr. Miko explained everything clearly, and I had fun following along with the files. Concise and applicable.
