Day 4 of Excel Ignited (Illuminating Excel for Beginners), Today: The IF Function. This is one of what I consider Excel’s primary colors because these 3 things can take a beginner a long long way: – Filter – Sort – IF function This video provides an extensive explanation of the IF funtion and wraps up […]
Day 3 of SSSVEDA and Excel Ignited: Introduction to Excel Formulas and Functions The month of August 2016 is dedicated to Excel Beginners. Video on Absolute and Relative Cell References 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
Day 2 of Excel Ignited and SSSVEDA: Overview of the Excel Ribbon. Here I cover each of the main tabs, showing the most important features that an Excel beginner should know, and I point out features that are more advanced or specialized. The video includes brief demos of key Excel features, including: conditional formatting, sort, […]
“What is Excel?” I’ve been asked this over the years by people who are curious about Excel or want some insight into what Excel can do. Answering the question is difficult because of the endless ways that people have used Excel to serve their needs. In this video I answer “What is Excel?” several ways, […]
“What is Excel?” I’ve been asked this over the years by people who are curious about Excel or want some insight into what Excel can do. Answering the question is difficult because of the endless ways that people have used Excel to serve their needs. In this video I answer “What is Excel?” several ways, […]
For VLOG EVERY DAY IN AUGUST 2016 I’m dedicating it to 31 consecutive days of basic Excel and calling it Excel Ignited! My regular work had focused on complex Excel skill and data management needs. But Excel Ignited will start with the most basic in Excel. That initial spark that grows into a roaring fire […]
Excel’s PowerQuery (Get & Transform) forces the user to think in terms of full column, full rows, full datasets. This creates a problem: What if you need to shift a column up by just 1 cell? That’s easy in native Excel. In PowerQuery this takes several steps. In this example, artists aren’t matched with the […]
The goal is to split a name out of a cell that included the person’s age, and the make, model and year of the car they drive. (download the workbook: http://datascopic.net/ParseGT) I started this video with the idea of showing you a complex array formula solution. But I kept thinking about an easier way. Ah! […]
This video is in response to a question about a previous video where I showed how to unwind some data. (https://www.youtube.com/watch?v=zlEp9IXdaoI) Delta Sport asked about going in the opposite direction: starting with the unwound data, wind it back up again. This is challenging. It calls for multiple steps in both native Excel and Power Query. […]