Intermediate Excel

How the business world uses Excel is forever changing. Trying to keep up with it all can be intimidating, complex, and confusing given Excel’s ever-expanding library of functions and features. The Intermediate Excel course will provide students with essential foundational knowledge and understanding of Microsoft Excel, helping to reinforce and strengthen students’ capabilities.

Excel will be explored through a combination of mind-provoking discussion topics and lectures with detailed videos, each one timeless, short, easy to understand and follow along with. The course’s final capstone dashboard project will help tie everything together.

This course will help arm students with practical yet powerful tactics to apply Excel towards your professional life, in ways that has never been considered before.
 

Key Topics:

•    Entering and managing data sets into data tables in a normalized structure
•    Data manipulation and data formatting techniques
•    Settings related to printing worksheets, protecting worksheets, and customizing settings
•    Working with arrays and data ranges, absolute vs. relative cell references, and naming ranges. 
•    Excel Functions: Understanding general formula syntax, general mathematical equations, data and time functions, basic logic functions, lookup functions (EX: SUM, AVERAGE, MIN, MAX, IF, COUNT, V/H/XLOOKUP and many more.)
•    Correcting formula errors and various troubleshooting techniques 
•    Exploring conditional formatting
•    Exploring the ins and outs of how to make general charts and graphs
•    Creating sparklines, and using slicers
•    ... and more!

Course Learning Outcomes: 

By the end of this course students will:
 
•   Be familiar and comfortable navigating the Excel ribbon,
•   Know how to enter data and normalize datasets,
•   Manage large datasets with data tables,
•   Manage general printing settings and protection settings,
•   Know how to customize Excel settings for more personalized experience,
•   Automate calculations with formulas,
•   Gain skills to conditionally format data to help identify key pieces of information,
•   Learn to create charts and graphs, to present their data effectively
 

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

Course typically offered: Online, every quarter

Software: Office 365 highly recommended

Prerequisites: Begginner level of knowledge and comfort using MS Excel, and general computer knowledge

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 program

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