USC Annenberg Digital Lounge Logomark

Data Analysis with Excel Series

Microsoft Excel is the industry standard spreadsheet editor and is one of the most important tools to learn if you want to do anything data-related with your career.

This project-based, four-part workshop series will give you an introduction to Excel and build the foundations to showcase solid data analytics skills. By the end of the series, you’ll have a dashboard you can include in a portfolio to impress employers.

Part 1: Formulas & Formatting

The first workshop, Spreadsheet Formulas & Formatting, introduces the Excel platform, showcases basic formulas, and explains how to format a spreadsheet.

Part 2: Advanced Formulas

The second workshop, Advanced Formulas, expands upon the basic formulas shown in the first workshop to show how to complete more complex data analysis.

Part 3: Charts and Tables

The third workshop, Charts and Tables, introduces how to organize data and turn it into visualizations.

Part 4: Dashboards

The final workshop, Dashboards, takes all the skills from the previous workshops and culminates into a portfolio-worthy dashboard.

Interested in learning more about data analytics? Check out our other data analytics tutorials and workshops!