Roem Ltd - software training and support - Microsoft Excel - Introduction (Affordable, guaranteed to run and fun!)


Roem Ltd - software training and support - Microsoft Excel - Introduction (Affordable, guaranteed to run and fun!)

Microsoft Excel is a widely used, powerful spreadsheet package. The primary objective of this one-day Introduction course is to introduce you to the basic operations of Excel. This extremely practical course will provide hands-on experience of many of the features found in this product.

Dates 13 Mar 2019 - This event is in the past.
Opening times 09:30 - 16:30
Venue Sun House, 23 Queen Edith's Way, Cambridge CB1 7PH
Organiser name Karen Roem
Telephone
01223214177
Email
Website

Event details:

Microsoft® Excel® Introduction - course outline

Microsoft Excel is a widely used, powerful spreadsheet package. The primary objective of this one-day Introduction course is to introduce you to the basic operations of Excel. This extremely practical course will provide hands-on experience of many of the features found in this product. By the end of the course you will be competent with the following skills:

Getting started

  • what is Excel?, starting Excel, the Excel application window
  • using the Excel menu system, using the Microsoft Office Button
  • using the Quick Access Toolbar
  • displaying help information
  • exiting from Excel

Modifying an existing worksheet

  • resetting the working folder
  • moving the cell pointer, changing data in a worksheet
  • reversing an edit operation, saving a workbook
  • adding data to a worksheet
  • entering a formula into a worksheet
  • adjusting column width in a worksheet
  • adjusting row height in a worksheet
  • printing a worksheet

Building a new worksheet

  • opening a new workbook
  • using the spelling checker

Editing a worksheet

  • working in edit mode
  • selecting ranges in a worksheet
  • using autofill
  • copying cells, moving cells, clearing cells
  • using autosum
  • inserting and deleting rows and columns
  • inserting and deleting a range of cells

Formatting a worksheet

  • resetting the alignment of cell entries
  • resetting font options for cell entries
  • resetting the number format of cell entries
  • adding borders and shading to a worksheet
  • using autoformat

Enhancing a worksheet printout

  • changing the page setup for a worksheet
  • previewing a worksheet
  • inserting a manual page break into a worksheet
  • printing titles
  • printing selected worksheet entries

Using Excel functions

  • what is a function? using the SUM function
  • using the AVERAGE function, using the MAX and MIN functions
  • using the COUNT function, using the insert function button

This course outline is a guide. All our courses can be tailored to customer requirements.

Target audience 
This course is aimed at new or recent users of Excel.

Assumed knowledge 
Delegates should be familiar with the Windows operating system, either from attending a Windows Introduction or Getting Started Course or knowledge gained from their own experience. No knowledge of Excel is expected.

Price: £197 + VAT (10% discount for Cambridge Network members)

Once payment is received, the course is guaranteed to run!

Roem Limited

Independent, innovative software training company based in Cambridge. Registered supplier to local companies such as AstraZeneca, University of Cambridge, South Cambridgeshire District Council and NHS England.

Roem Limited directory information