Home

Consulting

Training

Courses

Skill Standards

This course increases your ability to productively use spreadsheets for ministry activities and analysis.  After taking the course, you should be proficient in the following spreadsheet skills:

Spreadsheets for ministries

Microsoft Office Specialists

Creating Data and Content

 

• Enter and edit cell content

• Navigate to specific cell content

• Locate, select, and insert supporting information

• Insert, position, and size graphics

 

Analyzing Data

 

• Filter lists using AutoFilter

• Sort lists

• Insert and modify formulas

• Use statistical, date and time, financial, and logical functions

• Create, modify, and position diagrams and charts based on worksheet data

 

Formatting Data and Content

 

• Apply and modify cell formats

• Apply and modify cell styles

• Modify row and column formats

• Format worksheets

 

 

Collaborating

 

• Insert, view, and edit comments

 

 Managing Workbooks

 

• Create new workbooks from templates

• Insert, delete, and move cells

• Create and modify hyperlinks

• Organize worksheets

• Preview data in other views

• Customize Window layout

• Setup pages for printing

• Print data

 

Organize workbooks using file folders

 

• Save data in appropriate formats for different uses

Theresa Davison

Phone: 731-514-4973

Fax::   270-568-1003

theresa@davisongroup.com