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

Microsoft Excel Introduction

Description

The Microsoft Excel Introduction training course is designed to enable the participant develop a good working knowledge of Excel to include features such as basic functions and formulae, sorting and filtering data, formatting and printing spreadsheets.

Price: €325 per person

Dates

  • Book a place on this course and pay with your credit card.03 September 2019 , 1 Day
  • Book a place on this course and pay with your credit card.09 October 2019 , 1 Day
  • Book a place on this course and pay with your credit card.05 November 2019 , 1 Day
  • Book a place on this course and pay with your credit card.17 December 2019 , 1 Day


Target Audience

The Microsoft Excel Introduction training course is aimed at users who are new to Excel and want to set up their own spreadsheets and manipulate existing ones.

PREREQUISITES

Participants need have no prior knowledge of Excel but should be comfortable using Microsoft Windows and should be able to start a Microsoft Office application, use the Help feature, and open, close and save files.

Goals and Objectives

Having completed this course, participants will have a good working knowledge of Excel including the following features:

  • 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
Question Time

Contact Us

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