Sharing data table with someone and wanting to quickly highlight a cell based on some dropdowns? This could be a situation where you’ve got a dashboard or report and you need users to find the main data point after they select something.
This video will show you how simple it is to create a dropdown. Not one but two! And once the choice is made, it’ll quickly highlight that part of a table to show the important information.
Monday, July 17, 2023
Monday, July 10, 2023
Filtering and Slicers - Google Sheets
Filtering column data in sheets in another way to help you narrow done on the important stuff of your data. Also something a bit newer called Slicers, and I’ll cover that closer to the end of the video. But did you know you could filter for value, conditions or colors in sheets? There’s all sorts of ways you can tease out the important stuff in your data with filters and you can even hide your filtering when you are collaborating with others in google sheets.
Monday, July 3, 2023
Extract First, Last & Middle Name Excel Power Query
You’ve got names in a column cell and you want to separate first, middle and last names. Easy to do if ALL the values were the simple first…middle… and last name. But what if some didn’t have middle names? What if some had two or three middle names?
Easy if it was like 5 to 10 names. 20 names…not that easy...2000 names? Much harder to do. But if you’ve got power query, it’ll only take under 5 minutes to do. Plus once you set it up, you can do it over and over again.
Subscribe to:
Posts (Atom)