Microsoft Access

Microsoft Access Training

Excel is one of the most widely used software packages currently in use. The package can be used for a variety of tasks. On a basic level, you can use Excel for creating tables, storing data and setting up simple calculations like addition, multiplication, division or subtraction.

For more demanding uses, Excel can be used to create charts, automate spreadsheets, apply advanced formulas, create Pivot tables and much much more!

Please select the version that you’re interested in

Please select the version that you’re interested in

Microsoft Access 2016 Introduction

Course Overview

Audience:

This course is aimed at experienced Excel users who need to perform more complex functions, lists analysis, use What-If tools and who would like to start recording basic macros.

Prerequisite:

No Prior experience or knowledge of Spreadsheets is required to attend this course. You must have good basic windows, keyboard and mouse skills.

Duration:

This is a 1 day Excel Advanced Course. The course starts at 09:30 and runs until 16:30. Alternate timings can be arranged upon request. The course can be held on a date that suits you.

Location:

Our Microsoft Excel Advanced course can be run at our training venue near Liverpool Street (London) or any preferred location in the UK or Europe.

Excel 2016 Introduction Course Outline

SPREADSHEET PRINCIPLES

What is a spreadsheet?

SCREEN LAYOUT AND EXCEL BASICS

Ribbon

Understanding Workbooks, Worksheets, Rows, Columns, Cells

Various selection techniques

Understanding different Mouse shapes

Tabs

Groups

Dialog Box Launchers

Quick Access Toolbar (QAT)

Customizing QAT

Formula Bar Customization

Live Preview

Contextual tabs

File Tab (Backstage View)

Zoom Feature

Page Layout View

Full-Screen View

Access Keys (Shortcut keys)

Saving, File types, File Compatibility (with earlier Versions)

Getting Help

Various selection techniques

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

Concept

Creating Formulae

Editing Existing Formulae

BODMAS: Mathematical Order

Copying Formulae

Understanding Relative Referencing

Understanding Absolute Referencing

Using the Auto Sum Feature

Common Basic Functions: SUM, MIN, MAX, AVERAGE, COUNT, COUNTA

Using the Formulas Tab

FORMATTING CELLS, ROWS, COLUMNS AND SHEETS

Formatting Cells

Number Formatting

Date Formatting

Text Formatting

Cell Alignment And Orientation

Wrap text

Applying borders and shading

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

CHARTS/GRAPHS

Creating Simple Charts

Editing Charts

Formatting 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

Show more
One to One

(which includes a tailor-made training programme for the individual where they can mix and match the topics from various levels to get the most cost-effective training

Group for up to 8 learners
The Course outlines on our website are standard, however, we would be happy to tailor them to your specific requirements. Please call us on 020 3696 2796 or send us a message to discuss further.

What Our Clients Say

Extras

This is a sample of some of the Short training videos. Please note that you can get access to many more, once you have done a course with us and are registered as one of our delegates.