Microsoft Excel
Short course
In London
Description
-
Type
Short course
-
Location
London
-
Duration
1 Day
Facilities
Location
Start date
Start date
Reviews
Course programme
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: Morning
- Entering data
- Editing Data
- Formatting
- AutoSum
- Formulas
- Absolute Reference
- Charts
- Practice
Microsoft Excel Courses: Afternoon (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
- Data Validation
- To Set The Print Area
- Page Break Preview
- Header & Footer
- Borders
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 !
Private training:
A student who has some knowledge already of Excel may 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.
2003 or 2007?
Both Excel 2003 and 2007 although 2003 predominates. If only 2007 is required, please let us know.
Additional information
Cost: £95 per half day Private training: Cost: £60 per hour
Microsoft Excel