Intermediate Excel
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 during each academic quarter.
Software: Microsoft Office 2016 required, 2019 or Office 365 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 Number: CSE-41250
Credit: 3.00 unit(s)
Related Certificate Programs: Business Intelligence Analysis
+ Expand All
-
7/9/2024 - 9/7/2024
$695
Online
-
-
-
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.
Archer-Williams, Mariah
Mariah Archer Williams is a Strategic Planning Manager at UC San Diego Health. She specializes in data visualizations and predictive modeling.
-
TEXTBOOKS:
No information available at this time.
-
POLICIES:
No refunds after: 7/15/2024.
-
7/9/2024 - 9/7/2024
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.
-
9/24/2024 - 11/23/2024
$695
Online
-
-
-
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.
Archer-Williams, Mariah
Mariah Archer Williams is a Strategic Planning Manager at UC San Diego Health. She specializes in data visualizations and predictive modeling.
-
TEXTBOOKS:
No information available at this time.
-
POLICIES:
No refunds after: 9/30/2024.
-
9/24/2024 - 11/23/2024
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.