Advanced Excel for Analysis and Business Intelligence

The way the business world uses Excel is constantly evolving. Keeping up with these changes can be intimidating, complex, and confusing, given Excel’s ever-expanding library of functions and features.

The Advanced Excel for Analysis and Business Intelligence course provides students with a more comprehensive and intuitive understanding of Microsoft Excel, making many of its advanced technical aspects easier to grasp and apply in real-world scenarios.

Excel will be explored through a combination of mind-provoking discussion topics and lectures with detailed videos, each one timeless, short, easy to understand and follow along with. The course’s final capstone dashboard project will help tie everything together. 

This course will equip you with practical yet powerful Excel techniques to enhance your professional life in ways you may have never considered before.

Course Topics:

•    Importing and cleaning datasets and understanding data validation,
•    PivotTables: Creating and using PivotTables for frequency measures and data analysis,
•    Advanced Pivot Charting - Pivot Tables and Pivot Charts,
•    Analysis ToolPak, What-if Analysis, Solver, and Goal seek,
•    Statistical Functions and Analysis: Use Excel for various statistical analyses, including normal probability, point estimates, and z-scores,
•    Power Pivot, linking to multiple datasets,
•    Power Query and managing multiple queries,
•    Utilizing the Data Model,
•    Advanced Charting in Excel: Scatter Diagrams and Regression: Construct scatter diagrams, develop regression equations, and perform residual analysis,
•    ... and more!


Course Learning Outcomes: 

By the end of this course students will:
 
•    Learn to automate importing and cleaning datasets,
•    Know how to use complex data validations,
•    Create advanced charts in Excel: Scatter Diagrams and Regression: Construct scatter diagrams, develop regression equations, and perform residual analysis,
•    Understand how to create and use more dynamic PivotTables for better data analysis,
•    Create advanced pivot charting,
•    Learn to use the Analysis ToolPak, What-if Analysis, Solver, and Goal seek functions,
•    Perform statistical functions and analysis including normal probability, point estimates, and z-scores,
•    Learn to use Power Pivot for linking to multiple datasets,
•    Use Power Query and manage multiple queries,
•    Utilize the Data Model


Software: Office 365 highly recommended

Course typically offered: Online, every quarter

Prerequisites: Previously taken CSE-41250: Intermediate Excel or an equivalent intermediate mastery of Microsoft Excel

Next Steps: Upon completion of this class, consider enrolling in other required coursework in the Business Intelligence Analysis Certificate Program

More Information: For more information about this course, please contact unex-techdata@ucsd.edu