Training and Certifications > Microsoft Office > Excel
Microsoft® Excel

Microsoft® Excel Trainings

Microsoft® Excel is the most popular spreadsheet program. Whether you are new to Excel or have a good working knowledge of the product, our Excel 2019 courses will teach you techniques and tips that will help you use Excel more effectively and professionally.

New Horizons Bulgaria offers a full range of courses for Microsoft® Excel 2016 / 2019 and Excel 365, suitable for users at various levels of proficiency with the product. With Excel trainings you will learn how to:
  • Perform simple and complex calculations using formulas and functions;
  • Format and print tables;
  • Create charts;
  • Create and use pivot tables;
  • Consolidate data from multiple spreadsheets or files;
  • Forecast data using What-If analysis;
  • Create macros using a Macro Recorder.

Microsoft® Excel 2019 - Part 1

Microsoft® Excel 2019 - Part 1 provides the perfect training for new users of Microsoft® Excel. Armed with this knowledge, you will be able to work confidently with Excel's core features and get more done in less time.

Throughout the course, you will learn how to:
  • Navigate the Excel interface effectively;
  • Master formulas and commonly used functions;
  • Efficiently manage worksheets, including copying, moving, creating, and deleting;
  • Apply various formatting styles;
  • Prepare and customize data for printing according to your needs.

Microsoft® Excel 2019 - Part 2

This course will increase your productivity in analyzing data, processing large amounts of information, sorting and filtering.

Upon completing this course, you will be able to:
  • Efficiently use and apply complex functions and nest functions within each other;
  • Create pivot tables to visualize valuable insights;
  • Process and analyze extensive datasets through effective filtering and sorting techniques;
  • Generate and manage multiple types of charts, significantly enhancing the quality of your presentation materials;
  • Apply conditional formatting to highlight data based on your specified condition (or criteria).

Microsoft® Excel 2019 - Part 3

This course is suitable for experienced users of Microsoft® Excel who wish to enhance their skills and automate their work.

You will gain skills in:
  • Restricting the type of data or values that users enter into cells;
  • Efficiently processing large and complex datasets through consolidation;
  • Automating daily operations in Excel using macros recorded with the macro recorder;
  • Embedding complex functions while utilizing conditional formatting;
  • Sharing, protecting entire workbooks, sheets, or ranges;
  • Forecasting based on known data using Solver and What-If analysis.

VBA in Excel Macros

The VBA in Excel Macros training will help you automate your work with Excel.

After completing the course, you will be able to:
  • Create your own procedures using VBA code, initiated with just a single mouse click;
  • Review and edit previously created procedures with ease;
  • Use conditional structures and loops to generate reports from long tables;
  • Implement variables effectively;
  • Develop your own interactive macros using dialogue boxes.

Dimitar Ionkov

Dimitar Ionkov

Dimitar Ionkov is a certified Microsoft® instructor. He has more than 20 years of professional experience in the IT and business sectors. He has excellent technical and business skills. For more than 15 years, he has been involved in developing and delivering training on Microsoft® Office and technical applications, as well as developing leadership skills. View Dimitar's full profile.

Hristine Dikidzhiyan

Hristine Dikidzhiyan

Hristine Dikidzhiyan is a certified Microsoft® Office Master 2016 instructor at New Horizons Bulgaria. She leads training courses in Excel, PowerPoint and Word. She approaches all new case studies with interest and does not leave any question of the students unanswered. Communication with Hristine is pleasant, and she easily creates a comfortable environment during the training. She has excellent teaching skills, explains clearly and patiently, and answers all questions. View Hristine's full profile.

Stefan Georgiev

Stefan Georgiev

Stefan is a certified IBM and Microsoft® instructor with deep technical expertise and proven experience in team and project management, software development and support, consulting, server and client systems support. In 2019 Stefan received his 5th international award (including TOP 25 Apps and TOP 25 MS Technical Instructor) for high professionalism and contribution to New Horizons training. View Stefan's full profile.

Gergana Petkova

Gergana Petkova

Gergana Petkova is a certified Microsoft® Office Master 2016. She has been a trainer at New Horizons Bulgaria since 2016 and teaches Microsoft® Office (Excel, Word, PowerPoint, Visio, Teams, OneNote) and VBA programming in Excel. In 2019, she takes the first place in the TOP 25 Instructors in Microsoft® Office Productivity Applications. View Gergana's full profile.


Assessment Test For Your Current Excel Level

Wondering at what level to start your Excel training? Our free assessment test will help you determine your current level of Microsoft® Excel knowledge! Take it now!

Test

What Do Our Students Say About Their Instructors?

Gergana is a wonderful instructor. She explains very carefully and comprehensibly for all age groups. She treats each student very carefully and she is an incredibly good specialist. I would attend another course led by her. Thank you for your professional and friendly attitude, the course was very useful.
Extremely professional and positive attitude. Possesses deep knowledge in the field and excellent communication skills. Creates interest and manages to provoke logical thinking in the learner. Teacher by example!
The course is extremely useful for people who are just starting to work with Microsoft Excel. It presents both the theoretical and practical aspects well.
Accounting, UBB
Hristine is a very knowledgeable girl who definitely knows what and how to do. She is a professional in her work. The course was extremely useful and informative!
Store Manager, Vivacom
She is perfect, organized, with excellent knowledge. She was born for this job! :) I would describe it to my colleagues and friends like this: "Enroll in the training! You will learn a lot of new and interesting things!"
Sales, BON EOOD
Very good communication with the group and creation of a pleasant working atmosphere.
Accounting/Finance, UBB
Very comprehensive and useful course. Hristine Dikidzhiyan is a competent and positive teacher!
Human Resources, UniCredit Group
Trainings: +359 885 666 815
Exams: +359 885 601 989
office@newhorizons.bg
New Horizons Bulgaria
36 Dragan Tsankov blvd.
Interpred, Block A, Floor 6
Sofia, 1040