Software Engineering

Open Access Open Access  Restricted Access Subscription Access
Open Access Open Access Open Access  Restricted Access Restricted Access Subscription Access

A Study on Advanced Excel in Industry 4.0


Affiliations
1 Department of BCA, PSGR Krishnammal College for Women, Coimbatore - 641 004., India
2 Department of BCA, PSGR Krishnammal College for Women, Coimbatore - 641 004., India
3 Department of BCA, PSGR Krishnammal College for Women, Coimbatore - 641 004, India
     

   Subscribe/Renew Journal


Nowadays, many jobs require Advanced Excel skills. The Advanced Excel users know how to structure, gather and Present the data. So that it looks Impressive. When we understand Excel at more advanced Level, we will have the ability to use its more sophisticated tools, which allows us to complete our tasks and to analyses the data more quickly. Processing Microsoft Excel skills has become one of the most strengthen one in our life. It was solely used for business purposes. But with the advancement of time, it has become so widespread that we use MS Excel almost every aspect of life, whether Educational, official, business or even for personal purposes. In Excel we can do the following things like Data filter, Data sorting, Pivot table, SUMIF,COUNTIF, Excel shortcut keys, Charts, Cell formatting, Managing page layout, Data validation, look up, Pivot charts, fill, Quick analysis, Power view, Conditional formatting, Moving columns into rows, IF Formulas, Auditing formulas.
User
Subscription Login to verify subscription
Notifications
Font Size

  • Preparing Data for Analysis Using Microsoft Excel Alan C. Elliott, Linda S. Hynan,Joan S. Reisch, Janet P. Smith

  • Microsoft Excel™ as a Tool for Teaching Basic Statistics C. Bruce Warner2, Anita M. Meehan

  • Data analysis with Microsoft Excel: Updated for Office 2000. Berk, K. N., Carey, P. (2000).


Abstract Views: 148

PDF Views: 0




  • A Study on Advanced Excel in Industry 4.0

Abstract Views: 148  |  PDF Views: 0

Authors

S. Vinitha
Department of BCA, PSGR Krishnammal College for Women, Coimbatore - 641 004., India
V. Pavatharani
Department of BCA, PSGR Krishnammal College for Women, Coimbatore - 641 004., India
T. S. Anushya Devi
Department of BCA, PSGR Krishnammal College for Women, Coimbatore - 641 004, India

Abstract


Nowadays, many jobs require Advanced Excel skills. The Advanced Excel users know how to structure, gather and Present the data. So that it looks Impressive. When we understand Excel at more advanced Level, we will have the ability to use its more sophisticated tools, which allows us to complete our tasks and to analyses the data more quickly. Processing Microsoft Excel skills has become one of the most strengthen one in our life. It was solely used for business purposes. But with the advancement of time, it has become so widespread that we use MS Excel almost every aspect of life, whether Educational, official, business or even for personal purposes. In Excel we can do the following things like Data filter, Data sorting, Pivot table, SUMIF,COUNTIF, Excel shortcut keys, Charts, Cell formatting, Managing page layout, Data validation, look up, Pivot charts, fill, Quick analysis, Power view, Conditional formatting, Moving columns into rows, IF Formulas, Auditing formulas.

References