Tavoitteet ja hyödyt
Are you annoyed with Excel troubles? Come and get the best tips and tricks easy using of Excel.
Excel users who are familiar with the basics and need more practice in taming Excel.
The course starts at 9.00 and ends at 16.00.
The course can be tailored according to customer’s wishes and can be held in customer’s premises or at Amiedu also with versions 2007 and 2010. Ask for an offer.
Tricks for creating a table faster
- Series and custom lists
- Short cut keys
- Data validation
- Find and replace
Solving common problems
- Showing insignificant digits
- Clear all formats at the same time
- Problems with number formats (i.e. dates)
- Comment and error indicators
- Custom number formats
- Hiding zero values in formulas
Paste special and paste options
- Using AutoSum in many ways
- Copying formulas
- Show formulas
- Formula auditing
- Add operators to Quick Access Toolbar
- Customize Status Bar
Grouping spreadsheets and 3D calculating
- Custom charts
Managing large spreadsheets
- Moving around
- Freeze panes (keep title rows and columns visible) and Print titles
- Synchronous scrolling
- Split windows
- Hide and unhide rows, columns and tables
- What to consider when sorting
- Split one column to multiple columns
- Importing data from other sources
The course price is 241,80 € / person (incl. VAT 24 %). The price includes course materials, certification and lunch with morning and afternoon coffees.
The course can be canceled free of charge 2 weeks prior to the agreed start date. Cancellation a week prior to the agreed start date will be charged 50 % of the course fee. Cancellations made after this will be charged of 100 % of the course fee.
Fill in the registration form on our website. Training will require a minimum of 6 persons enrolled. We send the invitation and other detailed instructions by email.
Registration is binding.
instructor, team leader
Tel. 020 7461 657