K2E Canada Office Tips August 2019
|
Summary: There may be times when you want to see as much of your worksheet as possible. You can quickly maximize your worksheet to replace virtually everything else on your screen by displaying the View tab of the ribbon and follow these steps:
Display the View tab of the ribbon.
When you are done viewing the workbook in this manner, again use the Ribbon Display Options icon to display the ribbon and, on the View tab of the ribbon, select the check boxes you unchecked in step 2. |
Word Tip
When to Hyphenate Your Document
Summary: Word includes a hyphenation tool that you can use to make better use of the horizontal text space on your page. You should not need to hyphenate your document often, if you remember these guidelines of when hyphenation is necessary:
|
Vertical Divider
We hope that you are enjoying our monthly newsletter featuring tips that will help you to be more effective using Microsoft Office products.
More Ways to
Earn Verified CPD
Access the many courses from the leader in providing CPD to professionals throughout North America.
Video Tip
Trapping Errors with IFERROR
Summary: The IFERROR function has the potential to simplify creating complex formulas because it traps all errors with a single function. In the past, users had to employ unintuitive formulas to trap simple errors or use multiple error- trapping functions, each of which trapped very specific errors.
Here’s the video tip from the webinar K2’s Road to Excellence with Excel – Part 11 - Excel Formulas and Adagio BI & Dashboard Reporting |
|