Imagine Training

Excel Modifying a worksheet

In this course you’ll learn how to use the different types of paste available in Excel, and the advantages. We’ll move on to using functions and how to copy them and secure cells to stop the formula going wrong! Quick ways to AutoSum functions are covered, and we’ll show you how to copy them correctly.

Description

  • Moving and copying data
  • Moving, copying and viewing formulas
  • Inserting and deleting ranges, rows, and columns
  • How to find blanks
  • Copying & pasting formula
  • Autosum

Prerequisites

It's useful to have completed the courses :-

EX2013S1 - Excel Getting Started; Entering & Editing Data; Saving

EX2013S2 - Excel Navigation shortcuts to speed up your work

EX2013S3 - Excel - 5 Basic functions; how to add up worksheets in one click