Monday, June 5, 2023

Key Word Search to Bring Back Multiple Results

Do you create dashboards or templates and want to have a mini search bar or search cell...Something like a mini google in your Excel sheet? Imagine having a cell where you can type some keyword or part of a word and expect it to bring back records that match the keyword. It’s not a full fledge search engine, but it is a neat thing you can do with just a few combinations of the newish dynamic array functions in the latest versions of Excel. Having a keyword search capability and using it for lookups is just another cool way you can use Excel to help you make spreadsheet data useful. Whether you’re doing it for yourself or have a template to send your users, think of this as a neat little tool that hopefully make your job easier.

Monday, May 29, 2023

Lookup to Find Multiple Matches

If you’ve done lookups with VLOOKUP, INDEX/MATCH or even the new XLOOKUP, it usually just brings back one record or one match per cell. But what if you wanted a lookup to find multiple matches? Think you’d have to write crazy long formulas or VBA code? Well with a neat dynamic array function in M365, it’s just a simple combination with other functions that will take you less than a couple minutes to put together...maybe even less that one minute, once you understand how it’s done.

Monday, May 22, 2023

Searchable Dropdown List - 2 Examples

Do you create dashboards or template files for others. Want to add some pizzazz and interactivity? Why not create a searchable dropdown list? You can then use this feature to perform lookups or change the appearance of data in your charts or graphs. You can make it look “cool” for your user and it’s not that hard to do. If you’re putting together a file that has gives users the ability to interact, why not let them also search for data that brings back results?

Monday, May 15, 2023

Data Dropdown Validation List without Duplicates

This video is all about how to create a dropdown list that removes the value you selected previously so it won’t show up on the next set of dropdowns! This is useful if your planning seating table arrangements or assigning roles to people for an event. This is an essential video for anyone has to project manage these types of activities! Something similar if you don't have the latest M365 Excel with Dynamic Array Functions

Monday, May 8, 2023

Dynamic Column Color for Positive / Negative Numbers

If you're looking for a quick and easy way to add some pizazz to your Excel spreadsheets, you're in luck! With a few clicks of the mouse, you can add dynamic column colors that change based on the positive or negative value of the number. This is a great way to add some visual interest to your data and make it easier to scan and interpret at a glance. It makes it easier for your audience to quickly understand where they should focus on your chart and make decisions decisively. Whether you present this in the sheet itself or put into a presentation it’ll be more effective when your using the colors to point out the important parts of your data.

Monday, May 1, 2023

Create Custom Horizontal or x-axis Labels

If you're working with data in Excel, you know that labels on the x-axis can make or break the way your data is presented. Are you looking for a way to create custom horizontal or x-axis labels in Excel? Look no further! This video will show you how to do just that, using a simple trick that anyone can learn. After watching this video, you'll be an x-axis labeling pro! You'll be able to create custom horizontal or x-axis labels in Excel, using a simple trick that anyone can learn. This skill will come in handy when you're working with data in Excel and want to ensure that your data is presented in the best way possible.

Monday, April 24, 2023

Highlight High and Low Sales on Column Chart

Column Charts can be the most common type of chart you show. Why not spice things up by leading your audience to certain parts of the chart. If you’re charting sales or productivity numbers, you may want to focus on the high numbers as well as the low numbers. And with most charts, one of the best ways to do this is with color. You’d choose one standout color for a high value and another color for a low value. And your other values could be some boring grey color. To highlight the MINs and MAXs of your data in a column chart is not on easy, but it’s a visually effective ways of helping your audience to focus on what you’d want them to see as the more important parts of the chart.