Tools
You are here: Home » Microsoft » Excel » Microsoft Excel 2016 » Microsoft Excel v2016 Introductory
Friday, 20 Apr 2018

Microsoft Excel v2016 Introductory

Course Objectives

This one day course will cover spreadsheet basics of Microsoft Excel. The topics introduced include an introduction to the spreadsheet, the graphics capabilities, and the database handling commands.

The broad objectives are to make clients aware of the full possibilities of the program and to give clients confidence to operate the program themselves.

Who Should Attend?

This course is designed for computer users with little or no previous experience of Excel, but who require a basic understanding of the product.

Some knowledge of computer basics and working with Windows is expected. The topics covered on our "Introduction to Microsoft Windows" course are an adequate prerequisite for this course.

Course Contents

Tour of the Excel screen

The Microsoft Office User Interface

  • The Ribbon
  • User Interface Tabs
  • The Quick Access Toolbar

Navigating in a Worksheet

Entering Data

  • Entering Formulae
  • Order of Mathematical Operators in Formulae
  • Editing a Cell
  • Entering a formula using the Pointing Technique

Excel's Functions

  • Sum, average, max & min
  • AutoCalculate

Autofill

  • Creating sequences
  • Custom Lists
  • Copying Formula

Flash Fill

File Commands

  • Create, save, open close and delete a file

Printing

  • Understanding the print options

Explanation of how Excel oganises data for charting

  • Creating a Chart
  • Choosing Chart Types
  • Inserting Titles
  • Choosing the location of the chart

Modifying the chart type etc. once the chart has been created

Formatting the Chart

  • Changing the appearance of chart elements
  • Creating a chart with two data series

Chart "extras"

  • Adding text boxes & arrows
  • Altering the scale of axes

Databases

  • Sorting
  • Searching using the Autofilter command
  • Using the Sub-totals command

Microsoft Excel 2013 Course DetailsDownload Course Details

Event Properties

Event date: 10-04-2018 09:30 AM
Event end date: 10-04-2018 05:00 PM
Individual Price £150.00
Location AJP IT Services
Please phone us on 0117 929 1509 to book this course