Microsoft Office

Excel Error Messages to Get to Know

If you create a formula in Excel that contains an error or circular reference, Excel lets...

Excel Cell References Worth Remembering

In Excel formulas, you can refer to other cells either relatively or absolutely. When you...

Excel Order of Operations to Keep in Mind

Mathematics dictates a protocol of how formulas are interpreted, and Excel follows that pr...

Excel Text Functions You’ll Find Helpful

Excel’s text functions are very helpful when you’re working with names, addres...

Excel Functions You’re Likely to Use

Some Excel functions apply to specific subject areas, but others are general and apply to...

Excel Formulas and Functions For Dummies Cheat She

It’s easy to use Excel for many of your day-to-day number-crunching tasks, like determin...

Excel Data Analysis For Dummies Cheat Sheet

Data analysis, by definition, requires some data to analyze. However, after you’ve impor...

Excel’s Database Functions

To help you analyze data that’s stored in a table or range, you can turn to Excel’s po...

How to Build Excel Comparison Expressions

A comparison expression — also known as a logical expression or a Boolean expression —...

Excel’s Descriptive Statistics Functions

When it’s time to get down to analyzing your data, a good place to start is with some ba...