Whether you’re a beginner or expert, Microsoft Master Instructor Janet Epps shares three tips to help you excel:
- Today’s date
Want a date that updates to the current date automatically every time you open the workbook? Type this formula =TODAY() and then press the Enter key. Format in the way you want under the Number group on the Home tab as usual.
- Mysterious cell behaviour
The cause could be many things but frequently it is simply unwanted formatting left behind (feels like a haunting sometimes). On the Home tab go to the Editing group and select Clear Format from the Clear drop down arrow. Format is removed but your content is retained.
- Increase worksheet readability
By printing with gridlines, heading and rows, it makes it easier to match up the cells when editing from a printout. Go the Page Layout tab and Sheet Options group, select Print.
Learn more about Excel with Janet: Excel 2016
Janet is a professional trainer in the computer field. She holds internationally recognized Microsoft Master Instructor and Expert level certifications and provides training for corporations, colleges, and government. She also has extensive experience in business and has written several computer training manuals. Learners at all levels enjoy her down-to-earth teaching style. Janet is the winner of the 2016 Red River College Continuing Education Excellence in Teaching award.