Search This Blog

Showing posts with label Doug H. Show all posts
Showing posts with label Doug H. Show all posts

Tuesday, December 3, 2019

Create Filler Text in Word

Have you ever seen the text "lorem ipsum...." and usually followed by a bunch of non-sensical text in some kind of Latin / English words? This is basically filler text that is used as a placeholder for eventual meaningful text that will show up. Did you know that there is a function in Microsoft Word that can actually generate this lorem ipsum text? It's helpful if you don't have an internet connection. However if you do have an internet connection just google for lorem ipsum generator and you find a bunch of lorem ipsum generators. I found the cat themed one pretty funny.

Tuesday, November 26, 2019

Use the BINOM.DIST.RANGE Function for Hypothesis Testing

If you're performing hypothesis testing, you're probably familiar with the binomial distribution formula. And if you're using Excel to perform binomial distribution, you'll find a bunch of different Binomial functions. In this video, we'll cover BINOM.DIST.RANGE and how it can be used for hypothesis testing. via IFTTT

Tuesday, November 19, 2019

Use the Funnel Chart Feature

If you wanted to create a sales funnel chart in Excel (and if you've got Excel Office 365 or Excel 2019) there is a chart option to create a funnel chart. And it is pretty easy to create. If you don't have those version of Excel, you can still create a funnel chart. Just see my other video at

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

Monday, June 24, 2019

Highlight Parts of a Line Chart

Check out my Blog: You create a line chart and want to mark some areas of significance. Maybe the line chart showed sales and there are some area where there was a market downturn so it could help explain why the sales were impacted in those months. You may have seen this type of chart where it tracks the Dow Jones Average and there is somewhat of a shaded area that shows the months where there was a recession. This chart is not exactly like that but it is similar. And it's easy to create, so check out the video to learn how. P.S. Feel free to provide a comment or share it with a friend! #exceltips #exceltipsandtricks #exceltutorial #doughexcel #excel101 --------------------- Excel Training: Excel Books: