Microsoft Excel: Tips, Tricks, and Shortcuts

Location & Dates

If you're looking for quick tips to improve your use of Excel, this is the training for you. No matter what your current level, you will get nuggets of wisdom to help you save time—and we make the training fun. You will learn valuable keyboard shortcuts, insider tips, and hacks to get more meaning out of your data faster. If Excel is not fun for you (yet), don't worry—Jennifer Buchholz of Excel and Flourish teaches in a way that helps all levels of learners. If you haven't taken Excel training lately (or ever), we promise you will learn something to save you time! 

 

Learning Objectives:

·      Use keyboard shortcuts to navigate the worksheet.

·      Write formulas with a relative and absolute cell reference.

·      Select cells to autofill and flash fill data in a row or column.

·      Apply the $ in a formula to lock the formula creating an absolute cell formula.

·      Set conditional formatting rules for specific cells.

·      Quickly create pivot tables and charts without writing formulas.

 

Who Should Attend: This training is for individuals who have Microsoft 365 and Excel installed on their computer.