Excel Introduction

Software: Microsoft Excel

Training Course: Introduction to Microsoft Excel

Location: London  

To Book Call:  0700 233 6600 or click here .

Summary: This course provides an introduction to Microsoft Excel , part of the Microsoft Office suite of programs. The course will identify and describe the component features that make up Microsoft Excel and introduce you to working with them.

Pre-requisites: All attendees to a Microsoft Excel Course must be proficient with basic Mouse, Keyboard and Windows skills. If you are new to Microsoft products, and Excel in particular, we suggest you spend a little time looking over the basic toolbar and menu options.

Duration: 1-Day
Start & Finish Times: 10am to 5pm

Objectives: The course will enable participants to Identify and describe the component features that collectively make up the working Excel environment. Participants will be taught how to plan and construct basic Excel spreadsheets for forecasting and general numeric work. Delegates will be able to create formulae and work with a selection of functions. Users will progress on to produce simple charts from the spreadsheet data they have created.

Who should attend: Our ‘Excel Introduction’ course is designed for busy people who need to know how to get the best from their applications from the outset. If you are new to Excel or have not used Excel in its proper capacity for creating spreadsheets, then this Introduction course will get you started.

Overview of Content

The Excel Workplace: Getting Started. Microsoft Excel . The Excel Screen. Excel ’s Menus. Shortcut Keys. Toolbars. Dialog Boxes. Scrolling Window Contents. The Office Assistant. Microsoft Excel Help.

Working with Files: Excel Files. Workbook Sheets. Workbook Windows. Saving Files. Opening Existing Workbook Files.

Worksheet Basics: How Worksheets Work. Navigation of Worksheets and Work Books. Exiting Excel . Creating a New Workbook. Activating & Selecting Cells. Entering Values & Formulas. Values. Formula Basics.

Editing Worksheets: Editing Worksheets. Editing Cell Contents. Inserting & Deleting Cells. Copying Cells. Copy & Paste. Drag & Drop. The Fill Handle. The Fill Command. Series & AutoFill. Copying Formulas. Relative vs. Absolute Cell References. Moving Cells. Undoing, Redoing, & Repeating Actions.

Using Functions in Formulas: Functions. Anatomy of a Function. Arguments. Entering Functions. Statistical Functions. Logical Functions

Basic Charting in Excel : Create an Automatic Chart using the Wizard. Change Chart properties including Colours, Data Labels and Chart Types. Adding CHARTS to spreadsheets as stand-alone or Embedded Objects Worksheets.

Printing: Printing. The Page Set-up Dialog Box. Print Preview. Page Break View. The Print Dialog Box.

Public Course Cost. £220.00
Reward Price. £110.00

Company Room Rates & Work Shops – Please call for quote Associated courses: Excel Intermediate; Excel Advanced; Excel Programming