Monday, November 11, 2019: 1:00 PM - 2:30 PM
The registration period has closed for this event.
Excel Formulas and Functions* can greatly enhance your ability to perform tasks in day to day spreadsheet activities. Don’t waste any more hours in Microsoft Excel doing things manually. Learn to use Excel Formulas and Functions to decrease the amount of time you spend in Excel and increase the accuracy of your data insights and your reports.
*Please note: This workshop will be instructed using Microsoft Excel but many of the concepts work similarly on Google Sheets and the commonalities will be pointed out.
This session will incorporate instructor-led demonstration and hands-on guided practice. This workshop will be in a conference room. A laptop will be provided for you but please feel free to bring your own.
At the completion of this productivity workshop, participants will understand the structure and components of an Excel Formula and Function and be able to set-up formulas and functions from scratch as well as modify and troubleshoot existing formulas and functions.
All Excel users
1 hour plus an additional half hour for open Q & A.
Tips for building simple and complex formulas quickly and accurately
How to utilize the hundreds of functions at your fingertips
How to use Absolute and Relative Cell References
Math and Logic Functions: Sum, Average, Count, If, And
Text Functions to select, extract, and combine text entries
Professional Development and Training Coordinator
TBD (Colgate Campus)