Microsoft Training in Tashkent

Microsoft 365 is a suite of cloud-based productivity and collaboration tools that includes Teams, OneDrive, Planner, and Copilot to support modern workplace workflows.

This instructor-led, live training (online or onsite) is aimed at intermediate-level professionals who wish to adopt Microsoft 365 capabilities to improve productivity, governance, and cross-team collaboration.

Upon completion of this training, participants will be able to:

• Configure and manage Teams for effective team collaboration and meeting practices.
• Use OneDrive for secure file storage, sharing, and version control.
• Plan and track work using Planner and integrate tasks into team workflows.
• Leverage Copilot to accelerate document drafting, meeting summaries, and data insights.

Format of the Course

• Interactive demonstrations combined with guided, hands-on labs.
• Scenario-driven exercises reflecting real organizational workflows.
• Practical sessions on configuration, governance, and user adoption best practices.

Course Customization Options

• We can tailor examples, governance checklists, and hands-on labs to match your organization's policies and environment.

Microsoft 365 offers a robust suite of tools for constructing enterprise-grade knowledge management systems by integrating SharePoint, Teams, Power Automate, and Power BI to effectively organize, synchronize, and visualize information. This course examines how to create dynamic intranet dashboards, link diverse data sources, and implement structured workflows to boost collaboration and knowledge exchange among teams.

This instructor-led, live training (available online or onsite) targets advanced professionals seeking to develop and oversee sophisticated knowledge management frameworks using Microsoft 365 tools.

Upon completion of this training, participants will be able to:

• Design advanced knowledge management systems utilizing Microsoft 365 tools.
• Construct interconnected SharePoint sites and Teams channels to facilitate information flow.
• Automate content workflows via Power Automate.
• Create Power BI dashboards for visualizing knowledge and generating reports.
• Optimize governance, access controls, and versioning across shared repositories.

Course Format

• Interactive lectures and discussions.
• Numerous exercises and practical implementation tasks.
• Hands-on configuration within a live Microsoft 365 environment.

Course Customization Options

• To request customized training for this course, please contact us to arrange.

Microsoft Intune is a cloud-based endpoint management solution that empowers organizations to securely manage users, devices, and applications. It offers comprehensive tools for configuration, compliance, and protection across Windows, macOS, iOS, and Android environments.

This instructor-led, live training (available online or onsite) is designed for intermediate to advanced IT professionals who aim to deploy, configure, and manage enterprise devices using Microsoft Intune and related Microsoft 365 technologies.

By the end of this training, participants will be able to:

• Implement and manage Microsoft Intune for endpoint management.
• Configure device enrollment, compliance, and security policies.
• Deploy and protect enterprise applications using Intune.
• Integrate Intune with Microsoft 365, Entra ID, and Defender for Endpoint for unified management.

Format of the Course

• Interactive lecture and discussion.
• Extensive exercises and practice.
• Hands-on implementation in a live-lab environment.

Course Customization Options

• To request a customized training for this course, please contact us to arrange.

Microsoft 365 is a suite of integrated productivity tools that enable collaboration, data-driven insights, and workflow automation through applications like Excel, Word, PowerPoint, Outlook, and Copilot.

This instructor-led, live training (online or onsite) is aimed at intermediate-level professionals who wish to master Microsoft 365 tools and AI-powered features to improve decision-making, communication, and organizational efficiency.

By the end of this training, participants will be able to:

• Apply advanced Excel techniques and automation tools to support business and leadership decisions.
• Design impactful PowerPoint presentations using storytelling and data visualization techniques.
• Create, format, and collaborate on professional documents in Word with the help of Copilot.
• Enhance productivity and time management using Outlook and AI-driven features across Microsoft 365.

Format of the Course

• Interactive lecture and discussion.
• Hands-on exercises and scenario-based practice.
• Practical application using Microsoft 365 tools in a live-lab environment.

Course Customization Options

• To request a customized training for this course, please contact us to arrange.

Microsoft To Do is a cloud-based task management application designed to help individuals and teams organize, prioritize, and manage tasks across devices with seamless integration into Microsoft 365.

This instructor-led, live training (available online or onsite) is aimed at beginner to intermediate-level professionals who wish to leverage Microsoft To Do not only for personal productivity but also as a powerful collaborative tool integrated with Microsoft 365 applications.

Learning Objectives

By the end of this training, participants will be able to:

• Set up and configure Microsoft To Do across devices and integrate it with Microsoft 365.
• Create, organize, and prioritize tasks and lists for both personal and team use.
• Collaborate effectively by sharing lists, assigning tasks, and monitoring progress.
• Enhance workflows by using Microsoft To Do alongside Outlook, Teams, and Planner.
• Apply productivity best practices and advanced techniques for long-term adoption.

Format of the Course

• Interactive lecture and discussion.
• Hands-on exercises and guided labs.
• Practical team collaboration simulations.

Course Customization Options

• To request a customized training for this course, please contact us to arrange.

Microsoft To Do is a cloud-based task management application designed to help individuals and teams organize, prioritize, and manage tasks across devices with seamless integration into Microsoft 365.

This instructor-led, live training (online or onsite) is aimed at beginner-level to intermediate-level professionals who wish to use Microsoft To Do to manage tasks effectively, boost productivity, and collaborate better with teams.

By the end of this training, participants will be able to:

• Set up and configure Microsoft To Do for personal and team use.
• Create, organize, and prioritize tasks efficiently.
• Integrate To Do with Outlook, Teams, and other Microsoft 365 tools.
• Apply productivity best practices using To Do features.

Format of the Course

• Interactive lecture and discussion.
• Lots of exercises and practice.
• Hands-on implementation in a live-lab environment.

Course Customization Options

• To request a customized training for this course, please contact us to arrange.

Microsoft System Center Data Protection Manager (DPM) serves as the enterprise-grade backup and recovery solution from Microsoft, designed to safeguard workloads including file servers, databases, and virtual machines.

This instructor-led training session, available both online and on-site, is tailored for IT professionals at an intermediate level who aim to deploy, configure, and manage DPM to secure data and maintain business continuity.

Upon completing this training, participants will be equipped to:

• Install and set up DPM servers and agents.
• Establish and oversee protection groups.
• Execute backup and recovery procedures.
• Integrate DPM with other disaster recovery systems.

Course Format

• Engaging lectures paired with group discussions.
• Extensive practical exercises and hands-on practice.
• Live laboratory implementation.

Customization Options

• For inquiries regarding tailored training for this course, please reach out to us for arrangements.

This instructor-led, live training in Tashkent (online or onsite) is aimed at beginner-level to intermediate-level business users who wish to improve their productivity and digital collaboration using Microsoft Teams, OneDrive, and Outlook.

By the end of this training, participants will be able to:

• Effectively create, manage, and use teams and channels in Microsoft Teams.
• Leverage tags, mentions, and app integrations in Teams to streamline communication.
• Store, organize, and securely share files in OneDrive using best practices.
• Recover documents using version history and collaborate on files in real time.
• Use Outlook for advanced email management and shared calendar scheduling.

This instructor-led, live training in Tashkent (online or onsite) is designed for beginner to intermediate users who want to improve team productivity and streamline daily workflows using Outlook, OneDrive, Teams, Planner, and Forms.

By the end of this training, participants will be able to:

• Effectively organize and manage communication with Outlook.
• Store, share, and collaborate on files using OneDrive.
• Facilitate meetings, chats, and team collaboration with Microsoft Teams.
• Plan and monitor tasks efficiently with Microsoft Planner.
• Create and analyze online surveys and quizzes using Microsoft Forms.

Microsoft Exchange Server serves as a comprehensive messaging platform, offering functionalities for email, calendar management, contacts, and task tracking.

This instructor-led live training, available both online and onsite, is designed for IT professionals at an intermediate level who aim to install, configure, manage, and troubleshoot Microsoft Exchange Server environments.

Upon completing this training, participants will be equipped to:

• Install and set up Microsoft Exchange Server.
• Implement disaster recovery protocols and anti-malware safeguards.
• Configure message transport and facilitate migration to Exchange Online.
• Troubleshoot issues and maintain server availability.

Course Format

• Engaging lectures and discussions.
• Extensive exercises and practical applications.
• Hands-on implementation within a live-lab setting.

Customization Options for the Course

• To arrange a customized training session for this course, please contact us.

Microsoft OneNote is a digital notebook application used for organizing, sharing, and collaborating on information across teams and devices.

This instructor-led, live training (online or onsite) is aimed at professionals with limited or emerging experience in OneNote who manage or coordinate digital information and wish to use Microsoft OneNote effectively to organize notes, coordinate team knowledge, and enhance collaborative workflows.

By the end of this training, participants will be able to:

• Organize personal and team notes using notebooks, sections, and pages.
• Share and collaborate in real-time on OneNote content.
• Embed and link files, emails, and meeting notes into a unified workspace.
• Integrate OneNote with Microsoft 365 apps like Teams, Outlook, and Planner.

