Microsoft Excel Level 1

Microsoft Excel for Beginners (2.0 hr)

This is a basic computer workshop. Microsoft Excel is a spreadsheet program. We use it to create reports that need calculations and charts. In this workshop, we will learn how to move around and work inside the spreadsheet.

Gainesville Schedule Jacksonville Schedule Handout
Class Files (ZIP)

 

Excel 2016: Basics 1 – Navigating and Formatting (2.0 hr)

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 workshop assumes some experience with Microsoft Excel.

Gainesville Schedule Jacksonville Schedule Handout

 

Excel 2016: Basics 2 – Math and Functions (2.0 hr)

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.

Gainesville Schedule Jacksonville Schedule Handout

 

Excel 2016: Printing and Setup (1.5 hr)

Printing sounds like a simple concept, until that Excel data set just WILL NOT 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.

Gainesville Schedule Jacksonville Schedule Handout
Class Files (ZIP)

 

Excel 2016: Charts and Graphs (2.0 hr)

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.

Gainesville Schedule Jacksonville Schedule Handout
Class Files (ZIP)