Tools- 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.

Covered in a section on the GOTO and PASTE Special section

  • GOTO Special- find comments, values, formulas and more
  • Find errors, conditional formatting and data validation
  • Copy Visible Cells Only
  • Fill in all the blanks
  • Paste Special- Values, Formulas with/without formatting
  • Paste Special- convert negatives to positives
  • Switch rows to columns and columns to rows
  • Paste without overwriting blank cells
  • Re Use the Format Painter
  • Find Replace- standard uses
  • Find Replace- Change formatting on many cells
  • Remove between brackets or characters
  • Single Column to Multiple Columns
  • Import CSV’s into the correct columns

 

Back to: Advanced Excel Course > Tools for text