Skip Navigation
 

Course Details

 

Course Details

Course Code: BUSN661 Course ID: 4631 Credit Hours: 3 Level: Graduate

This course is designed to continue the examination of data and its use in the problem-solving process. In this course, students will integrate advanced skills in Microsoft Excel 2010® with data analysis techniques, including an introduction to big data add-ins such as Microsoft PowerPivot® and the use of Data Analysis Expressions (DAX) to create queries in the PowerPivot tool. (Prerequisite: BUSN660) Microsoft Excel 2010® is a registered trademark of Microsoft Corporation. Microsoft PowerPivot® is a registered trademark of Microsoft Corporation.

Course Schedule

Registration Dates Course Dates Start Month Session Weeks
05/21/2022 - 11/04/2022 11/07/2022 - 01/01/2023 November Fall 2022 Session I 8 Week session
07/25/2022 - 12/30/2022 01/02/2023 - 02/26/2023 January Winter 2023 Session B 8 Week session
09/26/2022 - 03/03/2023 03/06/2023 - 04/30/2023 March Winter 2023 Session D 8 Week session

Current Syllabi

After successfully completing this course, you will be able to

CO‐1 Learn about various Excel functions and how to use them to carry out calculations and produce outcomes.

CO‐2 Learn about Optimization in Excel and how to use Solver add‐in to Perform calculations and produce optimization reports.

CO‐3 Summarize & describe data, and compute measures to demonstrate knowledge of descriptive statistics.

CO‐4 Learn about variable relationships and regression modeling CO‐5 Learn about PowerPivot & DAX

CO‐6 Use Data Visualization Software features within spreadsheet, statistical, and data visualization programs to display data.

After successfully completing this course, you will be able to

CO‐1 Learn about various Excel functions and how to use them to carry out calculations and produce outcomes.

CO‐2 Learn about Optimization in Excel and how to use Solver add‐in to Perform calculations and produce optimization reports.

CO‐3 Summarize & describe data, and compute measures to demonstrate knowledge of descriptive statistics.

CO‐4 Learn about variable relationships and regression modeling CO‐5 Learn about PowerPivot & DAX

CO‐6 Use Data Visualization Software features within spreadsheet, statistical, and data visualization programs to display data.

Book Title:Microsoft® Excel® 2013: Building Data Models with PowerPivot (Ebook available through the APUS Online Library)
ISBN:9780735676343
Publication Info:Microsoft Press/Pearson Lib
Author:Marco Russo and Alberto Ferrari
Unit Cost:$41.39
 
Book Title:Microsoft Excel 2013 Data Analysis and Business Modeling (Ebook available through the APUS Online Library)
ISBN:9780735669130
Publication Info:Microsoft Press/Pearson Lib
Author:Wayne Winston
Unit Cost:$51.39
 

Previous Syllabi

Not current for future courses.