Excel level 1 - Introduction
Microsoft Office 365 - Microsoft ExcelBook Course Now
Become familiar with Excel spreadsheet basics. Learn best practice from expert tutors.
This course is designed to familiarise the inexperienced user with the basic concepts of
Excel and its business uses. The essentials of building and editing a spreadsheet, identifying different types of data, correcting mistakes and copying formulae within the spreadsheet are covered, as is the ability to print information. You will learn how to make a colourful and informative series of charts from your data.
This is a one-day course running from 9:30 am - 4:00 pm.
Training is hands-on and tutor-led.
We provide a comprehensive training manual, lunch and certification.
Courses run at both Swansea and Cardiff locations.
This course can be run as a company specific option either at your site or our own.
Screen familiarisation and accessing on-line help.
Identification of columns, rows and cells. Quick ways
to move around the screen. Saving your work.
Entering text, numbers, simple formulae and current
date/time. Deleting/editing entries. Copying
information and using AutoFill. Using relative and
absolute cell addresses.
Order of operations when performing calculations.
Use of fonts, bold, underline, patterns, colour and
borders. Use of the AutoFormat feature. Setting
numbers to fixed decimal places. Adjusting column
widths. Inserting rows and columns. Use of the
AutoComplete and AutoCalculate features.
Previewing and printing the spreadsheet.
Selecting data to make charts. Overview of different types of charts. Editing charts.
To gain the maximum benefit from this course an attendee should have a basic knowledge of Windows and be able to use the mouse.
This course covers material from the standard European Computer Driving Licence (Module 4, contributes towards an ITQ level 2 / ECDL: Extra qualification and the Microsoft Office Specialist Core Excel syllabus.
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.
Developing formulas for calculations you want to make in Excel can be tedious and complicated. Excel has an entire library of functions or predefined formulas that you can use. There are hundreds of functions in Excel that allow you to format text, reference cells, calculate financial rates, look up information and more.
- 140.00 +VAT Per Person
- 1 Day Course