How to Think and Write More Clearly using Four Word and PowerPoint Shortcut Keys and One Menu Choice

Communication Skills , Creativity

After 27 books and a bazillion PowerPoint slides I’ve learned the best way for me to write is just to get my thoughts down as quickly as possible, reorganize them, then let the stuff simmer over night. The next morning is the best time for me to give it a strong edit, cutting as much […]

Continue reading

How to Build a Super-Memory for Business

Learning to Learn

I was a noob, not long out of the Air Force holding a newly-minted MBA. He was the wise and experienced CEO of one of the world’s largest computer chip companies. Somehow, I’d been selected to escort him through the world’s largest computer convention and brief him on competitors in one of the markets we […]

Continue reading

Speed Reading Non-Fiction Books and Remembering What is Critical to Success

Learning to Learn

If you are like most business professionals you have little time or energy after work for reading non-fiction, all those books you know would help your career, your life, your future. But, there is a way to read, and enjoy it, and even remember what you have read when you need it. I still remember […]

Continue reading

Do You Have What It Takes? The Skills 1,261 Recruiters Value Most

Career , Communication Skills , Creativity , Decision Making , Personal Performance , Strategy , Work-Life

Bloomberg Business reporters Francesca Levy and Christopher Cannon completed the Bloomberg annual survey of which job skills are most valued in managers. They reported their results on Bloomberg.com on February 9, 2016. I thought this was something you might find of value in your career and learning decisions. I hope you do find it of […]

Continue reading

Time and Project Management with an Even More Advanced Gantt Chart in Excel

Charts , Excel , Excel Project Management , Project Management , Project Management , Time Management

This advanced Gantt Chart in Excel has the basic scrolling Gantt Chart and custom weekends and holidays, but it also includes alerts for percent complete, email links to task leads, Work Breakdown Structure numbering (WBS), and filters to show only the tasks and date ranges you want. If you are managing personal tasks or small […]

Continue reading

Time and Project Management with an Advanced Gantt Chart in Excel

Charts , Excel , Excel Project Management , Functions , Project Management , Project Management , Time Management

This tutorial shows you how to take the basic Excel Gantt Chart and add conditional formatting so the Gantt chart shows today’s date, custom holidays, and custom weekends. Changing the WORKDAYS.INTL function will also adjust the end date to account for non-working custom weekends and holidays. A Gantt Chart in Excel is a powerful way […]

Continue reading

How to Build a Gantt Chart in Excel

Charts , Dashboards , Excel , Excel Project Management , Functions , Project Management , Project Management

Gantt charts help you track the progress of tasks in a project. This and the following tutorials will show you how to create a Gantt chart in Excel and then enhance it with robust features. The tutorial starts with a simple Gantt chart using conditional formatting and a few functions and evolves into a project […]

Continue reading

Microsoft Excel 2016 Charts and Analytics: Are You Ready? Can You Wait?

Charts , Excel

Microsoft Excel 2016 was released September 22, 2015. Do you need its new charts and a few analytics gadgets it has added? I’m not so sure. However, if you work with teams there are some enterprise collaboration features that will make life less frustrating. (It works on Windows 7 SP 1 or later.) Overall, the […]

Continue reading

PowerPivot and Power View for Excel 2013

Analysis , Charts , Dashboards , Excel , Pivot Table and PowerPivot

If you are using PowerPivot for Excel 2010, then click here. The following collections of links and resources will help you go from short video overviews of PowerPivot and Power View capability to being fairly proficient. Video Overview of Excel 2013 PowerPivot and Power View Here’s a collection of short videos from Microsoft on Excel […]

Continue reading

Excel 2010 PowerPivot

Analysis , Charts , Dashboards , Excel , Pivot Table and PowerPivot

To learn more about PowerPivot and PowerView for Excel 2013, click here. If you have Excel 2010 you have access to Power Pivot, but not Power View. Just the capabilities of Power Pivot make it an extremely powerful tool that any power Excel user has to be familiar with. The ribbon has slight differences from […]

Continue reading