Loading...

Course Description

This comprehensive Excel Business Analytics class combines foundational Excel skills with advanced data modeling techniques and business analytics concepts. Participants will learn to proficiently use Excel for data manipulation, visualization, and decision-making, while also exploring predictive and prescriptive analytics models. The course emphasizes practical applications across various industries, equipping learners with the skills needed to analyze data effectively and derive actionable insights. 

 

Course Outline

Excel Fundamentals 

  • Explore Excel Basics 
  • Data Entry and Editing 
  • Formulas, Functions, and AutoSum 
  • Worksheet Views and Print Options 

Formatting and Managing Data 

  • Formatting Values and Cells 
  • Adjusting Fonts, Alignment, and Borders 
  • Managing Rows, Columns, and Worksheets 
  • Applying Conditional Formatting 

Advanced Data Analysis with Formulas 

  • Quick Analysis Tool and Logical Functions 
  • Statistical Functions (COUNTA, Round, Date) 
  • Equation Tools and Worksheet Calculations 

 Data Visualization with Charts and Tables 

  • Planning and Creating Charts 
  • Formatting and Customizing Charts 
  • Creating Tables and Using Formulas 
  • Data Sorting, Filtering, and Lookups 

 Managing Workbook Data 

  • Viewing and Arranging Worksheets 
  • Protecting and Saving Workbooks 
  • Hyperlinks, Grouping Data, and Workbook Distribution 

 Integrating with Other Programs 

  • Importing and Linking Data 
  • Inserting Graphics and Working with External Files 

 Advanced Data Analysis with PivotTables 

  • PivotTable Creation and Customization 
  • PivotTable Functions and Data Relationships 
  • Creating PivotCharts and Dynamic Reports 

What-If Analysis and Modeling 

  • Data Tables for Sensitivity Analysis 
  • Goal Seek and Scenario Manager 
  • Introduction to Predictive and Prescriptive Models 

Spreadsheet Models and Influence Diagrams 

  • Building Mathematical Models in Excel 
  • Influence Diagrams for Model Visualization 
  • Implementing and Designing Spreadsheet Models 

Auditing and Error Checking 

  • Trace Precedents and Dependents 
  • Showing and Evaluating Formulas 
  • Error Checking Tools and Watch Window 

Predictive and Prescriptive Analytics 

  • Overview of Predictive and Prescriptive Models 
  • Practical Applications in Business Analytics 

Legal and Ethical Considerations 

  • Data Privacy and Ethical Use of Data 
  • Compliance and Regulatory Issues 

 

Learner Outcomes

This course is designed for professionals seeking to enhance their Excel skills and leverage advanced data analytics techniques to improve decision-making processes within their organizations. Participants will gain practical experience and insights applicable across various industries, enhancing their proficiency in business analytics using Excel. By the end of this course, participants will be able to: 

  • Navigate and utilize Excel: Efficiently use Excel tools for data entry, manipulation, and visualization. 
  • Apply advanced formulas and functions: Create complex formulas and utilize advanced functions for data analysis. 
  • Design and format visualizations: Create and customize charts, tables, and PivotTables for data presentation. 
  • Perform What-If analysis: Utilize Data Tables, Goal Seek, and Scenario Manager for decision support. 
  • Build spreadsheet models: Construct mathematical and influence diagram models in Excel. 
  • Conduct audits and error checking: Trace precedents, evaluate formulas and use error-checking tools effectively. 
  • Understand predictive and prescriptive analytics: Apply predictive and prescriptive models to business scenarios. 
  • Integrate and link data: Import, export, and link data. 
  • Practice data ethics: Understand legal and ethical considerations when handling data in business analytics. 
  • Apply business analytics concepts: Implement descriptive, predictive, and prescriptive analytics techniques. 

 

Notes

Target Audience: 

The Excel Business Analytics class is designed for a diverse range of professionals seeking to enhance their data analysis skills using Excel. Target participants include business professionals across finance, marketing, operations, and human resources who need to leverage data for informed decision-making. It also caters to analysts and data managers responsible for collecting, managing, and interpreting data to support organizational strategies. Whether you're already proficient in basic Excel functions or looking to transition into roles requiring advanced analytical capabilities, this course provides practical insights and hands-on experience in applying business analytics techniques. It's ideal for executives, consultants, graduate students, and small business owners alike, emphasizing the use of Excel for transforming raw data into actionable insights that drive organizational success. 

