Learn how to create date lists in Excel using autofill, formulas, and advanced techniques. Save time and boost efficiency with these tips ...

You can create custom Excel functions using VBA matching using your criteria. Create custom Excel functions using Macros in Excel & use user-defined functions in Excel.

Microsoft Excel sorts slider buttons alphabetically and numerically. Fortunately, you can add a custom sort list to sort the buttons in a more meaningful way, when necessary.

Not all sorts in Excel are alphabetical. Sometimes, you need to sort by an irregular set of terms, and when that happens, you need to create a custom sort. Here's how.

Microsoft Excel is a power-packed program with some of the best tools for people working in data-related fields. It provides users with a seamless blending of advanced calculations, pivot tables, ...

Helen Bradley demonstrates Excel formatting tricks that will help you when things don't work as planned. Learn her methods now.

Learn how to make custom templates in Microsoft Excel to save you time and effort when creating similar reports or spreadsheet data analysis ...

How to Create Progression in Excel With Alphabets. Microsoft Excel can use the contents of a cell range to populate adjacent cells. If a range of cells contains a progressive series of numbers ...

What’s the difference between a table and a range of columns and rows on an Excel spreadsheet? How do I create and populate tables? And, once a table is created, how do we custom filter, format ...

You can easily create a drop-down list in Excel to limit the values that can be entered in a column. Here's how to set one up.