If you find yourself always merging worksheets of client data and know that there must be duplicates, here is an easy way to find those duplicate entries. Select the range of cells On the menu bar, click on format, conditional formatting Under Condition 1, select Formula is In the formula =Countif (column range you are [...]

What’s Your Opportunity Number? Is your revenue increasing or decreasing every year?  There are many factors that can cause your revenue to slide, and one of them I’d like to introduce is your opportunity number. Your opportunity number is the smallest amount of business you’re willing to take on when you take on a new [...]

Want a way to quickly enter today’s date?  Press Control + ; (Ctrl and semicolon simultaneously). Now if you also need to enter the time just press Control + Shift + : (Ctrl, shift, colon simultaneously). Another way to get the most of those keyboard shortcuts.

Wisdom of the 8 Bowls: a modern myth for women at mid-life and beyond (c) 2012 by Flo Schell, EdM Imagine your life exactly as it is now. You’re feeling grateful for what you’ve accomplished but wondering, “Is this all there is?” Part of you is asking, “Is it possible to try something new and different [...]

Here’s another keyboard trick for your iPad. Holding the hide keyboard button allows you to split the keyboard. Some people may find it easier to type using the split keyboard. So who has the newest generation iPad on their wish list? I have the original iPad, and boy the features from the 2nd and 3rd [...]

I can’t stress enough how important it is to have an off-site back up of your computer files.  Having an external hard drive is a step in the right direction, but what if your office had a fire or flood. Besides dealing with that type of catastrophic event, now you are wondering how you are [...]

If you could wave a magic wand and work with any client you wanted in 2012, who would they be and what would your business look like?  It’s a fun exercise to think about in the early part of the new year. Let’s begin with your current client base.  You may want to create a [...]

You are working in an Excel file and entering text in a column but you want to start a new line and hitting enter/return just brings you to another cell. To edit the cell, press F2, type your text and then press Alt-Enter to bring the cursor to the next line and continue typing. The [...]

Did you know your iPhone 4 has a compass? In Google Maps, tap your location twice to begin using the built-in compass. This will orient the map based on your location. To drop a pin in Maps, touch and hold anywhere on the map to drop a pin – this will allow you to find [...]

I have been seeing a lot of mention over the months about Pinterest and to be honest, I just skipped over it. I thought another social media site? Who has time for all these different sites? I know I don’t. So I just continued to focus my time on LinkedIn, Twitter and Facebook. Well one [...]