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
   88   89   90   91   92   93   94   95   96   97   98