Microsoft Excel

8 week course covering the main aspects of Microsoft Excel  One 2 hour class per week.

Candidates will be able to use Microsoft Excel to create and work with spreadsheets. You will also learn to manage workbooks & worksheets, apply formatting styles to numbers, dates etc as well as understand key Formulas & Functions. You will also display your data visually using charts.

After completing this course, you will feel confident entering, moving, editing, and deleting data, as well as performing common spreadsheet tasks such as functions & formulas, charts & tables.

 You will be able to:

  • Create and understand the key concepts of spreadsheets.
  • Recognise good practice in inserting, editing, and deleting data.
  • Apply a range of mathematical and logical formulas and functions.
  • Know how to communicate information using charts and graphs.
  • Sort and filter data using tables. 

What is Excel used for?

Excel is typically used to organize data and perform financial analysis.  This application is widely used across all aspects of business & personal functions, in companies from small to large and to your personal home accounts.  The Excel software program includes many functions, formulas and shortcuts that can be used to enhance its functionality. 

The main uses of Excel include:

  • Data entry
  • Data management
  • Accounting
  • Financial analysis
  • Charting and graphing
  • Time management
  • Product or stock control analysis
  • Task management
  • Invoicing
  • Cash control
  • Almost anything that needs to be organized!