Introduction to Excel – Excel level 1
Understand spreadsheet basics and learn best practice from expert tutors on this Introduction to Excel course.
Introduction to Excel – Course Objectives
This hands-on, tutor-led Introduction to Excel course is designed to familiarise the inexperienced user with the basic concepts of Excel and its business uses. Delegates will learn the essentials of building and editing a spreadsheet, identifying different types of data, correcting mistakes and copying and editing formulae. Delegates will learn how to print information in a clear and accessible manner. Attendees will find out how to make a colourful and informative series of charts from their data.
Introduction to Excel – Course Contents
Getting Started
Using the mouse; screen familiarisation and accessing on-line Help.
Spreadsheet Basics
Identification of columns, rows and cells. Quick ways to move around the screen.
Data Entry
Entering text, numbers, simple formulae and current date and time. Deleting and editing entries. Copying information and using AutoFill.
Cell Referencing
Using relative and absolute cell addresses.
Formatting Entries
Use of fonts, bold, underline, patterns, colour and borders. Use of the AutoFormat feature. Setting numbers to fixed decimal places. Adjusting column widths and row heights. Inserting rows and columns. Use of the AutoComplete and AutoCalculate features.
Printing
Previewing and printing the spreadsheet.
Charting
Selecting and charting data and editing standard charts.
Introduction to Excel – Course Details
This is a one-day introductory course running from 9:30 am – 4:00 pm. Courses run in Swansea.
Prerequisites
To gain the maximum benefit from this course an attendee should have a basic knowledge of Windows and be able to use the mouse.
Qualification
This course covers material from the standard International Computer Driving Licence (Module 4) and the Microsoft Office Specialist Core Excel syllabus.
What Next? Excel Level 2
Learn useful formulas to help you with your work. Explore the potential of Excel as a database. Customise the Excel environment to fit your requirements.