Career Advice
Get practical guidance on career growth, job search, interviews, CV improvement, and the next steps in your professional path.
Finance and Accounting
·Offline
Advanced MS Excel Program for Companies
Why should teams join the “Advanced MS Excel Program for Companies”? The Advanced MS Excel program helps teams develop strong data processing, analysis, and automation skills, m...
What you'll gain
- ✓ Work efficiently in Excel and manage files effectively
- ✓ Create clear and well-structured reports
- ✓ Perform complex calculations using formulas and functions
- ✓ Manage and process large datasets
✓ Free consultation · Certificate on completion · Practical learning · Certificate-ready · BDG since 2009
Duration
1 month
Format
Offline
Starts
May 30, 2026
Certificate
On completion
The BDG ecosystem
More than a course
At BDG, learning continues beyond lessons. You get access to guidance, community, events, spaces, and resources that support your professional growth.
Personal Branding
Learn how to present your skills, build professional visibility, and create a stronger personal brand in your field.
Free Webinars & Seminars
Join free webinars, seminars, and open sessions every month to keep learning, meet experts, and discover new opportunities.
Big Community
Become part of a large professional community of students, graduates, trainers, and industry specialists.
Coworking Spaces
Use BDG spaces for learning, networking, teamwork, and focused work when you need the right environment to grow.
Library
Access useful books, materials, guides, and learning resources selected to support your development.
Who can you become?
Why should teams join the “Advanced MS Excel Program for Companies”?
The Advanced MS Excel program helps teams develop strong data processing, analysis, and automation skills, making their work faster, more accurate, and more efficient.
During the course, participants learn how to work with large datasets, apply functions and calculations, build Pivot Tables and reports, and automate processes using macros.
This program is especially valuable for teams working with reporting, analytics, finance, sales, operations, and administrative processes who want to improve productivity and work more effectively with advanced Excel tools.
What you will learn
- ✓Work efficiently in Excel and manage files effectively
- ✓Create clear and well-structured reports
- ✓Perform complex calculations using formulas and functions
- ✓Manage and process large datasets
- ✓Conduct data analysis and use Pivot Tables
- ✓Automate processes using Macros
Program
- MS Excel interface, its elements, and customization
- Workbook structure and components
- View modes
- Settings and preferences
- Formatting cells, ranges, and tables
- Conditional Formatting
- Form controls in Excel
- Advanced applications of Conditional Formatting
- Charts in Excel 2013/2016
- Using the Fill Series tool
- Difference between functions and formulas
- MS Excel errors and how to interpret them
- Inserting formulas (functions), basic operators, formula categories, and different ways of applying them
- Relative and absolute references, references to other worksheets and files
- Using named ranges in formulas (functions)
- The most commonly used functions (around 50 functions from text, date and time, mathematical, statistical, financial, logical, lookup, and reference categories)
- Complex formulas (functions)
- Hidden functions in Excel
- Advanced applications of the Data Validation tool
- Protecting workbook structure and appearance using different
- Protect Workbook options
- Collaborative and simultaneous work on files /Sharing workbooks with colleagues/
- Using the Track Changes tool in Excel
- Using the Watch Window tool in Excel
- Dynamic (“smart”) tables
- Removing duplicate data, splitting data, logical transformations
- Transposing, filtering, and sorting tables
- Filtering and sorting data
- Grouping and ungrouping, subtotals and final results (Subtotals)
- Data consolidation (Consolidate)
- Finding and replacing data (Find & Replace)
- Printing tables and print settings
- Freezing and unfreezing rows, columns, and panes
- Formula calculation and working in automatic, semi-automatic, and manual calculation modes
- Advanced Filter tool and its advantages
- What-If Analysis
- Using the Goal Seek tool
- What-If Analysis – Scenario Manager
- What-If Analysis – Data Table
- Dependency tracing, introduction to Solver, optimization problems
- Data Tables: sensitivity analysis and risk assessment simulations Mathematical and statistical analysis tools package – Analysis ToolPak
- Creating charts, chart types, and data sources
- Chart formatting, dynamic and interactive charts
- Creating and managing Pivot Tables & Pivot Charts
- Understanding the Data Model and creating Pivot Tables from multiple worksheets
- Slicer and Timeline tools and their advantages
- X-Y charts and forecasting with charts
- Protecting cells, ranges, worksheets, and workbooks
- Protecting files from unauthorized access
- Data validation and input restrictions
- File sharing and multi-user database usage
- MS Excel and external databases /for example, Access/
- MS Excel and MS Word
- MS Excel and the Internet: importing data from web sources and working with connected data sources
- Introduction to array functions
- Working with arrays and array operations
- Array functions such as Sumproduct, Transpose, Offset, Frequency, and Mmult
- Practical examples of using array functions
- Doing what VLOOKUP cannot do: searching for information by the nth occurrence of a lookup value and searching arrays of values based on lookup criteria
- Macro recording
- Relative reference mode
- Running macros using keyboard shortcuts, worksheet buttons, and other methods
- Editing macro code
- Automation with macros
- Add-ins – expanding program capabilities through integrated tools
Course details
🗓
Schedule
Wednesday 19:00-21:30
Friday 19:00-21:30
🎓
Certificate
On completion
10 lessons
Frequently asked questions
Each course is labelled beginner, intermediate or advanced. If you are unsure, book a free consultation and we will help you choose.
Flexible payment options are available for most programs. Contact us to discuss the right plan for you.
Certificates
Certificates you can receive
Depending on the course format and results, students can receive one of BDG's certificate types.
- ✓ Verified BDG certificate
- ✓ QR / signature-ready format
- ✓ Armenian & English certificate design
Co-branded
Participation
For students who actively participate in the course learning process.
For active participationCompletion
For students who complete the course requirements and finish the program.
For successful completionExcellence
For students who complete the course with outstanding results and strong performance.
With distinctionHR Drone
A co-branded certificate for selected HR and partner-certified programs.
Co-brandedFinance and Accounting
Ready to start Advanced MS Excel Program for Companies?
Book a free consultation and reserve your place in the next cohort.
59,000 ֏
1 month · Starts — May 30, 2026
Keep exploring
Related courses
Finance and Accounting
•4 months
•Offline
Financial and Tax Accounting
Starts Sep 2024
Beginner
Certificate
Finance and Accounting
•1 week
•Offline
Meet and Grow։ Financial Literacy
Starts Sep 2024
Certificate
Finance and Accounting
•4 months
•Offline
Accounting and Tax Course for Beginners
Starts Apr 2026
Beginner
Certificate
