Autoflash instead of entering data manually on a worksheet , you can use the Auto Fill feature to fill cells with data that follows a pattern or that is based on data in other cells .
Flashfill is feature gives you the ability to take a part of the data entered into one column of a worksheet table and enter just that data in a new table column using only a few keystrokes .
There are some examples of autofill and flashfill learned by me in Microsoft Excel ;
Text formatting capabilities can make the results of your financial , statistical or scientific spreadsheet calculations more esthetically pleasing and easier to follow . You can use one of several Excel themes with predefined font families , color schemes and text fill effects and apply them to the whole spreadsheet . You can also make discrete changes in the text style of individual cells by using the "Font group" options in Excel's "Home" tab ribbon .
There are some examples of text formatting learned by me in Microsoft Excel ;
Simple Vlookup lets you search for specific information in your spreadsheet . For example , if you have a list of products with prices , you could search for the price of a specific item .
There are some examples of Simple Vlookup learned by me in Microsoft Excel ;
Then last but not least , I make a budget's table and produce a graphs with the data obtained from the table .
No comments:
Post a Comment