Loading...

Course Description

Saving time is the name of the game! This course will provide 20 tips and tricks to improve your ability to use Excel. Learn how to enter data for optimal use and skills such as generating charts & graphs, automatic formatting, and protecting spreadsheet data. Finally, learn several important formulas and how to use them to build spreadsheets to assist with business analysis for profitability and growth.

Course Outline

  1. Tips & Tricks to quickly enter data such as dragging and locking cells 
  2. Conditional formatting of sheets to reduce time manually formatting color and high lighting 
  3. Keyboard short cuts to reduce time navigating Excel 
  4. How to generate charts and graphs and move them into worksheets and workbooks 
  5. Learn key formulas and how to use them to analyze data
  6. Best practices for entering data into Excel and more! 

 

Learner Outcomes

Participants will be able to display the following skills upon completion
  1. Increase your comfort level and confidence using Excel
  2. Generate charts and graphs 
  3. Learn key formulas and how to use them to analyze data
  4. How to format cells to automatically change based on the data in the cell
  5. Tips and tricks to enter data and reduce time navigating Excel

Notes

A Public Service and Outreach Unit of the University of Georgia. Funded in part through a Cooperative Agreement with the U.S. Small Business Administration. All programs of the UGA SBDC are open to the public on a non-discriminatory basis. Reasonable accommodations for persons with disabilities will be made if requested at least two weeks in advance.
Loading...
Thank you for your interest in this course. Unfortunately, the course you have selected is currently not open for enrollment. Please complete a Course Inquiry so that we may promptly notify you when enrollment opens.
Required fields are indicated by .