Page 93 - ModularV1.1 _c6_flipbook
P. 93
Explore More
Excel 2016
Excel 2016 is a part of MS Office 2016 software suite. It comes with a colourful
interface and many new features.
FEATURES OF EXCEL 2016
Excel provides several features that makes it the first choice for professionals to quickly
perform lengthy accounting and financial tasks, and take immediate decisions. Some of
them are as follows:
Flash Fill is a new feature of Excel 2016 that recognises patterns you start to make
with your data functions and automatically fills in the rest of the columns based on the
pattern established in the first cell.
You don’t have to work with complex formulas. For example, you already have a list
of unique patient IDs without the dashes but you want to create one with the dashes.
To do this, you insert a new column next to the original column of unique patient IDs
without any dashes. Type the first patient ID including the dash in the new column.
When you move to the next cell, and begin to type, Excel will fill in the rest of the column
based on the pattern established in the first cell. You just need to press the Enter key
to accept the suggestions made by Excel.
A new command called Recommended Charts has been added under the Insert tab
of Excel 2016. When you select data in your worksheet and click this button, the most
suitable charts for your data will be recommended.
Functions are the built-in formulas used for calculating percentage, interest, average,
etc., in Excel. Formulas are mainly used for performing simple as well as complex
calculations.
Excel allows to use formatting features to improve the look and feel of the data.
Data is automatically recalculated in the worksheet if any change is made in a single
cell.
Excel allows fast searching and instant replacing of data.
Data can be viewed in a graphical form as charts. The charts help to understand,
analyse and compare data in an effective manner.
Explore More 91

