Career Advice
Get practical guidance on career growth, job search, interviews, CV improvement, and the next steps in your professional path.
Finance and Accounting
·Online
MS Excel Full Course
Why take the "MS Excel Full Course"? Microsoft Excel is an indispensable tool for solving lots of challenges across various fields such as finance, sales, marketing, administratio...
What you'll gain
- ✓ Calculations and tables
- ✓ Diagrams
- ✓ Application of functions
- ✓ Pivot Table
✓ Free consultation · Certificate on completion · Practical learning · Certificate-ready · BDG since 2009
Duration
5 weeks
Format
Online
Level
Beginner
Starts
Jun 29, 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 take the "MS Excel Full Course"?
Microsoft Excel is an indispensable tool for solving lots of challenges across various fields such as finance, sales, marketing, administration, technical roles, engineering, programming, and data analysis. This software proficiency is also deemed a fundamental skill by employers across diverse positions. Our comprehensive "MS Excel Full Course" is designed to take learners from the basics to advanced functionalities, catering to the needs of professionals seeking to enhance their Excel skills. Starting with foundational capabilities, the course progresses to delve into intricate topics, including functions, Pivot Table, Smart Table, data manipulation, and the application of Power Queries. Each class incorporates hands-on practical exercises, providing participants with the opportunity to apply acquired knowledge to real-life problem-solving scenarios. By the end of the course, participants will be equipped to- Confidently use Excel to solve everyday problems, create tables and diagrams, make calculations;
- Apply functions for more complex operations;
- Work with Pivot Table and Smart Table;
- Use Queries in working with databases.
Get 5% Cashback
Pay with 
QR Code
Who is this course for
-
✓
Beginners
If you need proficiency in Excel for your job but have yet to acquaint yourself with its functionalities, then this course is tailored for you. Geared towards beginners, we start the course from the foundational level, making it accessible to those with little to no prior experience using Excel.
-
✓
Professionals in Other Fields
This course caters to professionals across diverse domains who routinely leverage Excel to address a range of challenges and are eager to hone their skills, particularly delving into the more advanced features of the software.
What you will learn
- ✓Calculations and tables
- ✓Diagrams
- ✓Application of functions
- ✓Pivot Table
- ✓Smart Table
- ✓Power Query
Program
- Structure of an MS Excel Workbook
- Concepts of cell, column, row, worksheet, workbook, and application in MS Excel
- Changing cell sizes manually and automatically (Format → Row height, Column width, Hide, Unhide, Rename sheet…)
- Clipboard / Types of Copy-Paste Special
- Fonts, Alignment, Cells (Insert/Delete Rows, Columns…)
- Number / Format Cells – Data types and formats
- Add, Delete, Copy, Move Sheets
- Calculations in Excel, Mathematical operators
- Relative and absolute references
- Naming cells and selected ranges and using them in formulas
- Clipboard / Types of Paste Special
- Assigning practical problems, solution checks, group discussions
- Sorting and Filtering Tables: Sort/Filter
- Advanced Filter
- Find and Replace
- Hyperlink
- Conditional Formatting
- Protection of workbooks, sheets, and cells
- Entering and editing comments
- Overview of Page Layout window
- Overview of Review window
- Text to Columns
- Flash Fill
- Remove Duplicates
- Data Validation – Concept and application
- ConsolidateWhat-If Analysis: Goal Seek
- Grouping and Ungrouping data reflected in the file
- Use of Subtotal tool
- Exploring the View window
- Charts – Types
Text Functions
- Concatenate, Proper, Upper, Lower, Right, Left, Mid, Exact, Rept, Text, Trim, T, Code, Unicode, Clean, Char, Unichar, Len, Substitute, Value, Replace, Find
- Datevalue, Now, Edate, Eomonth, Hour, Today, Time, Timevalue, Weekday, Weeknum, Year, Month, Minute, Second, Day, Days, Date, Networkdays, Workday, Yearfrac
- Assigning practical problems, solution checks, group discussions
Statistical Functions
- Average, Averagea, Averageif, Averageifs, Count, Counta, Countblank, Countif, Countifs, Max, Maxa, Min, Mina, Median, Mode, Large, Small, Rank
- ABS, Ceiling, Combin, Even, Floor, Int, Mod, Odd, Product, Power, Mround, Round, Roundup, Rounddown, Sum, Sumif, Sumifs, Sumproduct, Subtotal, Roman, Randbetween
- Assigning practical problems, solution checks, group discussions
Logical Functions
- If, Iferror, Or, Xor, And, Not
- Address, Indirect, Columns, Column, Lookup, Vlookup, Hlookup, Index, Match, Offset, Rows, Row, Areas, Hyperlink, Formulatext, Choose
- Cell, Error.Type, Info, Iserr, Iserror, Iseven, Isodd, Isblank, Istext, Isformula, Islogical, Isnumber, Sheet, Sheets, Type, N
- Practical examples of function usage
- Assigning practical problems, solution checks, group discussions
- Smart Tables – Concept, advantages over standard tables, calculations
- Pivot Tables – Concept, components, advantages, calculations, formulas, and modifications
- Displaying Subtotals and Grand Totals in Pivot Tables, flexible filtering (2D and 3D), use of Timeline and Slicer
- Creating Calculated Fields in Pivot Tables
- Importing data from other sources (PDF, Excel, CSV, etc.) and their usage
- The concept and advantages of Power Query
- Creating a query (Importing from…)
- Query structure and steps
- Editing steps
- Basic operations with rows and columns
- Assigning practical problems, solution checks
- Data types, transformations, and modifications
- Grouping and summarizing data (Group By)
- Merging data
- Appending data
- Adding columns (Custom Column, Conditional Column)
- Using most common formulas in calculated columns
- Assigning practical problems, solution checks
- Automating tasks with Power Query
- Creating and summarizing different reports for automated future reporting
- Practical examples
- Assigning problems, verifying solutions
- Summary of the provided information
- Discussion and resolution of problems presented by students
- Final Exam
Course details
🗓
Schedule
Monday 19:00-21:00
Thursday 19:00-21:00
🎓
Certificate
On completion
11 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 MS Excel Full Course?
Book a free consultation and reserve your place in the next cohort.
39,000 ֏
5 weeks · Starts — Jun 29, 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
