If it has been a while since you attended a brush-up course on Microsoft Excel, you’ll know this feeling; you leave the seminar inspired. You can’t wait to get to work and use the new tricks at work, but over the course of a few weeks, you’re lucky if three or four of the new shortcuts you learned make it into your daily rotation. Sound familiar?
Here are some simple Microsoft Excel 2013 tricks you can share at your weekly meeting to keep coworkers up to speed.
Select All. Quick keyboard commands can shave seconds, which quickly add up to minutes and hours, off of your everyday computer tasks. [Ctrl]+A can be used to select all of the data in your Excel spreadsheet at one time. It also works in Word and other Windows applications.
Copy/Transfer Formatting. Here’s a trick you’ll really thank us for. The Excel Format Painter Tool is often neglected, but not for long. When you want to transfer the cell formatting (not formula), simply select the cell and right click. See the paint brush in the bottom-right corner? Select it. Then click on any other cell(s) and the identical formatting will be copied.
Display formulas. When you hit [Ctrl] + ~, all of the formulas in a spreadsheet will be visible, allowing you to edit/tweak them as needed.
Labyrinth Learning has a host of Microsoft Excel 2013 products that can teach your employees basic and advanced skills, or can be used for a FastCourse refresher at your next training seminar.