Introduction to Excel

Introduction to Excel Course Objectives:

At the end of this Introduction to Excel course you will be proficient in entering data quickly into a spreadsheet. You will also be able to format a spreadsheet, plus using basic calculations such as Sum, Average, Count, Max and Min. You will also be able to create a basic chart on the data in the spreadsheet. This course is ideal for beginners or those who have just started using Excel.

Quality Training – Practical Benefits

Benefits

At the end of this course you will have a good working knowledge of Excel basics. You will feel more confident using Excel and be able to create a spreadsheet from scratch. Understanding and using some of the built in calculation and formula functionality will allow you to be more productive in your work and home Excel environments.

We will travel onsite anywhere in Ireland

For more information please contact us at info@inspiresit.ie

Introduction to ExcelSpreadsheets that you create will be easier to use and look more presentable.

Introduction

  • Introduction to Excel Environment
  • Navigation of spreadsheet
  • Enter Data
  • Highlight Data
  • Highlighting Data in non-adjacent cells

Editing a Worksheet

  • Cut, Copy & Paste Data
  • Inserting & Deleting Rows & Columns

Basic Formulaes

  • Sum, subtract
  • Autosum
  • Copy Formulaes across rows & columns
  • Editing Formulaes
  • Viewing all formulaes on spreadsheet

Formatting Spreadsheet

  • Changing Font size, type, colour
  • Adjusting column & row width and height
  • Using number formats eg. currency
  • Merge cells
  • Clearing all formats

Creating and Editing Charts

  • Selecting Data to be used in chart
  • Creating chart using shortcut key
  • How to create chart on the same sheet as data
  • Applying Chart Titles
  • Moving & Enlarging Chart after creation
  • Printing Charts & Data on sheet
  • Deleting Chart

Editing a Workbook

  • Inserting & Deleting worksheets
  • Renaming worksheet
  • Moving worksheets in workbook

Printing a Workbook

  • How to print a worksheet
  • Printing Highlighted data
  • Using Header & Footers
  • Creating a Print Title

For more information please contact us at info@inspiresit.ie

Recommended Course: Intermediate Excel