3 New Tips In The August 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. August 3 2016 Hello How Welcome to the August 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. Manually Sort An Excel Pivot Table 2. Copy A Worksheet From One Workbook To Another 3. Print Two Or More Excel Worksheets Together My Recent Blog Posts You Might Like- Formula Friday – Use The INDEX and MATCH Functions In Excel To Calculate Distances Between US National Parks Create A Micro Chart In Excel From A Normal Chart Formula Friday – Searching Made Easy With SEARCH Function in Excel 1. Manually Sort An Excel Pivot Table. As well as using the usual sort options in a Pivot Table, buy value and label, you can also decide yourself the sort order, by using the Manual Sorting option.  I find this useful if maybe the labelling you have used is more bespoke than the usual chronological order of dates for example you may have some periods that are labelled like my data set below running every 4 weeks. If I try to use the built in options, Excel will sort it incorrectly for me as it will sort on the first numbers in the data labels.  That's ok though because we can take control of the situation.  So once I have created my Pivot Table I can sort manually by rows or columns. To sort manually- Select the cell you want to move- in my example I want to move 27 Jun to 03 July 2016 Hover over the border of the cell until you see a four headed arrow When you see the green line drag it to the position you want, your value field will be moved also My data is not sorted exactly as I want it to be. If you now go to your normal sort options in your Pivot Table, you will now see that the options are set to Manual.  To return the sorting back to normal just select either ascending or decending for your sort options. 2. Copy A Worksheet To Another Workbook. I find this is such a time saver.  If you want to duplicate a worksheet into another workbook, wihtout haveing to copy a whole workbook then delete the worksheets you do not want.  I used this recently to copy one League Table worksheet to another workbbok, and it saved me having to delete all of the pages I didnt need in the workbook, if I had copied the whole workbook. As usual in Excel there are a couple of ways to achive the same thing.  So here is longer process (then I will share a quick shortcut). Open the source and the destination workbook Navigate to the source workbook and sheet (the one you want to copy) Right click on the source sheet tab Click the Move or Copy option Click to Create A Copy Choose the target sheet from the To Book dropdown. Excel will display only the open workbooks in this list Click Ok.  Job Done. I find this method a lot quicker though :-) Again have the source and destination workbook open side by side Click the sheet tab in the source workbook and drag it to the target workbook. If you want to copy the sheet instead of move it, hold down the [Ctrl] key while you drag the sheet to the target workbook. That's it. Which method do you prefer?????? 3. Print Two Or More Excel Worksheets Together. Here is a great time saving tip.  If you need to print two or more Excel worksheets in the same workbook, we can group the Excel worksheets together and the worksheets don't even need to be next to each other in the workbook. Select your first sheet Hold down the CTRL key then select the other sheets one by one you want to print The sheets will now be in a GROUP and will appear white against the ungrouped In the example below you can see the 3 worksheets that are grouped together With your group of worksheets still active, go ahead and proceed with your printing tasks as normal. 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:

All the Coolest Features of Windows 10's Anniversary Update

Newsletter

Top Stories Lifehacker · Eric Ravenscraft All the Coolest Features of Windows 10's Anniversary Update Microsoft's first big feature update for Windows 10, the Anniversary Update, is out today. Lifehacker · Thorin Klosowski Hey Siri Is a Massive, Growing List of Everything You Can Ask Siri To Do Siri has grown a lot over the years, and in doing so, it's hard to remember everything you can ask... Lifehacker · Patrick Allan Poke Radar Still Works Great, and Now Has a Webapp and Android App Niantic has been cracking down on a lot of the Pokémon Go maps out there, but there's been a lot... Vitals · Stephanie Lee A Full-Body Workout You Can Do In Your Office Chair Even if work piles up in the office, you don't have to completely shove aside taking care of your fitness.... Sponsored Solé Bicycles Cruise The Streets And Beach In Style On Your Solé Bike ($100 Off) Why subject yourself to subway overflow or surge pricing when you can cruise the streets in style? Save $100 on... Other Stories You Might Like io9 · Germain Lussier Movie Review: Suicide Squad Is Chaotic, Manic, and a Total Mess The Garage · Freddy "Tavarish" Hernandez BMW Engines Are Gigantic Pieces Of Shit Kotaku · Patricia Hernandez Legendary Articuno 'Appears' In Ohio, Tears Pokémon Go Community Apart [Update] The Muse · Bobby Finger The Reviews for Suicide Squad Are In, and They Aren't Pretty

