Category:
Excel
This course is designed to improving skills in using MS Excel. It provides students with both an overview of the features and functions of the program and practical know-how. Practical exercises accompany every topic covered during the course.
Microsoft Certificate: for an additional fee of 20 GBP per person, we provide registration with Microsoft Authorized Training system. Training participant registered in this system receives a certificate recognized and respected anywhere in the world, and additional electronic training materials provided by Microsoft.
Genuine Microsoft certification not only confirms the holder's skills - it can also be a valuable part of a resume. Important: authorization is available for on-demand training courses only.
Duration
2 days
Agenda
- Introduction to Excel – Quick review of the basics
- Entering and editing data, selecting data, searching cells and ranges.
- Copying, pasting, filling cells and ranges.
- Inserting and modifying simple graphical objects.
- Manual formatting. Data types and formatting by data type.
- Inserting, editing and changing appearance of comments.
- Naming cells and ranges.
- Calculations.
- Math functions.
- Relative references and absolute references.
- Financial functions.
- Other useful functions (data/time functions, text functions).
- Logical functions.
- Conditional function If.
- Conditional formatting.
- Forms.
- Tracing precedents and dependants.
- Sorting and filtering data.
- Subtotals – summarizing data by categories.
- Simple Data Validation (combo boxes).
- Working with Charts.
- Understanding Chart Types.
- Selecting Data Sources.
- Formatting charts.
- Printing.
- Preparing Worksheets for printing.
- Worksheets management.
- Creating and organizing Workbooks.
- Linking to data in other Worksheets and Workbooks.
- PivotTables and PivotCharts.
- Sorting and filtering PivotChart.
- Goal seek.
- File management.
- Understanding File Formats.
- Importing and Exporting Data.
For open training, the course materials are prepared for MS Office 2010. Other versions (2013, 2007, 2003) are available on request. Contact us for details.
Download as PDF
Audience and prerequisites
This course is intended for professionals and office workers who want to learn intermediate-level Excel skills.
Before attending this course, students must have:
- Basic computer knowledge, such as keyboard and mouse skills.
- Basic file-management skills. The student should know how to navigate to folders and files on a computer running Windows Vista / Windows 7.
- Basic Excel knowledge, such as opening workbooks and entering simple data.
Certificates
Course participants receive completion certificates signed by ALX.
Our locations
- Online (EN) – your home, office or wherever you want
- London – Asra House, 1 Long Lane, London SE1 4PG
- Warsaw (EN) – Jasna 14/16A
- any other location (London, UK, EU) on request
Group size
Open training groups are no larger than 14 participants.
Private training can be conducted for groups of any size, according to the Customer's preference. To assure high quality and good learning environment, the group size should not exceed 12.
On-demand training costs and registration
The prices provided in the general tables cover the cost of an open (public) training for one person in London.
In case of on-demand training at Customer's premises, you provide the necessary facilities (room, computers, projector), we send a trainer to conduct the training, and the cost of a session is calculated for the whole group.
The cost does not vary significantly with the number of participants. There is no minimum number of participants. We recommend no more than 10-12 participants, as above this number, the training becomes much less effective.
The cost of an on-demand training consists of:
- the base training cost, plus
- trainer travel and accommodation charges.
The base price of on-demand training varies on case-by-case basis, but it is usually about the price of an open training for 3-5 persons (regardless of your group size).
The typical travel and accommodation charge for the EU/Schengen zone is under 1250 GBP (1500 EUR) for a 5 day session. We do our best to keep it as low as possible in your location.
The payment can be in GBP or EUR whichever you prefer. When we send you a quotation with the exact amount in your currency, that amount will be valid for 3 months, regardless of any changes in the exchange rate.
For more information, or to register a group, please contact us at groups@alx-training.co.uk and tell us:
- the course(s) that you are interested in,
- your location,
- your preferred dates,
- the number of people you wish to train,
And any other questions that you may have.
Customized training
We can also customize the training program of any of our trainings (or create a new one) according to your needs – whether you want to focus on particular solution used in your company, include material concerning a technology we do not usually cover, or create a tailor-made training.
Read more about customized training here or contact us at groups@alx-training.co.uk.
Individual consultation
For individual persons for whom all scheduled open training is inconvenient, we offer individual consultation. Virtually all of our training courses are available as such.
During individual consultations, while it can be a direct equivalent of a group training in terms of subject covered, we can also provide more than that – we can solve problems, help choose appropriate solutions and provide advice on the most effective use of chosen tools.
More information about individual consultations can be found on the separate Consulting page. In case of any question, we encourage you to contact us.
Price
140 EUR
The price includes:
- course materials,
- snacks, coffee, tea and soft drinks,
- course completion certificate,
- one-time consultation with the instructor after course completion.
Discounts and allowances
- 7% - a discount for return customers
- applicable for all courses and training
- for any individual who already has participated in any of our courses or training and any employee of a company which previously delegated at least one employee to one of our courses or training
- 5% - for European Youth Card (EURO<26) card holders
- applicable for all courses and training
- 3% - for all students
- applicable for all courses and training
- 3% - allowance for early enrolment (does not apply to short courses)
- applicable for enrolments which occurred at least 30 days before the start of the course
- discounts apply only in case of upfront payment made at least 7 days before the start of the course and only in case of standard application form being sent or standard training contract being signed
- discounts, reductions and promotions cannot be combined
- discounts, reductions and promotions do not apply to:
- closed trainings and training on demand
- group offers
- participants delegated by third parties
