Excel Tips – How to Select All Cells Matching A Particular Criteria in Excel 2010

Excel Tips – How to Select All Cells Matching A Particular Criteria in Excel 2010 What do you do if you need to select all cells matching a criteria like a specific word, character or value and you want to look at each cell individually… and then possibly edit them? And if these cells are scattered all around the worksheet? Well I have found a trick to make this very easy to do. Let’s look at an example. Say you want to locate all cells in your spreadsheet that contain the word Rental. Press CTRL+F and type Rental in the ‘Find what’ field. Click the Find All button and all cells containing the word ‘Rental‘ will be listed at the bottom of the ‘Find and Replace‘ dialog. Pretty cool, huh? Now, here’s the best part!  With the ‘Find and Replace‘ dialog still open, pressing CTRL+A will select all of the items listed at the bottom of the dialog, and it will also select these cells on the worksheet. At this point, you could close the Find and Replace dialog and all o
http://bit.ly/1quZ3Nm

How to Automate the Video So That It Moves From One Side of the Screen to the Other In Camtasia

How to Automate the Video So That It Moves From One Side of the Screen to the Other In Camtasia Camtasia by TechSmith is a great tool for creating and editing video.  You have a lot of control over the video compared to other video editing software. When using Camtasia to create video tutorials of software, it is still a very good idea to at least show a smaller video within the main video of yourself giving the tutorial.  It helps you connect with your audience. There will be times when you are sharing your screen when your image is in the way of what you are trying to show on your screen.  You can move your image anywhere on the screen… and it is nice to have some special effects while moving the image.  In this tutorial we demonstrate how to slide video from one side to the other part in Camtasia, revealing the previously blocked portion of the video canvas  to continue the tutorial. Automating the Video So That It Moves From One Side of the Screen to the Other Watch the fol
http://bit.ly/1en8k1v

Everyday is Wisdom – Episode 1, Part 1/2

Everyday is Wisdom – Episode 1, Part 1/2 In this episode of Every Day is Wisdom wellness and yoga coach, Jewels Lamm, shares her thoughts and a guided meditation on manifesting a dream life. This discussion is all about feeling the good feeling first and then manifesting second.  The goal in life no matter what you are wanting is happiness. So find a way to feel good first. Look for the good n things.  Be constantly grateful for the good, and your life will move into a beautiful flow. Enjoy the video! If this article was of value to you, please comment below and share. By the way, please be free to check out our own Facebook Fan Page: Bren & Mike Prosperity Tips.   Bren Koger Facebook: bren.koger Twitter: @brenkoger If you have a passion and want to share it with the world, and want to make money while doing it, then check out http://www.urmoneymagnet.com.  Learn how our viral blogging system can work for you.  Article: Everyday Is Wisdom – Episode 1, Part 1 of 2
http://bit.ly/1fhPhKh