Data Academy Course

Intermediate Excel

About This Course

*** Data Academy has suspended its in-person classes due to the City’s Shelter-in-Place Directive.  Meanwhile, please take advantage of the free SF Public Library online Intermediate Microsoft Excel from Gale Courses if you have a library card, or other Excel related analytics courses at (audits only).***

This classroom-based workshop is the second in a series of workshops on Excel offered by the Data Academy. It builds on the fundamentals of Excel and introduces more advanced formulas and ways to manipulate and format data in spreadsheets.

This course assumes some comfort with Excel, including a basic understanding of formulas and standard functions and capabilities of Excel. By the end of the class, you’ll have the fundamentals of skills that will help you to do basic analysis, manipulation, and summary of datasets.

What You’ll Learn In This Course

This course will cover the following topics:

  • Review Excel Basics (reference, filtering/ sorting)
  • Date and Time Functions
  • Count Functions (Count, Countif, Countifs)
  • Text Functions (Len, Trim, Concatenate)
  • Logical Functions (IF and AND)
  • Lookup Functions (VLOOKUP and Index/Match)
  • Basics of Conditional Formatting
  • De-duplicating data
  • Pivot Tables
  • Formatting Charts

More resources

Created 3/16/2016