资讯

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!
Microsoft Excel can save you time in lots of little ways, like adding a drop-down list to cells so that only pre-written text can be entered.
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.
Learn how to make custom templates in Microsoft Excel to save you time and effort when creating similar reports or spreadsheet data analysis ...
In this guide, you’ll learn how to create a dynamic search box that filters data based on your input, using Excel’s built-in features and Developer tools.
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.
Here's a quick tip for creating a Microsoft Excel drop down list from another tab.
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.
Helen Bradley demonstrates Excel formatting tricks that will help you when things don't work as planned. Learn her methods now.
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 ...