Sorry, but deal is over

Sign up for notifications so we can send you new offers from "Basic".

You can also see other discounts and deals "Basic"

Do you want to receive new offers by mail from Basic?

Enter your email so you don’t miss anything

Other deals you may like

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

Kiev, Evgeniya Konovalets street, 31

Basic317 user feedbacks
https://cdn1.pokupon.ua/uploaded/new_campaign_pictures/764827/data/main720x340/shutterstock_1646694124.png?1616504379
https://cdn1.pokupon.ua/uploaded/new_campaign_pictures/764825/data/main720x340/46516267_2130066503725884_5331343557359828992_n.jpg?1616504230
https://cdn1.pokupon.ua/uploaded/new_campaign_pictures/764826/data/main720x340/26993210_1719162098149662_9128161880842849188_n.jpg?1616504231
1/3
https://cdn1.pokupon.ua/uploaded/new_campaign_pictures/764827/data/main620x292/shutterstock_1646694124.png?1616504379
https://cdn1.pokupon.ua/uploaded/new_campaign_pictures/764825/data/main620x292/46516267_2130066503725884_5331343557359828992_n.jpg?1616504230
https://cdn1.pokupon.ua/uploaded/new_campaign_pictures/764826/data/main620x292/26993210_1719162098149662_9128161880842849188_n.jpg?1616504231
discount-50%
saving₴1 000
bought9

Description of the campaign

With the certificate you receive training on the course «Excel - Expert level» in the computer training center «Basic» with discount.

Service description

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 data you need according to one or several criteria, perform complex calculations, create smart tables with automatic sizing, automatic copying of formulas, generate Subtotals, collect from several tables (even of different types!) one, create visual reports and build charts using Pivot Tables.
The course is suitable both for 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 held on practical examples taken from life.

During the training, the following topics are considered:

  • Customizing the MS Excel interface "for yourself".
  • Accelerated methods for entering data on a worksheet.
  • Working with formulas (types of references, tracing of formulas, types of errors).
  • Analyze data and create visual reports and charts using pivot tables, customize 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 (protection of cells, sheets, file encryption).
  • Application of macros to automate routine tasks (overview).

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

The course includes methodological material in electronic form (a short summary of lectures and practical exercises).

Workshops:

  • In each lesson, students complete practical exercises based on real life examples. Homework is set.

Requirements for students:

  • For successful assimilation of the course material, students need to have MS Windows skills.

At the end of the course, each student is tested on the website http://www.basic.com.ua/tests.php and receives an author's certificate from the BASIC TC. You can read more about certificates here

Trainer Information:

Since 2005 he has been a leading teacher at the BASIC educational center.
With the help of 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 directions may have (letters of recommendation from corporate clients can be read at the CA).
Has versatile experience of practical work in Microsoft Excel, likes to solve non-standard tasks. Knows how to find an approach to each listener and patiently explain difficult topics. He successfully improvises, imitates tasks and problems that may arise in life.
Has successful experience in conducting on-line MS Excel courses.

What is included in the price of the certificate?

COURSE PROGRAM

Topic 1. Interface overview, data entry and formatting

  • Principles of data storage in Excel.
  • Custom formats.
  • Effective techniques and tricks when working in Microsoft Excel.

Topic 2. Methods for fast filling with data. Notes. Hyperlinks

  • Copying, moving cells of the workbook.
  • Paste special (transpose, value, picture, etc.) Use paste special to calculate without formulas.
  • Find and replace, selection of groups of cells.
  • Autocompletion, using a drop-down list to select values.
  • Autocomplete, progressions.
  • Lists, creating custom lists.
  • Cell notes (insert, edit, display on screen, print).
  • Working with hyperlinks (hyperlinks to files, web page and place in the document).

Topic 3. Conditional formatting

  • Standard conditional formatting functionality. Highlighting duplicate values in a table.
  • Using visualization to display in cells histograms, various icons, and color scales.
  • Conditional Formatting Rules Manager. Editing formatting rules.
  • Using formulas and functions to create conditional formatting rules.
  • Find cells with conditional formatting.

Topic 4. Working with sheets in a workbook

  • Organization of the workbook. Working with sheets: renaming, pasting, moving and copying, deleting.
  • Sheet structure. Simultaneous data entry on multiple sheets.

Topic  5. Data protection in Microsoft Excel

  • Setting a password to open the book.
  • Hiding formulas.
  • Protection of the sheet from changes. Selective range protection.
  • Protection of the structure of the book.

Topic 6. Calculations in Microsoft Excel

  • Creation of elementary formulas.
  • Copying formulas.
  • Types of errors in formulas, correction of formulas.
  • Relative, absolute, mixed links.
  • Using data from other sheets in formulas - links removed. Three-dimensional formulas.
  • Trace formulas. Influencing and dependent cells.

