Chuyển tới nội dung chính
Side panel
Call us : 024-2662350
E-mail :
it@huph.edu.vn
Bạn đang truy cập với tư cách khách vãng lai (
Đăng nhập
)
Trang chủ HUPH
Microsoft Teams
Các khóa học
Tài nguyên
Google Classroom
Videos học tập
Hướng dẫn
Hướng dẫn sử dụng LMS (dành cho giảng viên)
Hướng dẫn sử dụng LMS (dành cho học viên)
Hướng dẫn sử dụng Microsoft Team cho giảng viên
Hướng dẫn sử dụng Microsoft Team cho sinh viên
Hướng dẫn soạn thảo bài giảng Elearning
Big Data Analytics With Excel
Trang chủ
Khoá học
Data Science Courses
Big Data Analytics With Excel
1. Introduction
1.1. Introducing Excel Big Data
1.1. Introducing Excel Big Data
Sửa lần cuối: Thứ ba, 17 Tháng tư 2018, 1:09 PM
Chuyển tới...
Chuyển tới...
1.2. About The Author
1.3. Using The Working Files
1.4. How To Access Your Working Files
Diễn đàn tin tức
2.1. Fixing Headers For Screen And Print
2.2. Sorting Data
2.3. Filtering Data
2.4. Add A Chart In A Second
3.1. Starting Out The Cleaning Process
3.2. Removing Duplicate Records
3.3. Changing The Case
3.4. Replacing Text Method Part - 1
3.5. Replacing Text Method Part - 2
3.6. Removal Of Non Printing Characters And Spaces
3.7. Numbers Standardized On Import And Export
3.8. Dealing With Date And Time Issues
3.9. Merging And Splitting Data Columns
3.10. Rearranging Columns And Rows
3.11. Comparing Multiple Datasets
4.1. Creating A Table
4.2. Formatting Made Easy
4.3. Managing Rows And Columns
4.4. Sorting And Filtering Table Data
4.5. Using The Totals Row
4.6. Adding A Calculated Column
4.7. Adding Charts And Pivot Tables Using Table Data
4.8. Data Entry And Editing Through A Form
4.9. Filtering Using The Slicer
4.10. Advanced Filtering
4.11. External Data As A Table Source
5.1. Introducing Pivot Tables
5.2. Recommended Pivot Tables
5.3. Use Named Ranges And Rename Column Headings
5.4. Change The Data Function And Format The Numbers
5.5. Moving And Or Removing A Pivot Table
5.6. The Report Filter Option
5.7. Sorting And Filtering By Pivot Table Columns
5.8. Refreshing A Pivot Table
5.9. Drilldown Behind Pivot Table Numbers
5.10. Using Pivot Table Styles
5.11. Use Of Multiple Fields In Rows And Columns
5.12. Grand And Sub Totals
5.13. Filtering Columns And Rows Within A Pivot Table
5.14. Exploring Additional Options
5.15. Using The Data Slicer
5.16. Connecting To A SQL Server Database
5.17. Using External Connection Files
6.1. Creating And Using Charts
6.2. Using Trendlines
6.3. Dynamic Named Ranges
6.4. Creating A Forecast Sheet
6.5. Plotting On Two Axis
7.1. Creating A Pivot Chart
7.2. Altering Chart Design And Location
7.3. Filtering And Hiding Elements
8.1. Introducing Get And Transform The New Power Query
8.2. Making The Most Of The Query Editor
8.3. Using The Query Editor To Group Or Combine
8.4. Using An Odata Feed And Merging Data
8.5. Using Google Sheets As Your Source Data
8.6. Connecting To Using And Combining Webpage Data
8.7. Connecting To And Using Data From Facebook
8.8. SQL Server Data Connections
8.9. Get And Transform Data From Multiple Files In A Folder
9.1. Activating And Creating Your First 3D Power Map
9.2. A Simple Map Alternative To 3D Power Map
9.3. Tours Scenes And Layers
9.4. Create A Tour And Customize A Layer
9.5. Displaying Additional Data With Additional Layers
9.6. Adding And Animating Scenes
9.7. Filtering Data Within A Layer And Scene
9.8. Customization Options
9.9. Exporting Images And Videos Of Your 3D Map Tour
10.1. Introducing Power Pivots
10.2. Importing Data And Adding Additional Data To The Data Model
10.3. Adding Tables To The Data Model And Creating Relationships
10.4. Powerpivot Pivotstables And Pivotcharts
10.5. Adding Calculated Fields To Your Data Model
10.6. Measures And KPIs In Your Powerpivot
11.1 Use Goal Seek To Carry Out What If Analysis
11.2. Installing And Uninstalling Solver
11.3. Use Solver To Carry Out What If Analysis
11.4. Using Scenarios
11.5. Adding Constraints To Solver
12.1. Introducing The Analysis Toolpack
12.2. Calculating And Graphing The Moving Average
12.3. Creating A Histogram With A Bell Curve
13.1. Sharing Your Big Data
13.2. Resume
Download tài liệu tham khảo
1.2. About The Author ►
Big Data Analytics With Excel
1. Introduction
Basic Data Manipulation
3. Data Cleansing
4. Excel Tables
5. Pivot Tables
6. Charts
7. Pivot Charts
8. Power Query
9. Power Map
10. Power Pivot
11. Goal Seek And Solver
12. Data Analysis Tools
13. The End
Tài liệu tham khảo
Trang chủ
Lịch