Reading: Excel Keyboard Shortcuts

• link
  
  
  

• As a CPA, I use Microsoft Excel on a daily basis and I have done so for the duration of my career. The functionalities, the pivot, the pivot tables, the charts, etc. But also, being able to use formulas. My personal favorite is Index Match for using a pretty simple way to take just thousands of lines of information and sift through all of that to find specifically what you're looking for.

• s very difficult to handle the extremely large data set in spreadsheets. Besides spreadsheets have less flexibility for complicated analysis and presentation.

• 질문 4 What happens when you use the median calculation but select an even number of values in a range?

  	- Returns middle figure between the two middle values in the selected range

• 질문 5 What are Excel cell references by default?

  	- Relative references : By default in Excel, cell references are always relative, and you must manually configure a cell reference to be absolute or mixed