Pastor Excel | TCN

Courses
Pastor Excel

Pastor Excel

Pastor Excel a.k.a. Glenn Wood shares tips and tricks for using Excel in church administration. This series of articles has appeared in the Association's Journal over the last several years. These tips and tricks are free to all. Don't have a TCN account. Just click sign and create your free account. These resources are a free download and do not count for CEUs.

Worksheet Setup Tips

Document: Pastor Excel 20.1- Worksheet Setup Tips

The Fix for Common Errors in Excel

Document: Pastor Excel 19.4- The Fix for Common Errors in Excel

Customer Numbers in Cells

Document: Pastor Excel 19.3- Customer Numbers in Cells

Flash Fill makes Separating Data Easy

Document: Pastor Excel 19.2 - Flash Fill makes Separating Data Easy

Locking Excel Cells and Sheets

Document: Pastor Excel 19.1- Locking Excel Cells and Sheets

Finding Specific Numbers

Document: Pastor Excel 18.4 - Finding Specific Numbers

Slicers not just for PivotTables

Document: Pastor Excel 18.3 - Slicers not just for PivotTables

Excel Camera Tool and the Datedif Function

Document: Pastor Excel 18.2 - Excel Camera Tool and the Datedif Function

MS Excel's Paste Special Options

Document: Pastor Excel 18.1 - MS Excel's Paste Special Options

Viewing More and Calculating Financial Quarters

Document: Pastor Excel 17.4 - Viewing More and Calculating Financial Quarters

Watch Window and Goal Seek

Document: Pastor Excel 17.3 - Watch Window and Goal Seek

Excel Camera Tool and DATEDIF Function

Document: Pastor Excel 17.2 - Excel Camera Tool and DATEDIF Function

How Much Will It Cost? Mortgage Calculations in Excel

Document: Pastor Excel 17.1 - How Much Will It Cost? Mortgage Calculations in Excel

Using Color Themes in Excel

Document: Pastor Excel 16.4 - Using Color Themes in Excel

Comments in Excel "Let Me Explain."

Document: Pastor Excel 16.3 - Comments in Excel "Let Me Explain."

MS Excel Shortcuts Continued

Document: Pastor Excel 16.2 - MS Excel Shortcuts Continued

Quick Formatting Numbers and Working with Tabs

Document: Pastor Excel 16.1 - Quick Formatting Numbers and Working with Tabs

Conditional Formatting in Excel - Part Two

Document: Pastor Excel 15.4 - Conditional Formatting in Excel - Part Two

Conditional Formatting in Excel - Part One

Document: Pastor Excel 15.3 - Conditional Formatting in Excel - Part One

Nothing But Dates

Document: Pastor Excel 15.2 - Nothing But Dates

Contribution Data Evaluation

Document: Pastor Excel 15.1 - Contribution Data Evaluation

Grab Bag of Tips

Document: Pastor Excel 14.4 - Grab Bag of Tips

Date Calculations in Excel

Document: Pastor Excel 14.3 - Date Calculations in Excel

Adjusting Cell Values by "X" and Cell References

Document: Pastor Excel 14.2 - Adjusting Cell Values by "X" and Cell References

Fixing "Case" Issues and Concatenating Text

Document: Pastor Excel 14.1 - Fixing "Case" Issues and Concatenating Text

What Is It Going to Cost?

Document: Pastor Excel 13.4 - What Is It Going to Cost?

Custom Lists and Numbers in Excel

Document: Pastor Excel 13.3 - Custom Lists and Numbers in Excel

Back to the Basics: Suggestions and Observations from Twenty Years of Using Spreadsheets

Document: Pastor Excel 13.2 - Back to the Basics: Suggestions and Observations from Twenty Years of Using Spreadsheets

SumIf, SumIfs, AverageIf, AverageIfs, and CountIf Functions

Document: Pastor Excel 13.1 - SumIf, SumIfs, AverageIf, AverageIfs, and CountIf Functions

Charting Zero Values, the IF, OR and the AND Functions

Document: Pastor Excel 12.4 - Charting Zero Values, the IF, OR and the AND Functions

Reporting and Charts

Document: Pastor Excel 12.3 - Reporting and Charts

Shortcut Keys and Data Extraction, Part 2

Document: Pastor Excel 12.2 - Shortcut Keys and Data Extraction, Part 2

Shortcut Keys and Data Extraction

Document: Pastor Excel 12.1 - Shortcut Keys and Data Extraction

What Can You Do with Excel?

Document: Pastor Excel 11.4 - What Can You Do with Excel?

An Introduction to Excel Pivot Tables

Document: Pastor Excel 06.1 - An Introduction to Excel Pivot Tables