Testing Demo PS All

Testing Demo PS All Course in London, the UK, and Europe

Adobe Acrobat is a family of application software and Web services developed by Adobe Systems to view, create, manipulate, print and manage files in Portable Document Format (PDF).

The family comprises Acrobat Reader (formerly Adobe Reader), Acrobat (formerly Acrobat Exchange) and Acrobat.com.

Please select the level that you are interested in

Microsoft Excel 2010 Introduction

Course Overview

  • Create and maintain spreadsheets
  • Create and edit formulae
  • Format and print worksheets
  • Perform basic list management task

Audience:

This course is designed for new users of Microsoft Excel, or self-taught users. The course covers all aspects of creating and maintaining spreadsheets; including basic formulae and functions.

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 Introduction 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 Introduction course can be run at our training venue near Liverpool Street (London) or any preferred location in the UK or Europe.

Excel 2010 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 usingScroll 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
See 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.