Occupational Outlook: 

The U.S. Bureau of Labor Statistics (BLS) reported management analysts are projected to grow 14 percent from 2018 to 2028, which is faster than the average for all occupations. Recommended education level bachelor's degree or higher. 

Information Technology Continuing Education Certificate:  

A certificate of completion for the class will be issued to participants with at least 80% attendance, class participation, and completion of hands-on practice and projects. 

Industry Certification: 

MO-201: Microsoft Excel Expert.

Method of Instruction:  

Lecture with demonstration, discussion, hands-on exercises, and problem-solving. May have outside assignments. 

Evaluation: 

Participation in class discussions and completion of skill practices in and outside of the classroom is expected. 80% attendance is required.

 

Prerequisites

Materials: This class does not include course materials. Students are required to purchase the necessary materials directly from the bookstore or our designated partner. Detailed instructions will be given the first day of class.

Resources: 

  • Participants are required to have a laptop or desktop computer with a minimum 4GB ram, 256GB HD, Core i5. Recommended 8GB ram, 256GB SSD, Core i5.  
  • Access to reliable internet as well as a camera, a headset, and preferably dual monitors.  

Prerequisite and desired knowledge: 

By ensuring you possess these fundamental knowledge and skills, you will be better prepared to grasp the concepts taught in this Excel Business Analytics class and successfully apply them at work. 

Basic Computer Skills 

  • Proficiency in using Windows: Ability to navigate the operating system, install software, and manage files. 
  • Basic Internet skills: Competence in browsing the web, downloading files, and using online resources. 

Basic Excel

  • Working knowledge of Excel basic functions and formulas. 
  • Data manipulation: Skills in sorting, filtering, and organizing data within Excel. 

Optional but Beneficial Knowledge: 

Mathematical and Statistical Concepts 

  • Understanding of fundamental mathematical operations (addition, subtraction, multiplication, division) 
  • Basic statistical concepts (mean, median, mode, standard deviation) used in data analysis. 

Attention to Detail and Accuracy 

  • Skill in reviewing and validating data for accuracy, identifying outliers or errors, and ensuring data integrity throughout analysis and reporting processes. 

Analytical Thinking 

  • Problem-solving skills: Ability to approach problems methodically and think critically about data. 
  • Attention to detail: Careful consideration of data accuracy and report precision. 

Communication Skills 

  • Basic reporting skills: Ability to present data and insights clearly in written and visual formats. 
  • Collaboration tools: Familiarity with collaboration tools such as Microsoft Teams, SharePoint, or other project management and communication platforms. 

 

Recommendations

IMPORTANT: Make sure to have your Network Login, DUO authentication, and student email before the first day of class.

Testimonials

With the skills I learned from your course, I can now process data more quickly and efficiently on my own. I am also much more organized thanks to the many tips and best practices you shared. I use tools such as converting data ranges to tables, using pivot tables and charts(they indeed do rock!), conditional formatting, hyperlinking, assigning macros for small automation, and the visual basic backend view to name a few. You made learning Excel less intimidating and more practical with your teaching style and expertise. Thanks to your course, I can now apply these tools to my work today and see myself continuing to use my natural curiosity to explore Excel and create solutions for both work and personal projects. 

Accrediting Associations

Loading...
Enroll Now - Select a section to enroll in
Section Title
Excel Business Analytics
FIS ID
331483
Type
Discussion / Lecture
Dates
Feb 24, 2025 to May 14, 2025
Type
Online, Synchronous
Days
M, W
Time
6:00PM to 9:00PM
Dates
Feb 24, 2025 to May 14, 2025
Schedule and Location
Contact Hours
120.0
Location
  • Central Campus / CPCC
Delivery Options
Course Fee(s)
Reg fee greater than 50 hours non-credit $180.00
Additional Fee(s)
TECH Fee $5.00 Mandatory
Drop Request Deadline
Feb 17, 2025
Transfer Request Deadline
Feb 17, 2025
Instructors
  • Tracy Dougherty
  • Thomas Hinkle
  • Sandra Torres Paez
Section Notes

Class Schedule: 2/24/25 - 5/14/25, 6 - 9 p.m. Mondays and Wednesdays virtual in MS Teams.

This class requires 5 hours per week of online self-directed work. Materials are not included. 

Please make sure to have your Network LoginDUO authentication, and student email before the first day of class.

Accrediting Associations
Required fields are indicated by .