202R0/01 MS Excel Essentials

MS Excel is a tool for managing data, really numerical data,such as sales figures or weather data! Sometimes it is used for keeping records like an address book or catalogue. Without doubt its real strength is in managing and manipulating numbers so you dont have to. You can

  • input all types of data, text, numbers, currency, date/time etc
  • arrange your data in the grid provided, for organisation. This grid can be altered as required
  • use different worksheets (pages) to build a workbook (spreadsheet), keeping information in one place
  • apply formatting (bold, colour etc) to your values
  • carry out calculations on your numerical values (including dates etc)

The Essentials

VIDEOCONTENTMORE

  • 15 min
  • 00:00 Learn the Basics of Microsoft Excel
    00:27 Anatomy of a spreadsheet in Microsoft Excel
    01:20 What is a Cell in Microsoft Excel
    03:50 What is a Range in Microsoft Excel
    04:41 Excel Cursor and Mouse Pointer Shapes
    05:48 How to Change Size of Rows and Columns in Excel
    07:26 How to Use the Ribbon in Microsoft Excel
    09:25 How to Enter Data in Microsoft Excel
    11:47 How to Format Data in Microsoft Excel