Designing Spreadsheets - Level One

Description

This workshop is for beginners to spreadsheet applications. Through guided, hands-on practice, participants will create a simple project that includes setting up rows and columns, entering data, entering formulas, using functions, and graphing. Focus will be on designing spreadsheets to increase teacher productivity and enhance student learning.

Prerequisite: Basic word processing

Topics

Data Entry Methods
Navigate the Worksheet
Formatting Cells
Alignment
Formatting Font
Using Borders
Formatting Rows and Columns
Using Fill Techniques
Using Formulas
Inserting Functions
Column Chars
Line Charts
Pie Charts
Printing Options
Borders vs. Grid Lines

Designing Spreadsheets - Level Two

Description

This full day workshop builds on the skills learned in the Level One workshop. Participants will delve more deeply into creating and formatting charts, including additional chart types. They will also learn how to use the sorting and filtering feature of Excel, how to create more complex, multi-sheet formulas and functions, using conditional formatting, and number formatting.

Topics

Choosing the Right Chart for Your Data
Column Charts In-Depth
Bar Charts
Line and Pie Chart In-Depth
Area Charts
Excel Database Features
AutoFilter
Sorting Data
Complex Formulas
Referencing Cells from Other Worksheets
Conditional Formatting
Number Formatting
How Functions Work
Understanding Arguments
Useful Functions (Average, Count, Countblank, Countif, If, Is, Min, and Max)
Spreadsheet Security
Panes
Comments

Designing Spreadsheets - Special Topics

Description

If the topics covered in Level One and Level Two don't meet your needs, we can custom design a workshop just for you. That is the purpose of the Special Topics workshops. We can create a spreadsheet workshop that will cover any features and functions of the program about which you need to learn. Just let us know.