Formulas and Functions that Cut Work Down to Size (Excel)

Thursday, August 16, 2018:  10:00 AM - 11:30 AM


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.

 

 


Session Outcomes

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.


Target Audience

All Excel users


Workshop Length

1 hour plus an additional half hour for open Q & A.


Topics

 

  • 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


Presenting

Robin Bridson
Professional Development and Training Coordinator
x6559

rbridson@colgate.edu 

 




Register
Registration open through 8/16/2018 2:45 PM Eastern Time (US & Canada)

Location

DLMC (5th Floor, Case-Geyer)

 

Click here for Campus Map.