3 Fresh Tips In The September 2016 Edition Of The How To Excel At Excel Newsletter

View this email online if it doesn't display correctly
Don't Forget To add barbara@howtoexcelatexcel.com to your safe or contacts list to ensure you always receive your 3 FREE Excel Tips. Sept 7 2016 Hello How Welcome to the September 2016 edition of the How To Excel At Excel Newsletter.  I hope you enjoy these next 3 tips. You can download the examples used in this newsletter here and follow along with the tips. Below are other places you can find and follow me for more Excel Tips on Social Media or download the FREE How To Excel At Excel App (IOS only) from the App Store for updates directly to your iPad or iPhone. Your 3 Excel Tips Are- 1. Zooming In Excel To Select Large Areas In Your Worksheet 2. Slicers Are Not Just For Pivot Tables! 3. Automatically Refresh Your Pivot Tables My Recent Blog Posts You Might Like- Formula Friday – Whats The Difference Between An Excel Formula and A Excel Function? Macro Mondays – Remove Personal Information From Excel Using Some Simple VBA Count Unique Items In A Pivot Table 1. Zooming In Excel To Select Large Areas In Your Worksheet. Here is a great way to select very large areas of you Excel worksheet, both contiguos and non contiguous, which can be sometimes tricky to do if the areas you want to select are dotted all over your worksheet and you find yourself scrolling for days. It uses the functionality in Excel of zooming.  An Excel worksheet can zoom a range of 10 to 400%.  To change the zoom settings of your worksheet you can either Use the zoom slider at the bottom of the screen to the left Use the zoom percentage indicator adjacent to the slider to open the zoom Dialog Box Once you can see all of the areas you want to select you can go ahead and select either contiguous or non contiguous ranges, as you can easily see the whole section of data you need to select. Easy huh?. 2. Slicers Are Not Just For Pivot Tables. Slicers were introduced in Excel 2010 to use with Pivot Tables, this slicer functionality has been extened and...if you have versions of  Excel 2013 onwards then you can use slicers not ony with Pivot Tables but with Excel Data tables too.  So you can use the easy to see and use slicer buttons to interrogate your data table. To use slicers with your data table, you need to have your data in a table format.  If your data is currently stored as a range, then you can easily convert it to a table. Select your data with CTRL+A Insert Tab - Table - Tick 'My Table Has Headers' in the Create Table Dialog Box Once your data is in a Table format you can go ahead and insert a slicer to use just as you would with a Pivot Table. Place your cursor inside the data table Insert tab Slicer Select the slicers you require - I have selected Month and Region in my example You can now go ahead and use the slicer to filter your data in your Excel data table as easily as a Pivot Table. 3. Automatically Refresh Your Pivot Tables. If like me you share your workbooks with other users, or you have your data source in one of the following types Another Excel workbook An Access Database SQL server OLE data .... then getting your Pivot Tables to automatically refresh when the workbooks they are in are opened is a really useful function.  It's really easy to do and means you can add data to your data source, then users (or you) can open their or your Pivot Table reports with the data already updated. It is easy to set up. Click anywhere in the Pivot Table Analyse Options - PivotTable Options Data Tick or select Refresh Data When Opening The File Hit Ok That's it. Next time the user openes the file, any new new data will be refreshed. Let me know what you think of the Excel tips. If you want a tip mentioned in the Excel at Excel Newsletter- at the email address below. I really hope you enjoyed this edition of the How To Excel At Excel Newsletter.  If you have any tips you want to share with other Excellers just email me- barbara [at] howtoexcelatexcel [dot] com and I will share with newsletter readers.   Keep Excelling!! BJohnston MSc,Bsc(Hons),MCP,MOS Don't forget you can follow me on Twitter for even more Excel Tips and Updates. The How To Excel At Excel Newsletter Is Available To Subscribers Only.  My records show that star.basak.howtodoit@blogger.com subscribed to this newsletter. If you have been forwarded this newsletter or you would like your own copy then send a blank email to me at the address above to subscribe or visit www.howtoexcelatexcel.com and hit Sign Up. Copyright B.Johnston All Rights Reserved
Barbara (at) howtoexcelatexcel (dot) com Co.Kildare, 00447510677 418 Ireland You may unsubscribe or change your contact details at any time. Powered by: