Category: Excel
This course is designed to improve skills in using MS Excel to an advanced level. It provides students with an overview of the advanced features and functions of the program and knowledge of their practical applications. 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
- Advanced formulas.
- Date/time functions.
- Lookup and reference functions: MATCH, INDEX, VLOOKUP.
- Text functions.
- Financial functions.
- Conditional functions IF, SUMIF.
- Naming ranges. Working with named ranges.
- Defining names. Scope and visibility.
- Linking to named ranges from other worksheets.
- Name manager. Managing growing ranges.
- Advanced conditional formatting.
- Changing appearance of data based on a formula.
- Forms.
- Advanced filters.
- Multi-level Subtotals.
- Data validations.
- Sharing workbook.
- Managing changes.
- Tracking changes. Accepting /rejecting changes.
- Protecting data.
- Preventing unwanted changes to the data, structure and formatting of cells, worksheets and workbooks.
- Typical scenarios.
- PivotTables and PivotCharts.
- Sorting and filtering PivotChart.
- Connecting to a database, querying a database.
- Macros.
- Creating, editing, running macros.
- Typical scenarios.
- Solver tool.
- Watch window.
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.
Audience and prerequisites
This course is intended for experienced Excel users who want to learn advanced-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 knowledge of the Excel interface, workbook manipulation and formula creation.
Certificates
Course participants receive completion certificates signed by ALX.
