Thursday, November 11, 2021

Four Excel Tips in Four Minutes

 Contributed by Jack Sherwood 

1. Split up data within a cell 

  • Highlight cells you would like to split 
  • Go to the “data” tab and select “text to columns” 
  • Select “delimited” (this allows you to designate a split based on a character, symbol, or space) 
  • Identify your delimiter 
  • Click “Next” 6. “Finish” 

2. Bring data together into one cell 

  • In a new cell, select the first item to insert (ex. A2) 
  • In the cell formula, type &” “& followed by the next cell to insert (ex. A2&” “&B2) 
    • Don’t forget the “ “, as this creates a space between the data! 

3. Conditional formatting 

  • Select cells to apply highlight to 
  • Under the home menu, select conditional formatting 
  • Select logic from the dropdown 
  • Provide subsequent information about rule 
  • “OK” 

4. Transpose data 

  • Highlight row/column of interest, right-click, and copy
  •  Select row/column where you wish to transpose
  •  Right-click, “paste special”
  •  At bottom of the module, select transpose 
  •  “OK” 
_____________________________________________________

Want to see a demonstration of these tips?  Check out the recording of the November 3 Fiscal Administrators' Meeting, available here: https://fro.vpfinance.virginia.edu/fiscal-administrator-meetings 

No comments: