This site under reconstruction.
I think a couple of posts ago, I wrote something about using Word’s special auto feature so store commonly used words, long words, most often misspelled words, in the “auto dictionary” that comes up when you type in the shortened “code” form. In that post, I used the longest village name as an example. Well,…
I don’t think I have written this before but sometimes it can be useful to create your own functions via VBA. This need happens very rarely but it occurs when I need to do something and there is no simple function to do the job. When Googling, the only option that would come up would…
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…
You must be logged in to post a comment.