Microsoft Excel Courses
Excel is Microsoft's spreadsheet software and is basically used to store and add up numbers. In many ways Excel is like a super-powered calculator.
You could use Excel to calculate your monthly spending, do simple accounts for your small business or work out what your mortgage repayments are going to when the interest rate rises. If you've got children they may be able to use Excel to help them do calculations for their Maths or Science homework.
Kensington College offers easy-to-understand courses in Microsoft Excel. The topics covered include:
Microsoft Excel Courses:
- Entering and editing data
- Moving about. Selecting
- Formatting
- AutoSum
- Other formulas. Absolute Reference
- Charts
- Practical application. (Students are encouraged to bring along any sheet they may need to work upon.)
- Some advanced topics - time permitting.
Microsoft Excel Courses: (Advanced)
- Sorting
- Filtering
- Goal Seek
- Sub Totals
- Linking
- Inserting & Moving Worksheets
- If
- Macros
- Intro to VBA
- Templates
- Scenarios
- Auditing
- Pivot Tables
- Solver
- Conditional Formatting
- Vlookup & Hlookup
- Index, Match, Offset etc.
- Data Validation
- Page Break Preview
- Header & Footer
- Date Functions
Cost:
£185 per day.
£95 per half day.
Extra Topics
Tailor-made. Topics selected from:
Topics
- Linking to Access
- Random Number Generation
- More Advanced Charts
- Outlining
- Data Functions
- Data Tables
- Financial Functions
- More Advanced Pivot Tables
- Histograms
- Add Ins
- etc !
Next Courses (Intermediate morning - Advanced afternoon)
Day: Wednesday:
26th February 2020
Individual
Basic training for beginner but someone who has some knowledge already
of Excel mayalso benefit more from 2-3 hours of individual lessons. In that
time advanced topics eg scenarios, macros, pivot tables, etc can easily
be covered.
Given time it would also be possible to consider any job-specific spreadsheet
requirements that a student has.
Cost: £65 per hour.