Troubleshooting Text Files Imported into Excel

Excel , Excel - PivotTables and Lists

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

Professional Expertise

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

Professional Expertise

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

Connect! How to Use Data and Digital Marketing to Create Lifetime Customers

Professional Expertise

I’ve enjoyed writing books and I think I’ve written some that have helped thousands of people, but this book was both a lot of fun, I got to work with two great co-authors, Lars Petersen and Chris Nash, and this book will change the world of marketing.   Connect is the marketer’s guide to becoming […]

Read More

Easy and Awesome Infographics and Stock Photo Designer for Use with Excel and PowerPoint

Professional Expertise

For those of us who aren’t graphic designers, but need to create backgrounds, infographics or designs with stock photos, icons, and symbols, there’s a great free tool, www.canva.com. Canva.com gives us all drag-and-drop graphics, images, infographic design and access to 1,000,000 stock photos at almost zero costs. But, there are a few provisos… In the […]

Read More

Creating Dynamic Excel Chart Legends that Link to Worksheet Cells

Excel , Excel - Dynamic Dashboards and Charts

Want to create Excel chart legends that show additional information? Wouldn’t it be great to have a multiline legend that has notes in it. Just add a dynamic legend that updates when worksheet data updates. It’s pretty easy to make a chart like this one that shows custom legends in a cell and that has […]

Read More

Creating Dynamic Excel Chart Titles that Link to Worksheet Cells

Excel , Excel - Dynamic Dashboards and Charts

You don’t have to settle for Excel’s static chart titles. Your Excel chart titles can be dynamic and link to cell contents. When the worksheet changes, the title changes. They can even have multiple lines that include dynamic data. Link Chart Titles to a Worksheet Cell It’s not hard to link worksheet cells to a […]

Read More

How to Protect Yourself Against the Heartbleed Internet SSL Security Failure

Professional Expertise

The Heartbleed bug can affect anyone that has used a “secure” website like Amazon, eBay, PayPal, your bank, your investments, etc. in the last year. Basically that little green “lock” symbol up in the URL of secure websites doesn’t work and has had a “hole” in it for over a year. The hole was just […]

Read More

Creating Dynamic Excel Timelines That Scroll

Project Management

Last week’s newsletter described how to create a static event timeline in an Excel chart. In this article you’ll learn how to make the timeline dynamic so you can scroll the timeline through a database of events or project due dates. Timelines are great for project management in Excel, event management, and editorial or marketing […]

Read More

Adding the Developer Tab to the Excel Ribbon

Excel , Excel - Tips

Reading this will teach you one of the secret incantations need to move from mid-level Excel user to Excel power user. Hidden to the eyes of novice and mid-level Excel users is the Developer tab. It holds tools that give you extra Excel power – the power to add check boxes to turn IF statements […]

Read More