Skip to main content
Business Analytics Series

Interested in data analysis? Our Business Analytics Series will give you a better understading of business analytics and how it plays a role in decision making. Learn how Excel can help you analyze your data.

Introduction to Business Analytics - 3/10/2017, Room 616

Organizations are relying on business analytics or the use of data, statistical and quantitative analysis, exploratory and predictive models, and fact-based management to make decisions and develop action plans. This course covers the foundation and business use as well as a working model of capacity planning. You will also learn the terms, techniques, and how business decisions are made using business analytics.

Prerequisite: None

Business Analytics Using Excel 2016 - 3/17/2017, Room 616

In today’s business world, understanding business analytics can give your organization a competitive advantage. This course uses MS Excel, the foundational data analysis tool, to cover advanced Excel formulae, concepts, and applications using larger and more professional worksheets, and focuses on the data modeling approach using Excel vs. the calculator approach. Topics include if-then modeling, built-in functions, charting, transferring data across applications, PivotTables, Spark Lines, Slicers, Power Pivots, and Macros.

Prerequisite: For the intermediate Excel user.

Excel 2016: Pivot Tables, Power Pivots & Pivot Charts - 5/12/2017, Room 613

Pivot Tables allow you to analyze raw data for business analysis purposes, but they are limited. Due to Excel’s own limitations you cannot analyze more than 1048576 rows of data, and there may even be limitations in analyzing data from two or more spreadsheets. The PowerPivot Add-In allows importing, merging and analyzing data from several data sources at once, with barely any limitations. Turn your raw data into a Pivot Table to help you gather business analytics. Create a Pivot Chart from your Pivot Table. V-Lookup is another neat tool found in Excel. It allows you to look at a value in one column, and finds its corresponding value on the same row in another column, based on a unique identifier. Explore these amazing tools in Excel, and make the most of your data.

Prerequisite: Students must have Excel intermediate level skills, and know how to use formulas and functions in Excel.

Enroll in these series and save 10%, or take a course individually. Please see pages 13, 18 and 19 for the individual courses.