Thursday, February 13, 2020
Power Query - Create a Table that References Itself After an Update
There may be a time when you want to make an addition (like add a column) to your output table from Power Query and have that update show up in the right place. It becomes a query that takes its output as its new input, appends the new data and overwrites the old result with the new one. This can be called (or at least the concepts are similar to) a self referencing query, circular reference, recursive table, self join or self referencing table. Though it sounds complicated, the steps to do this are quite simple.
Wednesday, February 12, 2020
Convert a Series of Column Pairs into a Table
Got a table that is a series of pair column attributes? Like one column is Date and the right next to it is Quantity, but instead of one pair of this Date-Quantity column pairs, you have multiple ones? How are you supposed to do any proper analysis or charting on this? If this was a small table, copy/paste/transpose might work, but if it was a larger table or something you'd have to convert on a recurring basis it would get tedious. Well that's where Power Query comes in to save you...see the video to learn more
Wednesday, February 5, 2020
Calculate Z Scores in Excel
What is a Z-score? Well it helps you measure how far a value is from the mean (or average) of a group of values. It quickly helps you find out if the number is an outlier or within the "normal" confines of a group of values. This video will show you how to use the STANDARDIZE function as well as the formula to figure out a z-score
Subscribe to:
Posts (Atom)