Inside Disney's digital 'newsroom': 'Our goal is to win the Internet every day' and 10 More

Not displaying correctly? View this newsletter online.

Inside Disney's digital 'newsroom': 'Our goal is to win the Internet every day' DI Media has built its social footprint to 1.15 billion followers across its platforms. This photo is officially peak Bay Area Steph Curry, a tech exec and E-40 together as one. Last laugh: How Steph Curry is the world's most subtle assassin Nice jacket. Would Apple really change the design cycle of the iPhone? Rumor has it, Apple will now only redesign the iPhone every three years. Does that make any sense? How Zlatan Ibrahimović prepares for the Euros This legend prepares to lead yet another Swedish football team to the Euros. Hacker steals Katy Perry's Twitter account, sends insults to her 89 million followers The unknown hacker managed to get a hold of the most popular Twitter account out there. North Korea made a Facebook clone and it was immediately hacked Kim Jong-un reportedly had 7 billion friends. JetBlue passenger forced to change after crew decided her shorts were too short Her short shorts didn't cut it. Kid destroys $15,000 LEGO sculpture an hour after new exhibit opens The artist spent three days and nights to construct the giant figurine. This Android phone will put military-grade security in your pocket -- for $14,000 Is it worth it? Probably not. Ferrari just built a one-off supercar for a very lucky (and rich) British buyer Really, you don't want to know how much it cost. 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

The Easiest Way to Start Composting!

Open this email in your browser »

HORTICULTURE SMART GARDENING NEWSLETTER June 1,  2016

Subscribe  |  Renew  |  Shop GardenersHub.com  |  Garden How-To University  |  Gardening Coupons We Love 'Pink Pig' Crapemyrtle Sometimes a new plant introduction is approached with caution. Will it perform? Will it live up to the hype? But when Dr. Michael A. Dirr, renowned plant breeder, speaker and author, unveils a new plant, we take notice and immediately add it to our must-have list. This pink delight is no exception! Pink Pig crapemyrtle will have all of us adding a bit of Southern charm to the garden this year. Seeking Garden Knowledge The more you garden, the more you want to learn, because the longer you garden, the more you discover what you don't know. It's what makes gardening exciting for the new gardener and someone who has been working the soil for decades. We share ideas on how you can expand your garden knowledge, for free! Have No Fear! Compost I will admit that the idea of composting was intimidating to me. So many books, websites, blogs, articles on how to and how not to compost made me think this was one giant scientific undertaking. Then I realized it is pretty basic and I have actually been doing it all along! Here are a few tips. GardenersHUB.com Composting Inside & Out identifies the rewarding benefits of composting and the methods that works best for your lifestyle. Stephanie Davies explains the many natural and beneficial ways to get rid of waste and how to put it to good use. Whether you live on a farm, in the city or in the suburbs, there's a composting method that will work for you. Subscribe  |  Renew  |  Shop GardenersHub.com  |  Garden How-To University  |  Gardening Coupons

This email was sent to: star.basak.howtodoit@blogger.com by: F+W, 10151 Carver Road, Suite 200 Blue Ash, OH, 45242 USA Unsubscribe | Update Profile | Web Version »

We respect your right to privacy. View our policy.

June 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. June 1 2016 Hello How Welcome to the June 2016 edition of the How To Excel At Excel Newsletter.  I hope you like the new monthly scheduling.  I am excited to share three more Excel tips with you.  If you have any tips or Excel questions then email me and I can include them in upcoming newsletters. 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. How To Remove All Cells Containing  Specified Words/s Or Values. 2. Using the Distinct Count With Pivot Table In Excel  2013 onwards. 3. Create A Dynamic Table Of Contents My Recent Blog Posts You Might Like- Formula Friday - Splitting Text And Numbers Formula Friday - Extract A Name From An Email Address Shhhhh…Want To Hide Your Excel Formulas?????…. 1. How To Remove All Cells Containing Specified Word/s Or Values Do you ever need to quickly do a bit of data cleansing by identifying cells that contain a specific value then delete those rows? It's really quick and easy to do.  Let's say we want to find all of the cells that contain the words FUNNY FISH, and delete those rows of data. Hit CTRL+F to bring up the Find and Replace Dialog box Type FUNNY FISH in the Find What box Hit Find All All cells that contain FUNNY FISH will de displayed Scroll down the results holding the SHIFT key which will select all of your results Hit CTRL+ - the shortcut to bring up the Delete dialog box Select to delete the entire row then hit  Ok That's it all of the FUNNY FISH data rows have been deleted! See how easy it is below- 2. Using The Distinct Count With Pivot Table In Excel 2013 onwards If you using Excel versions prior to 2013 then you may want to look away now...only kidding!!!! But this tip relly does only apply to Excel 2013 onwards, that is the ability to count unique items in your Pivot Table. First let's use a data table in Excel as our data source. Select your data set (CTRL+A) Hit CTRL+T Confirm your data table has headers Create your Pivot Table in the usual way by selecting the data table (or the shortcut keys ALT+N+V) Insert Tab - Tables Group - Pivot Table To ensure you can use the Distinct Count function this is where where MUST tick Add This Data To The Data Model in the Create Pivot Table Dialog Box (the data model is part of Power Pivot and works even if you dont have it installed) Simply drop the field you want to make a unique count of into the Values area in this case it is Product Names Then navigate to the Value Field Settings of the value you added At the bottom of the list you will now see Distinct Count (this does not appear if you do not click Add To Data Model) In this example I have chosen to count the number of unique products in the product list.  The result is 4 unique items.  Easy as that.  This is a handy feature that has at last been included in the Pivot Table functionality, saving a lot of time and effort removing the need for extra helper columns and formulas in your data to accommodate a unique or distinct count feature. Note this is not available in Excel versions prior to Excel 2013. 3. Create A Dynamic Table Of Contents In Excel. This Excel tip is in response to a comment on one of my blog posts from 'Harry'.  He had created a Table Of Contents (TOC) using the method below. SAVE YOUR WORKBOOK Select the cell you want to LINK TO Point to the cell border, and right click with the mouse. Press the ALT key and and drag the cells to the TOC area Once the destination sheet has been activated you can then drag the cells to position you want the hyperlink to be on the TOC area Release the ALT key and when the pop up menu appears, select "Create Hyperlink Here" So that is straightforward enough, but what happened when Harry has added new columns or rows, the references then became invalid and the links are broken!! One easy solution to this is to name the cell or cells your are hyperlinking to as a Named Range.  The benefit of using a named range is when the contents of a cell are moved for example when adding columns or rows, the named range does not change.  Handy. In my example below (dont forget to download the example workbook to take a closer look at the examples), I have 3 Report areas, 1, 2 and 3.  Both 1 and 2 have named ranges for their hyperlinks and 3 does not. The Names can be views in Name Manager. All three links work if I click on them and the target cells are the Report 1,2 and 3 Headers, in cells C2, C9 and H2 respectively. If I decide to insert an extra Column, then Hyperlinks to Report 1 and Report 2 work just as expected, but Report 3 points to an incorrect cell, as it does not have named range as a target.  Report 3 is hard coded into the Hyperlinks reference and must manually be changed anytime cells or rows are added.  H2 is now a blank cell and not the reference we wanted. Grrrrr See why I love named ranges. :-)... Hope you like that tip and thanks to Harry for the question!! 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: