Welcome to the main SPGuides Tutorials Hub. This is your starting point for learning and implementing Microsoft 365, SharePoint, Power Platform, and related development technologies with practical, real-world examples.
Whether you are an IT professional, consultant, solution architect, or a motivated beginner, this page will guide you to the right hub for SharePoint, Power Apps, Power Automate, Power BI, Copilot Studio, Power Pages, Microsoft Teams, PowerShell, and TypeScript.
Use this page as your launchpad: bookmark it, and come back whenever you start a new project or want to grow your Microsoft 365 and Power Platform skills in a structured way.
How to use the tutorials hub
Each link on this page is a focused “mini‑academy” for one part of the Microsoft 365 and Power Platform stack. Inside every hub, you will find:
- A clear overview of the technology and where it fits in real solutions
- Structured sections that move from basics to advanced topics
- Dozens to hundreds of step‑by‑step tutorials
- Real business scenarios and patterns, not just theory
If you are learning with a specific job role in mind, use the role‑based learning paths as your guide:
- SharePoint Developer: Start with SharePoint Online, then add Power Automate and PowerShell.
- SPFx Developer: Focus on SPFx and TypeScript, supported by SharePoint Online and (optionally) Power BI.
- Power Apps / Power Platform Developer: Combine Power Apps, Power Automate, SharePoint Online, and Power BI.
- Copilot Studio Developer: Learn Copilot Studio together with Power Automate, SharePoint Online, and Microsoft Teams.
- Power BI Developer: Focus on Power BI with supporting skills from SharePoint Online, Power Apps, and Power Automate.
- Power Pages / Portal Developer: Combine Power Pages with Power Apps, Power Automate, and Power BI.
- Microsoft 365 Solution Architect: Gradually work across all hubs on this page, starting from your current project needs.
If you are just getting started and do not yet have a defined role, begin with SharePoint Online, then move into Power Apps and Power Automate. After you can build basic apps and flows, expand into Power BI for analytics, Copilot Studio for AI agents, and Power Pages for external portals.
If you are already experienced, jump straight into the hub that matches your current role or project and use the tutorials there as a pattern library to solve specific problems quickly.
1:1 Career Coaching for Working Professionals
Already in the industry and want to break into Microsoft 365, SharePoint, or Power Platform roles, or move up to the next level? These 60‑minute, 1:1 sessions are designed specifically for professionals planning a smart career switch or promotion.
- SharePoint Framework Career Guidance (60 mins): Plan your move into modern SharePoint and SPFx roles with a clear skill roadmap, project strategy, and how to present your current experience so it translates into strong SPFx developer opportunities.
- Power Platform Career Guidance (60 mins): Get a personalized transition plan into Power Apps, Power Automate, Power BI, and Copilot: which skills to learn first, how to build a relevant project portfolio, and how to position yourself for better roles and salary growth.
- Power Apps Mock Interview (60 mins): Experience a realistic Power Apps interview, tailored to mid‑level and senior roles. You will get feedback on your answers, how to frame your current work, and practical tips to close gaps before talking to real hiring managers.
Ideal for professionals who want to move from support or admin roles into developer/consultant positions, switch from other tech stacks, or step up from junior to more senior Microsoft 365 / Power Platform roles.
SharePoint Online tutorials hub
If your organization uses Microsoft 365, SharePoint Online is usually at the core of your intranet, document management, and business solutions. The SharePoint Online tutorials hub focuses on site creation, lists and libraries, permissions, content types, views, and modern user experiences.
This hub is ideal for IT admins, SharePoint developers, and power users who want to build stable, maintainable solutions on top of SharePoint Online and integrate it deeply with Power Apps and Power Automate.
Go to: SharePoint Online Tutorials
SharePoint Framework (SPFx) tutorials hub
If you need to build modern client-side customizations for SharePoint, the SharePoint Framework (SPFx) tutorials hub is for you. It covers SPFx web parts, extensions, React-based solutions, deployment, and integration with Microsoft Graph and SharePoint REST APIs.
This hub is best suited to developers and consultants who want to extend SharePoint beyond out‑of‑the‑box capabilities, create custom UI components, and deliver enterprise-grade solutions that integrate with the full Microsoft 365 stack.
Go to: SharePoint Framework Tutorials
Power Apps tutorials hub
The Power Apps tutorials hub is your gateway to building custom business apps without traditional full-stack development. Inside, you will find 350+ tutorials on canvas apps, modern controls, forms, galleries, collections, formulas, SharePoint, and Dataverse integration, security, and real-world app scenarios.
Use this hub if you want to digitize manual processes, build internal tools, or create apps that connect to SharePoint, Dataverse, SQL, and hundreds of other data sources. It is particularly useful for IT pros and citizen developers who want to ship production-quality apps quickly.
Go to: Power Apps Tutorials
Power Automate tutorials hub
The Power Automate tutorials hub focuses on automation and orchestration. It includes 200+ step-by-step examples that show how to build flows for approvals, reminders, document generation, SharePoint and Dataverse integration, Outlook and Teams automation, REST API calls, and Power Automate Desktop RPA patterns.
Use this hub when you want to replace manual, repetitive work with reliable flows: sending notifications, synchronizing systems, processing invoices, updating lists and tables, or integrating with external services.
Go to: Power Automate Tutorials
Power BI tutorials hub
The Power BI tutorials hub helps you turn data into insights. It covers Power BI Desktop basics, DAX measures, Power Query transformations, data modeling, visuals and slicers, conditional formatting, security, and export scenarios.
If your goal is to build interactive reports and dashboards on top of SharePoint, Dataverse, Excel, or other data sources, this hub will guide you from foundational topics to advanced DAX and visualization patterns that work in real projects.
Go to: Power BI Tutorials
Microsoft Copilot Studio tutorials hub
The Microsoft Copilot Studio tutorials hub (formerly Power Virtual Agents) is dedicated to building custom AI agents and copilots. It covers creating agents, multi-agents, autonomous agents, SharePoint and file-based knowledge, Power Automate integration, authentication, and publishing bots to websites and Microsoft 365.
Use this hub if you want to design conversational copilots for HR, IT, support, or knowledge management, and connect them to your existing data and processes in Microsoft 365 and Power Platform.
Go to: Microsoft Copilot Studio Tutorials
Power Pages tutorials hub
The Power Pages tutorials hub is focused on building secure, data-driven portals and external websites that connect to Dataverse and other data sources. You will find tutorials on Power Pages basics, forms, multistep forms, lists, galleries, authentication (Microsoft and Google), and embedding Power BI.
This hub is ideal if you want to build customer, partner, or community portals that surface data and workflows outside your internal environment while still leveraging the Power Platform and Microsoft 365 security model.
Go to: Power Pages Tutorials
Microsoft Teams tutorials hub
The Microsoft Teams tutorials hub shows how to get the most from Teams for collaboration and solution delivery. It covers Teams basics, channels, meetings, apps, integration with SharePoint and Power Platform, and embedding Power Apps and Power BI inside Teams.
Use this hub when you want to deliver apps, dashboards, and automation directly inside Teams so your users can work in one place instead of jumping between multiple tools.
Go to: Microsoft Teams Tutorials
PowerShell tutorials hub
The PowerShell tutorials hub is focused on automation and administration. It includes scripts and walkthroughs for managing SharePoint, Microsoft 365, Azure, and Windows environments, as well as general scripting best practices.
This hub is particularly valuable for administrators and engineers who want to automate repetitive admin tasks, enforce governance, and manage environments at scale using code.
Go to: PowerShell Tutorials
TypeScript tutorials hub
The TypeScript tutorials hub helps you build strong typing and modern JavaScript skills that are especially useful when working with SPFx and client-side web development for Microsoft 365. It covers TypeScript basics, interfaces, classes, functions, and real-world usage patterns.
Use this hub if you are moving from JavaScript to TypeScript, or if you want to write more robust, maintainable code for SPFx, web parts, and other client-side solutions that integrate with Microsoft 365 services.
Go to: TypeScript Tutorials
Learning paths by role – where should you start?
If you are learning with a specific job role in mind, use these curated paths to decide which hubs to focus on first. Each path combines only the hubs listed on this page.
SharePoint Developer
Focus on building robust solutions on top of SharePoint Online and integrating them with automation and apps.
- Start with: SharePoint Online Tutorials
- Add client-side skills with: SharePoint Framework Tutorials
- Automate site, list, and document tasks using: Power Automate Tutorials
- Build admin and deployment scripts via: PowerShell Tutorials
SharePoint Framework (SPFx) Developer
Focus on modern web development for Microsoft 365, using TypeScript and SPFx to build rich experiences.
- Core platform: SharePoint Framework Tutorials
- Strengthen language skills with: TypeScript Tutorials
- Embed and integrate apps and reports using:
Power Apps Developer / Power Platform Developer
Focus on building business apps, integrating them with data sources, and automating processes.
- Core app development: Power Apps Tutorials
- Automate workflows and backend logic via: Power Automate Tutorials
- Use SharePoint and Dataverse as data sources with:
- SharePoint Online Tutorials
- Power BI Tutorials for reporting on app data
Copilot Studio Developer / AI Agent Developer
Focus on building intelligent copilots and integrating them with your Microsoft 365 and Power Platform solutions.
- Core AI agent development: Microsoft Copilot Studio Tutorials
- Use Power Automate for backend actions: Power Automate Tutorials
- Use SharePoint as a knowledge and data source via: SharePoint Online Tutorials
- Expose copilots to users in Teams with: Microsoft Teams Tutorials
Power BI Developer / BI Consultant
Focus on modeling data, writing DAX, and building dashboards for business stakeholders.
- Core analytics and modeling: Power BI Tutorials
- Use SharePoint and Dataverse as sources via:
- SharePoint Online Tutorials
- Power Apps Tutorials for app‑driven data entry
- Automate refreshes, exports, and notifications using: Power Automate Tutorials
Power Pages / Portal Developer
Focus on external portals and secure data-driven sites that extend your internal solutions.
- Core portal development: Power Pages Tutorials
- Integrate apps and flows using:
- Add embedded analytics via: Power BI Tutorials
Microsoft 365 Solution Architect
If you are responsible for designing complete solutions, you should gradually cover all hubs.
- Collaboration and content: SharePoint Online Tutorials and Microsoft Teams Tutorials
- Apps and automation: Power Apps Tutorials and Power Automate Tutorials
- Analytics and reporting: Power BI Tutorials
- Portals and external users: Power Pages Tutorials
- AI and copilots: Microsoft Copilot Studio Tutorials
- Administration and scripting: PowerShell Tutorials and SharePoint Framework Tutorials for advanced customization
Join Our Premium SPGuides.Academy
If you want more than standalone tutorials and prefer complete end-to-end solutions, join our premium SPGuides.Academy.
Inside the academy, you will find:
- Structured courses for SharePoint, SharePoint Framework (SPFx), Power Apps, Power Automate, Power BI, Copilot Studio, Power Pages, and PowerShell.
- Real-time projects that walk through planning, design, build, test, and deployment
- Downloadable app packages, flows, scripts, and report files
- Best practices for architecture, security, performance, and governance across Microsoft 365 and Power Platform
The tutorials on this site help you solve specific problems. SPGuides.Academy connects all the pieces into complete, real-world solutions you can implement in your own environment.
Final thoughts
This Start Here page is your central entry point to the entire SPGuides ecosystem. Each hub link above leads to a comprehensive library of practical, step-by-step tutorials you can apply immediately to your projects.
You can start with a single hub that aligns with your current work, or follow the recommended paths to become a full Microsoft 365 and Power Platform solution expert. Bookmark this page, share it with your team, and come back whenever you are ready to learn the next tool in the stack.