This was sent to star.basak.howtodoit@blogger.com About GMG      Terms of Use      Privacy Policy      Unsubscribe Gawker Media - 114 5th Avenue, Floor 2, New York, NY 10011

                                                           

The Dog Trainer Newsletter Is Back!

How to help your pets get along better and more

To view this email as a web page, go here.

The Dog Trainer Is Back in Action! We missed you! We took some time over here to make updates and changes to the newsletter and hope you choose to keep up with us. Going forward you can plan on fresh new tips and tricks for life with dogs, updates about new celebrity pet books, and contests for pet-lovers. Bark on!                 FEATURED TIP Three Important Tips to Help Your Pets Get Along from Laura Young If there's one thing Laura Young, owner of the famous Pumpkin the Raccoon, knows, it's pet relationships. In this week's Dog Trainer newsletter, she shares three tips for helping your pets get along—plus, a bonus three tips from Pumpkin herself! Rule Number One When you are first introducing a new pet to your existing animals make sure you do it one at a time and slowly. It is important for each animal to feel comfortable and at ease so there is little stress involved, for you and the animals. Rule Number Two During dinner time it is best to make sure they are all fed at the same time but slightly apart. That way if one eats faster than the other there won't be the need to be greedy and enjoy the other pet's food. Rule Number Three Make sure each of your pets receive lots of love and attention. Sometimes there can be jealousy and the need to be dominant but equal love can help calm the stress of that.                 Three Important Tips to Help Your Pets Get Along from Pumpkin the Raccoon Rule Number One Always ensure that the smallest creature in the house is given extra treats. Always. One treat is just not enough. Rule Number Two When positioning oneself on the sofa always make sure the smallest creature in the house is given the most amount of space. This is very important to ensure that there is ample room to stretch and play. Rule Number Three (And this one is very critical) When it is supper time it is important to allow the smallest creature in the house to receive supper first, and they must be the first to receive seconds, thirds, and then of course bed time treats. And any leftovers should be left by the bed for midnight snacking!             Pumpkin: The Raccoon Who Thought She Was a Dog (publishing this October but available for pre-order now!) is a sweet, unique look at an adorable household pet, captured in gorgeous, never-before-seen photographs in luxurious settings. Follow Pumpkin Here!                 THIS WEEK ON THE DOG TRAINER Should You Still Hug Your Dog?   There's been a lot of buzz in the news lately about hugging your dog. Does your pup love it? Or does he or she despise it? Sarah Hodgson, author of Modern Dog Parenting , weighs in on the controversy on Quick and Dirty Tips' The Dog Trainer. Read More ...                 What's New on QDT's The Dog Trainer? How to Potty Train a Small Dog or Puppy in a Big Home 5 Fresh and Fun Ways to Teach Your Dog or Puppy to Come Signs of Dog Aggression Get Your Dog to Automatically Sit with These 6 Steps                 Want more tips? If this was forwarded to you by a friend and you'd like to receive future tips, you can sign up here. Please don't use the subscribe/unsubscribe link at the bottom of the page because this will overwrite your friend's subscription. (If this came directly to you, you can use the subscribe/unsubscribe link below to manage your subscription.)                 SHARE THIS EMAIL

This email was sent by: Macmillan 175 Fifth Avenue New York, NY, 10010, USA We respect your right to privacy - view our policy Macmillan believes piracy hurts writers, readers and everyone who loves books. Learn more and report suspicious activity here. To subscribe to this or other email communications from Macmillan, please click here. Visit our profile center to update your email address and/or other information. If you no longer wish to receive this email communication, click here to unsubscribe.