Showing posts with label excel. Show all posts
Showing posts with label excel. Show all posts

Tuesday, November 12, 2019

Calculate a Confidence Interval in Excel

Whenever you see statements like "we are confident that the average is between x and y number" ever wonder what that means and how it's figured out? Well here's a short video that touches on the topic of confidence intervals and how it can be calculated in Excel.

Tuesday, November 5, 2019

Compare Two Tables in Excel [2 Examples]

Have you sent a table to someone to ask for feedback and they send it back to you with changes...BUT they don't tell you where it is! Before you strangle your friend, co-worker or boss, there is actually a couple ways to quickly find out where the changes are. I'll cover 2 example of how to do this.

Wednesday, October 30, 2019

Transpose Data in Power Query

In Excel you can you the copy or cut and then paste transpose to switch data from columns to rows, or vice versa. You're basically rotating data from rows to columns or columns to rows. This functionality is also available in Power Query. Most of the time you shouldn't have to bring a small data set into PQ to do any transpose of data, but if rotating data is part of your overall transformation steps there is some extra steps you need to be aware of.

 *SUBSCRIBE* to my channel at