課程資料
- 可獲發
- *證書的發放與分配,依課程提供者的政策及安排而定。
課程簡介
Learn how to create pivot tables, charts, amazing dashboards, and make sense of large data sets in Microsoft Excel
Are You A Beginner to Intermediate Excel User?
Have You Heard Of Pivot Tables But Never Fully Understood How To Create Them?
Are You Not Even Sure What You Can Do With A Pivot Table?
Do You Want To Create Sleek Dashboards Using Big Data Sets Condensed Into Useful Reports?
If You Answered "Yes" To Any Of The Above, Look No Further. This Is The Course For You!
*** Updated with new content! ***
Enroll today and join the 100,000+ successful students I have taught as a Top Rated Udemy instructor!
Three reasons to TAKE THIS COURSE right now:
You get lifetime access to lectures, including all new lectures, assignments, quizzes and downloads
You can ask me questions and see me respond to every single one of them thoroughly!
You will are being taught by a professional with a proven track record of success!
Bonus reason: Udemy has a 30 day 100% money back guarantee if for some reason you don't enjoy the course!
Recent Review:
Matthew F. says: "Terrific course, pivot tables always seemed so confusing to me. After this course I realized it's really not that hard at all to put one together. So powerful, such a useful tool. Creating charts and dashboards was pure bonus material for me. Really recommend the course, Chris made learning fun and easy."
Why You Should Take This Course With Me:
Microsoft Excel is a very powerful tool when used to its fullest extent. Pivot tables are one tool that is not one of the first things you learn in Excel, but should be in your backpack of tools you have available. They are an amazing tool to quickly make sense of big data sets and analyze information from multiple different views, all very quickly. While they may seem confusing at first, once you learn the in's and out's of pivot tables, you'll be a pivot table wizard.
In this course we will start with a blank Excel workbook, open a sample large data set, and then demonstrate how to create multiple pivot tables as well as pivot charts. From there we will explore all of the options you have with pivot tables by adding to them. After that, we then create a dashboard that any manager would love!
What We Do In The Course:
Learn Excel basics to start
Review a large data set
Build a basic pivot table to begin
Build multiple additional pivot tables to give us a selection of reports
Create charts using our pivot table data
Create a fully functional Dashboard with multiple graphs and selection abilities
And much more!
At any point if you have a question, please feel free to ask through the course forum, I'd be happy to answer any and all questions.
***CLICK "BUY NOW" AND LEARN PIVOT TABLES, CHARTS AND DASHBOARDS IN EXCEL! ***
About The Instructor
Chris Benjamin, MBA & CFO is a seasoned professional with over 25 years experience in accounting, finance, financial reporting, small business and business consulting. Having spent the first 10 years of my career in corporate settings with both large and small companies, I learned a lot about the accounting process, managing accounting departments, financial reporting, external reporting to board of directors and the Securities and Exchange Commission, and working with external auditors.
The following 10+ years I decided to go into CFO Consulting, working with growing companies and bringing CFO level experience to companies. I help implement proper best business practices in accounting and finance, consult on implementation of accounting systems, implementing accounting procedures, while also still fulfilling the CFO roll for many of my clients which includes financial reporting, auditing, working with investors, financial analysis and much more.
Thank you for signing up for this course on Udemy. I look forward to being your instructor for this course and many more!
Chris Benjamin, Instructor, CFO & MBA
課程章節
- 3 個章節
- 16 堂課
- 第 1 章 Introduction
- 第 2 章 Pivot Tables
- 第 3 章 Course Conclusion
課程內容
- Learn From A Top Rated Instructor Who Has Been Teaching On Udemy Since 2013 and Taught Over 100,000 Students!
- Consolidated Reporting
- Pivot Tables
- Data Analysis
- Large Data Set Analysis
- Customizable Reporting
- Averages, Sums, Counts, Min, Max, and More
- Charts and Graphs
- Intelligent and Dynamic Dashboards
- Data Filtering
- And Much More!
此課程所涵蓋的技能
評價
-
LLance
The material overall is very basic. Only 2 hours worth of material for what I paid for and the instructor sometimes doesn't understand his own work and his to explain it in the next video which is bizarre and haven't seen before.
-
SSara Sainvilus
The Course was short and concise. However, the instructor does not respond to messages. I purchased the course with the intention to practice as I learned the material. It was difficult to do that because the instructor did not include any practice files within the course. So, if you are a hands-on learner, do not purchase this course because all you can do is watch the videos. I took the chance of messaging the instructor to ask for the sample data or recommendations on where I can find similar sample data, and he did not respond. Because of this, I was very disappointed with this course and would love to get my money back so I can put it towards a hands-on learner friendly course. Overall, the information was okay but its not going to stick without practice.
-
TTina Louise Reader
Great insight into Pivot Tables. Couple of hiccups on the way through but rectified issues in next course section on the whole though a great course
-
BBren Stepp
The course content was what I wanted to learn and the instructor presented clearly and in a easy to follow way, without being boring.