preview

Excel Essay

Decent Essays

Microsoft Excel contains many useful features that I have learned about in my Unit 3 readings. The first would be customizing the quick access toolbar. Utilizing the backstage view by clicking the file tab, you can access a workbook’s options via the options tab. Here you can select Quick Access Toolbar and customize the options you would like to show. You can view the most popular commands, or a range of other options filtered by tab, or specific function. You can then add or remove the commands you wish to appear. I have added different commands like the camera tool, the SUM formula, and set print area. These are some of my go-to functions that I want to quickly access and this process saves me multiple “clicks” with each Excel session. …show more content…

Conversely, a relative reference (this is the standard format) will remain relative to where it is placed; if you copy the formula down a particular row or column, the formula will auto-update based on its placement in the data. You can also combine the two functions, also known as a mixed cell reference. If you place the $ sign before only 1 reference point – column OR row, it becomes a mixed reference. Based on where you place the $ sign, that particular row or column will remain fixed, while the rest of the data will update if it is moved or copied. It is also possible to reference data from another worksheet in the workbook, or from an entirely different workbook. You can link workbooks and their data in this way. I have used external references at work to link a cost analysis review to another workbook that was shared with other users in a local network so they could be apprised of a certain set of data.

The next set of valuable learnings in this unit came from advancing my use of functions. I have plenty of practice with the basic functions in Microsoft Excel; functions like SUM and AVERAGE are common place in spreadsheet work. However, I have not fully taken advantage of other functions like MIN, MAX, TODAY, and other useful options. Essentially, functions are a template of their own; they are pre-built functions that can save a lot of time and

Get Access