Tips and Tricks- covered in Intermediate course

Below a listing of what you would have learnt in the Intermediate course which feeds into this Advanced course.

Please check that you are comfortable with these items.

  • Viewing many parts of the spreadsheet (at the same time)
  • Don’t hide rows- group them rather
  • See sheet names in portrait style
  • Selecting ranges with mouse and arrow keys- short cuts
  • Enter date and time stamps- unchanging
  • Doing Quick Calculations in a spreadsheet
  • The Quick Access Toolbar

 

Back to: Advanced Excel Course > Tips and Tricks- Advanced