Course Highlights

MS Excel the popular spreadsheet from Microsoft. This 1 day course is designed to increase knowledge of the features and functions within Excel and realize the advantages of using a powerful electronic spreadsheet. The course is entirely hands on, so those attending will get practice in creating and modifying actual spreadsheets, enhancing them with charts.

Overview

On completion of this course, delegates will be able to:

• Work with Spreadsheets
• Insert and Select cell data
• Copy/ Move and Delete data
• Manage Rows and Columns
• Create Formulas and Functions
• Create Formatting
• Create Charts
• Prepare Outputs including Page Setup & Check and Print

It is a practical hands- on course. Delegates are "learning by doing" with access to MS Excel Software for the course duration.

Course Includes

Learn by doing – in additional to the formal presentations from Trigraph, attendees will benefit by using the MS Excel software itself on their own dedicated PC / Laptop. They will build their own Worksheets.

All of our trainers are highly skilled project management professionals with formal Microsoft Excel certification.

The training materials are fully owned by Trigraph which means we have full flexibility to tailor the content to suit particular client requirements.

Working with Spreadsheets

• Opening/Closing Excel
• Opening Existing Workbook
• Switching Between Open Spreadsheet Files
• Creating a New Spreadsheet
• Saving an Existing Workbook
• Saving an Existing Workbook as another File Type

Enhancing Productivity

• Setting Basic Options/Preferences
• Using the Zoom Tool
• Displaying/Hiding Ribbon
• Using Available Help Functions

Inserting and Selecting Cells

• Cells Contents
• Making a Cell Active
• Entering Text/Number/Date in a Cell
• Selecting Cells, Columns, Rows, Worksheet
• Using the Fill Handle

Editing Data

• Replacing Cell Content
• Modifying Cell Content
• Undo/Redo

Copy/ Moving and Deleting

• Copying/Moving within a Worksheet

Managing Worksheets

Rows and Columns

• Delete, Insert, Copy, Move, Hide Rows/Columns
• Modify Column Width

Worksheets

• Delete, Insert, Copy, Move Worksheets
• Copying/Moving between Worksheet

Formulas and Functions

• Arithmetic Formulas
• Using Cell References
• Relative Cell Referencing
• Absolute Cell Referencing
• Functions Sum, Count, If

Formatting

• Numbers and Dates
• Cell Contents
• Alignment and Border Effects
• Text Wrap

Charts

• Create a Chart
• Edit a Chart
• Page Setup
• Check and Print
• Selecting/Changing a Chart Type
• Moving a Chart
• Resizing/Deleting a Chart
• Chart Title
• Data Labels
• Background
• Legend

Prepare Outputs

• Page Setup
• Page Orientation
• Margins
• Page Set-up
• Headers and Footers
• Check and Print
• Checking and Correcting Calculations and Text
• Turn On/Off Gridlines, Row/Column Headings
• Apply Title Pringing on every page
• Previewing a Worksheet
• Printing a Worksheet

Requirements

It is assumed that you can bring your own laptop to the course with MS Excel installed.

Users with a basic understanding of MS Excel who want to consolidate and expand on their knowledge of the basic features in a short space of time.

A working knowledge of using PCs, Windows, gained from the workplace or by prior attendance on a course.