-
If you need a way to create invoices in Excel, feel free to use one of the many invoice templates on Office.com. While these templates are a great starting point, they won't automatically generate unique invoice numbers for you—you need a macro for that. Fortunately, Excel MVP Bill Jelen created...
-
Suppose you want to send someone a demo workbook, but you don’t want that workbook to be used more than a certain number of times, perhaps because you want to be paid for your work. In today's VBA tip, Excel MVP Bob Umlas shows you how to limit the number of times a file can be used by using...
-
This week, the Excel team here at Microsoft received the tragic news that Excel MVP Nathan Oliver passed away unexpectedly. Nate was a vital member of the MVP community who loved sharing his vast knowledge of Excel with customers and fellow Excel enthusiasts. We’ll always be grateful to Nate for...
-
Hi everyone!
Yesterday I experienced the tedious task of figuring out what the differences are between the VBA projects of two different versions of a customer project I built a long time ago. Luckily there are tools to compare differences in text files, such as ExamDiff.
But the VB editor doesn’t...
-
Unlike Word, Excel doesn't have a Change Case button or keyboard shortcut for magically switching between uppercase, lowercase, and proper case. Now, that doesn't mean that you have to manually retype all your text. (In fact, the very thought of you doing that makes me weep.) Instead, you can...
-
Hi All,
I’ve just updated Charles Williams and my Name Manager utility.
New in this version is that when you delete a range name, you will be asked whether you want to unapply the range name in your formulas. This should effectively prevent any #NAME! errors from surfacing when you remove a range...
-
Hi all,
I had a bit of time to spare the other day (got snowed in during travel by train) and wrote a couple of pages about a new Excel 2010 feature: Pivot table slicers
I show how to customise them and also included some VBA examples on how to work with them. Enjoy the read!
Regards,
Jan Karel Pieterse...
-
Today’s author is Mike Alexander, a Microsoft Excel MVP who shows us how to add a rank to a PivotTable in Excel 2003, 2007, and 2010. For more information, visit www.datapigtechnologies.com . Adding Rank in Excel 2003/2007 Step 1: Sort your pivot table on the data measure you are trying to rank...
-
Today’s author is Charley Kyd, an Excel MVP, who has worked with spreadsheets in business since 1979, and has written books on spreadsheet use for McGraw-Hill and Microsoft Press. In 1990, he also created the first-ever Excel dashboard. You can find more useful tips and posts from Charley and...
-
This is a first time event for me so I have no idea of what to expect. I volunteered and Microsoft took me up on my offer to be one of the Excel panelists.
The blurb from Microsoft:
Would you like to learn more about the cool new features in Office 2010 and Windows 7 and [...] Read More...
-
Today’s author is Richard Petti President and Co-founder of Modelsheet. For more info http://www.modelsheetsoft.com . Microsoft has enhanced Excel® in many ways to help build spreadsheets easily and reliably. Every one of us has made spreadsheets for a wide range of applications ranging from sales...
-
According to Microsoft, I’m awesome. Who am I to disagree? I’ve actually been an MVP for a few years, but the stackable acrylic award only started last year. I’m not sure when I was first awarded, but it was around the same time as Debra and Jon, so maybe they remember.
There was a...
-
Hi folks,
Many of the regulars here probably know the Name Manager utility, which Charles Williams and I created and give away for free on our websites.
Rumour has it this is one of best tools ever built for the Excel developer. I won’t argue with that!
Anyway, as I was looking at my web stats...
-
In Preventing auto_open and Workbook_Open events from running I descibed how to do exactly that. Well, it appears that the methods I gave do not always work with Excel 2007.
A visitor of my website complained he could not prevent his Auto_Open macro from running and during a BeamYourScreen session I...
-
Today’s post was written by Excel MVP Nate Oliver. Excel 2010 presents traditional numerical analysts with new and old tools; today we’ll explore two of them. The difference is that the first shall be what we call qualitative, and the second, quantitative. As a real-world example, on a really hot day...