Excel Training 101

Been in a situation where you had to convert values in columns or rows into comma separated values (csv)? Maybe you got a column of value ...

Been in a situation where you had to convert values in columns or rows into comma separated values (csv)? Maybe you got a column of value ...

Grouping dates in a pivot table is one of those nice slice and dice features. If you get dates in a MM/DD/YYYY or DD/MM/YYYY format and w...

PowerPoint is great for animations and if you wanted to simulate a mobile phone screen as if someone was to browse through their social me...

If you want to create a puzzle piece image out of an existing image, you'd think it was something that could only be done in Photoshop...

A Pareto analysis tries to find out what variable are responsible for the bulk of the outcomes. It's referred to as a Pareto Principl...

Importing a table from a PDF document into Excel can be a difficult process. You might have been doing a copy and paste and editing or de...

A Chord Diagram or Network Radial Diagrams as a type of chart that is popular in data viz programs. You can't find it in Excel and no...

Animated Bubble Chart probably got their start from Hans Rosling's TED talk demo using their Gapminder tool. This data visualization ...

If you need to chart some kinds of data to a goal like sales to a target, Excel makes this easy with the combo chart of a column chart alo...

Convert numbers to words seems lot a often sought out request for Excel. One day it may be a function or even command that can be entered...

In Excel, creating a risk assessment chart (aka impact / probability chart) is fairly easy. All you need is the risk assessment matrix (w...

If you are trying to do a case insensitive keyword lookup for a table of records, you could just use the filtering capabilities in the Tab...

Appending or combining tables that have common headers in not hard to to if you only have a few. But if you have a couple or combine commo...

A combination chart is a chart type that has more than one type of chart in a single view. Most times it's a combination of a column ...

An animated chart in Power BI is nothing new since you could create an animated bubble chart. But the animation of a bar chart has been s...

When you get date and time values from another systems, sometimes it is in a time zone that is different from yours. For example you might...

If your familiar with Pivot Tables, it's basically taking a proper table and summarizing the data for further analysis. However what i...

If you're creating a scatter plot it may begin with one series of x,y data. But later on you may want to put a second set of data or a ...

If you were to pull out hyperlinks (or URLs) from a table, it would be fairly easy if it were in the beginning or end of the contents in a ...