MS Excel+ Advanced Training Course

MS Excel+ Advanced Training Course

In this advanced course you will gain in-depth knowledge of Excel software, learn tools and formulas to help speed up your work by calculation automation.

MS Excel+ Advanced Training Course

Number of lessons 15

Time spent on a lesson 1:30h

Number of lessons: 15 lessons

Lesson Duration: 1:30 Hour

Course Format։ Face-to-face learning

Course Fee։ 65․000 AMD (group)

Venue։ IBT Educational Center, Citadel Business Center, 105/1 Teryan, Yerevan

Who is the course intended for?

Excel advanced course is designed for accountants, economists, analysts, marketers, as well as those who want to deepen their knowledge of Excel. At the end of the course, the participating student will gain in-depth knowledge of the Excel program, will study such tools and formulas that will allow him/her to automate his/her calculations.

Course benefits

The course includes practical tasks, theoretical materials, video lessons,
Basic + intermediate + advanced level training,
Free consultation on your work files,
Small groups, maximum 8 person,
Individual approach to each participant,
Each student is provided with a computer,
Course participation: online and offline formats,
Day and evening groups,
Catch up the missed classes with the next group,
There is no age restriction and no prior knowledge is required for the participation in the course.

Course Content

Lesson 1.

MS Excel interface, elements, its regulation
Workbook structure and elements
Insertion of formulas (functions)
Percentage and share calculation
Formatting of cells, ranges, and tables
Relative and absolute links, links to the other newspapers and other files

Lesson 2.

Data types and formats in Excel (Cells format)
Conditional formatting
Data Filtering and Sorting
Data Find & Replace
Table Transpose
Copy-Paste Special Types

Lesson 3.

Data analysis Pivot Table
Data Consolidation
Conditional formatting in the digital range we define

Lesson 4.

Mathematical functions: Sum, Sumif, Sumifs, Sumproduct, Subtotal, Round, Roundup, Rounddown, Product
Statistical functions: Count, Counta, Countblank, Countif, Countifs, Max, Min, Average, AverageA, Averageif, Averaifs, Large, Small

Lesson 5.

Logical functions: If, Ife rror, Or, And
Complex formulas (combination of functions)
Role of the symbols in the formulas

Lesson 6.

Search and hyperlink functions: Choose, Vlookup, Hlookup, Index, Match
Spreadsheets printing, additional settings (Print)
Strengthening and loosening of rows, columns, sections
View Modes

Lesson 7.

Cell, range, sheets, and workbook protection
Data Validation
Duplicates removal
Dynamic Smart Tables
Insert Diagrams, Types, Data Source (Chart)

Lesson 8.

Data and Time Functions: Datedif, Now, Today, Edate, Eomonth, Weekday, Year, Month, Day, Date, Networkdays, Networkdays.intl, Workday, Workdat.intl, Yearfrac, Days360, Hour, Minute, Second, Time
Types of false formulas
Lists Comparison

Lesson 9.

Text Functions: Concatenate, Proper, Upper, Lower, Left, Right, Mid, Rept, Trim, Clean, Len, Substitute, Search, Find, Exact, T
Text to columns
Grouping and disgrouping
Go to tool application

Lesson 10.

Word and Excel program combination
Sparklines
Тesting
Summary

Lesson 11.

Intermediate and final results (Subtotals)
Data analysis Pivot Table (exploring new tools)
Formula Auditing
Automated texts
Copy-Paste Special – Operation
Data Find&Replace (exploring new tools)
Mathematical functions: ABS, Mod, Randbetween, Rand, Even, Odd, Power, Product, Roman, SQRT, Roman, Arabic, Int, Aggregate, Mmult, Quotient, Sumsq
Information Functions: Info, Iserror, Iseven, Isodd, Isblank, Istext, Isformula, Islogical, Isnumber, Sheet, Sheets, N

Lesson 12.

Creation of named ranges (Name Manager)
Link insertion types with the Hyperlink tool
What if Analysis - Goal Seek tool application
What if Analysis - Table tool application
Search and hyperlink functions: Column, Columns, Row, Rows, Formulatext, Transpose, Hyperlink, Indirect

Lesson 13.