Learn the basics of creating Excel spreadsheets: entering and editing data, navigating aworksheet, adjusting column width and row height, formatting cells, creating formulas and common functions, organizing large amounts of data, creating basic charts, adding headers and footers, and more. Learn keyboard shortcuts for basic techniques.

2 Part Workshop - This is an introductory course to basic grant writing.  You will learn to speak the language, identify potential funding sources, understand the different types of proposals, understand the proposal process, identify the basic elements of a proposal, develop a simple budget, and avoid common mistakes. 

SEPTEMBER 17th & SEPTEMBER 23rd

Learn intermediate-level Excel techniques, including sorting and filtering data, using conditional formatting, creating custom lists, working with multiple worksheets, creating subtotals, and more. Also learn useful functions to modify text, to make decisions withthe IF function, and to lookup data with VLOOKUP and HLOOKUP functions.

Learn how to organize data in Excel with tables: create data validation rules for consistent and proper data entry, use simple and multiple sorts, create custom sorts,and use simple and advanced filters to find subsets of data. Also, learn how to use the three What-If Analysis tools: scenarios, data tables, and Goal Seek. These features allow users to see how using different numbers will affect their results.

Learn how to use PivotTables, the powerful and popular Excel tool used to summarize data from an existing worksheet, and to create PivotCharts from PivotTables. Work with the important tools needed to create and enhance both.

2 Part Workshop - This is an advanced course that builds upon the foundation laid in Grant Writing 101.  Students will learn more grant terminology, find grant opportunities, review program announcements, develop a problem statement/needs assessment, write goals and objectives, and develop complex budgets. 

OCTOBER 6th & OCTOBER 14th

***Prerequisite Grant Writing 101***