Master Excel Pivot Tables and practical data analysis with a business consultant!
Welcome!
What you’ll learn
- Pivot table analysis and business data analysis skills using Excel spreadsheets..
- How to use several Excel functions and tools to analyze data in Excel..
- How to answer key business questions by practicing and working with real world business datasets.
- How to apply quantitative analysis and problem solving techniques within the Excel spreadsheet..
Course Content
- Introduction –> 5 lectures • 28min.
- Pivot Table Analysis –> 3 lectures • 18min.
- Income Statement Analysis –> 2 lectures • 12min.
- Lookup and CountIF Functions –> 2 lectures • 20min.
- Breakeven Analysis –> 2 lectures • 8min.
- Charting and Graphing in Excel –> 3 lectures • 12min.
Requirements
Welcome!
Microsoft Excel spreadsheets are widely used to store, organize, and analyze data. In light of this, Excel has grown to become arguably the most important computer program in workplaces around the world. Any role in any industry can benefit from someone like you with strong Excel knowledge.
Excel is a powerful tool that has become ingrained in business processes worldwide, from analyzing stocks, budgeting, and organizing client sales lists, to analyzing staff performances, managing employee schedules, and comparing periodic product sales performances, to name a few.
Through the manipulation of stored data, Excel enables you to identify trends and organize and sort data into meaningful categories. With the use of pivot tables in Excel (one of my personal favorites) you can skillfully summarize data from a worksheet into an illustrative chart. Finance and accounting professionals choose Excel for its complex analytical and computing features, while Excel also performs Human Resources functions, such as sorting worked hours and organizing employee profiles and expenses, which help businesses better understand the structure and activities of their workforce.
This Business Data Analysis with Excel course will provide you with an in-depth understanding of:
- Excel functions and pivot tables, pivot charting, and pivot reporting, to group, slice, calculate and summarize large syndicated datasets in order to answer specific questions
- Sorting, filtering and grouping tools in Excel
- Creating financial statements (with particular focus on the income statement)
- Analyzing employee performance using the LOOKUP and COUNTIF functions
- Performing break-even analysis and introductory cluster analysis
- Charting, graphing, and illustrating data trends in Excel, amongst others!
Using Excel for business has almost no limits for applications. Here are some examples:
– Excel creates revenue growth models for new products based on new customer forecasts.
– When planning a team outing to a baseball game, you can use Excel to track the RSVP list and costs.
– When planning an editorial calendar for a website, you can list out dates and topics in a spreadsheet.
– When creating a budget for a small product, you can list expense categories in a spreadsheet, update it monthly and create a chart to show how close the product is to budget across each category.
– You can calculate customer discounts based on monthly purchase volume by product.
– You can conduct a thorough analysis of patient and medical research data
– You can summarize customer revenue by product to find areas where to build stronger customer relationships etc.
A working knowledge of Excel is vital for most professionals today, and stronger Excel skills can open the door to promotion and leadership opportunities.
Enroll now and start your journey to data management and storytelling through Excel data analysis and visualization!