In this Excel tutorial, you’ll see the essential steps for creating a user-defined function in VBA. Want to learn more about this and other abilities in Excel? Check out our Excel Training courses, taught by live instructors in our virtual, online or in-person formats.
In this Excel tutorial, you’ll see how to use the Print Titles feature, which helps make large printouts easier to understand with less flipping around in dozens of pages. Want to learn more about this and other abilities in Excel? Check out our Excel Training …
The table is just too useful to keep out of many business documents these days. It’s too good at organizing data. Luckily, even a desktop publishing program like InDesign has the feature handy. And we can even import an existing one pretty much as-is, to …
When Excel 2007 was introduced, the PivotTable Field List included a “Filter” area, where one could drop a field to use as a filter (for example, year, brand name, size, etc. from a block of sales data). If the user filtered for one year, or …
One of my wife’s colleagues recently asked about whether it’s possible to track changes in an Excel spreadsheet. It certainly is, though it works a little differently than in Word, say. Turning the feature on in Excel is quite easy–simply go to the Review tab …
Judging Access vs Excel can take thought. Most people find Microsoft Excel fairly easy to learn—it has a fairly gentle learning curve, the fundamentals only take a short time to pick up, and the program is actually fairly versatile—it’s not just a ledger book on …
Some of the Excel functions, such as IF, come into play all the time, even outside business. They’re versatile and can do a lot. But others seem a little abstruse, or out in left field. One question I occasionally get from business people in Excel …