Category Archives for "Reporting"

Show or Hide Data and Charts with Dynamic Excel Reports

Excel , Reporting , VBA

With a few simple lines of Excel VBA your static Excel reports can become dynamic. A single click shows or hides charts, objects, or rows and columns. Dynamic Excel reports give your users the ability to show or hide specific parts of reports, such as selected sales regions or to expand a table to show […]

Continue reading

Top 5 Best Excel Funnel Charts Sales and Marketing Love — One Funnel Chart You Should Never Use — And Two Dynamic Funnel Charts in PowerPoint!

Charts , Excel , Functions , Reporting , Tips , Top Best Tips

This blog will show you five different ways to make funnel charts in Excel and two ways to link Excel funnel chart data into PowerPoint slides. Funnel charts are a favorite of marketing and sales for showing the volume and progress through different stages of the customer journey, from initial contacts, to qualified leads, to prospects […]

Continue reading

Creating Custom Excel Reports and Dynamic Sub-Lists Using Complex Criteria

Excel , Reporting

Create sub-lists and custom Excel reports on a worksheet separate from the database using Excel’s Advanced Filter with complex criteria, such as ANDs, ORs, and math conditions. This is an excellent way to create sales reports by region and amount sold, inventory restocking lists that show low items, customer response lists by purchase amounts and […]

Continue reading

Creating Dynamic Excel Lists and Custom Reports from One Master Excel List

Excel , Reporting

A highly valuable Excel skill is being able to create dynamic sub-lists, custom reports, or chart data from a larger master Excel list or database. Use these techniques to create dynamic sub-lists and custom reports that will match almost any report writer. Add a simple macro and you can automate work that would take hours. […]

Continue reading