Excel has over 475 formulas in its Functions Library, from simple mathematics to very complex statistical, logical, and engineering tasks such as IF statements (one of our perennial favorite stories); ...

Use Excel's conditional formatting to flag status changes, budget issues, missing data, duplicates, and deadlines ...

Q. I am trying to create a formula in our accounting system, but I keep getting errors. What can I do to get the formula to work? A. All Excel users know how powerful formulas are, but sometimes it ...

Most spreadsheet problems come from static cell ranges—Excel tables replace them with dynamic, self-managing data structures.

Excel is the best piece of software ever made. We've talked a lot about basic formulas and advanced tricks that will make you way better at the program, but we've been remiss and forgot about our ...