Tips

Excel tips by Janet Epps, Microsoft Master Instructor

May 8, 2017

Whether you’re a beginner or expert, Microsoft Master Instructor Janet Epps shares three tips to help you excel:

  1. 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.
  2. 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.
  3. 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

This spring and summer she will be teaching Access 2013, Outlook & OneNote 2016, and Word 2013. Register today to make your Microsoft Office skills sharper this summer.

 

About Janet:
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.