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 easy to follow along with.

The course’s final capstone dashboard project will help tie everything together.

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 a 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 is highly recommended Prerequisites: Beginner 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 appliedscience@ucsd.edu.