Format of the Course

• Interactive lecture and discussion.
• Hands-on use of Microsoft OneNote in sample collaboration scenarios.
• Guided exercises focused on note-taking, content organization, and teamwork.

Course Customization Options

• To request a customized training for this course based on your department's workflows or internal tools, please contact us to arrange.

This instructor-led, live training in Tashkent (online or onsite) is intended to assist participants in preparing for the Microsoft Azure Data Engineer certification exam (DP-203).

The curriculum explores the fundamentals of Azure data services and their application in processing, storing, and managing cloud-based data. Participants will acquire the skills to build data processing solutions utilizing Azure Data Factory, Azure Stream Analytics, and Azure Databricks, as well as work with NoSQL databases through Azure Cosmos DB.

This instructor-led, live training in Tashkent (online or onsite) is aimed at beginner-level leadership teams who wish to effectively manage and coordinate tasks using Microsoft Planner and its related tools, leading to enhanced productivity and collaboration across the organization.

By the end of this training, participants will be able to:

• Effectively create, manage, and track tasks and projects using Microsoft Planner, enhancing team coordination and project visibility.
• Organize and prioritize individual tasks, share task lists, and collaborate on tasks using Microsoft To Do.
• Utilize Microsoft Loop components for real-time collaboration, integrating them seamlessly into projects and meetings, and enhancing communication and information sharing among team members.
• Design and manage custom lists tailored to specific project needs, automate workflows, and integrate Lists with other Microsoft 365 tools for more efficient task tracking.

This instructor-led, live training in Tashkent (available online or onsite) is designed for beginner-level business professionals who want to acquire the skills needed to effectively use Teams, Word, and Excel within a management context.

Upon completing this training, participants will be able to:

• Gain a thorough understanding of Microsoft 365
• Navigate and leverage Microsoft Teams for communication, collaboration, and project management.
• Develop proficiency in creating, formatting, and managing Word documents.
• Utilize Excel for data entry, manipulation, and analysis.
• Explore methods to integrate Microsoft 365 applications for seamless workflows.

This instructor-led, live training in Tashkent (online or onsite) is designed to help participants prepare for the Microsoft Azure DevOps Engineer certification exam (AZ-400).

The course covers the basics of DevOps practices and how they can be implemented on the Azure platform. Participants will learn how to use Azure DevOps to manage code, build and release pipelines, and implement continuous integration and continuous delivery (CI/CD) practices.

This instructor-led, live training in Tashkent (online or onsite) is designed to help participants prepare for the Microsoft Azure Solutions Architect Expert (AZ-305) certification exam.

The course covers advanced concepts of cloud computing and Azure services. It provides a comprehensive introduction to Azure solutions architecture, including its principles, components, and services. Participants will also learn how to design and deploy Azure solutions using best practices and industry standards.

This course covers various methods and best practices aligned with business and technical requirements for modeling, visualizing, and analyzing data using Power BI. It demonstrates how to access and process data from diverse sources, including both relational and non-relational systems. The course also explores implementing appropriate security standards and policies across the Power BI ecosystem, covering datasets and groups. Additionally, it discusses managing and deploying reports and dashboards for effective sharing and content distribution.

Excel is a spreadsheet application utilized for data entry, analysis, reporting, and automation.

This instructor-led, live training (available online or onsite) is designed for users from beginner to advanced levels who wish to build confidence and proficiency across Excel’s essential, intermediate, and advanced capabilities.

Upon completion of this training, participants will be prepared to:

• Work confidently with spreadsheets, formulas, and formatting.
• Utilize intermediate tools such as tables, charts, and conditional logic.
• Apply advanced functions, data analysis features, and automation techniques.
• Create professional worksheets that support business decision-making.

Format of the Course

• Instructor-led demonstrations and guided explanations.
• Extensive workbook exercises and hands-on practice.
• Practical lab activities using real-world spreadsheet scenarios.

Course Customization Options

• For tailored coverage based on your department’s workflows, please contact us to arrange a customized version of this course.

This instructor-led, live training in Tashkent (online or onsite) is designed to help participants prepare for the Microsoft Azure Security Engineer Associate (AZ-500) certification exam.

The course covers various security topics related to Azure, including identity and access management, platform protection, data and application protection, and operations management.

Microsoft System Center Operations Manager (SCOM) is a monitoring tool designed to ensure the availability, performance, and reliability of IT services across datacenters and applications.

This instructor-led, live training (online or onsite) is aimed at intermediate-level IT professionals who wish to deploy, configure, and manage SCOM for enterprise monitoring and alerting.

By the end of this training, participants will be able to:

• Install and configure System Center Operations Manager.
• Set up monitoring rules, alerts, and reports.
• Integrate SCOM with other System Center components.
• Troubleshoot and optimize performance in monitored environments.

Format of the Course

• Interactive lecture and discussion.
• Lots of exercises and practice.
• Hands-on implementation in a live-lab environment.

Course Customization Options

• To request a customized training for this course, please contact us to arrange.

This instructor-led, live training in Tashkent (online or onsite) is designed for intermediate-level IT professionals who aim to manage and secure their organization's IT environment using Microsoft 365.

Upon completing this training, participants will be capable of:

• Deploying and managing Microsoft 365 services, including Intune, MDM, and Autopilot.
• Configuring and enforcing security policies using Windows Defender and other Microsoft 365 security tools.
• Monitoring and troubleshooting devices and applications within a Microsoft 365 environment.
• Understanding and implementing compliance and data protection measures in Microsoft 365.
• Managing Microsoft 365 security services such as Microsoft Secure Score, Exchange Online Protection, Safe Attachments, and Safe Links.
• Implementing compliance solutions using Microsoft Purview, data loss prevention, and sensitivity labels.

This instructor-led, live training in Tashkent (online or on-site) is designed to assist participants in preparing for the Microsoft Azure Developer Associate (AZ-204) certification exam.

The curriculum covers the core concepts of developing Azure solutions, including Azure compute, storage, and security features. It provides a thorough introduction to Azure development, encompassing the tools and services necessary for building, testing, and deploying applications.

This instructor-led, live training in Tashkent (online or in-person) is designed for data analysts ranging from beginner to advanced levels who want to leverage Excel to carry out various tasks, including data entry, formula development, data analysis, and advanced automation.

Upon completing this training, participants will be capable of:

• Navigating Excel’s interface and executing fundamental data entry, formatting, and calculations.
• Implementing sophisticated formulas, functions, and conditional formatting for data analysis.
• Building and managing pivot tables and charts for effective data visualization.
• Utilizing tools such as Power Query, Power Pivot, and conducting in-depth data analysis.
• Automating processes using macros and VBA to optimize workflows.

This instructor-led, live training in Tashkent (online or onsite) is aimed at beginner-level to intermediate-level professionals who wish to enhance their productivity and efficiency by leveraging the advanced features of Excel and Google Sheets for data organization, analysis, and collaboration.

By the end of this training, participants will be able to:

• Navigate and utilize the core features of Excel and Google Sheets.
• Perform data analysis and create actionable insights using advanced spreadsheet techniques.
• Collaborate in real-time using Google Sheets for seamless teamwork.
• Create reusable templates for reporting, tracking, and project management.

This instructor-led, live training in Tashkent (online or onsite) is aimed at intermediate-level IT professionals who wish to manage and secure an organization's IT environment using Microsoft 365.

By the end of this training, participants will be able to:

• Deploy and manage Microsoft 365 services such as Intune, MDM, and Autopilot.
• Configure and enforce security policies using Windows Defender and other Microsoft 365 security tools.
• Monitor and troubleshoot devices and applications within a Microsoft 365 environment.
• Understand and implement compliance and data protection measures in Microsoft 365.
• Apply best practices for Microsoft 365 administration and security.

This instructor-led, live training in Tashkent (online or onsite) is designed to assist participants in preparing for the Microsoft Azure Administrator Associate (AZ-104) certification exam.

The course covers the skills required to manage Azure resources, including Azure virtual machines, storage solutions, and Azure network management.

This live, instructor-led training in Tashkent (online or onsite) is designed to help participants prepare for the Microsoft Azure Fundamentals (AZ-900) certification exam.

The course covers foundational cloud computing concepts and Azure services. It provides a comprehensive introduction to Azure, including its architecture, pricing and support, and the most commonly used Azure services.

Upon completing this course, participants will be proficient in leveraging key data analysis tools like scenarios and pivot tables. They will learn to utilize functions for date calculations and text processing, and develop the ability to create and customize macros to automate spreadsheet tasks according to specific requirements.

