This site under reconstruction.
A couple of posts ago, I wrote something about creating custom lists so that a list of items – could be products, could be departments – will automatically show up in the order you want when you do pivot tables or when you do autofill. Well, in this post, I am going to give an…
Come November first, CoPilot will be coming to Excel (if not the other Microsoft products) for those corporations that pay for certain licenses: I believe E3, E5 and Business Premium. For single individuals or for homeowners, I don’t think CoPilot will be coming for your machine. Here’s my reasoning for why that is so: my…
A couple of weeks ago, Microsoft announced a new feature: Python in Excel! Perfect! Because I’m learning Python. I don’t know a whole lot about this new feature because I don’t have access to it. I could do one of those beta testers type thing, but I really don’t know much about Python, so I…
Here’s a new one that I learned – or I kind of knew but never really implemented it. It’s called Customs List. I took an advanced Excel class from this guy who knows of some interesting features in software products. I think he might have been an engineer at one point, but he teaches how…
What if your company is not on the analytics kick or does not make enough money to afford those fancy software tools advertising predictive analytics or some kind of analytics? What if your peers simply do not have any interest in exploring how to use data and find valuable information? You might still be able…
Not all Excel tools and functions require complicated math or processes; sometimes it’s just a simple productivity tool. I’m going to show you two that I’ve recently started using, one that appears more productive than the other. First, here’s a full PDF that explains in slightly more details the 2 tricks I’ve been using and…
You must be logged in to post a comment.