Excel Introduction
Training
In London
Description
-
Type
Training
-
Level
Beginner
-
Location
London
-
Duration
1 Day
To give users an introduction to Excel and enable them to realise the advantages of using a powerful electronic spreadsheet. Delegates will learn how to create and modify spreadsheets, whilst also learning key essentials such as basic calculations and formatting work sheets. Suitable for: This is suitable for anyone who wants a basic knowledge of how to use Excel and get the most out of it. It is primarily for people who have not used Excel a great deal before but wish to know how to not only use it, but create functions through formatting, organising data and using multiple spread sheets.
Facilities
Location
Start date
Start date
About this course
No requirements as this is entry level Excel.
Reviews
Course programme
Excel / Introduction
Objective: To give users an introduction to Excel and enable them to realise the advantages of using a powerful electronic spreadsheet. Delegates will learn how to create and modify spreadsheets.
Delegates: Maximum 8
This course is suitable for new or intending users of Excel who want to gain a good understanding of the software in a short space of time. A basic understanding of Windows is required, gained either by previous experience or by attendance on an “Introduction to Windows” course. Delegate numbers are restricted to 8, to ensure personal attention from the trainer
Structure: PC for every delegate
All pass training courses involve extensive hands-on activity including exercises that give participants practical experience of using Excel’s tools.
Duration: 1 day 9.30 am – 4.30 pm
Further Training: Excel Intermediate
Course Outline:
Excel Introduction
- What is a Spreadsheet?
Getting Started with Excel
- Starting Excel; Excel Opening Screen
- The Title Bar; The Menu Bar; Toolbars
- Scroll Bars; Active Cell, Column and Row Headers
- Sheet Tabs; The Status Bar; Menus and Submenus
- SpeedKeys; Dialogue Boxes; Exiting Excel
Getting Assistance with Excel
- Using the Office Assistant
- Getting Help Without the Office Assistant
- Manipulating the Help Window
- Finding Out What is On the Screen
Starting a Workbook
- Creating a New Workbook
- Moving Around the Sheet
- Scrolling; The Mouse Pointer
- Selecting Cells with the Mouse
- Selecting Cells with the Keyboard
- Spreadsheet Data Types
- Entering and Editing Data
- Editing Long Entries
- Undoing Incorrect Edits
- AutoFill; Custom Lists
- Saving, Closing, Opening and Deleting a Workbook
Working with Worksheets and Cells
- Using Go To
- Moving Data with Drag-and-Drop
- Cut, Copy and Paste
- Moving Entries (Cut and Paste)
- Copying Cell Contents (Copy and Paste)
- Using the Office Clipboard
- Using Find and Replace
Entering Basic Calculations
- AutoSum; Entering a Calculation
- Statistical Functions
- Using Relative and Absolute Cell Addresses
- Circular References
Formatting the Worksheet
- The Formatting Toolbar
- Enhancements
- Alignment
- Formatting Numbers
- Resizing Columns and Rows
- Clearing a Worksheet
Structuring the Worksheet
- Inserting and Deleting Rows and Columns
- Inserting and Deleting Worksheets
Printing Worksheets
- Print Preview
- Changing the Page Setup; Printing
Additional information
Payment options: All Courses can be held privately at our premises or otherwise.
Excel Introduction