Advanced Excel Tips for Consultants Using Advanced Filter and AutoFilter consulting frameworks and tools

Excel AutoFilter is a simple Excel feature for filtering lists. As a consultant or analyst looking through...

See More...
The Best Excel Checklist consulting frameworks and tools

The Best Excel Checklist uses no Visual Basic, but has a great set of features. It’s easy to create...

See More...
Advanced Excel VLOOKUP Tips for Consultants consulting frameworks and tools

You’re on a consulting project where you need to compare, analyze, and recalculate thousands of items...

See More...
Guide Consulting Clients Decisions with an Excel-Based Decision Matrix consulting frameworks and tools professional skills

Prioritizing, justifying, and documenting decisions are easier when you use an Excel-based decision matrix....

See More...
Create Floating Markers for Actual vs Target Excel Charts for Consulting Presentations consulting frameworks and tools

Colored markers show target values against actual values in columns. They are excellent to illustrate...

See More...
Create Excel Charts and Dashboards with Color Alerts for Actual and Target Values consulting frameworks and tools

As a consultant you want your client to see when they have exceeded or fallen short of metrics and KPIs you...

See More...
5 Top Budget vs Actual Excel Charts Consultants Need consulting frameworks and tools

Here are five of the easiest to create and cleanest budget vs. actual (target) Excel charts you might need...

See More...
Top 5 Excel Funnel Charts for Sales and Marketing Consultants consulting frameworks and tools

Every, and I mean every, sales and marketing consultant or manager needs to have funnel charts somewhere in...

See More...
How to Build a Gantt Chart in Excel for Your Next Consulting Project consulting frameworks and tools professional productivity professional skills

A lot of organizations use online project management systems, like Asana. But, sometimes you want a quick...

See More...
Tips on Leading a Team in a SWOT Analysis consulting frameworks and tools

Prepare for strategic plans, projects, organization changes, or career moves with a SWOT Analysis. 

...
See More...
Consulting Power Tools, 2X2 Four Quadrant Matrix Charts in Excel consulting frameworks and tools professional skills

The Four Quadrant or Matrix Model is a valuable and widely used tool for strategic decision making. I...

See More...
Create a Strategy Map in PowerPoint with this Template consulting frameworks and tools

Strategy Maps are a visual diagram of the relationships between objectives in your strategy. It’s a...

See More...