Mnemonic Devices

March 27, 2011 by 6 Comments

One of the main reasons for this blog is to build a community of people who are not only committed to improving themselves, but also to teaching and learning from others.  To that end, I would like to request feedback and tips on mnemonic devices employed by others.

I still remember “My Very Education Mother Just Served Us Nine PizzaPies”, taught to me in the second grade or so as a way to remember the Planets (Mars, Venus, Earth, Jupiter, etc.)  And in a book called “The Brain Book“, I learned the importance of tapping into both sides of your brain in putting together mind maps when studying or just organizing thoughts.  This ability to remember things in “chunks”, something we naturally do as human beings, can significantly help you in several areas of your life, from the obvious benefits for school and work to every-day tasks of remembering phone numbers, names, and shopping lists. Read more of this post

Filed under Business Stuff, Self Improvement & Motivation Tagged with , , , ,

Hiding your work- Part 1

March 25, 2011 by Leave a comment

What if you want to hide your work?

There are times when you are working on a spreadsheet, when you must create placeholders. Perhaps you are applying some custom formatting to a specific area, but must reference information in another sheet. (For more information on Custom Formatting, see Custom Formatting). You’ll quickly discover that Excel doesn’t allow you to do that. Or maybe you are modeling your business and want to refer to a different sheet and perform different calculations when the month in question is closed and you have actual data than when it is in the future and you are forecasting. An easy way to tell Excel where to look is to put an “A” (for actual) or “F” (for forecast) in the top row. (How you get Excel to automatically determine which to use can be done in a number of different ways, but some functions you might use INDEX, VLOOKUP, IF, or MAX functions; I’ll be sure to fit in a discussion of each of those at some point.)

But you don’t necessarily want the user of the spreadsheet to see this work, right?  Well, you can hide it in one of several ways. You could change the font color to white (the same color as the background), but any user who selected that and other cells, would still see the cell contents. Read more of this post

Filed under Application (Excel, Access) and Process Development, Business Stuff Tagged with , , , , , , , , , ,

It’s Absolute(ly) Relative

March 23, 2011 by Leave a comment

If I had a dollar for every time someone asked me “what the heck are those dollar signs for?,” I’d be a millionaire.  Well, anyone worth their weight in gold as an Excel user should really understand what those pesky dollar signs are used for.

Most of us know how to use relative references

It’s really pretty simple.  The inclusion of dollar signs ($) in a formula changes at least part of the cell reference from relative to absolute.  Let me explain.  You see, Microsoft Excel is a very, very powerful tool. So powerful, in fact, that more times than not, it tries to help you get your work done faster and more effectively, even attempting to save you, the user, from yourself.  Like auto-numbering and spell-check in Microsoft Word, this type of “help” is what we’ve come to expect with Microsoft products.  So when you copy a formula for use somewhere else in your worksheet, which I’m sure you’ve done, Excel assumes that you want to keep the same relationship.

For example, say if you have three columns of data that represent daily transactions for your store.  Column A represents quantity sold, Column B lists the price per item, and Column C is the product of the two (A*B).  Because of this intuitiveness built into Excel, you need only enter “=A2*B2” into column C (assuming the first row is your column headings).  You can then copy and paste or fill-down the formula. And, as I’m sure you know, Excel will continue with the relative positions (A3*B3, A4*B4, etc.). Read more of this post

Filed under Application (Excel, Access) and Process Development Tagged with , , , ,

Downtime, but a little HIIT, too!

March 21, 2011 by 2 Comments

I’m beginning to realize the importance of balance in my life and setting aside time for recovery.  I am working on a post that will summarize a book that was recommended by a colleague of mine called The Power of Full Engagement that emphasizes rest and balance along four dimensions- physical, emotional, spiritual, and mental.  The physical part is a no-brainer.  As an athlete (some would say former, but real athletes know ‘once an athlete, always an athlete’), I fully understand and build into my workout program regular rest and recovery periods.  It is not so easy for me, however, to appreciate and apply that same discipline to the other areas of my life.

Which made this last weekend very, very important.  On the surface, three days in the Santa Cruz (CA) Mountains, spent listening to music; playing video games; laughing; drinking; eating; and watching basketball looks like nothing more than childish fun.  Five former teammates with an excuse to act crazy.  Well, aside from the fact that we really didn’t act crazy–the first sign, mind you, that we are getting old–it was actually a good time for us to connect in a way we hadn’t ever before.  As fathers and husbands, and as professionals in careers that have had their ups and downs, we provided for each other a much-needed refuel of energy and drive, of hope and optimism, and of passion and compassion.  With enough quiet time to reflect on things other than sports and women, we were able to give to each other comfort, guidance, and encouragement that only long-time friends can provide.  And I’m thankful to my wife and the wives and significant others of my dear friends for being so supportive of this much-needed MAN-cation. Read more of this post

Filed under Family and Friends, Fitness Stuff Tagged with , , , , , , , , , , , ,

Easy way to get the last day of the month in Excel

March 19, 2011 by Leave a comment

There are a lot of times I need to get the last day of a particular month.  One example I’ve used lately is trying to forecast sales for the remainder of a month using the average to date.  If it’s February 12, for instance, and the average daily sales so far are 12k.  I want to extrapolate that out for the rest of the month.  To do so, I need for Excel to know how many more days are remaining in the month- February.

Excel makes this very easy in one of two ways: Read more of this post

Filed under Application (Excel, Access) and Process Development, Business Stuff Tagged with , , , ,

← Older posts

Newer posts →