The earlier tutorial we wrote on VLOOKUP prompted more questions. I made a reference to naming cell ranges. Sure enough, people asked me for more details. Using Excel's Name Manager feature can make creating formulas or finding data easier. In Excel, we’re used to seeing cell references such as
These pages include all the site tutorials regardless of category. These mainly cover Microsoft and Google products. In addition, there are some posts that provide information about key terms. Presently, the categories include:
This section is several pages long so be sure to use the blue Next Page >> button at the bottom or the search box to the right.
Some reader favorites include:
Spreadsheets are known for having a number of formulas and functions. One that continually intrigues users is VLOOKUP. Excel does include additional information. But sometimes it's best to learn how to use VLOOKUP by following along with example spreadsheets. — If you're using Google Sheets,
An interesting email question came in about MIMO. The reader wanted to know what it was and if these broadband routers could help solve his wireless situation. Defining MIMO is the easier part. The harder part is finding out if all MIMO routers should be considered. MIMO technology is used in
One problem people face is the proper sharing of sensitive information. The information can be anything from contracts, technical specifications, to resumes. A problem arises when you want to show the information, but not all of it for confidentiality or competitive reasons. In other words, you need
Microsoft Excel has some nice features that can save repetitive typing. One that people are familiar with is using a fill series for continuous cells. These are often common values like months or days of the week. This feature is called an Excel Custom List and can be used for a creating repetitive