MS Excel Advanced Training Course

MS Excel Advanced Training Course

Number of lessons 10

Time spent on a lesson 1։30h

Number of lessons: 10 lesson

Lesson Duration:1 hour 30 min

Course Format։ Face-to-face learning

Number of participants։ 8 people

Course Fee։ 42․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 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, elements
• Insertion of formulas (functions)
• Percentage and share calculation
• Formatting of cells, ranges, and tables

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, Iferror, Or, And
• Compound formulas (combination of functions) 
• The role of 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

Lesson 8.

• Data and Time Functions: Datedif, Now, Today, Edate, Eomonth, Weekday, Year, Month, Day, Date, Network days, Network days.intl, Workday, Workday.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
• Link insertion types with the Hyperlink tool  
• Sparklines
• Google Sheets application
• Тesting
• Summary