Find Courses Find Providers Providers - Promote Your Courses About Us

Microsoft Excel - Introductory

Training Courses

Would you like to see more Microsoft Excel courses?

Training course summary

Sponsored links

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.

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.
Regions:
  • London
  • Midlands
  • South East England
  • South West England
Delivery:
  • In House
  • Public
Category:
Difficulty:
  • Introductory

Further Details

Who should attend: Our ‘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.

Pre-requisites: All attendees must be proficient with basic Mouse, Keyboard and Windows skills. You should be familiar with the topics covered on our introduction course, either directly by attending the course, or having had hands on experience of the areas covered.

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

Guide price

£195 +VAT

 

Sponsored links

Interested in this course?

 

 
Information provided is for information purposes only and no guarantees are made with regards to accuracy. It is advised that all details are checked prior to making a booking. Terms of use
Website design by Brit-net