Category Archives for "Time Management"

Top 17 Best Business and Personal Productivity Tips

Charts , Creativity , Dashboards , Decision Making , Excel , Four Quadrant Model , Goals and Objectives , Strategy , Strategy Map , SWOT Analysis and Action Plan , SWOT Analysis and Action Plan , Time Management , Tips , Top Best Tips

Last week’s newsletter contained the Top 25 Excel Dashboard Tips by page views from 2015 articles in Critical to Success. This week’s list has the 17 Most Popular Personal Productivity and Business Performance Tips from 2015. A few of these productivity and performance tips are in both lists, because they use Excel charting, like the Steven Covey […]

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

Excel’s Four Quadrant – Matrix Model Chart : Don’t Make a Decision without It!

Analysis , Balanced Scorecard , Charts , Dashboards , Decision Making , Excel , Personal Performance , Strategy , SWOT Analysis and Action Plan , Time Management

The Four Quadrant or Matrix Model is one the most valuable and widely used tools for decision making. This article has short descriptions of a few famous Four Quadrant – Matrix Model charts. The related article shows you how to create the two most used types using Excel charts. You can’t be a successful consultant […]

Continue reading

Get More Work Done – Focus with the Pomodoro Technique

Personal Performance , Time Management

The age of being a proud multi-tasker has come and gone! Brain function and task efficiency research show that multi-tasking and being open to interruption makes tasks take longer and produces lower quality results. For effective professional productivity you need to focus. Personally, I’ve found my brain distracts itself by continually thinking of new ideas […]

Continue reading

Creating dynamic Excel timelines that scroll

Analysis , Charts , Dashboards , Excel , Excel Project Management , Personal Performance , Project Management , Project Management , Time 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 […]

Continue reading

Create an Excel Timeline Chart to Manage Your Projects and Events

Charts , Dashboards , Excel , Excel Project Management , Personal Performance , Project Management , Time Management

Excel timeline charts are a great tool in any professional’s toolkit. You can insert Excel timelines in your Excel workbooks where you manage projects, show resources and expenses, schedule marketing events, etc. They make communication and detection of conflicts much easier. In the following article you’ll learn how to make a static timeline. In the […]

Continue reading