Excel is a widely used spreadsheet application developed by Microsoft. It is utilized for storing, organizing, and analyzing data in tabular format. Below are some key features and functions of Excel: 1. Spreadsheets: Excel consists of worksheets, where each sheet is a grid made up of cells arranged in rows and columns. It allows the creation of multiple worksheets within a single file, enabling the organization of various data sets. 2. Calculations and Formulas: It supports a wide range of mathematical, statistical, and logical calculations using formulas. It includes a comprehensive set of built-in functions such as SUM, AVERAGE, MAX, MIN, IF, VLOOKUP, and others. 3. Data Formatting and Presentation: Provides tools for formatting data, including changing fonts, colors, styles, as well as creating charts, pivot tables, and diagrams. 4. Sorting, Filtering, and Grouping: Enables sorting data based on specified criteria. Allows filtering data to display only selected information. Offers the ability to group data according to specific needs. 5. Data Analysis: Includes tools for advanced analysis, such as scenario analysis, trend identification, forecasting, and macro creation. 6. Data Sharing: Facilitates real-time sharing and collaboration on data, allowing multiple users to work simultaneously on the same dataset. 7. Task Automation: Provides the capability to create macros and automate tasks using the VBA (Visual Basic for Applications) programming language. Excel is extensively used across various fields, from business to science and education. Its versatile features support data analysis, report generation, budgeting, scheduling, data management, and many other applications.

Microsoft Excel is a robust spreadsheet application designed for organizing, analyzing, and visualizing data.

This live training session, led by an instructor and available either online or in person, is specifically designed for beginner-level data analysts looking to leverage Excel for data analysis and reporting tasks.

Upon completing this course, participants will be capable of:

• Creating and managing spreadsheets within Excel.
• Formatting and organizing data to enhance clarity and operational efficiency.
• Employing formulas and functions to streamline calculations.
• Visualizing data through charts, tables, and conditional formatting techniques.
• Collaborating on and securely sharing workbooks via Microsoft 365.

Training Format

• Engaging lectures and interactive discussions.
• Extensive exercises and practical practice sessions.
• Hands-on implementation within a live laboratory environment.

Customization Options

• For personalized training tailored to this course, please reach out to us to make arrangements.

This course provides finance professionals with advanced Excel techniques essential for financial analysis. Topics range from lookup functions, search formulas, and Pivot Charts to conditional formatting, external data workflows, and securities analysis. Participants will gain practical skills in evaluating time value of money concepts, identifying market trends, building financial forecasting models, and leveraging Excel's comprehensive analytical tools for complex financial computations and reporting.

This instructor-led training session, available both in-person and remotely, will walk you through the essential tools of MS Excel. By combining thoroughly prepared training materials with the instructor's deep expertise, the course will showcase the extensive potential of Excel spreadsheets.
Compared to standard Excel courses, this training reveals unique Excel features designed to accelerate and improve your productivity.

Analyzing Financial Data in Excel empowers financial analysts and accountants with sophisticated methods for automating intricate calculations and reporting. The course explores fundamental financial functions, INDEX-MATCH lookups, database queries, PivotTables, PivotCharts, and external data integration. It delves into Goal Seek, Solver, Analysis ToolPak, and VBA macros to streamline repetitive tasks. This training enables professionals to convert raw data into actionable financial insights and precise forecasts for strategic decision-making.

About This Course

This three-day, instructor-led course is designed for individuals aspiring to transition into a database professional role or those whose current job responsibilities are expanding to include database management. The curriculum covers fundamental database concepts, such as various database types, associated languages, and design principles.

Audience Profile

The target audience consists of professionals moving into database roles or those whose existing positions now incorporate database technologies.

At Course Completion

Upon completing this course, students will be capable of:
• Explaining core database concepts within the context of SQL Server 2016
• Describing the database languages utilized in SQL Server 2016
• Outlining data modeling techniques
• Explaining normalization and denormalization methods
• Describing relationship types and their impact on database design
• Explaining how database design influences performance
• Identifying commonly used database objects

About This Course

This three-day Instructor-Led Training (ILT) course is designed to meet the needs of IT professionals involved in administering, configuring, troubleshooting, and managing Office 365 services, including their identities, dependencies, requirements, and supporting technologies. The course focuses on the skills required to administer and troubleshoot the Office 365 tenant and key services such as Exchange Online, SharePoint Online, and Teams. It also covers the security and compliance features of Office 365.

Audience Profile

This course is intended for IT professionals and system administrators who wish to learn about administration and troubleshooting techniques in Office 365. These professionals should have at least three years of experience in their respective fields, ideally in system administration, network administration, and messaging.

At Course Completion

After completing this course, students will be able to:

