Workbook Download: http://datascopic.net/dlist This video takes you through spreadsheet layout using dropdown lists as a way to use ONE sheet where instincts would have us make 12 sheets. The inspiration for this tutorial is many real-life situations where teeth stopped gnashing once we were able to reduce thousands of formulas and dozens of spreadsheets down […]
You see in my videos that I highlight, scroll and right-click a lot when there are shortcuts available. But this is the first time you get to see my 2-mouse setup. 2 Reasons Why I Don’t Use Shortcuts: 1. When going from software to software, I found it tough to memorize what shortcut does what […]
You see in my videos that I highlight, scroll and right-click a lot when there are shortcuts available. But this is the first time you get to see my 2-mouse setup. 2 Reasons Why I Don’t Use Shortcuts: 1. When going from software to software, I found it tough to memorize what shortcut does what […]
You see in my videos that I highlight, scroll and right-click a lot when there are shortcuts available. But this is the first time you get to see my 2-mouse setup. 2 Reasons Why I Don’t Use Shortcuts: 1. When going from software to software, I found it tough to memorize what shortcut does what […]
Kevin Lehrbass offered a solution to a pretty common challenge with data. Data often comes out of a database looking as shown in the video: condensed rows in a single column. It’s not useful that way. We have to “parse” and “unwind” the data. Check out Kevin’s solution which he handles in native Excel with […]
Quick description of why my recent Excel videos have focused on context and development of tools.
Spreadsheet download: http://datascopic.net/bundledup Problem: There are 30 orders for bass strings and 12 orders for an Advanced Bundle that has 2 sets of strings in each. How can we get Excel to tell us that, to fill the day’s orders, we need: 30 + (12*2) = 54 sets of strings? Complicated formulas can help. However, […]
After watching this video of Felienne Hermans (https://youtu.be/wbiVK6HKHHg) I felt that she means well, but she painted Excel and Excel users quite negatively. Near the end of her video she showed images conveying BI solutions as the cockpit of an airplane and Excel as a rusted bike with flat tires. I don’t think she meant […]
One weakness in spreadsheet development isn’t weak formulas or not knowing how to use pivot tables. The weakness is poor layout. This is one topic that won’t show up in a help menu. This video discusses spreadsheet layout and formula development. The key points for avoiding “octopus spreadsheets”: – Don’t think about the results first. […]