Perform a Two Sample Test in Excel (paired t-test)

If you're testing a scenario that looks at a before and after situation AND wanted to know if there the result is based on random chance or NOT, you probably want to use a paired t test. Excel has some neat functions that give you the ability to do a paired or dependent t test easily. This video will show a quick way using the Data Analysis feature and then the various functions and formula to do it in a more manual (but challenging) way.

Google Sheets - Covert Columns or Rows into Comma Separated Values

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 and you needed to query it in another system, BUT that system needed the input values separated by commas (or semicolons). Using Google sheets, there are actually a couple of ways you can do this and I'll show three examples with three different functions to make it happen.

Animate a PPT with the Zoom Feature

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 and you needed to query it in another system, BUT that system needed the input values separated by commas (or semicolons). Using Google sheets, there are actually a couple of ways you can do this and I'll show three examples with three different functions to make it happen.