Category Archives for "Hidden"

Excel and Power BI Dashboard

Hidden

Time remaining until 20% discount ends. 01 Days 02 Hours 19 Minutes 55 Seconds The 20% discount is over, but you can still get a $20 Amazon gift certificate or copy of my book (in the USA). Mynda’s Excel dashboard and Power BI courses are open again!Mynda only opens her courses a few times each […]

Read More

Show or Hide Data and Charts with Dynamic Excel Reports

Hidden

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

Read More

Speedup Excel VBA Macros with Protect UserInterFaceOnly

Hidden

Many Excel macros run on protected worksheets. If you use the little piece of VBA code in this article they will run a lot faster. Let me give you an example. I just finished a very robust Return on Investment calculator that has seven sheets of data entry, revenue forecasts, and output reports. It uses […]

Read More

Speedup Excel Performance

Hidden

Regain faster performance with Excel 2013 (or newer versions) by turning off spreadsheet animation. Excel 2013 and newer versions use animation to make cell movements, filling cells, and even recalculation look smooth and fluid. For example, with animation filling a column with numbers makes the numbers appear to flow down the column. With animation on […]

Read More

Would You Like to Spy on Your Neighbor’s Dashboards? Here’s How.

Hidden

Have you ever wanted to see how others have designed a dashboard? Or what another organization’s Balanced Scorecard looks like? Come on. I know you have. Why learn things from scratch when you can stand on the shoulders of other good ideas. Seeing how others approach a problem can show you where you forgot something […]

Read More

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

Hidden

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

Hidden

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

Hidden

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

Hidden

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

How do Sparklines work with Non-Numeric or Hidden Data?

Hidden

Make sure you know how Sparklines work when their range includes non-numeric or hidden data. The data in the cell is the Sparkline Non-numeric ignores data and plots through non-numeric #NA ignores #NA and plots through #NA Blanks plots a blank Zero plots as zero Empty cells shows empty cells as you specify. See below. […]

Read More
1 2 3 10