Category: Excel
The course provides students with knowledge and skills to use MS Excel efficiently in everyday work. 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.
- Using the interface.
- Entering data. Editing cells.
- Searching and selecting cells and ranges.
- Inserting and modifying simple objects (images, borders).
- Working with cells and formatting.
- Copying, pasting, filling cells and ranges.
- Simple formatting.
- Data types and formatting by data type.
- Inserting, editing and changing appearance of comments.
- Calculations.
- Inserting and editing formulas. Automatic and manual cells select.
- Math functions
- Relative and absolute references.
- Logical functions.
- Conditional formatting (color scales).
- Naming cells and ranges
- Sorting and filtering data
- Autofilter
- Subtotals – summarizing data by categories
- Simple Data Validation (drop-down lists)
- Tracing precedents and dependents
- 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
- File formats, importing and exporting data to different file formats.
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 professionals and office workers who want to learn basic 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.
Certificates
Course participants receive completion certificates signed by ALX.