Contact Us:
+44 1244 940047

To apply for this course please use the button on the right or email us at info@win-training.co.uk or give us a call on 01244 940047

Course Requirements
This course is designed for delegates who have used Microsoft Windows, but are new to Excel 2013

Overview
In this course, delegates will use Excel 2013 to create spreadsheets and workbooks that can be used to store, manipulate and share data. The course covers the key topics required by users of this software, including the brand new features of this version, with lots of in-depth explanations, step by step instructions, key questions and group and individual activities.

Who Should Attend
This course is intended for delegates who wish to gain the preliminary understanding of Excel 2013 that is necessary to create and work with computer-based spreadsheets.

 

Course Content

Help

Ø  Selecting Help

Introduction to the Excel Screen

Ø  The screen

Ø  The ribbon

Ø  Cell address and formula bar

Ø  Mode indicator

Ø  Sheet tabs

Ø  The active cell

Ø  Row and column headings

Ø  The spreadsheet

The Workbook

Ø  Inserting a new sheet

Ø  Deleting a sheet

Moving in the Worksheet

Ø  Positioning with the mouse

Ø  Scroll bars

Finding your way around a spreadsheet

Ø  Worksheet navigation

Ø  Freezing panes

Ø  Splitting the screen

Ø  Scrolling two spreadsheets side-by-side

Entering Text and Labels

Ø  Text entry

Ø  Automatic alignment

Text Enhancement

Ø  Alignment

Ø  Formatting Text

Entering and Formatting Values

Ø  Entering values

Ø  Formatting values

Entering Dates

Ø  Formatting Dates

File Handling

Ø  Save/Save As

Entering Formulae

Ø  BODMAS

Ø  What is a formula

Ø  Creating a formula

Ø  Circular references

Ø  Editing calculations

Working with Ranges

Ø  Selecting ranges with a mouse

Ø  Selecting ranges with a keyboard

Using Built-In Simple Functions

Ø  Max, Min, Average, Count, IF

Formatting the Sheet

Ø  Column width

Ø  Row height

Ø  Borders and shading

Ø  Autoformat

Ø  Format painter

Copying and Moving

Ø  Copy text

Ø  Cut (move) text

Ø  Paste text

Ø  Auto fill

Page Setup

Ø  Scaling

Ø  Orientation

Ø  Margins

Ø  Gridlines

Printing

Ø  Select a printer

Ø  Print preview

Ø  Printing the spreadsheet

Appendix A: New Features in Excel 2013

Ø  The Ribbon

Ø  The Quick Access Toolbar

Ø  The Mini toolbar

Ø  New argument and function features

Ø  Function and Named Ranges shortcuts

Course Curriculum

No curriculum found !

Course Reviews

N.A

ratings
  • 5 stars0
  • 4 stars0
  • 3 stars0
  • 2 stars0
  • 1 stars0

No Reviews found for this course.

0 STUDENTS ENROLLED

    About Win Training

    Win Training specialise in a variety of training courses being offered both online and on-premise. Call us today to find out more about how we can help you achieve your training goals +44 1244 940047.

    Who’s Online

    There are no users currently online
    top
    © Win Training.All rights reserved