Topic 7. Functions

  • Function wizard.
  • AutoSum (SUM, AVERAGE, COUNT, MIN, MAX).
  • Mathematical and statistical functions. Functions of summation by one and several criteria (SUMIF, SUMIFS). Counting functions based on one and several criteria (COUNTIF, COUNTIFS). Averaging functions (AVERAGEIF, AVERAGEIFS).
  • Text functions (combining data - &, CONCATENATE. MID, DLSTR functions, bringing information into the correct form: TRIM).
  • Date processing functions: calculation of experience, age, period of operation RAZDAT, calculation of the number of working days in the time period NETWORKDAYS.
  • Logical functions (IF, OR, AND, IFERROR).
  • Nested functions.

Topic 8. Working with diagrams

  • Construction, editing of diagrams.
  • Types and types of diagrams.
  • Formatting charts.
  • Typical charts (bar graphs, graphs, pie charts, etc.).
  • Combo charts.
  • Charts with 2 axes.
  • Sparklines.

Topic 9. Output of a document to print. Page layout

  • Convenient presentation of data on the screen. Freezing areas (rows, columns).
  • Preparing a workbook for printing. Page Layout and Page Layout modes.
  • Setting page parameters: setting margins, changing page orientation, printing through rows (columns), printing grid, headers. Page breaks. Print area.
  • Printing a document. Print part of a table. Printing diagrams.

Topic 10. Filtering and sorting data

  • Sorting data. Simple and multilevel data sorting. Sorted by color. Sorting options.
  • Filtering data. Selection by value, by format, by condition. Numeric, text, date filters. Selection of the highest and lowest values. Filtering data by the content of the active cell.

Topic 11. Working with large tables. Ordering and summarizing data

  • Subtotal tool.
  • Grouping and structure. Column and row grouping. Working with control buttons. Multilevel grouping of information.
  • Data Consolidation - Combining data from multiple tables into one.
  • Removing duplicates.
  • Column-by-column text. Text parser wizard.
  • Auto-formatting tables. Smart Excel spreadsheet: creation, editing, formatting.

Topic 12. VLOOKUP (HLOOKUP) function. Array functions

  • Using the VLOOKUP (HLOOKUP) function to search and substitute data.
  • Suppression of # N / A errors in the absence of values.
  • SUMPRODUCT function

Topic 13. Summary tables

  • Creation of pivot tables.
  • Apply styles to quickly format your report. Formatting numeric fields.
  • Rotation of pivot tables.
  • Setting up the fields of the pivot table.
  • Create dynamic charts using pivot tables.
  • Filtering data: filters, slicers.

Topic 14. Macros. Automating Tasks Using Macros

  • Recording macros using a macro recorder.
  • Creation of controls for running macros.
  • Inserting the finished code into the file.
  • Testing.

How to use a certificate?

The certificate cannot be returned or refunded after its expiry date

The price includes payment for information services provided by SuperDeal on the basis of the Public Offer, including the commission of payment systems for transactions on the Internet.

  • Please note that depending on the quarantine measures in the region, the partner may ask a visitor to provide a complete vaccination course COVID certificate, a digital certificate about negative coronavirus test result taken no later than 72 hours before the visit, or about recovery for the last 6 months (ask the partner about possible restrictions before purchasing a certificate). The requirements are valid for persons over 18 years old.

IMPORTANT CONDITIONS

  • Services are provided as usual.
  • Pre-registration is required.

ADDITIONAL CONDITIONS

  • Discounts on certificates are not cumulative with other promotional offers.
  • To receive a discount, you must present a printed certificate or an electronic certificate.
  • Give the last digit of the certificate (activation code) only when you receive the service. After activation, the service is considered to be provided, and the certificate cannot be returned.
Contacts
Basic 3

Computer Training Center

Phones: +38 (098) 200-33-15 +38 (050) 353-54-45 +38 (093) 199-90-03
Links: basic.com.ua Facebook Youtube

Computer training center Basic specializes in training future specialists in IT fields. Teachers of UC Basic have more than 10 years of practical experience in Microsoft Excel. During their professional activities, they participated in many successful corporate training projects, so they really know what questions may arise from employees of various departments and areas. They are able to find an approach to each listener and patiently explain difficult-to-understand topics. They successfully improvise, as well as simulate tasks and problems that may arise in life.

1 address in 1 city

st. Pechers'ka , Kiev, Evgeniya Konovalets street, 31

How to get?

Sorry, the schedule is not available.

In detail

Feedbacks

To write a review or a question you need tolog inorregister

Other deals you may like

₴1 999₴999

Deal is completed

discount-50%
saving₴1 000
bought9

44 Wait for a restart