Tuesday, 17 October 2017

Hints - Microsoft Excel - Tips on Data Entry Part 2

Quickly Change Formulas to Values

To quickly change formulas into values, you can use this mouse shortcut, shown in the video below. The written instructions are below the video.
To change formulas to their values, follow these steps:


Create a Custom List





Use the Custom List For Data Entry

You can use the custom lists when sorting, and you can also use them with the AutoFill feature. 
To quickly create a list, based on a custom list:


Microsoft Accredited IT Training Provider
Microsoft Certified Training Materials
IT Training Courses delivered by Microsoft Accredited Facilitators
Microsoft MOS Test Centre London






































No comments:

Post a Comment