Microsoft Excel - 3 Day Course
Course
In Sketty
Description
-
Type
Course
-
Location
Sketty (Wales)
-
Start date
Different dates available
Course Overview:
To be a confident user of Excel with the ability to work with formulas, functions and formatting to present numerical information accurately, clearly and effectively.
This course is designed to familiarise the delegate with the basic concepts of Excel and its business uses developing a proficient use of Excel. 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 and output information.
Building on the skills learnt during day 1 delegates cover a wide range of commands and the production of high quality graphics and documents. The course includes an in-depth look at enhancing spreadsheets using multiple worksheets, charting, database capabilities, split screens, other ‘functions’ and advanced charting.
Delegates will practice their new skills, ask questions and complete revision exercises. Learners will sit “mock tests” including online diagnostics. This will enable them to address any gaps in their knowledge prior to taking the actual online ITQ Excel exam. The results will be shared with the delegate immediately after the test.
Facilities
Location
Start date
Start date
About this course
Progression Opportunities:
This course tests material from the standard ITQ level 1 & 2 syllabus.
Entry Requirements:
To gain the maximum benefit from this course, an attendee should have a basic knowledge of Windows and be able to use the mouse.
Reviews
Subjects
- MS Excel
- Microsoft excel training
- Database training
- Database
- Spreadsheet
- Microsoft Excel
- Excel
Course programme
Course Delivery:
Short session to complete relevant paperwork, ICT housekeeping and receive full induction to SFI programme
Using the mouse; screen familiarisation and accessing on-line Help, Spreadsheet Basics, Data Entry, Formatting Entries, Printing, Charting.
Multiple Worksheets, Advanced Charting, Functions, Naming Cells, Excel as a Database, Pivot Tables, Protecting Data, The Excel Environment
Revision, Q & A Session, Diagnostics, Online test
Additional information
Microsoft Excel - 3 Day Course
