Was the iPhone 7 just listed on Apple's website? and 10 More

Not displaying correctly? View this newsletter online.

Was the iPhone 7 just listed on Apple's website? Apple is definitely ready to update its site. If Apple kills the iPhone 7 headphone jack, it's hubris plain and simple Apple has enough influence to change the world's music habits. This time, it won't be for the better. College football star deletes Twitter account after Mia Khalifa puts him on blast Modern life. Delta launches Snapchat account with a Los Angeles scavenger hunt Snap to enter. Rihanna fed the pigeons of New York City at 7 a.m. because why not? All while wearing a giant heart-shaped fur coat. Snapchat's rumored augmented glasses could be one step closer to reality Hopefully it won't be Google Glass all over again. Instagram is killing photo maps Say goodbye to your photo maps. Pilot accidentally flies to the entirely wrong country in colossal stuff-up TFW your inflight navigational system is out to make a fool of you. Live from San Francisco: Apple iPhone 7 Event (Apple Event) All those iPhone rumors will soon be fortified or debunked. Every iPhone 7 rumor, ranked from most to least likely (Apple Event) Have no fear, Sept. 7 is almost here. Apple analyst note may have just revealed the new features coming to the iPhone 7 The latest batch of iPhone 7 rumors come from a very strong source. Read more at Mashable.com ▶ You received this email because you are registered on mashable.com. We respect your privacy. If you believe this has been sent to you in error, please safely unsubscribe. Mashable, Inc. is a Delaware Corporation. P.O. Box 64 New York, NY, 10159-0064

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: