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
-
10/5/2020 - 12/5/2020
$725
Online
-
-
-
CLASS TYPE:
Online Asynchronous.
All instruction and course materials delivered and completed online between the published course start and end dates.
Bugge, Steven
Steven Bugge currently consults for the US Dep. of Treasury and US Dep. of Defense. After working in the mental healthcare field as a financial analyst, he left and started Excel Advice, Inc. in 2012. He studied International Business with American University of Rome, Italy and Geographic Information Systems (GIS) with San Diego Community College. Excel Advice, Inc. consults management teams in both the public and private sectors, connecting clients with key developers who help tackle the automation of administrative and compliance centric tasks through the use of various MS Office tools; Excel, Access, Power BI, VBA, Azure and more.
Gilley, Lee
Lee received his bachelor's degree in Mechanical Engineering from Clemson University in 2008. He worked in industrial energy construction for two years before pursuing software consulting and development full time. He's built millions of dollars' worth of software and is passionate about software design, extensibility and user experience. In 2019, Lee launched Docmo: an Excel-based software service providing smart automation for dynamic documents like proposals and SOWs.
-
-
POLICIES:
No refunds after: 10/11/2020.
-
10/5/2020 - 12/5/2020
extensioncanvas.ucsd.edu
You will have access to your course materials on the published start date OR 1 business day after your enrollment is confirmed if you enroll on or after the published start date.
-
1/11/2021 - 3/12/2021
$725
Online
-
-
-
CLASS TYPE:
Online Asynchronous.
All instruction and course materials delivered and completed online between the published course start and end dates.
Bugge, Steven
Steven Bugge currently consults for the US Dep. of Treasury and US Dep. of Defense. After working in the mental healthcare field as a financial analyst, he left and started Excel Advice, Inc. in 2012. He studied International Business with American University of Rome, Italy and Geographic Information Systems (GIS) with San Diego Community College. Excel Advice, Inc. consults management teams in both the public and private sectors, connecting clients with key developers who help tackle the automation of administrative and compliance centric tasks through the use of various MS Office tools; Excel, Access, Power BI, VBA, Azure and more.
Gilley, Lee
Lee received his bachelor's degree in Mechanical Engineering from Clemson University in 2008. He worked in industrial energy construction for two years before pursuing software consulting and development full time. He's built millions of dollars' worth of software and is passionate about software design, extensibility and user experience. In 2019, Lee launched Docmo: an Excel-based software service providing smart automation for dynamic documents like proposals and SOWs.
-
-
POLICIES:
No refunds after: 1/17/2021.
-
1/11/2021 - 3/12/2021
extensioncanvas.ucsd.edu
You will have access to your course materials on the published start date OR 1 business day after your enrollment is confirmed if you enroll on or after the published start date.
There are no sections of this course currently scheduled. Please contact the Science & Technology department at 858-534-3229 or unex-sciencetech@ucsd.edu for information about when this course will be offered again.