Category Archives for "Excel"

Use an Excel Pareto Chart to Improve Business Impact and Performance

Excel

There are two or three charts that every business person must know. One of those should be the Pareto Chart. This chart is the god of productivity improvement. Pareto’s Rule, and its chart, shows you where small changes in your business create huge impacts. This tip will show you how spending five minutes with an Excel […]

Read More

Top 25 Best Excel Dashboard and Chart Tips for 2015

Excel

Tony Robbins and other performance gurus who strive to improve personal performance teach that one of the most powerful ways to improve ourselves is by modeling. Modeling is watching others so you can learn how they perform a task better, then modeling our behavior after theirs. These are the top 25 best Excel dashboard tips […]

Read More

Top 30 Best Excel Chart and Dashboard Tips in the “Excel Chart and Dashboard Quick Reference Guide”

Excel

Get your free copy now of the Excel Chart and Dashboard Quick Reference Guide. Quick Reference Excel Charts and Dashboards – US Letter Quick Reference Excel Charts and Dashboards – A4 Critical to Success now has over 4,000 subscribers with 72% of you consistently opening and using its tips and tools. That is so Awesome! It makes me […]

Read More

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

Excel , Professional Skills

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 […]

Read More

Time and Project Management with an Advanced Gantt Chart in Excel

Excel , Professional Skills

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 […]

Read More

How to Build a Gantt Chart in Excel

Excel , Professional Skills

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 […]

Read More

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

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 […]

Read More

PowerPivot and Power View for Excel 2013

Excel

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 […]

Read More

Excel 2010 PowerPivot

Excel

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 […]

Read More

Vertically Scrolling Dynamic Sparklines Alongside a Database

Excel

This Excel tutorial combines INDEX and Sparklines to create a window of vertically scrolling data and scrolling Sparklines. The “scrolling window” looks into a much larger database. The result is a very functional reporting technique that is cool and takes little space in Excel reports or dashboards. If you put the large database in a […]

Read More