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

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

• Increase your comfort level and confidence using Excel
• Generate charts and graphs 
• Learn key formulas and how to use them to analyze data
• How to format cells to automatically change based on the data in the cell
• Tips and tricks to enter data and reduce time navigating Excel