Blog Feed
Make Your Own Theme in Excel
Do you want to enhance your Excel dashboard, charts or reports with branded colors and elements? Say you are working on a new marketing effort that requires a specific look and feel. These elements include specific color combinations to match your corporate logo and so on. It’s possible that Excel’s…
Read More
Quickly Find Set Criteria With Data Filters in Excel
There are many ways to filter and isolate data in Excel. Using data filters is one of the fastest ways to locate the data you seek under set criteria. Say, you are looking at a list of sales records for a particular time period that includes multiple stores, sales associates,…
Read More
Health and Wellness: Making Our Workstations Work!
There are many ways to focus on your health and wellness at work. One way is to make sure your space is meeting your ergonomic needs. Many people go to work and accept their workstation as a fixed factor at work — and not something that is particularly flexible. Here…
Read More
Ergonomic Engineering: What Managers Can Do
Many supervisors and managers recognize the benefits of ergonomic workplaces and workspaces, but feel lost about what they can do, particularly when it involves physical investments. Here are some ideas that can go a long way in helping your employees — it often just takes a manager to advocate on…
Read More
Change Management for a Healthier You – Incorporating Ergonomics in the Workplace
I have a wonderful employee — Renée. Renée is bright, talented, driven and very aware of ergonomic design, given her recent surgery to address joint problems. A few months ago, after completing an ergonomic evaluation, Renée installed a piece of software that alerts her when it is time to take…
Read More
Apply Simple Formatting to Numbers, Dates and Times in Excel
Have you ever been asked to present your data in specific accounting formats? Excel provides a multitude of preset formatting options for customizing numbers, dates and times. You can present data in the way that best expresses your needs and conforms with any government, industry or company standards and styles…
Read More
Use Excel to Determine if Your Data Shows a Relevant Trend
Problem: You have a workbook that contains a full twelve months of production. Even after graphing the data, it still isn’t clear if production went up or down last year. Solution: Insert a trendline. With a trendline, you can see if your sales went up, and if so, by how…
Read More
How to Customize the Settings for Auto Spell Check in Excel
While working in Excel, you may want to change which AutoCorrect / AutoFormat alerts you see (and don’t see) in the creation process. Luckily, you can customize the spelling and grammar checker by selecting specific options to employ (or not) as Excel checks your cell data. Customize Spellcheck Settings Click…
Read More
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