00 353 1 2790020sales@olas.ie Olas: Professional, Direct, Clever & Helpful

Microsoft Excel Introduction

 

Description

To develop a good working knowledge of Excel including basic functions and formulae, sorting and filtering data, formatting and printing spreadsheets.

Price €260 per person

Dates

  • Book a place on this course and pay with your credit card.16 August 2017 , 1 Day
  • Book a place on this course and pay with your credit card.5 September 2017 , 1 Day
  • Book a place on this course and pay with your credit card.5 October 2017 , 1 Day
  • Book a place on this course and pay with your credit card.10 November 2017 , 1 Day
  • Book a place on this course and pay with your credit card.7 December 2017 , 1 Day

Target Audience

Our Microsoft Excel Introduction training course is aimed at users who are new to Microsoft Excel and wish to gain the necessary knowledge to set up their own spreadsheets and to edit and manipulate existing ones.

Goals and Objectives

To develop a good working knowledge of Excel including basic functions and formulae, sorting and filtering data, formatting and printing spreadsheets.

Course Content
Click here to download course oultline

Basic Knowledge
Understanding Workbooks, Worksheets, Rows, Columns, Cells
The Ribbon
Selection techniques
Understanding the different Mouse shapes
Quick Access Toolbar
Customizing the Quick Access Toolbar
Customising the formula Bar
Live Preview
Contextual tabs
Zoom Feature
Views explained
Shortcut keys
Saving, File types, File Compatibility (with earlier Versions)
Tell me what you want to do – feature
Smart Lookup
Pinning Recent Files

Entering, Selecting and Editing Data
Entering, Editing and deleting information in cells (Text, Date, and numbers)
Entering Auto Lists
Using Fill handle to create simple lists
Creating custom lists
Deleting Rows, Columns and Cells
Inserting Rows, Columns and Cells
Inserting, Deleting, Moving, Copying and Renaming Sheets
Various Navigation Techniques using Scroll bar, Keyboards and Go To command
Using the Paste Preview

Creating Formulae and Functions
Creating Formulae
Editing Existing Formulae
Mathematical Order
Copying Formulae
Understanding Relative Referencing
Understanding Absolute Referencing
Using the Auto sum Feature

Frequently Used Functions
SUM, MIN, MAX, AVERAGE, COUNT, COUNTA
Using the Formulas Tab

Formatting your Spreadsheet
Formatting Cells
Number Formatting
Date Formatting
Text Formatting
Cell Alignment and Orientation
Wrap text
Applying cell styles
Formatting ranges as tables
Border drawing
Clearing Formats
Changing Column Widths
Changing Row Heights
Changing sheet Tab Colours
Using Format Painter

Data Sort and Filter
Sorting Data
Auto Filter
Filtering using Timeline

Charts/Graphs
Creating Simple Charts
Editing Charts
Formatting Charts
Using Recommended Charts

Printing
Print Preview
Page Orientation
Adding Headers and Footers
Printing a Selection
Setting a Print Area
Scaling
Adjusting page breaks using Page Break Preview
Repeating columns and rows
Changing Margins
Centre on Page

Course Summary and Review
Recap of Topics Covered/ Questions
Question Time

Contact Us

Drop us a line, include your contact details and we will get back to you as soon as possible.