An email was just sent to confirm your subscription. Please find the email now and click 'Confirm Follow' to start subscribing.


You have already subscribed to this site. Please check your inbox.
You can manage your preferences at

Sparklines & Quick Analysis in Excel (Part 3 of 5: Essential Excel Skills Every Controller Should Know)

October 22, 2018 | New View Strategies

In part 2 of Essential Excel Skills Every Controller Should Know, I discussed the use of Conditional Formatting and how it can be used to create more dynamic reporting. If you missed it, take a look. As we continue our effort to spruce up our financials reports, let’s look at Sparklines and the Quick Analysis tool.


Much like Conditional Formatting, the use of Sparklines provides another opportunity for a quick graphic in Excel. There are three options – Line, Column, and Win/Loss, found on the Insert tab.

Excel Picture

Creating a Sparkline is simple. Place your cursor in the cell you want a Sparkline and select the output type. In the Sparkline creation box, select your Data Range.

Excel Picture

Once the Sparkline has been created, the Design tab will open allowing for changes, such as creating high point and low point colors.

Excel Picture

Repeat the process for each type / line of data where a Sparkline is desired.

Excel Picture

Quick Analysis

Conditional Formatting, Sparklines, Charts, Formulas, and Tables are all available using the Quick Analysis function. To get started, highlight data rows to analyze.

Excel Picture

In a few easy steps, you can transform your plain Excel financials into colorful reports and dashboards for the Executives in your business.

Read the next part of this series now: Excel Goal Seek (Part 4 of 5: Essential Excel Skills Every Controller Should Know)

Subscribe to our RSS Feed

Subscribe to Blog Updates

Enter your email address to subscribe to this blog and receive notifications of new posts by email.

Join 1 other subscriber

You can unsubscribe at any time. To view our Privacy Policy click here.

Leave a Reply

Your email address will not be published. Required fields are marked *

The experts at New View Strategies are experienced Dynamics NAV and Business Central trainers and business process consultants who have walked in your shoes as former Corporate Controllers, Directors of IT, and Solution Architects, and believe increased utilization of your business systems is critical to the continued success of your company.
Subscribe to our newsletter and keep up to date with classes, special registration discounts, and other NVS news

You can unsubscribe at any time. To view our Privacy Policy click here.

| Website Proudly Designed by Phoenix3 Marketing
Call Us!
linkedin facebook pinterest youtube rss twitter instagram facebook-blank rss-blank linkedin-blank pinterest youtube twitter instagram