Advanced Excel and Business Reporting
Build reliable business reports in Microsoft Excel using PivotTables, Power Query, the data model, XLOOKUP and dynamic arrays, then turn them into refreshable dashboards.
- Advanced
Set up and manage team workspaces using Microsoft Teams and SharePoint, including channels, sites, document libraries, permissions, versioning and Microsoft Lists.
The SharePoint and Teams Collaboration course in Doha, Qatar teaches how Microsoft Teams and SharePoint work together as the backbone of shared work in Microsoft 365. Every team in Teams is connected to a SharePoint site, yet many organizations end up with scattered files, unclear permissions and duplicate versions. Participants learn to plan and organize workspaces so documents are easy to find, access is controlled and collaboration stays structured as teams grow.
The course is delivered through guided practice in a working Microsoft 365 environment. Participants create teams and channels, build SharePoint team and communication sites, configure document libraries with metadata and views, manage permissions and version history, and track information with Microsoft Lists. Real scenarios, such as setting up a department hub or a project workspace, connect each feature to everyday needs. The course is offered publicly, live online, or as an in-house program aligned with an organization's governance rules.
By the end of this course, participants will be able to:
Explain how Microsoft Teams, SharePoint and OneDrive store and share files
Create and organize teams, standard channels and private or shared channels
Build SharePoint team and communication sites with useful pages and navigation
Configure document libraries with metadata, views and version history
Manage site and file permissions following least-privilege principles
Track information and workflows using Microsoft Lists
This course is aimed at staff who set up, own or coordinate shared workspaces in Microsoft 365.
Team owners and department coordinators
Project managers and PMO staff
Document control and records staff
IT support and Microsoft 365 champions
Administrative leads managing shared files
Managers planning a move to Teams and SharePoint
Teams, SharePoint and OneDrive: when to use each
Where channel files are stored
Team sites versus communication sites
Planning a workspace structure
Creating teams, channels and adding members
Standard, private and shared channels
Tabs, apps and pinned resources
Owner responsibilities and team settings
Creating sites, pages, web parts and navigation
Document libraries, folders versus metadata columns
Custom views, filters and grouping
Check-in, check-out and version history
SharePoint groups: owners, members and visitors
Breaking inheritance and unique permissions
External sharing and guest access
Reviewing access and avoiding oversharing
Creating lists from templates or Excel
Column types, views and conditional formatting
Alerts and rules for list changes
Introduction to Power Automate approval flows
Large programs in Qatar's construction, energy, government and healthcare sectors involve many departments, contractors and consultants sharing documents at once. Clear workspaces, controlled permissions and reliable version history reduce errors and protect sensitive information. As organizations continue their digital transformation in line with Qatar National Vision 2030, staff who can organize collaboration platforms properly help their teams work faster while keeping information secure and well governed.
Join a scheduled class at our training center in Doha or attend live online. For organizations, the course can run as an in-house program at your premises or online, tailored to your sector, examples and schedule.
It is a Microsoft 365 collaboration course in Doha covering Teams channels, SharePoint sites, document libraries, permissions, versioning and Microsoft Lists, so participants can build organized, secure workspaces for their teams and projects.
Team owners, department coordinators, project and PMO staff, document controllers, IT support staff and Microsoft 365 champions who create or manage shared workspaces will gain the most from this course.
No. It focuses on site owners and power users who build and manage sites, libraries and teams. Tenant-level administration, such as configuring the SharePoint admin center or security policies, is outside the scope, though the trainer explains how owner settings relate to those policies.
Yes. It can be delivered at your premises or online and tailored to your sector, your Microsoft 365 environment, governance rules and schedule. Contact Leaders Training Center to plan an in-house program.
Tell us a little about yourself and an advisor will contact you about batch timings, fees and eligibility. No obligation.
Sat–Thu: 09:00–22:00Fri: 08:00–22:00
Build reliable business reports in Microsoft Excel using PivotTables, Power Query, the data model, XLOOKUP and dynamic arrays, then turn them into refreshable dashboards.
Produce consistent, professional business documents in Microsoft Word using styles, templates, long-document tools, mail merge, tracked changes and accessibility checks.
Design clear, on-brand presentations in Microsoft PowerPoint using slide masters, sound design principles, effective charts and Designer, and deliver them with confidence.
Work smarter with Microsoft 365 by managing email in Outlook, storing files in OneDrive, collaborating in Teams, and organizing tasks with Planner, To Do, Forms and Loop.