Course «Excel - Expert level» in the computer training center «Basic»

The course is designed for those who plan to use Excel as a professional tool in their daily work. During the training period, you will learn how to generate a report of any complexity, select the necessary data according to one or more criteria, perform complex calculations, create smart tables with automatic size adjustment, automatic copying of formulas, generate subtotals, assemble several tables (even different types) into one, create visual reports and build charts using Pivot Tables.

The course is suitable for both those who are just starting to get acquainted with Excel, and for those who already use Excel and want to expand and systematize their knowledge to a higher level. Classes are conducted using practical examples taken from life.

During the training the following topics are covered:

• Customizing the MS Excel interface to suit your needs.
• Accelerated methods for entering data into a worksheet.
• Working with formulas (types of links, tracing formulas, types of errors).
• Analyze data and create visual reports and charts using pivot tables, setting up calculations and groupings in pivot tables.
• Processing large tables, using simple and complex filters and sorts, inserting subtotals.
• Using key built-in functions.
• Data protection when working together on shared documents (protecting cells, sheets, encrypting files).
• Using macros to automate routine tasks (overview).

The course is intended for economists, financiers, analysts, sales managers, logisticians, accountants and other professionals whose responsibilities include collecting and processing information.

Requirements for students:

• To successfully master the course material, students must have skills in working in MS Windows.

At the end of the course, each student is tested on the website and receives an author's certificate from the BASIC Training Center.

Trainer information:

Since 2005, leading teacher at the Basic Training Center. Using MS Excel, he solves problems related to both data analysis and optimization of work in MS Excel.

During his professional career, he took part in many successful training projects. He has extensive experience working with corporate clients, so he really knows what questions employees of various departments and areas may have (letters of recommendation from corporate clients can be read at the CA).
Has diverse practical experience in Microsoft Excel and likes to solve non-standard problems. Knows how to find an approach to each listener and patiently explain difficult-to-understand topics. Successfully improvises, imitates tasks and problems that may arise in life.
Has successful experience in conducting MS Excel courses on-line.

• Video lessons.