Microsoft Excel Level 2

Excel 2016: Formatting Beyond the Basics (1.5 hr)

In this workshop, we will learn to use conditional formatting to have Excel automatically format our data sets based on the cell contents; how to use tables which provide filters and automatic alternating row colors; apply themes to change the color schemes associated within our workbook; create comments to make notes within the cells; and protect the worksheets and workbooks. This intermediate workshop assumes prior experience with Microsoft Excel.

Gainesville Schedule Jacksonville Schedule Handout
Class Files (ZIP)

 

Excel 2016: Linking Worksheets (1.5 hr)

In this workshop, we will insert, delete and rename worksheets; change data and formatting on multiple sheets at the same time; link worksheets to create a Totals page; move sheets into a different workbook (file); and change the view to see multiple books and sheets at the same time. This intermediate workshop assumes prior experience with Microsoft Excel.

Gainesville Schedule Jacksonville Schedule Handout

 

Excel 2016: Math with Dates and Times (1.5 hr)

In this advanced math workshop, we will unlock the secrets of date/time math in Excel; learn lots of shortcuts and custom formatting options; explore many of the built in date/time functions; build our own date/time equations. By the end of this workshop, you will be able to create a simple time sheet, and calculate how many days between two dates, excluding holidays and weekends. This advanced workshop assumes prior experience with Microsoft Excel; experience with building equations in Excel required.

Gainesville Schedule Jacksonville Schedule Handout
Class Files (ZIP)

 

Excel 2016: Large Data 1 – Sorting and Filtering (1.5 hr)

In this workshop, we will work with single and multilevel sorting; learn to use data filters to automatically show only the specified data set; and do math on our filtered data sets. This workshop also contains a very brief introduction to other summary tools such as Subtotal and Pivot Tables. This intermediate workshop assumes prior experience with Microsoft Excel.

Gainesville Schedule Jacksonville Schedule Handout
Class Files (ZIP)