Watching Two Different Parts of a Workbook at the Same Time

Excel , Formulas , Tips

Every parent has wished they could be two places at the same time. I haven’t found a way to do that in the real world, but at least with this trick you can be in one part of a workbook and see what happens in other parts of the same workbook. You can enter data […]

Read More

Document your formulas right in the cell!

Excel , Formulas , Shortcuts , Tips

I’ve had worksheet amnesia so many times it’s not funny. I’ve learned not to make my formulas too complex or I’ll forget how they work. So now if the logic is arcane or I’m going to pass the worksheet to a client or co-worker I put documentation right in the formula. (Remember, what goes around […]

Read More

Inserting Multiple Lines (Line Breaks) in a Cell with Alt+Enter

Excel , Tips

I bet every Excel user has had it happen. You want to type a long line or paragraph in a cell and you press Enter to break line. Instead it enters the text in the cell. Without reformatting the cell for wrap text there’s a quick way to break a line and wrap it in […]

Read More

Creating an Excel Chart with Two Rows of Labels on the X-Axis

Charts , Dashboards , Excel

When the X-axis is crowded with labels one way to solve the problem is to split the labels for each data point into two parts and use two rows of labels on the X-axis. It’s really easy to do, even if you’ve already created the chart. For a new chart on which you want to […]

Read More

When data points are bad or missing, how do you create a usable and decent looking Excel Chart?

Charts , Dashboards , Excel , Tips

You may have faced the problem of having a chart where some of the data doesn’t exist or it’s entered as zero to represent missing data. When faced with these “holes” how can you create a valid and decent looking chart? Perhaps the worst case is when data is missing or invalid and that data […]

Read More

Troubleshooting Your Data Selection for Excel Charts, Databases, Tables, and Lists

Excel , Metrics and Measures , Tips

A lot of the work you and I do in Excel involves lists, tables, or large chunks of data. Learning how to get around these massive areas and learning how to see if you’ve got everything selected is an important skill. You want to avoid that worrisome doubt that there’s an error somewhere… It’s been […]

Read More

Exporting Data for Import into Microsoft Excel

Excel , Metrics and Measures , Tips

You can’t always link Excel worksheets, Pivot Tables and PowerPivots directly to a database. Sometimes you have to go back to the old days of text files to get the data you need for your Excel charts and dashboards. Most Excel users will at some point use data that is exported from another computer program. […]

Read More

Troubleshooting Text Files Imported into Excel

Excel , Metrics and Measures , Tips

Importing data into Excel can be extremely easy or it can be so frustrating you have to leave your desk and walk around outside while muttering to yourself as your colleagues worry about your mental health. To keep your sanity, check out these tips. Dates that won’t reformat Make sure the date format used in […]

Read More

CriticalToSuccess.com Delayed, to Iceland and Back

Work-Life Balance

What a month! I apologize to you for not getting tips to you that could help your careers. I’ve got a stack of helpful tips and tools that I wasn’t able to get to, but now I can start publishing again. It has been an amazing thirty days. Have you ever been hit by one […]

Read More

Connect Emotion and Analytics To Get Action and Impact

Charts , Dashboards , Presentation Skills

You can have great analysis and good answers, but if you can’t communicate and create action your work could be futile. I used to make presentations with the attitude, “Here’s the numbers. Here’s the decision I’d recommend. Questions?” That style doesn’t cut it if you want to make an impact. You have to connect the […]

Read More