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

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.

Q. There are formulas that I am repeatedly having to create in my Excel workbook, and there are no built-in functions in Excel that can do these calculations. Is there a quicker way to reuse the same ...

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

Build a custom Excel function library in minutes! Learn how to use VBA, create a personal macro workbook, and design a custom ribbon tab.

Often when you’re working with Excel you will use a calculation that is not available as a built-in Excel function. If you make this calculation repeatedly, you can save having to write the ...

Learn how to create, delete & use a Custom List in Excel. If your work requires typing specific lists repeatedly, you can create Custom Lists to save your time. Learn how!

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 Office Excel helps small-business owners analyze price trends, collect demographic data to improve your marketing efforts and produce customized reports for your bank or investors. The ...

We asked Rob Griffithsu2014our go-to expert on spreadsheetsu2014to use Excel 2008 and Numbers u201908 to create the same project, progressing from the basics (text entry and formatting) to more ...

How to Create an Excel Punch-in Time Card. The opening sequence of "The Flintstones" showed Fred Flintstone happily punching his time card at the end of a long Bedrock workday.

Here's how to create a pivot table in Excel to slice and dice your data, letting you perform in-depth analyses and spot important trends.