• Describe Office 365 services.
• Administer Office 365 by using the Microsoft 365 admin center, Office 365 services admin centers, and other tools.
• Administer and troubleshoot directory synchronization and directory objects.
• Administer and troubleshoot Exchange Online.
• Administer and troubleshoot Teams.
• Administer and troubleshoot SharePoint Online.
• Plan and deploy Microsoft 365 Apps for enterprise.
• Administer and troubleshoot compliance and security in Office 365.

About This Course

This five-day course equips you with the knowledge and skills needed to plan and administer a Microsoft SharePoint 2016 environment. It guides you through deploying, managing, and troubleshooting your SharePoint setup, while offering practical guidelines, best practices, and key considerations to optimize your deployment.

As the first course in a two-part series tailored for IT professionals, it aligns directly with the SharePoint 2016 IT Pro certification.

Audience Profile

This course is designed for experienced IT professionals seeking to master the installation, configuration, deployment, and management of SharePoint 2016 in either on-premises data centers or cloud environments.

Participants typically possess over one year of hands-on experience* in planning and maintaining SharePoint, along with two years of experience working with core technologies that SharePoint relies on. These include Windows Server 2012 R2 or later, Internet Information Services (IIS), Microsoft SQL Server 2014 or later, Active Directory Domain Services (AD DS), and networking infrastructure services.

The minimally qualified candidate generally:

• Is an IT professional responsible for planning, implementing, and maintaining multi-server SharePoint 2016 deployments.
• Has working knowledge, and preferably hands-on experience, with SharePoint Online.
• Is broadly familiar with SharePoint workloads.
• Has experience in business continuity management, including data backup, restoration, and high availability strategies.
• Is experienced with authentication and security technologies.
• Has practical experience using Windows PowerShell.

* Hands-on or job experience should stem from a solutions-based role where the candidate has worked on multiple SharePoint solutions encompassing document management, content management, and search capabilities.

At Course Completion

• Describe the key features of SharePoint 2016.
• Design an information architecture for a SharePoint 2016 deployment.
• Design a logical architecture for a SharePoint 2016 deployment.
• Design the physical architecture for a SharePoint 2016 deployment.
• Install and configure SharePoint 2016.
• Create and configure web applications and site collections.
• Plan and configure service applications for a SharePoint 2016 deployment.
• Manage users and permissions, and secure content in a SharePoint 2016 deployment.
• Configure authentication in a SharePoint 2016 deployment.
• Configure platform and farm-level security in a SharePoint 2016 deployment.
• Manage information taxonomy in SharePoint web applications and site collections.
• Configure and manage user profiles and audiences.
• Configure and manage the search experience in SharePoint 2016.
• Monitor, maintain, and troubleshoot a SharePoint 2016 deployment.

Participants will learn to efficiently perform complex calculations, clearly present results, and utilize various features to streamline and accelerate spreadsheet creation. The course also covers methods for protecting your data and formulas from unauthorized access.

Participants will be able to excel themselves, in the most optimal way to create, consolidate and manage data. A number of tools designed to streamline the work often significantly reduces the time to activities carried out so far and can help you design an application that could perform new tasks.

Elevate your VBA proficiency to an intermediate level by exploring custom interfaces, complex data types, conditional logic, looping structures, and professional debugging methods. This practical Excel VBA training covers robust error handling, performance optimization, VBA UserForms, and workflow automation through real-world exercises. It bridges the gap between basic macros and advanced automation solutions, tailored for data analysts, reporting specialists, and business users aiming to unlock enterprise-grade spreadsheet capabilities.

Take your skills to the next level with this professional training course on Microsoft Excel, designed to significantly boost your spreadsheet efficiency and productivity. You will learn essential techniques for editing worksheets, managing workbooks, constructing complex formulas using powerful functions, formatting cells, creating professional charts and graphs, working with PivotTables and data lists, and handling graphic objects. This course is ideal for business analysts, accountants, data specialists, and office professionals who wish to advance their Excel proficiency from an intermediate to an expert level. Enhance your data analysis capabilities, streamline your reporting workflows, and unlock the full potential of Microsoft Excel to drive better decision-making and workplace productivity.

This instructor-led, live training in Tashkent (online or on-site) is designed for beginner-level analysts who wish to use Excel VBA to automate repetitive tasks, clean and transform data, and improve reporting processes.

By the end of this training, participants will be able to: record and edit macros, write simple VBA procedures, work with Excel objects for reporting tasks, and debug basic automation solutions.

