【2024年】十大Excel 分析課程熱門排行推薦與優惠精選!
本文章推薦「Data Analytics with Excel PivotTables」、「Excel Analytics: Linear Regression Analysis in MS Excel」、「The Complete Microsoft Excel Pivot Tables and Pivot Charts」等相關LinkedIn線上課程,讓您滿足學習的慾望。
你是否想透過線上學習得到更多的技能,增加自己的技能樹?現在是學生的您,透過線上學習可以將更多專業知識用在課業學習上更加強所學。還是您是朝九晚五的上班族,尋找可以為工作上帶來更上一層樓的技能?或您是因為興趣或想培養其他興趣?
線上課程不受地理位置影響,不受時間早晚影響,老師來自世界各地,也不受學習程度影響的特色,讓您無時無刻想學都可以,想多看幾次增加熟悉度也可以。不同領域的老師將針對不同主題滿足您的學習目的,推薦的課程項目會陸續更新,絕對提供您最熱門人氣高的線上課程。
目錄
- Data Analytics with Excel PivotTables
- Excel Analytics: Linear Regression Analysis in MS Excel
- The Complete Microsoft Excel Pivot Tables and Pivot Charts
- Microsoft Excel Data Analysis and Dashboard Reporting
- Microsoft Excel DATA ANALYSIS Using my Proven 4-Step System
- Excel Data Analysis Masterclass with Excel Dashboards
- Microsoft Excel Data Analysis – Learn How The Experts Use It
- HR and Employee Dashboard using MS Excel
- R Tidyverse Reporting and Analytics for Excel Users
- Advance Analytics with Excel – data analysis toolpak/ Solver
Excel 分析課程總覽
課程資訊 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 |
---|---|---|---|---|---|---|---|---|---|---|
評價 | 4.3 分 (1,983 個評分) | 4.4 分 (642 個評分) | 4.3 分 (567 個評分) | 4.6 分 (4,453 個評分) | 4.4 分 (305 個評分) | 4.4 分 (208 個評分) | 4.9 分 (5,584 個評分) | 4.4 分 (192 個評分) | 4.7 分 (591 個評分) | 4.3 分 (438 個評分) |
學生 | 90,241 人人 | 77,822 人人 | 72,455 人人 | 37,111 人人 | 28,108 人人 | 19,823 人人 | 15,795 人人 | 12,476 人人 | 5,275 人人 | 2,441 人人 |
課程描述 | Step by Step, easy to comprehend guide on how to use Excel PivotTables with examples | Linear Regression analysis in Excel. Analytics in Excel includes regression analysis, Goal seek and What-if analysis | Excel Charts, Excel Analytics, Excel Pivot Table , Excel Pivot Charts, Excel Dashboard, Excel Data Analysis & Reporting | Build Dynamic, Interactive Microsoft Excel Dashboards (Excel 2010, 2013, 2016) with a Best Selling Excel Instructor | Excel Data Analysis w/Pivot Tables. Learn my valuable 4-step system to IMPORT, CLEAN, ENHANCE, & ANALYZE data in Excel. | Master Advanced MS Excel topics – Excel Formulas, Excel Formatting, Excel Pivot Tables, Excel Dashboards & Analytics | Learn the analytics capabilities of Excel and its add-ins, like PowerPivot & How it is used by business data analysts. | Learn to create HR Dashboard and explore powerful analysis for HR data | From Excel To Big Data and Interactive Dashboard Visualizations in 5 Hours | Advanced data analysis in excel: Data Analysis tools (toolpak add-in) for statistics / solver for linear optimization |
Excel 分析課程列表
Data Analytics with Excel PivotTables
課程老師 | Navya Kannan |
---|---|
課程評價 | 4.3 分(1,983 個評分) |
學生人數 | 90,241 人 |
課程介紹
About this course
This course will teach you how to do Data analytics with Excel PivotTables. With the help of this course, you will understand the concept, various scenarios, and types of Business analytics. Along with that, you will learn, how to
哪些人適合這堂課?
- This course is helpful for anyone who works on Excel reports as this will make reporting more efficient.
- If you deal with business presentations, then you can make use of this powerful tool to make an impact
學習目標
- Understand the importance of Data analytics in today’s business.
- Understand the types of Business analytics and real life examples of Business analytics
- How to use Excel PivotTables to easily and effectively work on your reports and make your data visually more appealing.
- You will learn the different features of PivotTables like Grouping, Calculated Field, Calculated Item, Slicers, PowerPivot and Charts
Excel Analytics: Linear Regression Analysis in MS Excel
課程老師 | Start-Tech Academy |
---|---|
課程評價 | 4.4 分(642 個評分) |
學生人數 | 77,822 人 |
課程介紹
You’re looking for a complete Linear Regression course that teaches you everything you need to create a Linear Regression model in Excel, right?
You’ve found the right Linear Regression course!
After completing this course you will be able to:
· I
哪些人適合這堂課?
- Working Professionals beginning their Data journey
- Anyone curious to master Linear Regression in short span of time
學習目標
- Learn how to solve real life problem using the Linear Regression technique
- Preliminary analysis of data using Univariate analysis before running Linear regression
- Predict future outcomes basis past data by implementing Simplest Machine Learning algorithm
- Understand how to interpret the result of Linear Regression model and translate them into actionable insight
- Indepth knowledge of data collection and data preprocessing for Machine Learning Linear Regression problem
- Course contains a end-to-end DIY project to implement your learnings from the lectures
The Complete Microsoft Excel Pivot Tables and Pivot Charts
課程老師 | A.M.A.M Mubeen (Expert In Tally & Finance & Microsoft Office) |
---|---|
課程評價 | 4.3 分(567 個評分) |
學生人數 | 72,455 人 |
課程介紹
Recent Student’s Reviews
***It Is Very Helpful And Easy To Understand. I Have No Doubts Regarding Pivot Tables And Its Formatting After Going Through It. Thank You For The Wonderful Teaching And Technical Support. – Deepak Kumar Kanaujia***
***V
哪些人適合這堂課?
- Sales manager
- Students
- Individual
- Accountants
- Auditor
- Financial analyst
- Information clerk
學習目標
- What Is Pivot Table and Pivot Charts and Key Benefit of Pivot Table?
- How to Normalize the Data for Pivot Table?
- How to Convert Normal Data to Table?
- How to Create the Pivot Table in Excel?
- How to Format Values in Pivot Table?
- How to Expand and Collapse Pivot Table in Excel?
- How to Report Filter Pivot Table in Excel?
- How to Refresh Pivot Table in Excel?
- How to Create Bar Chart by Using Pivot Table?
- How to Create Column Chart by Using Pivot Table?
- How to Create Pie Chart by Using Pivot Table?
- How to Create 3D Column Chart by Using Pivot Table?
- How to Create Line Chart by Using Pivot Table?
- How to Insert Slicer?
- How to Connect to an External Data Source in Excel?
- How to Create a Recommended Pivot Table?
- How to Copy and Move Pivot Tables?
- How to Delete the Pivot Table?
- How to Clearing & Reapplying Pivot Table?
- How to Copy the Values Only from Pivot Table?
Microsoft Excel Data Analysis and Dashboard Reporting
課程老師 | Kyle Pew |
---|---|
課程評價 | 4.6 分(4,453 個評分) |
學生人數 | 37,111 人 |
課程介紹
Microsoft Excel is one of the most powerful and popular data analysis desktop application on the market today. By participating in this Microsoft Excel Data Analysis and Dashboard Reporting course you’ll gain the widely sought after skills necessary
哪些人適合這堂課?
- Experienced Microsoft Excel users who are looking to efficiently analyze large data sets and create dynamic dashboard reports
學習目標
- Understand and Identify the principles of data analysis
- Effectively summarize and present data clearly
- Use effective design principles when creating and presenting data
- Take full advantage of the built in tools Microsoft Excel offers in order to analyze and build dashboard reports
- Build interactive dashboard reports
- Analyze Excel data using Excels TEXT based Functions
- Data Mine using Excels Array Functions
- Build Interactive Dashboard Reports with Buttons and Drop Down Menus
- Streamline and Analyze Data with Excel PivotTables and Pivot Charts
Microsoft Excel DATA ANALYSIS Using my Proven 4-Step System
課程老師 | Steve McDonald |
---|---|
課程評價 | 4.4 分(305 個評分) |
學生人數 | 28,108 人 |
課程介紹
Import
Clean
Enhance
Analyze
These are the 4 simple steps you should be using every time that you analyze data. In this course you’ll learn how to do each of the steps so that your data, your tables, and your pivot tables with work smoothly and e
哪些人適合這堂課?
- Students with some Excel experience who are looking to develop their skills in data analysis.
- Anyone who wants to master the use of pivot tables and a simple 4-step process for preparing their data.
學習目標
- Learn my effective 4-step process for importing, cleaning, enhancing and analysing your data.
- Learn how to use Pivot Tables to do lightning fast data analysis.
Excel Data Analysis Masterclass with Excel Dashboards
課程老師 | Data Is Good Academy |
---|---|
課程評價 | 4.4 分(208 個評分) |
學生人數 | 19,823 人 |
課程介紹
Welcome to the best online course on Excel.
Microsoft Excel is one of the most used software applications of all time.
Hundreds of millions of people around the world use Excel.
It is a very handy software that can be used to store and organize ma
哪些人適合這堂課?
- Who is interested in Data Analyst role.
- Who wants to become a Data Scientist.
- To become a successful Business Analyst.
- Those who are looking for Job who wants to be expertise in Excel.
- Students and professionals who want to improve the training capabilities.
- Job-seekers
學習目標
- Learn about basic formatting in excel.
- Learn about sorting and filtering functions in excel.
- Learn about UPPER, LOWER, PROPER, LEFT, RIGHT, SEARCH, CONCATENATE functions in excel.
- Learn how to find outliers and missing values in Excel.
- Learn how to find standard deviation and percentiles in data using Excel.
- Learn about IF, IF ERROR, COUNTIF, SUMIF and AVERAGEIF functions in excel.
- Learn about using Color Bars and Color scales in excel.
- Learn applying VLOOKUP and HLOOKUP functions and merge datasets using them in excel.
- Learn how to merge datasets using Index and match.
- Learn making Pivot Tables and Pivot charts in excel.
- Learn making interactive dashboards in excel.
- Learn about What-if analysis in excel.
- Learn how to perform linear regression in excel.
- Quizzes and exercises.
- Turn real world data into business insights in Excel.
- Best Practices for dashboard development, table and graph design.
- Discover the most Powerful tool in Excel to transform your Data into Insight and intelligence.
Microsoft Excel Data Analysis – Learn How The Experts Use It
課程老師 | New Horizon |
---|---|
課程評價 | 4.9 分(5,584 個評分) |
學生人數 | 15,795 人 |
課程介紹
Microsoft Excel is one of the most powerful and popular data analysis desktop application on the market today. Having a deep practical knowledge of Excel will greatly increase your productivity. You will be seen as a very skilled business data analys
哪些人適合這堂課?
- Anyone who wants to learn to apply data analysis techniques using Excel
- Anyone who wants to become good at using Excel for data analysis
- Anyone who wants to learn the core concepts of data analysis in Excel
- Anyone who wants to learn about PowerPivot, Pivot Charts etc..
學習目標
- Understand and Identify the principles of data analysis
- Build presentation ready dashboards in Excel
- Apply analysis techniques to datasets in Excel
- Become adept at using Excel functions and techniques for analysis
- Learn how to use Pivot Tables and Pivot Charts to streamline your workflow in Excel
- Use effective design principles when creating and presenting data
- Learn about Excel’s Ubiquity And Strategic Importance as a BI Tool
- Learn about the Excel Data Model
- GeoFLow
- Working with External Databases
- Integration with Sharepoint
HR and Employee Dashboard using MS Excel
課程老師 | Institute of Investment Banking |
---|---|
課程評價 | 4.4 分(192 個評分) |
學生人數 | 12,476 人 |
課程介紹
Excel dashboards help to maintain huge chunks of data and also to convert dashboard data into user friendly visuals. These online tutorials are self-paced to learn effective & interactive creation of Human Resource (HR) dashboards to create valuable
哪些人適合這堂課?
- Commerce students
- Human resource professionals
- Students from the business administration or planning to make a career in HR
- Working professionals who go through the hectic working schedule of same repetitive work every day
學習目標
- Learn index designing and tab designing supported with interactive charts and graphs
- Learn how to create and use Pivot table and charts effectively to arrange and analyze your data.
R Tidyverse Reporting and Analytics for Excel Users
課程老師 | Jonathan Ng |
---|---|
課程評價 | 4.7 分(591 個評分) |
學生人數 | 5,275 人 |
課程介紹
If you use Excel for any type of reporting or analytics then this course is for you. There are a lot of great courses teaching R for statistical analysis and data science that can sometimes make R seem a bit too advanced for every day use. Also since
哪些人適合這堂課?
- If you are currently using Excel to deliver a regular reporting requirement this course will be a good fit for you. This course is designed to introduce R to non programmer Excel users who are already familiar with Pivot Tables, vlookups ,if statements and charts.
學習目標
- How R implements common Excel functions and how it can actually be faster, easier and more flexible than the familiar Excel methods. By the end of this course you will have the knowledge to work with large sets of data faster and easier than you ever thought possible. This course uses the tidyverse libraries in R which provide an elegant solution for solving 99% of our reporting requirements. Tidyverse is incredibly well supported and by focusing solely on this one set of libraries we can massively shortcut the amount of time that is required to get up and running with R. Many beginner courses in R will start teaching what is known as base R which covers the original methods for working with R that have been enhanced and simplified through the tidyverse. Although it maybe useful to have some understanding of base R it is neither a requirement of this course or a requirement to becoming really productive in the R language. As we go through the exercises we are going to be comparing to the most common way that processes are typically carried out in Excel.
Advance Analytics with Excel – data analysis toolpak/ Solver
課程老師 | Gopal Prasad Malakar |
---|---|
課程評價 | 4.3 分(438 個評分) |
學生人數 | 2,441 人 |
課程介紹
What is this course all about?
This course demonstrates how to use “Data Analysis ToolPak”.
It explains the business scenario and then shows application of statistical procedure using data analysis tool pack on the given data.
The course also shows
哪些人適合這堂課?
- This course is for professionals who quickly want to learn statistical analysis / data analysis procedure / solver usage for getting solution of linear programming cases
- This course is not for someone, who is looking to get deep understanding of statistics / genesis of formula etc. For that I will recommend you to check my course “Statistics by Example” .
學習目標
- Perform Data Analysis / Statistical Analysis using Excel
- Be comfortable with data analysis tool pack / solver / goal seek
- Understand the business context / scenario where the statistical procedure is applicable
- Understand the most important portion of statistical procedure output and how to interpret it for a given scenario
- Know how to solve linear programming cases using solver
從老師查找更多Excel 分析課程
還是您有熱衷某個老師或某個品牌開的課程呢?嘗試從老師或品牌頁挑選吧!
參考其他理財工具線上課程
除了本文介紹的課程種類以外,想要瞭解理財工具領域還有哪些不同類型的課程值得一探究竟嗎?讓您可以從不同面向更紮實的學習,點擊參考以下其他熱門主題文章。絕對提供您最優惠人氣滿檔的課程,歡迎繼續延伸閱讀。
- 【2024年】十大Power Pivot課程熱門排行推薦與優惠精選!
- 【2024年】十大Excel 圖表課程熱門排行推薦與優惠精選!
- 【2024年】十大SAP課程熱門排行推薦與優惠精選!
- 【2024年】十大比特幣交易課程熱門排行推薦與優惠精選!