Blog Feed

Goal Setting Activities: From Process to Product to Outcome

One challenge in creating goals is defining what the goal is. We generally have some sense that a goal is a future state or milestone, associated with some good thing. How do we translate that into goal statements that are specific, measurable, achievable, realistic and timely? Here’s an example. The…
Read More

Reflecting on Resolutions: How to Achieve Your Goals

New Year’s resolutions are – for many – a repeated annual ritual. This year, let’s pause for a process check. How many of those resolutions have you achieved? If you can look back on past years and name the resolutions you have successfully completed, then good for you! For many…
Read More

A Goal Setting Worksheet: 9 Critical Questions

Checklists are wonderful tools for systematically completing tasks. Filling out a familiar worksheet or answering a series of repeated questions helps train our mind to anticipate the process, making intimidating tasks more accessible. With that in mind, here are 9 critical questions to help you with achieving goals. What’s the…
Read More

Excel Template or Macro? When to use each!

A lot of Excel users are confused about when to use macros and when to create templates.  A macro is a recording of formatting changes and other steps that can be replayed quickly. A template is a pre-formatted spreadsheet with headers and formulas – awaiting your data. I find that…
Read More

Calculations Without the Formulas!

Some people use Excel because they LIKE numbers and math. Some use Excel because they DON’T! Nick counts on Excel to do the mathematical heavy lifting. He needs to calculate rows of data, but the thought of creating formulas and then checking the answers seems daunting. If you feel the…
Read More

Hidden Security Options in Excel

If you have any experience in Excel, then you have probably found a few reasons to want to secure your workbooks.  Here’s an example of what happened to Mary.  She spent weeks making the perfect worksheet for her sales team to collect data about their sales.  Then, accidentally, one of…
Read More