This 5-day Advanced Excel for Sales Professionals course is designed to equip sales teams with the skills needed to manage, analyze, and automate sales data efficiently. Participants will learn advanced Excel functions, data analysis techniques, and automation tools to enhance reporting accuracy, create dynamic dashboards, and forecast sales performance. Through hands-on exercises, sales professionals will gain practical insights into building interactive sales reports, automating repetitive tasks, and using advanced tools like Power Query, Power Pivot, and Macros. This course is ideal for those looking to leverage Excel to drive data-driven sales strategies.

This course empowers IT professionals to effectively manage Azure subscriptions, safeguard identities, oversee infrastructure, configure virtual networks, link Azure with on-premises environments, handle network traffic, deploy storage solutions, build and scale virtual machines, establish web applications and containers, safeguard and share data, and monitor overall solution performance.

Designed for Azure Administrators, this training covers the implementation, management, and monitoring of identity, governance, storage, compute, and virtual networks within a cloud environment. Azure Administrators will learn to provision, size, monitor, and optimize resources as needed.

About This Course

This course explores various methods and best practices aligned with business and technical requirements for modeling, visualizing, and analyzing data using Power BI. Participants will learn how to access and process data from a wide range of sources, including both relational and non-relational datasets. The curriculum also covers the implementation of robust security standards and policies across the Power BI ecosystem, encompassing datasets and groups. Additionally, the course details strategies for managing and deploying reports and dashboards to facilitate effective sharing and content distribution.

Audience Profile

This course is designed for data professionals and business intelligence specialists seeking to master accurate data analysis techniques using Power BI. It is also tailored for individuals responsible for developing reports that visualize data from platform technologies deployed both in the cloud and on-premises.

Skills gained

• Ingest, clean, and transform data
• Model data for optimal performance and scalability
• Design and create reports for data analysis
• Apply and execute advanced report analytics
• Manage and share report assets

This instructor-led, live training in Tashkent (online or onsite) is designed for beginner to intermediate-level business and data analysts who wish to utilize Excel for data analysis and reporting in their projects and tasks.

By the end of this training, participants will be able to:

• Utilize Excel formulas and functions to perform calculations and manipulate data.
• Leverage Excel data analysis tools like PivotTables, What-If Analysis, and Forecasting to summarize and visualize data.
• Create and customize data visualizations using Excel charts and graphs.
• Apply Excel data validation and conditional formatting to ensure data quality and highlight key insights.
• Use Excel’s data import and export capabilities to connect with external data sources and share information effectively.

About This Course

Dynamics 365 Finance and Operations apps include, but are not limited to, Dynamics 365 Finance, Dynamics 365 Supply Chain Management, and Dynamics 365 Supply Chain Management, Manufacturing. Dynamics 365 Finance empowers you to: Automate and modernise your global financial operations. Monitor performance in real time, forecast future outcomes, and make data-driven decisions to fuel business growth. Drive strategic financial decisions with artificial intelligence (AI), unify and automate your financial processes, reduce operational expenses, and minimise global financial complexity and risk. Dynamics 365 Supply Chain Management enables you to: Transform your manufacturing and supply chain operations. Leverage predictive insights and intelligence from AI and the Internet of Things (IoT) across planning, production, inventory, warehouse, and transportation management. Maximise operational efficiency, product quality, and profitability. Innovate through intelligent manufacturing operations, modernise warehouse management, optimise production performance, extend asset lifecycles, and automate and streamline your supply chain. Note: For more information, please refer to https://docs.microsoft.com/learn/paths/get-started-finance-operations/ In this module, we will focus on the core features and functionality of Dynamics 365 Finance apps that are most frequently used by end users and consultants.

Audience Profile

A Dynamics 365 for Finance and Operations Functional Consultant is responsible for conducting discovery, capturing requirements, engaging subject matter experts and stakeholders, translating requirements into solutions, and configuring the solution and applications. The Functional Consultant implements solutions using out-of-the-box capabilities, codeless extensibility, and application and service integrations.

At Course Completion

Upon completing this course, students will be able to:

• Navigate and efficiently utilise search, filtering, and queries
• Use operational workspaces
• Work with Business Document Management
• Utilise record templates
• Integrate Power BI with Dynamics 365 Finance and Operations apps
• Personalise workspaces
• Identify when to use Power Platform within the Dynamics 365 Finance app
• Apply security roles to users
• Run and analyse security reports
• Create and utilise workflows for approval
• Work with Organisation Hierarchy and understand its purposes
• Apply the personalisation feature
• Use the Data Management workspace
• Create and utilise entity templates
• Copy configuration data between legal entities
• Import and export data and manage data using Office Integration
• Use the Regression Suite Automation Tool (RSAT)
• Create User Acceptance Tests (UAT) and test plans
• Create and work with the Business Process Modeler (BPM)
• Understand how to use Issue search

