Microsoft Excel 2016
Workshop Information

Back to All Handouts

Format used for handouts is Microsoft Word.

To save the files, right click on the link, choose "Save Target As..."

Back to All Handouts
 
Excel 2016: Basics 1 - Navigating and Formatting
2.0 hours
In this workshop we will learn keyboard and mouse shortcuts to quickly move through the worksheets and to format the cells. Topics include an introduction to the Excel interface; working with selections; entering and editing data in cells; cut and copy vs. move and duplicate; resizing, inserting and deleting columns and rows; formatting cell fonts, alignments, numbers, borders and shading. Lots of shortcuts! This basic workshop assumes some experience with Microsoft Excel.
 
Handout: 
27 pages
 
Excel 2016: Basics 2 - Math and Functions
2.0 hours
In this workshop we will work with patterns of text, numbers and dates; build simple equations; use basic mathematical functions such as SUM( ) and AVERAGE( ); learn about absolute and relative references, naming cells, and working with named cell ranges. This basic workshop assumes some experience with Microsoft Excel.
 
Handout: 
25 pages
 
Excel 2016: Printing and Setup
1.5 hours
Printing sounds like a simple concept, until that Excel data set just WON'T fit on that printed page! In this workshop we will work with the print preview; set paper size, page orientation, margins, headers and footers; learn how to print titles, gridlines, and column headings; work with the views Page Layout and Page Break Preview; change the document scaling to force the printout into a certain number of pages; and use print areas and page breaks to adjust what goes on each page. This basic workshop assumes some experience with Microsoft Excel.
 
Handout: 
16 Pages
Files: 
 
Excel 2016: Charts and Graphs
2.0 hours
This workshop assumes prior experience with Excel, Basics I recommended. Topics include data groupings; creating and modifying charts; chart types; source data; chart options; chart locations; formatting; adding trend lines and error bars.
 
Handout: 
23 Pages
Files: 
 
Excel 2016: Linking Worksheets
1.5 hours
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 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.
 
Handout: 
18 Pages
 
Excel 2016: Formatting Beyond the Basics
2.0 hours
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.
 
Handout: 
15 Pages
Files: 
 
Excel 2016: Math with Dates and Times
1.5 hour
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 timesheet, 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.
 
Handout: 
17 Pages
Files: 
Times-1-FormatFills.xlsx         Times-2-TimeSheet.xlsx
Dates-1-FormatsFills.xlsx        2-ApptDates.xlsx        3-Holidays.xlsx
 
Excel 2016: Large Data 1 - Sorting and Filtering
1.5 hours
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.
 
Handout: 
19 pages
Files: 
 
Excel 2016: Large Data 2 - PivotTables
1.5 hours
PivotTables are very powerful summary reports created from an organized data set. In this workshop we will learn to plan and create PivotTables; work with grouping, filters, and summary options; create a PivotChart; and explore formatting options. This advanced workshop assumes prior experience with Microsoft Excel.
 
Handout: 
18 Pages
Files: 
 
Excel 2016: Large Data 3 - vLookups
1.5 hours
In this advanced math workshop, we will work with multipart functions such as IF() and VLOOKUP() statements. We will also use Data Validation to create drop-down lists that help with data entry. We'll use the results of the list in our functions.
 
Handout: 
15 Pages
Files: 
Lookup-InvoiceAfter.xlsx
 
Excel 2016: Large Data 4 - Final Report
1.5 hours
In this advanced math workshop, we will create nested If statements and discover how logic functions can simplify our equations; use the Remove duplicates tool and vLookup function to create substitution lists to be used in our pivot tables; created summary pivot tables for text values; and move tables and charts to a summary page (dashboard). This advanced workshop assumes prior experience with Microsoft Excel; experience with building equations in Excel required.
 
Handout: 
13 Pages
Files: 
Final-Accounts.xlsx         Final-CityCounty.xlsx
Data.txt        Final-Inventory.xlsx        Final-Report.xlsx
 
 
OTHER STUFF...
Excel Text Functions (Upper, Right...)
5 pages
Excel Logic Functions (Conditional, If, SumIf...)
4 pages
Excel Other Math Functions (Complex)
11 pages
Excel Speedometer
5 pages
Sample File Speedometer.xlsx
     

Primary Navigation

  • Home
  • Schedule
  • Email Lists
  • Handouts
  • List All Workshops
  • UF Training Resources
  • Reserve Training Room
  • Directions
  • Contact Us