MS Excel Analytical Course

MS Excel Analytical Course

Number of lessons 6

Time spent on a lesson 1h

Number of lessons: 6 lesson

Lesson Duration: 1 Hour

Course Format։ Face-to-face learning

Course Fee։ 30․000 AMD (Individual)

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

Who is the course intended for?

Excel Analytics 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,
• Intermediate + advanced level training
• Free consultation on your work files.

Course Content

Lesson 1.

•  Conditional formatting
• Conditional formatting using different categories of formulas
• Grouping and disgrouping
• Duplicates removal
• Dynamic Smart Tables

Lesson 2.

• Data analysis Pivot Table
• Insert Diagrams, Types, Data Source
• Flash Fill

Lesson 3.

• Go to tool application
• Data Consolidation
• Power Query – Append Queries
• Power Pivot – Data Model
• Power Map

Lesson 4.

• What if Analysis - Goal Seek tool application
• What if Analysis - Table tool application
• What if Analysis - Solver tool application
• Combining spreadsheets from different Excel files
• Lists Comparison with Vlookup formula

Lesson 5.

• Cell, range, sheets, and workbook protection
• Strengthening and loosening of rows, columns, sections
• View Modes
• Data Validation
• Examples of Data Validation using different categories of the formulas
• Text to columns
• Link insertion types with the Hyperlink tool  
• Word and Excel program combination

Lesson 6.

• Тesting
• Summary