About This Course

This course provides developer-focused training for Microsoft Dynamics 365 Finance and Operations Apps. Developers learn to implement and extend applications to satisfy business requirements. Participants will deliver complete solutions by leveraging standardized coding patterns, extensible features, and external integrations.

Audience Profile

Microsoft Dynamics 365 Finance and Operations Apps Developers

This 5-day instructor-led training (ILT) course is designed for IT professionals involved in evaluating, planning, deploying, and managing Microsoft Office 365 services. The curriculum covers essential identities, dependencies, requirements, and supporting technologies. Key focus areas include setting up an Office 365 tenant, such as federation with existing user identities, and maintaining the tenant and its users.

The course is intended for IT professionals responsible for planning, configuring, and managing an Office 365 environment. Attendees are expected to have a solid understanding of several on-premises technologies, including Domain Name System (DNS) and Active Directory Domain Services (AD DS). Additionally, a general familiarity with Microsoft Exchange Server, Microsoft Lync Server or Skype for Business Server, and Microsoft SharePoint Server is required.

Upon completing this course, students will be able to:

• Plan an Office 365 deployment, configure the tenant, and plan a pilot deployment.
• Manage Office 365 users, groups, and licenses, and configure delegated administration.
• Plan and configure client connectivity to Office 365.
• Plan and configure directory synchronization between Microsoft Azure AD and on-premises AD DS.
• Plan and implement the Office 365 ProPlus deployment.
• Plan and manage Microsoft Exchange Online recipients and permissions.
• Plan and configure Exchange Online services.
• Plan and configure Microsoft Teams
• Plan and configure Microsoft SharePoint Online.
• Plan and configure Office 365 collaboration solutions.
• Plan and configure the integration between Office 365 and Microsoft Azure Information Protection.
• Monitor and review Office 365 services, and troubleshoot Office 365 issues.
• Plan and implement identity federation between on-premises AD DS and Azure AD.

This course is designed for individuals aiming for the Microsoft 365 Administrator role who have completed at least one Microsoft 365 role-based administrator certification path.

About This Course

This course delivers essential insights into the key considerations and advantages of adopting cloud services and the Software as a Service (SaaS) model, with a dedicated emphasis on Microsoft 365 offerings. Participants will start by mastering cloud fundamentals, gaining an overview of cloud computing principles and specifically Microsoft’s cloud ecosystem. The curriculum introduces Microsoft Azure and clarifies the distinctions between Microsoft 365 and Office 365. An in-depth examination of Microsoft 365 follows, covering comparisons between on-premises Microsoft services and cloud-based solutions, an exploration of enterprise mobility within Microsoft 365, and an analysis of how these services facilitate collaboration. Additionally, the course explores how Microsoft 365 addresses security, compliance, privacy, and trust, concluding with a detailed review of subscriptions, licensing, billing processes, and support options.

Audience Profile

This course is tailored for business decision-makers and IT professionals aiming to implement cloud services within their organizations or those seeking foundational knowledge of cloud computing essentials. It covers the critical factors and benefits of adopting cloud services, with a particular focus on the Software as a Service (SaaS) model and Microsoft 365 cloud solutions.

At Course Completion

Upon finishing this course, students will be able to:

• Distinguish between various cloud service models.
• Identify the primary differences among Microsoft 365 subscription plans.
• Plan for the migration to Microsoft 365 services.
• Differentiate between Microsoft on-premises services and Microsoft 365 cloud services.
• Explain how Microsoft 365 services enable teamwork.
• Describe identity types, including cloud, on-premises, and hybrid identities.
• Explain cloud device management and protection, including the role of Intune.
• Describe data protection strategies, including the use of Azure Information Protection.
• Outline general compliance and specific compliance features in Microsoft 365.
• Detail Microsoft 365 subscriptions, licensing, billing, and support structures.

This five-day, instructor-led course is tailored for IT professionals with prior experience in Windows Server. It is designed for those tasked with managing identity, networking, storage, and compute resources using Windows Server 2019, and who need to understand the applicable scenarios, requirements, and options available for this version. The course equips IT professionals with the fundamental administration skills necessary to deploy and support Windows Server 2019 in most organizational environments.