One of my YouTube scribers asked me, "How to Exclude Dates With No Data From Charts in Excel?" When you chart data, months with no data appear. For example, if you chart January through December and March and August do not have any data, they will show on the x-axis. You can use Format Axis and Text Axis to hide the months with no data.
Excel - Advanced Filters
Excel filters are great for seeing just a subset of your data. You can use filters for text, numbers, and dates, but also by color. You can use font color or fill color (the paint can). You can also use Advanced Filters. You Advanced Filters when you are looking at multiple fields but for different criteria. For example, I want to filter and only see people in Georgia and New York. That is easy to do and can be done with the drop-down filter. But, for Georgia, I want to see people who are Single, and for New York, I want to see Family. That requires an Advanced Filter.
Artificial Intelligence (AI) in Microsoft 365
Artificial Intelligence (AI) is in all Microsoft 365 apps - Excel, Word, Outlook, PowerPoint, Teams, and other M365 apps. In Excel, we have Analyze data on the Home tab and the ability to get data from a picture or screenshot.