Continuing the series for Excel beginners, this video shows the usefulness of the functions AND and OR. My book: Guerrilla Data Analysis 2nd Edition http://www.amazon.com/Guerrilla-Analysis-Using-Microsoft-Excel/dp/1615470336 My blog: http://datascopic.net/blog-2-2
This was a real question that came to me. Someone has 113 worksheets in a single Excel file. How can he get all of the data stacked up in a single worksheet? Here, I show how to consolidate the data on 7 worksheets. For 113, the process would be the same. Thanks to Ken Puls […]
In a previous video I showed pivot tavles and said that they big problem with pivot tables isn’t the pivot table; it’s having the data being ready to go into the pivot table. In this video I list some features and concepts that make source data pivot table ready. The first is the data must […]
In the previous video you saw pivot tables. We added new data to the pivot table and had to change the source range. In this video, the use of Excel tables eliminates the need for that extra step. We just have to refresh. Also in this video you’ll see Flash Fill and how Excel’s tables […]
Today, Excel Ignited and SSSVEDA Day 10, I show beginners that Pivot Tables are available to them. Pivot Tables aren’t an intermediate-level tool. The issue with Pivot Tables is that they require proper spreadsheet layout and an understanding of what’s being asked of the data. Then, Excel’s Pivot Table wizard takes care of the rest. […]
In Day 9 of Excel Ignited and SSSVEDA I share some thoughts on how we’ll be going forward through the rest of this month. Rather than teach tips and tricks, we’ll learn by integrating Excel features and data management concepts. Tips & tricks feel too much like the painful way that my dad and other […]
Day 6 of Excel Ignited (Illumintating Excel for Beginners) we look at the symbols in Excel formulas. $ : , ^ What do they mean? What are they doing? In this video I go through those one at a time. My book: Guerrilla Data Analysis 2nd Edition http://www.amazon.com/Guerrilla-Analysis-Using-Microsoft-Excel/dp/1615470336 My blog: http://datascopic.net/blog-2-2
Just 5 days into the “Vlog Every Day” challenge and I wanted to let you know I needed a break. A video a day … WOW! This is going to be a battle. But we’re going to do it. I just needed to reassess how to pace the content creation over these next few weeks. […]