During this course some basic tools of Excel were discussed and demonstrated. These included using the ribbon (the main control bar of the program), how to use the workbook and worksheet tabs, how to use key commands, formatting for numbers, changing text color and alignment, the proper use of font color (hard coded numbers in blue, formula numbers in black), changing cell size, making percentages, using autofill for numbers and dates, editing cells, writing formulas, absolute versus relative references (the former never changing and the later does), using VLOOKUP function, using data filters, how to sort list, and how to copy and paste information into different cells.
(Photos taken from: Chen, Al. “Excel for the Real World: Basic Skills of Microsoft Excel.” Skillshare. Skillshare, n.d. Web. 11 Apr. 2017. <https://www.skillshare.com/classes/Excel-for-the-Real-World-Gain-the-Basic-Skills-of-Microsoft-Excel/599396565>.)
Citation: