19 Top Tips on Excel Advanced Filter and Excel AutoFilter for Consultants Excel AutoFilter is a
Blogs - Excel Charts for Consultants
Microsoft Excel is one of the most used tools by consultants for analyzing and charting data. Analyze in Excel and PowerPivot, visualize in an Excel chart, and copy to PowerPoint to display.
Search with the magnifying glass icon at the right of the menu.
18 Top Tips for Creating Excel Lists or Excel Tables for Consulting Research As a consultant
Top 26 Best Excel Conditional Formatting Tips and Tutorial for Consulting Reports After spending hours, days,
Top 16 Best Excel Function and Formula Tips Every Consultant Should Know These are the top
Top 21 VLOOKUP Tips and Tricks for Consultants You’re on a consulting project where you need
Have you ever wanted to see how others have designed a dashboard? Or what another organization’s
One of the best things consultants can do for a company is transmit the best practices
Microsoft Excel 2016 was released September 22, 2015. Do you need its new charts and a
If you are using PowerPivot for Excel 2010, then click here. The following collections of links
To learn more about PowerPivot and PowerView for Excel 2013, click here. If you have Excel
This Excel tutorial combines INDEX and Sparklines to create a window of vertically scrolling data and
Make sure you know how Sparklines work when their range includes non-numeric or hidden data. The
This tutorial combines dynamic range names with Sparklines so your dashboard users can scroll Sparklines through
Here are some tips on working with Excel Sparklines. If you want to… then do this…
Use Excel’s OFFSET and COUNTA functions to create dynamic range names that automatically adjust as data
Excel’s OFFSET function will give you errors if you follow some instructions on the internet. Even
5 Top Budget vs Actual Excel Charts Consultants Need Here are five of the easiest to
Create sub-lists and custom Excel reports on a worksheet separate from the database using Excel’s Advanced
A highly valuable Excel skill is being able to create dynamic sub-lists, custom reports, or chart
Use INDEX to simulate a scrolling box of data in cells anywhere on your worksheet. It
Use multiple criteria to retrieve data from tables that do not have a unique identifier or
Page [tcb_pagination_current_page] of [tcb_pagination_total_pages]