DOC Office

Recent Tips & Tricks

What are logical tests in Excel?

In the most simple terms… Logical tests are used to determine whether to perform an action or not perform the action by making comparisons and returning True or False as the result of a simple comparison. However using logical tests in practicality is much cooler… Use them to determine whether to apply a conditional format […]

Excel Shortcut Keys Cheat Sheet

If you’re a keyboard user (like me) and hate having to take your hands off of the keyboard to reach for the mouse… There’s a keyboard shortcut to achieve everything in Excel. Ctrl, Alt and Shift in combination with letter keys, number keys and each other are used to negate the need for your hands […]

Video Tutorial: Excel Forms

Easily find, edit, add and delete records in an Excel data table using the forms tool. Excel’s Form tool simulates a database user interface when working with structured tables holding multiple records in Excel. It’s super simple to use and requires absolutely NO setting up. The Form tool isn’t available in Excel’s default ribbon though, […]

« Older Posts