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 https://www.youtube.com/watch?v=UIsKXur3CeE
Monday, May 15, 2023
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.
Subscribe to:
Posts (Atom)