Calculate a Two Way ANOVA with Replication in Excel

A two-way ANOVA test analyzes the effect of independent variables on the expected outcome along with their relationship to the outcome itself. Basically you'd use a two-way ANOVA when you want to know how two independent variables, in combination, affect a dependent variable. Excel make ANOVA calculation fairly easy. This video covers the basics of how to perform an ANOVA with replication test. The key concept to remember here is to see if there is a strong relationship of the interaction between the factors and if there is, it determines that the individual analysis of the factors are not as significant. So you'll need to do a deeper dive on which interactions are affecting your data.

Join Cell Values with CONCATENATE, CONCAT or TEXTJOIN Functions

Would you like to merge text or values in different cells? Depending on the version of Excel, you have several functions that can combine the cells contents together. When combining the values or text string of multiple cells you can put them all together or you can separate them with a delimiter like a comma or semicolon. Whether you want to put data into one column as a single entry or have a separator like a comma, this video will cover the different functions (CONCATENATE, CONCAT & TEXTJOIN) that you can use to do this.

Group Dates in a Pivot Table

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 want to see your data aggregated or rolled up into months, quarters, years or any other interval you need to group the dates. What is nice is you can expand and collapse the months (or whatever grouping or ungrouping you chose) to simplify your views. The other nice thing is that you can put the pivot table data into a chart and use the expand and collapse capabilities from the table to affect the chart or use the expand/collapse buttons on the chart itself. This chart can also be put on a separate sheet so you don't have to see the table. 

A note that is discussed in the video is what happens when you can't group and it may have something to do with the date format (Hint: It's not working because of text). There's another note on how this date grouping can be automatically done or undone.