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

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 health care 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

Software: A current and up to date version of Microsoft Excel (2016 recommended).

Course typically offered: Online in Fall, Winter, Spring, and Summer (every quarter).

Prerequisites: 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.

Course Number: CSE-41161
Credit: 3.00 unit(s)
Related Certificate Programs: Business Intelligence Analysis

+ Expand All