- Click the View tab, then choose View Settings.
- On the ribbon, click Other Settings.
- Click the Column Font and Row font buttons & enter a font size.
Best part of new Adobe Illustrator release: ability to make anchor points, handles and mouse pointers bigger. Go to Preferences > Selection & Anchor Display. Great for those of us over 22 years old.
Excel has two error detection functions that are almost identical: ISERR and ISERROR. Their syntaxes are identical:
ISERR(value) and ISERROR(value). They will both return True if the value throws an error. The difference is the ISERROR function will detect #N/A errors and ISERR won’t.
Big changes coming with the new WordPress editor, code-named Gutenberg. Rollout is planned for April with WordPress 5.0.
Happy new year! This is a good time to show Excel’s YEAR function. It extracts the current year from a date. It works whether you entered the date manually, if the date is the result of the =TODAY() or =NOW() functions, or if the date is a serial number, and it works regardless of formatting.
The syntax is:
For example, if the value of A2 is 12/31/2017, the result of =YEAR(A2) is 2017.
To get up to speed quickly on other functions, check out my course, “Excel 2016 Formulas & Functions in 90 Minutes” at www.udemy.com/excel90min