Session Overview

This workshop will cover basic Excel functions and formulas. We will explore the work area and develop a general understanding of how Excel works. 

Learning Goal: 

Learners will gain familiarity with the Excel environment and some of the basic tasks it can perform. 

• Explore the work area
• Understanding workbooks and worksheets
• Adding and modifying data
• Using functions and formulas
• Relative and absolute referencing
• Formatting text
• Adding borders and color to cells
• Applying different number formats
• Freezing and splitting window panes
• Creating a drop-down list
• Data validation
• Save Excel in multiple formats
• Working with headers and footers (inserting watermarks)
• Working with "Print set-up" options
• Using Excel Online (Office 365)

Software and Applications: https://ndsu.zoom.us/j/95073780876