Unit 5 Seminar

Unit 5 Seminar

Your Name (First M. Last)

School or Institution Name (University at Place or Town, State)

Unit 5 Seminar

Excel is the spreadsheet that is developed by Microsoft for computer and mobile phones. Sorting data systematically is the most difficult task. Using excel o arrange data, makes it easy to access. Find the logic and story behind data is the most difficult task and excel has solved this problem ADDIN ZOTERO_ITEM CSL_CITATION {"citationID":"pu9MLJ3S","properties":{"formattedCitation":"(\\uc0\\u8220{}Video,\\uc0\\u8221{} n.d.)","plainCitation":"(“Video,” n.d.)","noteIndex":0},"citationItems":[{"id":1260,"uris":["http://zotero.org/users/local/KZl8ZL3A/items/QHBKLI9X"],"uri":["http://zotero.org/users/local/KZl8ZL3A/items/QHBKLI9X"],"itemData":{"id":1260,"type":"webpage","title":"Video: What is Excel?","abstract":"With Excel on your PC, Mac, or mobile device, you can:","URL":"https://support.office.com/en-us/article/video-what-is-excel-842fb550-07cb-42d1-9a9f-c55789efed57","shortTitle":"Video","language":"en-US","accessed":{"date-parts":[["2019",2,5]]}}}],"schema":"https://github.com/citation-style-language/schema/raw/master/csl-citation.json"} (“Video,” n.d.).

Excel spread sheets are divided into rows and columns. One can create multiple workbooks in the Excel for different forms of tasks and data. We can put and sort the information of similar kind regarding same project in different sheets of the same workbook. Each box in the spread sheet is called cell and it the point of intersection of row and column. The current cell in use is referred to as active cell. Spreadsheet programs are also available online so that we can use them anywhere from our browser. All the work done in in a workbook should be saved through save button. Best feature of the excel is that we can get share all the work done in spread sheet with multiple users through uploading it on cloud, and those users can also edit it all at one. Final sheet can be printed on the paper using print option. ADDIN ZOTERO_ITEM CSL_CITATION {"citationID":"EIHGs5UZ","properties":{"formattedCitation":"(\\uc0\\u8220{}Create a workbook in Excel,\\uc0\\u8221{} n.d.)","plainCitation":"(“Create a workbook in Excel,” n.d.)","noteIndex":0},"citationItems":[{"id":1258,"uris":["http://zotero.org/users/local/KZl8ZL3A/items/3FXTI3CU"],"uri":["http://zotero.org/users/local/KZl8ZL3A/items/3FXTI3CU"],"itemData":{"id":1258,"type":"webpage","title":"Create a workbook in Excel","abstract":"Training: Get up and running quickly with our Excel Quick Start. Get started learning how to enter data and create a chart.","URL":"https://support.office.com/en-us/article/create-a-workbook-in-excel-94b00f50-5896-479c-b0c5-ff74603b35a3","language":"en-US","accessed":{"date-parts":[["2019",2,5]]}}}],"schema":"https://github.com/citation-style-language/schema/raw/master/csl-citation.json"} (“Create a workbook in Excel,” n.d.)

Excel also has Name box for locating the location of the cell and formula bar, in which user can develop formula to apply on all rows and columns, which saves a lot of time and energy. While working on bigger projects it gets difficult to select one row and columns one by one, Select All option in the Excel enables user to sleet all the data at once with ease. We can also choose the selected range of the cells and apply the formula on those cells. Formulas consist of Numbers, letters and mathematical symbols. We can also write date and time automatically in any selected particular column. Naming each row and column is also easy ADDIN ZOTERO_ITEM CSL_CITATION {"citationID":"i4az4ZoC","properties":{"formattedCitation":"(\\uc0\\u8220{}Basic tasks in Excel,\\uc0\\u8221{} n.d.)","plainCitation":"(“Basic tasks in Excel,” n.d.)","noteIndex":0},"citationItems":[{"id":1256,"uris":["http://zotero.org/users/local/KZl8ZL3A/items/MQGIJ5FL"],"uri":["http://zotero.org/users/local/KZl8ZL3A/items/MQGIJ5FL"],"itemData":{"id":1256,"type":"webpage","title":"Basic tasks in Excel","abstract":"Get started with basic tasks in Excel such as opening a workbook, entering and formatting data, calculating data, and trying some quick analysis features..","URL":"https://support.office.com/en-us/article/basic-tasks-in-excel-dc775dd1-fa52-430f-9c3c-d998d1735fca","language":"en-US","accessed":{"date-parts":[["2019",2,5]]}}}],"schema":"https://github.com/citation-style-language/schema/raw/master/csl-citation.json"} (“Basic tasks in Excel,” n.d.).

In middle of work if we forget to add any particular row or column, instead of removing all the working and editing it one by one we can simply insert new row and column according to requirement. We can also edit or delete any cell of range of row or column. Auto fill feature is the feature that enables user to contents of the cell in the other adjacent cell by dragging them. Excel helps users to understand the data trends through color codes, data bars and icon. We can find these features in File handle option that appears as blue box on the right side of cell, when two or more cells are selected.

References

ADDIN ZOTERO_BIBL {"uncited":[],"omitted":[],"custom":[]} CSL_BIBLIOGRAPHY Basic tasks in Excel. (n.d.). Retrieved February 5, 2019, from https://support.office.com/en-us/article/basic-tasks-in-excel-dc775dd1-fa52-430f-9c3c-d998d1735fca

Create a workbook in Excel. (n.d.). Retrieved February 5, 2019, from https://support.office.com/en-us/article/create-a-workbook-in-excel-94b00f50-5896-479c-b0c5-ff74603b35a3

Video: What is Excel? (n.d.). Retrieved February 5, 2019, from https://support.office.com/en-us/article/video-what-is-excel-842fb550-07cb-42d1-9a9f-c55789efed57