Skip to Content
Course

Intermediate Excel

CSE-41250

 

When you need to crunch numbers for sales, inventory, IT, or other departments, the ability to get the right information to the right people at the right time can create a powerful competitive advantage. The knowledge on how to manage data and effectively present the information is extremely important. To have a competitive edge in today’s world market, you need to have the knowledge to produce reliable and actionable results from your data. Excel is a powerful, economical, and readily available tool that provides a way to extract the data to get the answers for you.

This course will build a strong foundation of knowledge for you to use Excel in the most effective way to analyze your Excel data and keep up with market trends.

Our focus is to help you increase your productivity and minimize your frustration through the power of knowledge of Excel tools.

Key Topics:

  • Introduction to tables and formatting
  • Sorting and filtering
  • Number formatting and paste special
  • Conditional formatting
  • Basics of visualization
  • Intermediate charts and graphs
  • Understanding Excel's structure and capabilities
  • Introduction to Function Library
  • Introduction to Pivot Tables
  • Data linkage
  • Expediency tools

Practical Experience: Students will gain hands on experience through a real world analytical project

Course typically offered: Online, every quarter

Software: Microsoft Excel 2019 or Office 365 highly recommended

Prerequisites: Students should have basic familiarity with Office products and Excel, specifically

Next Steps: Upon completion, students will be well prepared for CSE-41161: Advanced Excel for Analysis and Business Intelligence or the Business Intelligence Analysis Certificate.

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

Course Information

Online
3.00 units
$695.00

Course sessions

Closed

Section ID:

183858

Class type:

Online Asynchronous.

This course is entirely web-based and to be completed asynchronously between the published course start and end dates. Synchronous attendance is NOT required.
You will have access to your online course on the published start date OR 1 business day after your enrollment is confirmed if you enroll on or after the published start date.

Textbooks:

All course materials are included unless otherwise stated.

Policies:

  • No refunds after: 9/30/2024

Schedule:

No information available at this time.
Closed

Instructor: Mariah Archer-Williams

Mariah Archer-Williams

Mariah Archer Williams is a Strategic Planning Manager at UC San Diego Health. She specializes in data visualizations and predictive modeling.

Full Bio
Add To Cart

Section ID:

185661

Class type:

Online Asynchronous.

This course is entirely web-based and to be completed asynchronously between the published course start and end dates. Synchronous attendance is NOT required.
You will have access to your online course on the published start date OR 1 business day after your enrollment is confirmed if you enroll on or after the published start date.

Textbooks:

All course materials are included unless otherwise stated.

Policies:

  • No refunds after: 1/20/2025

Schedule:

No information available at this time.
Add To Cart

Instructor: Mariah Archer-Williams

Mariah Archer-Williams

Mariah Archer Williams is a Strategic Planning Manager at UC San Diego Health. She specializes in data visualizations and predictive modeling.

Full Bio