Excel Business Analytics Free Course - Forecasting, Linear Programming, Simulation & more. Basic Excel Business Analytics #15: Count Transactions by Web Site Report & Chart
Basic Excel Business Analytics #15: Count Transactions by Web Site Report & Chart Transcript and Lesson Notes
Download files: https://people.highline.edu/mgirvin/AllClasses/348/348/AllFilesBI348Analytics.htm Video about: Frequency Distributions, Relative Frequency Distribution and Percent Frequency Distribution & Column Chart fo
Quick Summary
Download files: https://people.highline.edu/mgirvin/AllClasses/348/348/AllFilesBI348Analytics.htm Video about: Frequency Distributions, Relative Frequency Distribution and Percent Frequency Distribution & Column Chart fo
Key Takeaways
- Review the core idea: Download files: https://people.highline.edu/mgirvin/AllClasses/348/348/AllFilesBI348Analytics.htm Video about: Frequency Distributions, Relative Frequency Distribution and Percent Frequency Distribution & Column Chart fo
- Understand how Excel fits into Basic Excel Business Analytics #15: Count Transactions by Web Site Report & Chart.
- Understand how Microsoft Excel fits into Basic Excel Business Analytics #15: Count Transactions by Web Site Report & Chart.
- Understand how Highline College fits into Basic Excel Business Analytics #15: Count Transactions by Web Site Report & Chart.
- Understand how Mike Girvin fits into Basic Excel Business Analytics #15: Count Transactions by Web Site Report & Chart.
Key Concepts
Full Transcript
Download files: https://people.highline.edu/mgirvin/AllClasses/348/348/AllFilesBI348Analytics.htm Video about: Frequency Distributions, Relative Frequency Distribution and Percent Frequency Distribution & Column Chart for Categorical Data Learn: 1) (00:17) Introduction to Frequency Distribution and our Large Data Set 2) (01:08) PivotTable: Frequency Distribution for Categorical Data 3) (02:17) PivotTable Show Values As, % of Column Total: % Frequency Distribution for Categorical Data 4) (03:26) Why Formula for Frequency Distribution for Categorical Data? 5) (03:52) Create Unique List from a Field using Advance Filter, “Unique records only” 6) (05:06) COUNTIFS function with Sheet References for Frequency Distribution 7) (07:11) Formula for % Frequency 8) (07:35) Column or Bar Chart for Categorical Data Frequency Distributions 9) (10:15) Column Chart for Discrete Quantitative Data 10) (11:25) Conclusion Download Excel File Not: After clicking on link, Use Ctrl + F (Find) and search for “Highline BI 348 Class” or for the file name as seen at the beginning of the video.
Lesson FAQs
What is Basic Excel Business Analytics #15: Count Transactions by Web Site Report & Chart about?
Download files: https://people.highline.edu/mgirvin/AllClasses/348/348/AllFilesBI348Analytics.htm Video about: Frequency Distributions, Relative Frequency Distribution and Percent Frequency Distribution & Column Chart fo
What key concepts are covered in this lesson?
The lesson covers Excel, Microsoft Excel, Highline College, Mike Girvin, excelisfun.
What should I learn before Basic Excel Business Analytics #15: Count Transactions by Web Site Report & Chart?
Review the previous lessons in Excel Business Analytics Free Course - Forecasting, Linear Programming, Simulation & more., then use the transcript and key concepts on this page to fill any gaps.
How can I practice after this lesson?
Practice by applying the main concepts: Excel, Microsoft Excel, Highline College, Mike Girvin.
Does this lesson include a transcript?
Yes. The full transcript is visible on this page in indexable HTML sections.
Is this lesson free?
Yes. CourseHive lessons and courses are available to learn online for free.
