Want to know more?
Unless you’re an expert, you are unlikely to be using Microsoft Excel to its full potential. There are many time saving features and functionality. To help you get started on the road to expertise, here are the Microsoft Excel tips we have shared on Twitter and Facebook.
- Excel 2013 Quick Start Guide: http://officeimg.vo.msecnd.net/en-us/files/514/375/AF103733534.pdf
Here’s a very useful list of keyboard shortcuts for MS Excel:http://www.shortcutworld.com/
There are many “hidden gems” in Excel. Do you want to turn a mass of data into summarised results in just a few clicks? Pivot tables are your answer! I discovered pivot tables about 12 months ago and wished I’d found them years before. They helped reduce the manual work I was doing every week, making reports very quick to produce.
- The Most Useful MS Excel Shortcuts for Financial Analysts http://www.veodin.com/blog/2012/09/14/the-most-useful-ms-excel-shortcuts-financial-analysts/ … although pretty useful for other people too!
- Do you ever worry that someone will change your spreadsheet layout? Maybe you want to protect it from accidentally changing it yourself! For both situations, you can use the protect workbook command. Instructions for Excel 2010 can be found here: http://www.dummies.com/how-to/content/how-to-protect-an-excel-2010-workbook.html
- Here’s some very useful Excel formulas that everyone can use. I’ve used many of these myself and find some of them very handy, especially when copying data into Excel and trying to clean up the results: http://chandoo.org/wp/2008/08/13/15-microsoft-excel-formulas/
- Here are the instructions for copying the unique values from a column of data:
Here are 3 hidden gems you may have missed: http://www.siliconbeachtraining.co.uk/blog/excel-tips-tricks-hidden-gems/
- Have you ever wanted to use macros in MS Excel but didn’t know how? Learn some basic macro skills in this short course:http://office.microsoft.com/en-gb/excel-help/save-time-by-creating-and-running-macros-in-excel-2010-RZ102337714.aspx?CTT=1
- Excel Tips and Tricks sheet (PDF) http://bit.ly/1cpVFJR
- 200+ useful shortcuts for Microsoft Excel http://bit.ly/19mKCRT
- Easily add the current time or date to a cell:
If there are any specific subjects that you’d like us to cover, please contact us: firstname.lastname@example.org