Excel Training in Sussex
Microsoft Excel
Almost all businesses depend on spreadsheets to keep their administration running smoothly. Excel is the most widely used spreadsheet program in the world today.
We offer courses for beginners and advanced users.
Excel for Beginners
We offer a one–day course specially designed for people with basic computer skills who have no knowledge of Excel.
Although this course is aimed at people who are already familiar with computers, we can also teach basic computer skills if necessary. Please let us know your requirements when you book the course.
The following topics are covered:
- Getting Started
- toolbars and menus
- opening and closing a workbook
- saving a workbook
- Data
- entering and editing data
- cells, rows and columns
- find and replace
- copy, cut and paste
- filling: autofill handle
- filling: series filling
- Rows and Columns
- inserting
- deleting
- changing row height
- changing column width
- Formatting Cells
- numbers
- alignment
- font
- borders, colours and patterns
- Worksheets
- inserting and renaming
- move and copy
- inserting a comment
- Formulas and Functions
- mathematical functions
- excel functions
- Print and Layout
- page setup
- header and footer
- print area
- repeating header rows
- page breaks
- print preview
- printing your document
Excel for Advanced Users
This one–day course is aimed at people who have a basic knowledge of Excel or those who have completed the Beginners’ course and who wish to get to grips with some of the program’s more specialised features.
The following topics are covered in detail:
- Data
- sorting
- subtotals
- autofilter
- conditional formatting
- consolidating worksheets
- validation
- validation lists
- Charts
- creating a new chart
- adding data to an existing chart
- formatting an existing chart
- adding a secondary axis
- selecting inconsistent rows of data
- Using the If Function
- the if function
- the countif function
- the sumif function
- Using the Lookup Functions
- VLookup
- HLookup
- Macros
- recording a macro
Tailor–Made Courses
We are also able to provide tailor–made courses. If there is a particular area you are keen to study, please contact us.
Training Schedule
Daily courses at our premises start at 10am and finish at 4pm, with an hour for lunch, and a break in mid–morning and mid–afternoon.
Refreshments are included in the price of the courses, but students should provide their own lunch. There are several pubs, restaurants and cafés close to our offices.
Handouts and examples of exercises given during the training will be available to take away on a CDR with you for future use.
You can get a printer–friendly version of this or any page simply by clicking ‘File’ then ‘Print’ on your browser!
