Introduction to Excel | Chicago

About this class

For most professionals, the ability to organize information is quickly becoming a fundamental part of the job description. In this class — ideal for people working in business, management, or simply interested in getting more organized, you’ll learn the key fundamentals to make excel work

Takeaways

▸ Basic Excel (reference, rows/columns, inserting, deleting one at a time or in bulk)

▸ Filtering, Sorting, Formatting

▸ Finding unique values and removing duplicate values

▸ Visually find Totals, Averages, Counts with shortcut keys

▸ How to use built-in functions/formulas and understanding of parameters

▸ How to use summary functions (including subtotal)

▸ How to set up data to build simple pivot tables and charts

Prereqs & Preparation

A laptop loaded with Excel, a general familiarity with the program along with an eagerness to learn, share and collaborate with others. The students will be provided with a few files prior to the start of class that will be used and worked on /with during the class.