May 24

MICROSOFT OFFICE TUTOR: Keep your Excel operations in order

When you’re building formulas, don’t let Excel’s order of operations trip you up with inaccurate results. Table A is a list of the calculation precedence for many common operators.
Continue reading

For more specialized tips on leadership subscribe to our
monthly newsletter now!
Mar 22

MICROSOFT OFFICE TUTOR: 2 ways to designate Excel named ranges in a flash

Named ranges are a valuable asset to your Excel workbook because they make it easier to build formulas and navigate through your data. If you think the set-up time for applying named ranges is too much of a burden, you’re wrong.

Here are two ways to quickly assign a named range in your workbook:
Continue reading

For more specialized tips on leadership subscribe to our
monthly newsletter now!
Mar 01

MICROSOFT OFFICE TUTOR: Never type an Excel absolute reference again

Absolute references keep an Excel cell reference from changing when you copy and paste it into another cell. Although you can manually create an absolute reference by typing a dollar sign before any Excel reference, we’ll show you a faster option.

To toggle between absolute reference options:
Continue reading

For more specialized tips on leadership subscribe to our
monthly newsletter now!
Feb 08

MICROSOFT OFFICE TUTOR: Use an Excel shortcut key to instantly find cells connected to a formula

When an Excel formula relies on many other cells to calculate its result, it can be challenging to troubleshoot errors. Instead of using the Formula Auditing toolbar, which itself can be confusing, you can quickly pinpoint precedent and dependent cells using shortcut keys.
Continue reading

For more specialized tips on leadership subscribe to our
monthly newsletter now!