Adam Kolesar

77 Flips | 4 Magazines | 14 Likes | 8 Following | @adamkolesar2014 | Keep up with Adam Kolesar on Flipboard, a place to see the stories, photos, and updates that matter to you. Flipboard creates a personalized magazine full of everything, from world news to life’s great moments. Download Flipboard for free and search for “Adam Kolesar”

Webinar Wednesday: Data Visualization Design Discussion Lab

Take your dashboard and reports to the next level with a hands-on look at improving and updating your visual design in Wednesday's webinar!<p>Data …

How to configure an Excel file for use in Power BI

Getting viable data from an Excel workbook into Power BI for data visualization purposes takes some specific preparation. Here is what you need to do.<p>…

This Google-Backed Data Viz Platform Was Designed For Non-Coders

Flourish is meant to give journalists a way to work with data, no matter their technical skills.<p>Here’s a little known fact about data journalists: While they are masters at creating compelling stories with data and making that information accessible, they are not, by and large, coders. That means …

Introducing GE’s data visualization framework for IoT

I’d like to introduce you to the Predix Visualization Framework (aka Px-vis) , a charting framework designed and developed by the Predix Design …

Data Visualization

How to build a realtime graph using JavaScript

<i>This blog post was written under the Pusher Guest Writer program.</i>The world needs everything uber-fast now. There are plenty of data streams being …

20. Special charts (graphs) in Excel

Videokurzy Excel<p>Ve spolupráci se <b>SEDUO</b> jsem vytvoøil nìkolik videokurzù:<p><b>Jak na Excel - nauète se efektivnì využívat Excel</b> - nejoblíbenìjší (<i>Hodnocení</i> …

Sparklines in Excel

<b>Sparklines</b> in <b>Excel</b> are graphs that fit in one cell and give you information about the data.<p>Insert Sparklines<p>To insert sparklines, execute the …

Excel dashboard design with benchmarking

<b>Excel dashboard design with benchmarking in addition to internal key performance indicators</b><p>Excel dashboards always include the most important metrics …

How Option Buttons Can be Used to Control Your Dashboard Number Formatting

It has been far too long since I last posted on my blog. Between removing the popcorn ceilings throughout our entire upstairs of our home and just …

Analytics

Power Query

First and most interesting aspect of Power Query is the fact that the result is in a table.<p>Principe of Power Query<p>When you import your data with …

ASAP Utilities for Excel - The popular add-in for Excel users. Easy to use tools that save time and speed up your work in Excel. We also offer a free edition.

Sit down and relax while ASAP Utilities does the rest!<p>Frequently we write a new tip to show you how to benefit from the tools in ASAP Utilities to …

Software

Still Using Spreadsheets?

• Bring it all together: Visualize data from any source—including Excel—in one place.<br>• Automate your reporting: Automatically update key metrics to gain …

Excel Webinars • My Online Training Hub

Which Free Webinar Would You Like To Watch?<p>Creating Excel Dashboards<p>Learn to build this interactive Excel Dashboard, that you can update in less than …

Excel Dashboard Course • My Online Training Hub

Do your Excel reports take a long time to update each month/week?<p>Do you spend hours collating data, updating formulas and charts and then feel like …

Wordsmith for Excel turns your charts into reports on-the-fly

You might not have heard of Automated Insights before, but chances are you’ve probably seen what its software can do.<p>The company has developed Wordsmith, which is essentially AI that can write human-sounding reports from raw numerical data, such as financial reports and sales forecasts. It’s …

Analytics

Top 10 Cheat Sheets to Help You Master Microsoft Office

Microsoft Office is still the most popular office suite used by companies and individuals across the world. These Word, Excel, PowerPoint, and …

Software

Best Excel Tutorial - Analysis ToolPak Add-in

By following these steps, you will be able to use Analysis toolPak add-in:<p>1. Go to File on top left corner of the Excel. File has green color as a …

Real Statistics Resource Pack | Real Statistics Using Excel

<b>The Real Statistics Resource Pack</b> contains a variety of supplemental functions and data analysis tools not provided by Excel. These complement the …

Data Science

How to Make Your Graphs & Tables Look More Professional

Advertisement<p>Whether you’re creating charts and graphs 8 Types of Excel Charts & When You Should Use Them 8 Types of Excel Charts & When You Should …

Introducing the Waterfall chart—a deep dive to a more streamlined chart - Microsoft 365 Blog

Last month, we introduced six new chart types that will be available as part of Office 2016. Today, we will show you how to take advantage of the …

Floating Bars in Excel Charts

Floating bars can be used to plot many types of data sets. (“Bars” in this usage means “bars”, as Excel calls horizontally oriented bars, as well as …

Creating a VLOOKUP Function in Power Query

Tonight I decided to actually follow through on something I’d been musing about for a while: building a full fledged VLOOKUP function in Power Query. …

Interactive Dashboard in Excel using Hyperlinks » Chandoo.org - Learn Excel, Power BI & Charting Online

Charts and Graphs , Learn Excel , VBA Macros - 201 comments<p>Last week we learned how to create dynamic hyperlinks in Excel. Today, I want to show you …

This Excel Trick Lets You Easily Spot Trends In Piles Of Data

Sparklines are word-sized charts that live in individual cells. This great feature was added to Excel in 2010 but still remains massively underutilized.<p><i>Produced by Sara Silverstein.</i><p><b>Follow BI Video: On Facebook</b>

Excel Slicer Trick

That’s a rubbish title, I know. I couldn’t think of a succinct way to describe what I’m about to show you.I’ve combined a few techniques to create …

Interactive Dashboards using PowerPoint and Excel

Applies To: Excel 2010 PowerPoint 2010 Excel 2007 PowerPoint 2007 More... Less<p>Business Intelligence with Style and Functionality<p>By Glenna Shaw, …

Three ways to hide zero values in an Excel sheet

Although zero values are valid, you might need to hide them. Here are three methods for hiding zero values in an Excel sheet.<p>Zeroes are valid data, …

Software

Dynamic Excel chart with dynamic title based on cell selection | Excel Ticker

<i>This following post is a guest post and was written by Roberto Mensa, Krisztina Szabó and Gábor Madács. Thanks Roberto, Krisztina and Gábor 🙂</i><p>A few …

Making a slick on/off switch using Excel & little bit of VBA [case study]

Posted on December 5th, 2013 in VBA Macros - 28 comments<p><i>I have a confession to make.</i><p>I am not sure how to describe this new thing I made in Excel / …