Microsoft announced in early 2012 that it would extend support for aging Visual Basic 6 runtimes and code syntax for the entire life cycle of Windows Vista, Windows Server 2008, Windows 7 and the ...

In Microsoft Excel, a program packaged with Microsoft Office, you can create databases of information and then make calculations, graphs and charts based on that data. It's a handy program to have if ...

In this video, you'll learn to create an advanced automated data entry form in Excel. The tutorial covers input areas, dependent dropdowns, and automated error messages. When a user submits the form, ...

Microsoft Excel’s fill handle tool won’t create an alphabetic list by default, but there are a few tricks you can use to make it work. If you’ve tried to create an alphabetic list using Excel’s fill ...

Q. I want to place a footer that includes the file name and path on most of my Excel workbooks. What’s the easiest way to do that? A. I would suggest you create a default template that generates a ...

Q. I have an Excel workbook with dozens of custom-named worksheets. Is it possible to create a list of those worksheet names in Excel without having to retype them? A. Yes, you can create a list of ...

Need to know your organization’s YOY results? Susan Harkins will show you how to make a PivotChart in Microsoft Excel. You can make an Excel PivotChart to show year-over-year results like this one.