Home /  Courses And Programs / Advanced Excel for Analysis and Business Intelligence


Excel can be intimidating, complex and confusing with so many features and tools to use. After covering the basics to lay the foundation, this course will move to advanced features of Excel that can be applied in healthcare data analysis, statistics, and visualization, while building pragmatic solutions to common business problems. This course will follow a problem-solution format to explore data analysis options and cover best-practices for delivering solutions in Excel.

Topics include:

  • Dynamic dashboard
  • Pivot table and pivot reporting
  • Table and formatting
  • Advanced formatting
  • Advanced charting
  • Advanced formulas
  • Data tables
  • Simulations and solver
  • Functions
  • In cell drop down menu
  • Data validation
  • Error checking and data monitoring
  • Sparklines
  • IF statement
  • VLOOKUP
  • Macro operations
 

For more information about this course, please contact infotech@ucsd.edu or 858-534-9352

  • NOTE  Students must have an up to date version of Excel on their computers to take this course and understand Excel at an intermediate level.

  • COURSE NUMBER  CSE-41161
  • CREDIT  3.00 unit(s)


Popular in Business Intelligence

course

Mixed Methods Research

Read More
course

Introduction to SPSS

Read More
category

Business Intelligence

Read More
course

Introduction to Institutional Research

Read More
course

Introduction to SQL Programming

Read More
course

Dashboards and Data Visualization for Data Analysis

Read More
certificate

Business Intelligence Analysis

Read More
course

Overview of BI and Data Analysis

Read More
course

Quantitative Financial Methods, Theory and Application

Read More
course

Advanced Excel for Analysis and Business Intelligence

Read More
course

Introduction to Statistics

Read More

Certificate Programs

Business Intelligence Analysis

From the Blog