This Micro Tutorial will demonstrate how to use advanced filters in Microsoft Excel. These filters are commonly used in real-world client projects for a reporting dashboard.
The hint of using the apostrophe instead of the = sign at time ~5:00 saved my hide. I needed exact matches so ME didn't give me also MET in a criteria table (actually an Excel Table). When I tried ="=ME", the Table of criteria I was making activated the Totals row. Chaos ensued. Using the apostrophe did not have that problem. So, thank you very much for the hint. Note that I was creating the Table using VBA. I can now move on in my project.
On the official Microsoft website we can find out curious data about Excel. In this post, I will tell you about the ones that have caught my attention the most.
This document presents the Modern Active Directory project, which aims to bring a more modern view on your Active Directory, whether to view key indicators or to perform advanced searches in a simple way.
With this PowerShell module that accesses …