Office Add-Ins: Excel Solver & Power Query
The Microsoft Office Add-Ins course by Koenig Original equips developers and solution architects with skills to build cross-platform Office extensions using HTML, CSS, and JavaScript, solving the industry challenge of integrating web apps into desktop workflows. With over 250 million Microsoft 365 commercial users, demand for add-in expertise is surging among enterprises adopting cloud-first strategies.
This Koenig Original course prepares learners for real-world development success by teaching integration with Excel, Word, Outlook, and PowerPoint across Windows, Mac, and web platforms. Featuring Guaranteed-to-Run scheduling and 30-day lab access, it enables hands-on practice in a secure cloud environment, empowering developers to create marketplace-publishable solutions and advance into high-impact application development roles.
Training Formats & Pricing
100% Happiness Guarantee · Free Rescheduling · Secure Payment
Course Overview
The Microsoft Office Add-Ins course by Koenig Original is designed for developers, software engineers, and IT professionals aiming to master the creation of cross-platform solutions that extend Microsoft 365 applications. This training prepares candidates for the MS-600: Building Applications and Solutions with Microsoft 365 Core Services exam, a key component of the Microsoft 365 Certified: Teams Application Developer Associate certification. Target roles include Office Add-in Developer, Microsoft 365 Application Engineer, and Cloud Integration Specialist. With over 35% of organizations reporting staffing gaps in Microsoft ecosystem expertise, demand for certified professionals who can build scalable, secure add-ins across Excel, Word, Outlook, and PowerPoint continues to grow rapidly.
Participants engage with core technologies including the Office JavaScript API, Microsoft Graph, unified manifest for Microsoft 365, Yeoman Generator (Yo Office), Visual Studio Code, and Script Lab. The hands-on lab environment leverages Node.js-based development tools and simulates real-world deployment scenarios on Microsoft 365 platforms. Students build functional add-ins from scratch, such as an Outlook task integration that pulls data from external APIs into email clients, configure authentication via Azure AD, and package solutions using Partner Center for submission to Microsoft Marketplace. These labs emphasize responsive design, security best practices, and interoperability across Windows, Mac, iPad, and web versions of Office.
This Koenig Original course equips learners with skills directly aligned to the retired but still industry-recognized MS-600 certification, which validated expertise in modern enterprise-grade app development for Microsoft 365. Certified professionals have reported median salary increases, with Microsoft 365 Developers in the UK earning a median of £90,000 annually as of mid-2024. A key differentiator of Koenig’s training is its Guaranteed-to-Run policy, ensuring scheduled delivery regardless of enrollment numbers, combined with access to official Microsoft courseware and expert-led instruction. Graduates are positioned to lead digital transformation initiatives, enhance productivity through automation, and pursue advanced roles in cloud application development within global enterprises leveraging Microsoft's ecosystem.
What You'll Learn
Prerequisites
- Fundamental web development skills such as HTML, CSS, and JavaScript are essential for creating effective Microsoft Office Add-Ins using Koenig's Microsoft Office Add-Ins training.
- Proficiency in TypeScript or JavaScript for client-side programming enhances your ability to develop powerful Office Add-Ins with Koenig's expert-led courses.
- Experience with Visual Studio Code and Node.js (LTS version) is recommended to streamline your development process for Microsoft Office Add-Ins from Koenig Solutions.
- Familiarity with the Microsoft 365 environment and Office applications like Excel, Word, and Outlook ensures smoother integration of your Office Add-Ins developed through Koenig's training.
- Understanding REST APIs and JSON for data exchange is crucial for building dynamic Office Add-Ins that connect with external data sources, as covered in Koenig's comprehensive courses.
- Basic knowledge of XML for Office Add-in manifest configuration helps in customizing and deploying Office Add-Ins effectively, a key focus in Koenig's Microsoft Office Add-Ins prerequisites.
Certification Exam
Everything you need to know about the Office Add-Ins: Excel Solver & Power Query certification exam
Course Curriculum
Structured learning with hands-on labs and real-world scenarios
1
Day 1– Mastering Microsoft Office Add-Ins
2
Day 2– Development Environment Setup
3
Day 3– Core JavaScript API Mastery
4
Day 4– Advanced Add-In Functionality
5
Day 5– Deployment and Production Support
What's Included in Your Training
Every enrollment comes packed with resources to maximise your learning and exam success
Exam Preparation Materials
Practice Test Questions (200+)
Certificate of Completion
Post-Training Support (30 days)
Session Recording Access
Free Rescheduling (7+ days notice)
Career Outcomes
of Office Add-Ins: Excel Solver & Power Query certified professionals report career advancement within 6 months
Salary Impact
Average salary increase reported after obtaining the Office Add-Ins: Excel Solver & Power Query certification
*Source: Glassdoor / LinkedIn 2025
Job Roles
- Office Add-in Developer
- Microsoft 365 Integration Engineer
- Frontend Developer – Office Solutions
- Enterprise Application Developer (O365 Add-ons)
- Senior Outlook Add-in Developer
- Word/Excel Add-in Specialist
Companies Hiring
and 5,000+ organizations worldwide seeking Office Add-Ins: Excel Solver & Power Query certified professionals
Course Student Reviews
Real results from IT professionals who trained with Koenig — rated 4.9/5 from 18,400+ verified reviews.
-
★★★★★
“Passed AZ-104 on first attempt. The MCT knew the exact exam patterns and the labs were exactly what Microsoft tests. Worth every penny.”
AZ-104 Certified ✓ Verified -
★★★★★
“I trained 15 of my team members for SC-200. Koenig's on-site delivery was seamless and all 15 passed within 3 months.”
Enterprise Client ✓ Verified -
★★★★★
“The 1-on-1 format was a game changer. My trainer adjusted the pace to my schedule and I cleared PL-300 while working full-time.”
PL-300 Certified ✓ Verified -
★★★★★
“From AZ-900 to AZ-305 in 6 months. Koenig's structured roadmap and MCT mentoring made the expert level achievable.”
AZ-305 Expert ✓ Verified -
★★★★★
“As an L&D head I've used 5 training vendors. Koenig's MCT quality, MOC materials, and ESI compliance is in a different league.”
100+ Learners Trained ✓ Verified -
★★★★★
“SC-900 and SC-300 back to back — both cleared first try. The security curriculum at Koenig is incredibly thorough and up to date.”
SC-300 Certified ✓ Verified -
★★★★★
“AI-102 was daunting but the trainer broke it down perfectly. Real Azure OpenAI labs made the difference. Highly recommend.”
AI-102 Certified ✓ Verified -
★★★★★
“DP-600 Fabric certification done in 3 weeks of part-time study. The customised schedule around my timezone was a lifesaver.”
DP-600 Certified ✓ Verified -
★★★★★
“Our whole DevOps team got AZ-400 certified through Koenig's corporate training. Smooth logistics and top-tier MCTs throughout.”
AZ-400 Team Training ✓ Verified -
★★★★★
“Passed AZ-104 on first attempt. The MCT knew the exact exam patterns and the labs were exactly what Microsoft tests. Worth every penny.”
AZ-104 Certified ✓ Verified -
★★★★★
“I trained 15 of my team members for SC-200. Koenig's on-site delivery was seamless and all 15 passed within 3 months.”
Enterprise Client ✓ Verified -
★★★★★
“The 1-on-1 format was a game changer. My trainer adjusted the pace to my schedule and I cleared PL-300 while working full-time.”
PL-300 Certified ✓ Verified -
★★★★★
“From AZ-900 to AZ-305 in 6 months. Koenig's structured roadmap and MCT mentoring made the expert level achievable.”
AZ-305 Expert ✓ Verified -
★★★★★
“As an L&D head I've used 5 training vendors. Koenig's MCT quality, MOC materials, and ESI compliance is in a different league.”
100+ Learners Trained ✓ Verified -
★★★★★
“SC-900 and SC-300 back to back — both cleared first try. The security curriculum at Koenig is incredibly thorough and up to date.”
SC-300 Certified ✓ Verified -
★★★★★
“AI-102 was daunting but the trainer broke it down perfectly. Real Azure OpenAI labs made the difference. Highly recommend.”
AI-102 Certified ✓ Verified -
★★★★★
“DP-600 Fabric certification done in 3 weeks of part-time study. The customised schedule around my timezone was a lifesaver.”
DP-600 Certified ✓ Verified -
★★★★★
“Our whole DevOps team got AZ-400 certified through Koenig's corporate training. Smooth logistics and top-tier MCTs throughout.”
AZ-400 Team Training ✓ Verified
-
★★★★★
“Passed AZ-104 on first attempt. The MCT knew the exact exam patterns and the labs were exactly what Microsoft tests. Worth every penny.”
AZ-104 Certified ✓ Verified -
★★★★★
“I trained 15 of my team members for SC-200. Koenig's on-site delivery was seamless and all 15 passed within 3 months.”
Enterprise Client ✓ Verified -
★★★★★
“The 1-on-1 format was a game changer. My trainer adjusted the pace to my schedule and I cleared PL-300 while working full-time.”
PL-300 Certified ✓ Verified -
★★★★★
“Passed AZ-104 on first attempt. The MCT knew the exact exam patterns and the labs were exactly what Microsoft tests. Worth every penny.”
AZ-104 Certified ✓ Verified -
★★★★★
“I trained 15 of my team members for SC-200. Koenig's on-site delivery was seamless and all 15 passed within 3 months.”
Enterprise Client ✓ Verified -
★★★★★
“The 1-on-1 format was a game changer. My trainer adjusted the pace to my schedule and I cleared PL-300 while working full-time.”
PL-300 Certified ✓ Verified
-
★★★★★
“From AZ-900 to AZ-305 in 6 months. Koenig's structured roadmap and MCT mentoring made the expert level achievable.”
AZ-305 Expert ✓ Verified -
★★★★★
“As an L&D head I've used 5 training vendors. Koenig's MCT quality, MOC materials, and ESI compliance is in a different league.”
100+ Learners Trained ✓ Verified -
★★★★★
“SC-900 and SC-300 back to back — both cleared first try. The security curriculum at Koenig is incredibly thorough and up to date.”
SC-300 Certified ✓ Verified -
★★★★★
“From AZ-900 to AZ-305 in 6 months. Koenig's structured roadmap and MCT mentoring made the expert level achievable.”
AZ-305 Expert ✓ Verified -
★★★★★
“As an L&D head I've used 5 training vendors. Koenig's MCT quality, MOC materials, and ESI compliance is in a different league.”
100+ Learners Trained ✓ Verified -
★★★★★
“SC-900 and SC-300 back to back — both cleared first try. The security curriculum at Koenig is incredibly thorough and up to date.”
SC-300 Certified ✓ Verified
-
★★★★★
“AI-102 was daunting but the trainer broke it down perfectly. Real Azure OpenAI labs made the difference. Highly recommend.”
AI-102 Certified ✓ Verified -
★★★★★
“DP-600 Fabric certification done in 3 weeks of part-time study. The customised schedule around my timezone was a lifesaver.”
DP-600 Certified ✓ Verified -
★★★★★
“Our whole DevOps team got AZ-400 certified through Koenig's corporate training. Smooth logistics and top-tier MCTs throughout.”
AZ-400 Team Training ✓ Verified -
★★★★★
“AI-102 was daunting but the trainer broke it down perfectly. Real Azure OpenAI labs made the difference. Highly recommend.”
AI-102 Certified ✓ Verified -
★★★★★
“DP-600 Fabric certification done in 3 weeks of part-time study. The customised schedule around my timezone was a lifesaver.”
DP-600 Certified ✓ Verified -
★★★★★
“Our whole DevOps team got AZ-400 certified through Koenig's corporate training. Smooth logistics and top-tier MCTs throughout.”
AZ-400 Team Training ✓ Verified
Frequently Asked Questions
Everything you need to know about the Office Add-Ins: Excel Solver & Power Query training course
Is the Microsoft Office Add-Ins certification exam included in the course fee, and what is the separate exam cost if not included?
What training formats are available for the Microsoft Office Add-Ins course, and does Koenig offer Guaranteed-to-Run scheduling?
How long is lab access provided for Microsoft Office Add-Ins training, and what environment is used?
What is Koenig's rescheduling and cancellation policy for the Microsoft Office Add-Ins course?
What is the format, number of questions, passing score, and time limit for the Microsoft Office Add-Ins certification exam?
How long is the Microsoft Office Add-Ins certification valid, and what is the renewal process and cost?
What post-training support does Koenig provide after completing the Microsoft Office Add-Ins course?
What prerequisites or prior experience are recommended before taking the Microsoft Office Add-Ins course?
What career benefits and salary impact can be expected after earning the Microsoft Office Add-Ins certification?
How does instructor-led Microsoft Office Add-Ins training compare to self-study in terms of effectiveness and outcomes?
Still have questions?
Chat with a Training Advisor →Resources
Learn more about Office Add-Ins: Excel Solver & Power Query before you enroll
Top Skills You’ll Gain from Microsoft Office 365 Training
Microsoft Office 365 has become the backbone of the modern digital workplace, powering communication, collaboration, and productivity for mi…
Read GuideWhat is Office Administration Training? A Complete Guide for Beginners
Office administration plays a crucial role in any business, ensuring smooth day-to-day operations. Whether it’s managing schedules, organizi…
Read ArticleHow Office 365 Training Can Boost Workplace Productivity
In today’s competitive business landscape, maximizing workplace productivity is more important than ever. Microsoft Office 365 is a powerful…
Read ArticleHappiness Guarantee
We are so confident in the quality of our training that we offer a full money-back guarantee. Not satisfied? Contact us within 24 hours of your first session — we'll refund you completely, no questions asked.