{"title":"Dynamics 365","description":null,"products":[{"product_id":"microsoft-excel-training-course","title":"Microsoft Excel Training Course","description":"\u003cdiv\u003e\u003cp\u003eIntroduction to \u003cstrong\u003eMicrosoft Excel training\u003c\/strong\u003e empowers participants with key skills to create and edit worksheets, implement formulas and functions, and sort and filter detailed data with tables and slicers. Visualize the numbers in a consumable and professional format analyzing data with charting, conditional formatting, sparklines, and pivot tables.\u003c\/p\u003e\u003c\/div\u003e\u003cdiv\u003e\n\u003ch3\u003eMicrosoft Excel Training Course Benefits\u003c\/h3\u003e\n\u003cul\u003e\n\u003cli\u003e\n\u003cp\u003e\u003cstrong\u003eIn this Microsoft Excel training, you will learn to:\u003c\/strong\u003e\u003c\/p\u003e\n\u003cul\u003e\n\u003cli\u003eEfficiently navigate and manipulate worksheets and workbooks.\u003c\/li\u003e\n\u003cli\u003eImplement an income and expense statement with formulas, functions, and names.\u003c\/li\u003e\n\u003cli\u003eDesign a reusable data entry template that protects formulas.\u003c\/li\u003e\n\u003cli\u003eImplement conditional formatting to analyze sales information.\u003c\/li\u003e\n\u003cli\u003eConnect, prepare, and validate data employing editing tools, formulas, and Flash Fill.\u003c\/li\u003e\n\u003cli\u003eIdentify, sort, and select detailed data with tables and slicers.\u003c\/li\u003e\n\u003cli\u003ePresent and analyze data with conditional formatting, charting, sparklines, and printing parameters.\u003c\/li\u003e\n\u003cli\u003eConstruct IF functions that make decisions - present results visually.\u003c\/li\u003e\n\u003cli\u003eCombine data with 3-D formulas.\u003c\/li\u003e\n\u003cli\u003eAnalyze summary data with PivotTables and implement a quick dashboard.\u003c\/li\u003e\n\u003cli\u003eLeverage continued support with after-course one-on-one instructor coaching and computing sandbox.\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003c\/li\u003e\n\u003cli\u003e\n\u003cp\u003e\u003cstrong\u003ePrerequisites\u003c\/strong\u003e\u003c\/p\u003e\n\u003cp\u003eNone.\u003c\/p\u003e\n\u003c\/li\u003e\n\u003cli\u003e\n\u003cp\u003e\u003cstrong\u003eMicrosoft Excel Training Exam Information\u003c\/strong\u003e\u003c\/p\u003e\n\u003cul\u003e\n\u003cli\u003eLearning Tree end-of-course exam included\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003c\/div\u003e\u003cdiv\u003e\u003ch3\u003eMicrosoft Excel Training Course Outline\u003c\/h3\u003e\u003c\/div\u003e\u003cdiv\u003e\n\u003ch4\u003eModule 1: Introduction to Microsoft Excel\u003c\/h4\u003e\n\u003cul\u003e\n\u003cli\u003eWorking with cell ranges—navigating and selecting cells with the mouse and keyboard \u003c\/li\u003e\n\u003cli\u003eEntering and editing data and employing AutoFill to enter data \u003c\/li\u003e\n\u003cli\u003eInserting and deleting rows, columns, or cells. \u003c\/li\u003e\n\u003cli\u003eAdjusting column width and row height \u003c\/li\u003e\n\u003cli\u003eManipulating data with cut, copy, paste, with the clipboard, or dragging the mouse \u003c\/li\u003e\n\u003cli\u003eLeveraging multiple worksheets \u003c\/li\u003e\n\u003c\/ul\u003e\n\u003c\/div\u003e\u003cdiv\u003e\n\u003ch4\u003eModule 2: Formulas and Functions\u003c\/h4\u003e\n\u003cul\u003e\n\u003cli\u003eWriting simple formulas \u003c\/li\u003e\n\u003cli\u003eExploring audit tools to examine and evaluate formulas \u003c\/li\u003e\n\u003cli\u003eReferencing cells in formulas using relative and absolute references \u003c\/li\u003e\n\u003cli\u003eConfiguring cells for the number format and alignment \u003c\/li\u003e\n\u003cli\u003eConstructing common functions with the aid of the function wizard and the Formula tab \u003c\/li\u003e\n\u003cli\u003eImplementing names in formulas and functions \u003c\/li\u003e\n\u003c\/ul\u003e\n\u003c\/div\u003e\u003cdiv\u003e\n\u003ch4\u003eModule 3: Worksheet Formatting and Presentation\u003c\/h4\u003e\n\u003cul\u003e\n\u003cli\u003eSetting up initial cell formatting \u003c\/li\u003e\n\u003cli\u003eDrawing attention to data with formatting \u003c\/li\u003e\n\u003cli\u003eWorking with templates - Protecting cell ranges and worksheets \u003c\/li\u003e\n\u003cli\u003eAnalyzing data with conditional formatting \u003c\/li\u003e\n\u003c\/ul\u003e\n\u003c\/div\u003e\u003cdiv\u003e\n\u003ch4\u003eModule 4: Getting Data In and Out\u003c\/h4\u003e\n\u003cul\u003e\n\u003cli\u003eImporting data into Excel from various sources: text, web, Microsoft Access, SQL (Structured Query Language) Server \u003c\/li\u003e\n\u003cli\u003eTransforming data with global replace and data tools \u003c\/li\u003e\n\u003cli\u003eTEXT and DATE functions \u003c\/li\u003e\n\u003cli\u003e2013 Flash Fill assistant \u003c\/li\u003e\n\u003cli\u003eSetting WISE (Written, Integrated, Synergistic, and Expansive) goals \u003c\/li\u003e\n\u003c\/ul\u003e\n\u003c\/div\u003e\u003cdiv\u003e\n\u003ch4\u003eModule 5: Sorting, Selecting and Subtotaling data\u003c\/h4\u003e\n\u003cul\u003e\n\u003cli\u003eSubtotaling a Filtered list with the subtotal command \u003c\/li\u003e\n\u003cli\u003eImplementing Tables and Table Formulas \u003c\/li\u003e\n\u003cli\u003eSubtotaling a table with the Total Row \u003c\/li\u003e\n\u003cli\u003eFiltering Tables with Slicers \u003c\/li\u003e\n\u003c\/ul\u003e\n\u003c\/div\u003e\u003cdiv\u003e\n\u003ch4\u003eModule 6: Present Data Visually\u003c\/h4\u003e\n\u003cul\u003e\n\u003cli\u003eLeveraging charts to create a visual presentation \u003c\/li\u003e\n\u003cli\u003eCreating charts using wizards \u003c\/li\u003e\n\u003cli\u003eAdjusting chart settings, including titles, labels, and chart types \u003c\/li\u003e\n\u003cli\u003eWorking with Views of the spreadsheet \u003c\/li\u003e\n\u003cli\u003eSetting up your workbook for printing \u003c\/li\u003e\n\u003c\/ul\u003e\n\u003c\/div\u003e\u003cdiv\u003e\n\u003ch4\u003eModule 7: Introducing Advanced Features\u003c\/h4\u003e\n\u003cul\u003e\n\u003cli\u003eImplementing dates \u003c\/li\u003e\n\u003cli\u003eSummarizing data from other worksheets with 3-D formulas \u003c\/li\u003e\n\u003cli\u003eDesigning IF functions and conditional formatting \u003c\/li\u003e\n\u003cli\u003eAnalyzing summary data with Pivot tables and slicers \u003c\/li\u003e\n\u003c\/ul\u003e\n\u003c\/div\u003e","brand":"Learning Tree","offers":[{"title":"266A97US \/ 2026-06-10T09:00:00 \/ Online","offer_id":47534172438747,"sku":"US-1361-IL","price":2228.0,"currency_code":"USD","in_stock":true},{"title":"267D38US \/ 2026-07-08T09:00:00 \/ Austin","offer_id":48216535630043,"sku":"US-1361-IL","price":2228.0,"currency_code":"USD","in_stock":true},{"title":"268A75CN \/ 2026-08-19T09:00:00 \/ Ottawa","offer_id":48216535662811,"sku":"US-1361-IL","price":2228.0,"currency_code":"USD","in_stock":true},{"title":"269C55US \/ 2026-09-23T09:00:00 \/ New York","offer_id":48216535695579,"sku":"US-1361-IL","price":2228.0,"currency_code":"USD","in_stock":true},{"title":"26AB50US \/ 2026-10-28T09:00:00 \/ Herndon, VA","offer_id":48216535728347,"sku":"US-1361-IL","price":2228.0,"currency_code":"USD","in_stock":true},{"title":"26BB94US \/ 2026-11-23T09:00:00 \/ Austin","offer_id":48216535761115,"sku":"US-1361-IL","price":2228.0,"currency_code":"USD","in_stock":true},{"title":"271A21CN \/ 2027-01-06T09:00:00 \/ Ottawa","offer_id":48216535793883,"sku":"US-1361-IL","price":2228.0,"currency_code":"USD","in_stock":true},{"title":"272B25US \/ 2027-02-24T09:00:00 \/ New York","offer_id":48294634717403,"sku":"US-1361-IL","price":2228.0,"currency_code":"USD","in_stock":true},{"title":"273B50US \/ 2027-03-23T09:00:00 \/ Herndon, VA","offer_id":48500532478171,"sku":"US-1361-IL","price":2228.0,"currency_code":"USD","in_stock":true},{"title":"274B44US \/ 2027-04-21T09:00:00 \/ Austin","offer_id":48619725291739,"sku":"US-1361-IL","price":2228.0,"currency_code":"USD","in_stock":true},{"title":"276A21CN \/ 2027-06-02T09:00:00 \/ Ottawa","offer_id":48825880248539,"sku":"US-1361-IL","price":2228.0,"currency_code":"USD","in_stock":true}]},{"product_id":"designing-data-models-in-excel-for-power-bi-reports-training","title":"Designing Data Models in Excel for Power BI Reports Training","description":"\u003cdiv\u003e\n\u003cp\u003eThis course focuses on \u003cstrong\u003edesigning \u003cabbr title=\"Business Intelligence\"\u003eBI\u003c\/abbr\u003e Data Models\u003c\/strong\u003e to display in either an interactive Power BI report or an interactive Excel dashboard. This is both a fundamental Power BI course and an advanced Excel course that will take you through a data journey from importing, cleansing, and merging large amounts of data to analyzing the data to presenting strategic data in a PivotTable and a Power BI dashboard. This practical course provides flexibility and empowers you to choose how you want to present your business insights to help management make informed decisions.\u003cb\u003e\u003c\/b\u003e\u003c\/p\u003e\r\n\u003cul\u003e\u003c\/ul\u003e\n\u003c\/div\u003e\u003cdiv\u003e\n\u003ch3\u003eDesigning Data Models in Excel for Power BI Reports Training Benefits\u003c\/h3\u003e\n\u003cul\u003e\n\u003cli\u003e\u003cp\u003eTransform and present sophisticated data to provide Business Intelligence (BI)\u003c\/p\u003e\u003c\/li\u003e\n\u003cli\u003e\u003cp\u003eActualize a data model from multiple sources with Power Pivot\u003c\/p\u003e\u003c\/li\u003e\n\u003cli\u003e\u003cp\u003eShape and prepare your data with Power Query\u003c\/p\u003e\u003c\/li\u003e\n\u003cli\u003e\u003cp\u003eMine and expose hidden information with Data Analysis eXpressions\u003c\/p\u003e\u003c\/li\u003e\n\u003cli\u003e\u003cp\u003eCommunicate business and data insights with Power BI reports and dashboards\u003c\/p\u003e\u003c\/li\u003e\n\u003cli\u003e\u003cp\u003eLeverage continued support with after-course one-on-one instructor coaching and computing sandbox\u003c\/p\u003e\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003c\/div\u003e\u003cdiv\u003e\u003ch3\u003eData Models in Excel for Power BI Outline\u003c\/h3\u003e\u003c\/div\u003e\u003cdiv\u003e\n\u003ch4\u003eImportant course information\u003c\/h4\u003e\n\u003cp\u003e\u003cb\u003ePrerequisites\u003c\/b\u003e\u003c\/p\u003e\n\u003cul\u003e\n\u003cli\u003eExperience with Excel at the level of:\n\u003cul\u003e\n\u003cli\u003eExcel Data Analysis Course • Course 195\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003c\/li\u003e\n\u003cli\u003eThis course is applicable to all versions of Excel, from Excel 2010 to Excel 2021\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003c\/div\u003e\u003cdiv\u003e\n\u003ch4\u003eModule 1: Identifying the Role of Power Pivot in Business Intelligence (BI)\u003c\/h4\u003e\n\u003cp\u003e\u003cb\u003eIntroducing the Business Intelligence Tools\u003c\/b\u003e\u003c\/p\u003e\n\u003cul\u003e\n\u003cli\u003eExploring the Microsoft Business Intelligence tools\u003c\/li\u003e\n\u003cli\u003eDefining the requirements for a collaborative solution\u003c\/li\u003e\n\u003cli\u003eIdentifying the steps to create a Power BI dashboard\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003cp\u003e\u003cb\u003eFamiliarization with Power Pivot \u003c\/b\u003e\u003c\/p\u003e\n\u003cul\u003e\n\u003cli\u003eNavigating the Power Pivot interface\u003c\/li\u003e\n\u003cli\u003eExtracting information from data with Power Pivot\u003c\/li\u003e\n\u003cli\u003eUncovering data interpretation issues\u003c\/li\u003e\n\u003cli\u003eCreating a simple dashboard\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003c\/div\u003e\u003cdiv\u003e\n\u003ch4\u003eModule 2: Building the Data Model with Power Pivot\u003c\/h4\u003e\n\u003cp\u003e\u003cb\u003eDefining a consolidated view of data\u003c\/b\u003e\u003c\/p\u003e\n\u003cul\u003e\n\u003cli\u003eGenerating a data mashup from structured and unstructured data sources into a data model\u003c\/li\u003e\n\u003cli\u003eDeriving relationships from data sources with the Relationships tool and the Diagram View\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003cp\u003e\u003cb\u003eDenormalizing data to simplify usage within other BI reporting tools\u003c\/b\u003e\u003c\/p\u003e\n\u003cul\u003e\n\u003cli\u003eSimplifying the data model\u003c\/li\u003e\n\u003cli\u003eAcquiring data from related tables\u003c\/li\u003e\n\u003cli\u003eConsolidating information with calculated columns\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003cp\u003e\u003cb\u003eQuerying SQL Server data\u003c\/b\u003e\u003c\/p\u003e\n\u003cul\u003e\n\u003cli\u003eDesigning queries to import data from \u003cabbr title=\"Structured Query Language\"\u003eSQL\u003c\/abbr\u003e Server\u003c\/li\u003e\n\u003cli\u003eRelating tables with outer joins\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003cp\u003e\u003cb\u003eFixing common data issues with Power Query\u003c\/b\u003e\u003c\/p\u003e\n\u003cul\u003e\n\u003cli\u003eExtracting, Transforming, and Loading (\u003cabbr title=\"Extracting, Transforming, and Loading\"\u003eETL\u003c\/abbr\u003e) data\u003c\/li\u003e\n\u003cli\u003eConverting data formats with Power Query steps\u003c\/li\u003e\n\u003cli\u003eParsing columns to aid analysis\u003c\/li\u003e\n\u003cli\u003eRemoving duplicates from a data set\u003c\/li\u003e\n\u003cli\u003eConstructing a single data set from multiple sources with the same field headings\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003c\/div\u003e\u003cdiv\u003e\n\u003ch4\u003eModule 3: Shaping Data with Power Query\u003c\/h4\u003e\n\u003cp\u003e\u003cb\u003eFamiliarization with Power Query\u003c\/b\u003e\u003c\/p\u003e\n\u003cul\u003e\n\u003cli\u003eNavigating the Power Query interface\u003c\/li\u003e\n\u003cli\u003eExtracting, Transforming, and Loading (ETL) data\u003c\/li\u003e\n\u003cli\u003eConverting data formats with Power Query steps\u003c\/li\u003e\n\u003cli\u003eParsing columns to aid analysis\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003cp\u003e\u003cb\u003eCombining Data\u003c\/b\u003e\u003c\/p\u003e\n\u003cul\u003e\n\u003cli\u003eMerging tables of data\u003c\/li\u003e\n\u003cli\u003eConstructing a single data set from multiple sources with the same field headings\u003c\/li\u003e\n\u003cli\u003eDevelop an automated solution to combining data\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003cp\u003e\u003cb\u003eFiltering Data with Parameters\u003c\/b\u003e\u003c\/p\u003e\n\u003cul\u003e\n\u003cli\u003eDeveloping queries\u003c\/li\u003e\n\u003cli\u003eRemoving duplicates from a data set\u003c\/li\u003e\n\u003cli\u003eDefining Excel tables as parameters for a Power Query\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003c\/div\u003e\u003cdiv\u003e\n\u003ch4\u003eModule 4: Manipulating and Analyzing Data with the Data Analysis eXpressions (DAX) Language\u003c\/h4\u003e\n\u003cp\u003e\u003cb\u003eDefining measures for business performance\u003c\/b\u003e\u003c\/p\u003e\n\u003cul\u003e\n\u003cli\u003eDistinguishing the role of measures\u003c\/li\u003e\n\u003cli\u003eTranslating key business concepts into measures\u003c\/li\u003e\n\u003cli\u003eProviding context for measures within a PivotTable\u003c\/li\u003e\n\u003cli\u003eDetermining between implicit and explicit measures\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003cp\u003e\u003cb\u003eImplementing DAX functions in Power Pivot\u003c\/b\u003e\u003c\/p\u003e\n\u003cul\u003e\n\u003cli\u003eExpressing information with measures\u003c\/li\u003e\n\u003cli\u003eExposing hidden information from data\u003c\/li\u003e\n\u003cli\u003eTroubleshooting and debugging DAX calculations\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003cp\u003e\u003cb\u003eExploiting data analytics with aggregation\u003c\/b\u003e\u003c\/p\u003e\n\u003cul\u003e\n\u003cli\u003eQuantifying and mining information with DAX functions\u003c\/li\u003e\n\u003cli\u003eSummarizing and aggregating data from other tables with the X functions\u003c\/li\u003e\n\u003cli\u003eEvaluating expressions with the CALCULATE() function and filter functions\u003c\/li\u003e\n\u003cli\u003eSubstituting values with the SWITCH() function\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003cp\u003e\u003cb\u003eMining for information with date and time analysis\u003c\/b\u003e\u003c\/p\u003e\n\u003cul\u003e\n\u003cli\u003eGrouping dates for time analysis\u003c\/li\u003e\n\u003cli\u003eComparing and categorizing time periods with Time Intelligence functions\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003cp\u003e\u003cb\u003eSetting key business targets with KPIs\u003c\/b\u003e\u003c\/p\u003e\n\u003cul\u003e\n\u003cli\u003eAnalyzing performance with measures\u003c\/li\u003e\n\u003cli\u003eGauging performance against goals\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003c\/div\u003e\u003cdiv\u003e\n\u003ch4\u003eModule 5: Designing Interactive Power BI dashboards\u003c\/h4\u003e\n\u003cp\u003e\u003cb\u003eFamiliarization with Power BI\u003c\/b\u003e\u003c\/p\u003e\n\u003cul\u003e\n\u003cli\u003eDeciding on where to develop a dashboard\u003c\/li\u003e\n\u003cli\u003eImporting an Excel data model into Power BI Desktop\u003c\/li\u003e\n\u003cli\u003eDeveloping a data model in the Power BI Desktop\u003c\/li\u003e\n\u003cli\u003eCrafting visualizations from the analytics\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003cp\u003e\u003cb\u003eBuilding a Power BI dashboard\u003c\/b\u003e\u003c\/p\u003e\n\u003cul\u003e\n\u003cli\u003eConstructing Power BI visualizations\u003c\/li\u003e\n\u003cli\u003eDesigning visual-level, page-level, and report-level filter\u003c\/li\u003e\n\u003cli\u003eAssembling a Power BI Dashboard\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003c\/div\u003e","brand":"Learning Tree","offers":[{"title":"267B23US \/ 2026-07-15T09:00:00 \/ Herndon, VA","offer_id":47534211072219,"sku":"US-1362-IL","price":2228.0,"currency_code":"USD","in_stock":true},{"title":"269C56US \/ 2026-09-09T09:00:00 \/ Herndon, VA","offer_id":48216585142491,"sku":"US-1362-IL","price":2228.0,"currency_code":"USD","in_stock":true},{"title":"26BB95US \/ 2026-11-04T09:00:00 \/ Herndon, VA","offer_id":48216585175259,"sku":"US-1362-IL","price":2228.0,"currency_code":"USD","in_stock":true},{"title":"271B78US \/ 2027-01-13T09:00:00 \/ Herndon, VA","offer_id":48216585208027,"sku":"US-1362-IL","price":2228.0,"currency_code":"USD","in_stock":true},{"title":"273B51US \/ 2027-03-10T09:00:00 \/ Herndon, VA","offer_id":48334731149531,"sku":"US-1362-IL","price":2228.0,"currency_code":"USD","in_stock":true},{"title":"275B74US \/ 2027-05-12T09:00:00 \/ Herndon, VA","offer_id":48762886062299,"sku":"US-1362-IL","price":2228.0,"currency_code":"USD","in_stock":true}]},{"product_id":"collaborating-in-ms-teams-a-hands-on-approach","title":"Productivity with Microsoft Teams and Al","description":"\u003cdiv\u003e\n\u003cp\u003eThis course will empower any user to maximize their understanding and usage of Microsoft Teams. From basic user tips to more advanced features, from chatting to using Al, getting to know more Team features makes you more productive and more collaborative with colleagues. Users will deep dive into the built-in Teams tools and use cases. Users will be able to transform Microsoft Teams into an advanced communication platform and a comprehensive collaborative environment.\u003c\/p\u003e\r\n\u003cp\u003eThis course is beneficial for any organization that utilizes Microsoft Teams and\/or introducing Copilot and Al to its users.\u003c\/p\u003e\n\u003c\/div\u003e\u003cdiv\u003e\n\u003ch3\u003eProductivity with Microsoft Teams and Al Benefits\u003c\/h3\u003e\n\u003cul\u003e\n\u003cli\u003e\n\u003cp\u003e\u003cstrong\u003eIn this course, you will learn how to:\u003c\/strong\u003e\u003c\/p\u003e\n\u003cul\u003e\n\u003cli\u003eUse Teams for chats and meetings\u003c\/li\u003e\n\u003cli\u003eSearch and find content across teams\u003c\/li\u003e\n\u003cli\u003eCreate and manage Teams \u0026amp; channels\u003c\/li\u003e\n\u003cli\u003eManage settings and permissions\u003c\/li\u003e\n\u003cli\u003eManage files in Teams\u003c\/li\u003e\n\u003cli\u003eIntegrate other apps into Teams\u003c\/li\u003e\n\u003cli\u003eUse Copilot features within Teams\u003c\/li\u003e\n\u003cli\u003eHave Al summarize, search, and revise your Teams content\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003c\/li\u003e\n\u003cli\u003e\n\u003cp\u003e\u003cstrong\u003ePrerequisites\u003c\/strong\u003e\u003c\/p\u003e\n\u003cp\u003eNone.\u003c\/p\u003e\n\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003c\/div\u003e\u003cdiv\u003e\u003ch3\u003eCollaborating in MS Teams Training Outline\u003c\/h3\u003e\u003c\/div\u003e\u003cdiv\u003e\n\u003ch4\u003eIntroduction and Overview\u003c\/h4\u003e\n\u003cul\u003e\n\u003cli\u003eUnderstand the purpose and scope of Microsoft Teams as a digital workspace\u003c\/li\u003e\n\u003cli\u003eReview core Microsoft 365 components that integrate with Teams (Teams, SharePoint, OneDrive)\u003c\/li\u003e\n\u003cli\u003eLearn how Teams supports communication, collaboration, and file sharing\u003c\/li\u003e\n\u003cli\u003eGet introduced to Microsoft 365 Copilot and its role in productivity\u003c\/li\u003e\n\u003cli\u003eUnderstand navigation, access methods, and core Teams concepts\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003c\/div\u003e\u003cdiv\u003e\n\u003ch4\u003eChapter 1: Chats\u003c\/h4\u003e\n\u003cul\u003e\n\u003cli\u003eGet started with one-on-one and group chats in Microsoft Teams\u003c\/li\u003e\n\u003cli\u003eLearn different ways to communicate effectively inside chats (formatting, emojis, mentions, actions)\u003c\/li\u003e\n\u003cli\u003eUnderstand how file sharing works in chats and how files are stored in OneDrive\u003c\/li\u003e\n\u003cli\u003eExplore advanced chat features such as unified chats and @mentions\u003c\/li\u003e\n\u003cli\u003eUse Microsoft 365 Copilot to summarize chats, draft messages, and adjust tone\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003c\/div\u003e\u003cdiv\u003e\n\u003ch4\u003eChapter 2: Creating Teams and Channels\u003c\/h4\u003e\n\u003cul\u003e\n\u003cli\u003eUnderstand what Teams are and when to create them\u003c\/li\u003e\n\u003cli\u003eLearn the different types of Teams (Private, Public, Org-wide) and their use cases\u003c\/li\u003e\n\u003cli\u003eCreate Teams using templates or from scratch\u003c\/li\u003e\n\u003cli\u003eUnderstand channels, including standard and private channels\u003c\/li\u003e\n\u003cli\u003eLearn how to manage roles, permissions, and team settings\u003c\/li\u003e\n\u003cli\u003eUse Copilot to support productive channel conversations and summaries\u003c\/li\u003e\n\u003cli\u003eLearn how to search across Teams, channels, chats, and files\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003c\/div\u003e\u003cdiv\u003e\n\u003ch4\u003eChapter 3: Manage Meetings\u003c\/h4\u003e\n\u003cul\u003e\n\u003cli\u003eUnderstand different meeting types (channel vs. private, scheduled vs. ad hoc)\u003c\/li\u003e\n\u003cli\u003eLearn how to schedule meetings in Teams and Outlook\u003c\/li\u003e\n\u003cli\u003eConfigure meeting options, lobby settings, and participant roles\u003c\/li\u003e\n\u003cli\u003eManage meetings in progress (sharing, recording, breakout rooms, reactions)\u003c\/li\u003e\n\u003cli\u003eUse Whiteboard for real-time collaboration\u003c\/li\u003e\n\u003cli\u003eLeverage Copilot and AI features such as Facilitator, transcription, summaries, and action items\u003c\/li\u003e\n\u003cli\u003eApply best practices for effective video meetings\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003c\/div\u003e\u003cdiv\u003e\n\u003ch4\u003eChapter 4: File Management\u003c\/h4\u003e\n\u003cul\u003e\n\u003cli\u003eManage files within Teams, chats, and channels\u003c\/li\u003e\n\u003cli\u003eUnderstand the differences between OneDrive and SharePoint\u003c\/li\u003e\n\u003cli\u003eLearn how Teams stores files and how SharePoint integrates with channels\u003c\/li\u003e\n\u003cli\u003eUpload, edit, share, and manage permissions on files\u003c\/li\u003e\n\u003cli\u003eOrganize files using views, filters, and sorting in SharePoint document libraries\u003c\/li\u003e\n\u003cli\u003eAccess files through multiple entry points in Teams\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003c\/div\u003e\u003cdiv\u003e\n\u003ch4\u003eChapter 5: Adding Tabs and Apps\u003c\/h4\u003e\n\u003cul type=\"disc\"\u003e\n\u003cli\u003eUnderstand default channel tabs (Conversation, Files, Notes)\u003c\/li\u003e\n\u003cli\u003eAdd tabs to surface documents, apps, and content directly in channels\u003c\/li\u003e\n\u003cli\u003eUse productivity apps such as Planner and Microsoft Lists\u003c\/li\u003e\n\u003cli\u003eExplore additional apps (Forms, Power BI, Polls, project management tools)\u003c\/li\u003e\n\u003cli\u003eInstall apps to enhance chat and channel experiences\u003c\/li\u003e\n\u003cli\u003eConfigure personal Teams settings for notifications, devices, and behavio\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003c\/div\u003e\u003cdiv\u003e\n\u003ch4\u003eChapter 6: More with AI and Copilot\u003c\/h4\u003e\n\u003cul type=\"disc\"\u003e\n\u003cli\u003eIncrease productivity using effective Copilot prompts\u003c\/li\u003e\n\u003cli\u003eExplore common Copilot use cases across meetings, files, and calendars\u003c\/li\u003e\n\u003cli\u003eUnderstand the Copilot page in Teams and when to use it\u003c\/li\u003e\n\u003cli\u003eLearn the difference between “Work” and “Web” Copilot experiences\u003c\/li\u003e\n\u003cli\u003eUse Copilot for summarization, research, content creation, and analysi\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003c\/div\u003e\u003cdiv\u003e\n\u003ch4\u003eChapter 7: Course Summary\u003c\/h4\u003e\n\u003cul type=\"disc\"\u003e\n\u003cli\u003eReinforce core Microsoft Teams concepts and capabilities\u003c\/li\u003e\n\u003cli\u003eReview how to effectively use Chats, Meetings, Teams, and Files\u003c\/li\u003e\n\u003cli\u003eRevisit best practices for collaboration and organization\u003c\/li\u003e\n\u003cli\u003eSummarize how Microsoft 365 Copilot enhances productivity across Teams\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003c\/div\u003e","brand":"Learning Tree","offers":[{"title":"266A19US \/ 2026-06-09T09:00:00 \/ Online","offer_id":47250437472475,"sku":"US-4618-IL","price":716.0,"currency_code":"USD","in_stock":true},{"title":"269A21US \/ 2026-09-08T09:00:00 \/ Online","offer_id":47570765381851,"sku":"US-4618-IL","price":716.0,"currency_code":"USD","in_stock":true},{"title":"26BA09US \/ 2026-11-03T09:00:00 \/ Online","offer_id":48041972793563,"sku":"US-4618-IL","price":716.0,"currency_code":"USD","in_stock":true},{"title":"271A16US \/ 2027-01-19T09:00:00 \/ Online","offer_id":48161142178011,"sku":"US-4618-IL","price":716.0,"currency_code":"USD","in_stock":true},{"title":"273A05US \/ 2027-03-09T09:00:00 \/ Online","offer_id":48331762991323,"sku":"US-4618-IL","price":716.0,"currency_code":"USD","in_stock":true},{"title":"274A13US \/ 2027-04-27T09:00:00 \/ Online","offer_id":48682092691675,"sku":"US-4618-IL","price":716.0,"currency_code":"USD","in_stock":true}]},{"product_id":"managing-microsoft-teams-training-ms-700","title":"Managing Microsoft Teams Training (MS-700)","description":"\u003cdiv\u003e\n\u003cp\u003eThe \u003cstrong\u003eManaging Microsoft Teams Training course\u003c\/strong\u003e is designed for persons who are aspiring to the Microsoft 365 Teams Admin role. A Microsoft Teams administrator plans, deploys, configures, and manages Microsoft Teams to focus on efficient and effective collaboration and communication in a Microsoft 365 environment.\u003c\/p\u003e\r\n\u003cp\u003eIn this course, you will learn about various Teams management tools, security and compliance features for Teams, network requirements for Teams deployment, and different Teams settings and policies for managing collaboration and communication experience in Teams.\u003c\/p\u003e\n\u003c\/div\u003e\u003cdiv\u003e\n\u003ch3\u003eManaging Microsoft Teams Training (MS-700) Benefits\u003c\/h3\u003e\n\u003cul\u003e\n\u003cli\u003e\n\u003cp\u003e\u003cstrong\u003eIn this course, you will:\u003c\/strong\u003e\u003c\/p\u003e\n\u003cul\u003e\n\u003cli\u003eLearn what Microsoft Teams is and how the components work together\u003c\/li\u003e\n\u003cli\u003eHow to implement Governance, Security, and Compliance for Microsoft Teams\u003c\/li\u003e\n\u003cli\u003eHow to prepare an organization environment for a Microsoft Teams deployment\u003c\/li\u003e\n\u003cli\u003eHow to deploy and manage teams\u003c\/li\u003e\n\u003cli\u003eHow to manage collaboration and communication experiences in Microsoft Teams\u003c\/li\u003e\n\u003cli\u003eTechniques to manage and troubleshoot communication in Microsoft Teams\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003c\/li\u003e\n\u003cli\u003e\n\u003cp\u003e\u003cstrong\u003ePrerequisites\u003c\/strong\u003e\u003c\/p\u003e\n\u003cp\u003e\u003cspan\u003eBefore attempting MS-700, attendees should have:\u003c\/span\u003e\u003c\/p\u003e\n\u003cul\u003e\n\u003cli\u003eA proficient understanding of basic functional experience with Microsoft 365 services.\u003c\/li\u003e\n\u003cli\u003eA proficient understanding of general IT practices, including using PowerShell.\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003c\/li\u003e\n\u003cli\u003e\n\u003cp\u003e\u003cstrong\u003eExam Information\u003c\/strong\u003e\u003c\/p\u003e\n\u003cp\u003e\u003cspan\u003eThis course can help you prepare for the following Microsoft role-based certification exam — \u003ca href=\"https:\/\/docs.microsoft.com\/en-us\/learn\/certifications\/exams\/ms-700\" title=\"Exam MS-700: Managing Microsoft Teams | Microsoft Learn\" rel=\"nofollow noopener\" target=\"_blank\"\u003eExam MS-700: Managing Microsoft Teams\u003c\/a\u003e.\u003c\/span\u003e\u003c\/p\u003e\n\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003c\/div\u003e\u003cdiv\u003e\u003ch3\u003eManaging Microsoft Teams Training Outline\u003c\/h3\u003e\u003c\/div\u003e\u003cdiv\u003e\n\u003ch4\u003eModule 1: Explore Microsoft Teams\u003c\/h4\u003e\n\u003cp\u003eLearn about Microsoft Teams capabilities, including Teams core workloads and integration with other Microsoft services and platforms. Understand the Teams architecture and Teams certified solutions.\u003c\/p\u003e\n\u003cp\u003e\u003cb\u003eBy the end of this module, you will be able to:\u003c\/b\u003e\u003c\/p\u003e\n\u003cul type=\"disc\"\u003e\n\u003cli\u003eDescribe Microsoft Teams core workloads\u003c\/li\u003e\n\u003cli\u003eDescribe how Microsoft 365 integrates with Teams\u003c\/li\u003e\n\u003cli\u003eDescribe how Microsoft Power Platform integrates with Teams\u003c\/li\u003e\n\u003cli\u003eExplain the architecture of Microsoft Teams and dependent services\u003c\/li\u003e\n\u003cli\u003eDescribe how Microsoft Teams interacts with SharePoint, One Drive and Exchange\u003c\/li\u003e\n\u003cli\u003eDescribe Teams certified solutions\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003c\/div\u003e\u003cdiv\u003e\n\u003ch4\u003eModule 2: Plan and deploy Microsoft Teams\u003c\/h4\u003e\n\u003cp\u003eLearn how to plan and deploy Microsoft Teams to your organization, including different Teams admin roles, available management tools, and processes to roll out Teams. Understand required licensing and how to deploy Teams clients.\u003c\/p\u003e\n\u003cp\u003e\u003cb\u003eBy the end of this module, you'll be able to:\u003c\/b\u003e\u003c\/p\u003e\n\u003cul\u003e\n\u003cli\u003eDescribe different Teams admin roles\u003c\/li\u003e\n\u003cli\u003eExplain which management tools are available for Teams\u003c\/li\u003e\n\u003cli\u003ePlan for Teams rollout\u003c\/li\u003e\n\u003cli\u003eUnderstand the importance of a user adoption plan when deploying Teams\u003c\/li\u003e\n\u003cli\u003eIdentify required licensing for Teams\u003c\/li\u003e\n\u003cli\u003eDeploy Teams clients\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003c\/div\u003e\u003cdiv\u003e\n\u003ch4\u003eModule 3: Implement lifecycle management and governance for Microsoft Teams\u003c\/h4\u003e\n\u003cp\u003eLearn about Teams lifecycle management and governance, including different features to govern Microsoft 365 Groups, ways to assign Teams policies, and Teams preview features controls.\u003c\/p\u003e\n\u003cp\u003e\u003cb\u003eBy the end of this module, you are able to:\u003c\/b\u003e\u003c\/p\u003e\n\u003cul type=\"disc\"\u003e\n\u003cli\u003eDescribe the lifecycle management for Teams\u003c\/li\u003e\n\u003cli\u003ePlan governance features for Teams\u003c\/li\u003e\n\u003cli\u003eConfigure Microsoft 365 Groups governance features\u003c\/li\u003e\n\u003cli\u003ePlan the Teams policy assignment for different scenarios\u003c\/li\u003e\n\u003cli\u003eCreate and manage policy packages\u003c\/li\u003e\n\u003cli\u003eControl Teams preview features for users\u003c\/li\u003e\n\u003cli\u003eCreate and manage team templates and templates policies\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003c\/div\u003e\u003cdiv\u003e\n\u003ch4\u003eModule 4: Monitor your Microsoft Teams environment\u003c\/h4\u003e\n\u003cp\u003eLearn about different reports and dashboards to monitor your Teams environment, including Microsoft 365 and Teams usage reports, Microsoft Adoption Score, Microsoft Entra access reviews, and Microsoft 365 network connectivity dashboard.\u003c\/p\u003e\n\u003cp\u003e\u003cb\u003eBy the end of this module, you will be able to:\u003c\/b\u003e\u003c\/p\u003e\n\u003cul type=\"disc\"\u003e\n\u003cli\u003eAnalyze usage patterns by monitoring Microsoft 365 and Teams usage reports\u003c\/li\u003e\n\u003cli\u003eInterpret Microsoft Adoption Score\u003c\/li\u003e\n\u003cli\u003eManage user access by using Microsoft Entra access reviews\u003c\/li\u003e\n\u003cli\u003eAssess network readiness by using the Microsoft 365 network connectivity dashboard\u003c\/li\u003e\n\u003cli\u003eManage Teams notifications and alerts to monitor Teams capabilities and receive alerts\u003c\/li\u003e\n\u003cli\u003eManage feedback policies\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003c\/div\u003e\u003cdiv\u003e\n\u003ch4\u003eModule 5: Manage access for external users\u003c\/h4\u003e\n\u003cp\u003eLearn about the options to work with external users in Teams and the access controls from different places, including Azure AD, Microsoft 365, Teams, and SharePoint admin centers.\u003c\/p\u003e\n\u003cp\u003e\u003cb\u003eBy the end of this module, you will be able to:\u003c\/b\u003e\u003c\/p\u003e\n\u003cul type=\"disc\"\u003e\n\u003cli\u003eExplain external access and guest access.\u003c\/li\u003e\n\u003cli\u003eDescribe how to manage external access and guest access.\u003c\/li\u003e\n\u003cli\u003eManage external collaboration in Microsoft Entra.\u003c\/li\u003e\n\u003cli\u003eManage external collaboration in Microsoft 365.\u003c\/li\u003e\n\u003cli\u003eManage external access in Microsoft Teams.\u003c\/li\u003e\n\u003cli\u003eManage guest access in Microsoft Teams.\u003c\/li\u003e\n\u003cli\u003eManage file sharing in SharePoint.\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003c\/div\u003e\u003cdiv\u003e\n\u003ch4\u003eModule 6: Implement security for Microsoft Teams\u003c\/h4\u003e\n\u003cp\u003eLearn about different security capabilities for Microsoft Teams, including Conditional Access, multifactor authentication, Safe Attachments, Safe Links, and Defender for Cloud Apps.\u003c\/p\u003e\n\u003cp\u003e\u003cb\u003eBy the end of this module, you will be able to:\u003c\/b\u003e\u003c\/p\u003e\n\u003cul type=\"disc\"\u003e\n\u003cli\u003eConfigure Conditional Access and multifactor authentication for Microsoft Teams.\u003c\/li\u003e\n\u003cli\u003eConfigure Safe Attachments for Microsoft Teams.\u003c\/li\u003e\n\u003cli\u003eConfigure Safe Links for Microsoft Teams.\u003c\/li\u003e\n\u003cli\u003eExamine the Defender for Cloud Apps.\u003c\/li\u003e\n\u003cli\u003eDescribe security reports for Microsoft Teams.\u003c\/li\u003e\n\u003cli\u003ePlan and configure enhanced encryption policies.\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003c\/div\u003e\u003cdiv\u003e\n\u003ch4\u003eModule 7: Implement compliance for Microsoft Teams\u003c\/h4\u003e\n\u003cp\u003eLearn about different compliance capabilities for Microsoft Teams, including sensitivity labels, retention policies, DLP policies, communication compliance, and information barrier policy.\u003c\/p\u003e\n\u003cp\u003e\u003cb\u003eBy the end of this module, you will be able to:\u003c\/b\u003e\u003c\/p\u003e\n\u003cul type=\"disc\"\u003e\n\u003cli\u003eDescribe how sensitivity labels work and how to configure them.\u003c\/li\u003e\n\u003cli\u003eDescribe how to create retention policies.\u003c\/li\u003e\n\u003cli\u003eGenerate Data Loss Prevention policies to protect against data leakage.\u003c\/li\u003e\n\u003cli\u003eDeploy communication compliance for reviewing communication.\u003c\/li\u003e\n\u003cli\u003eActivate the scoped directory search in Teams.\u003c\/li\u003e\n\u003cli\u003eDescribe how information barrier policies work and how to create them.\u003c\/li\u003e\n\u003cli\u003eConfigure alert policies for events in Microsoft Teams\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003c\/div\u003e\u003cdiv\u003e\n\u003ch4\u003eModule 8: Plan and configure network settings for Microsoft Teams\u003c\/h4\u003e\n\u003cp\u003eLearn about the network requirements for Microsoft Teams and associated settings, including Network Planner, Quality of Service (QoS), configuration for location-enhanced reports, and Microsoft 365 network connectivity test tool.\u003c\/p\u003e\n\u003cp\u003e\u003cb\u003eBy the end of this module, you will be able to:\u003c\/b\u003e\u003c\/p\u003e\n\u003cul type=\"disc\"\u003e\n\u003cli\u003eExplain the network requirements of Microsoft Teams.\u003c\/li\u003e\n\u003cli\u003eWork with the Network Planner tool.\u003c\/li\u003e\n\u003cli\u003eUtilize the Network Test Companion.\u003c\/li\u003e\n\u003cli\u003eDescribe the required network ports and protocols.\u003c\/li\u003e\n\u003cli\u003eConfigure reporting labels for Microsoft Teams.\u003c\/li\u003e\n\u003cli\u003eImplement Quality of Service in your environment.\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003c\/div\u003e\u003cdiv\u003e\n\u003ch4\u003eModule 9: Create and manage teams\u003c\/h4\u003e\n\u003cp\u003eLearn about creating teams from various approaches and managing teams' settings and membership. You'll also learn how to archive, restore, and delete a team.\u003c\/p\u003e\n\u003cp\u003e\u003cb\u003eBy the end of this module, you are able to:\u003c\/b\u003e\u003c\/p\u003e\n\u003cul type=\"disc\"\u003e\n\u003cli\u003eCreate new teams\u003c\/li\u003e\n\u003cli\u003eCreate teams from existing resources\u003c\/li\u003e\n\u003cli\u003eCreate an org-wide team\u003c\/li\u003e\n\u003cli\u003eManage team settings\u003c\/li\u003e\n\u003cli\u003eManage users in a team\u003c\/li\u003e\n\u003cli\u003eConfigure dynamic membership for teams\u003c\/li\u003e\n\u003cli\u003eArchive, restore from archive, delete, and restore deleted teams\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003c\/div\u003e\u003cdiv\u003e\n\u003ch4\u003eModule 10: Manage collaboration experiences for chat and channels\u003c\/h4\u003e\n\u003cp\u003eLearn about different controls for collaboration experiences in Microsoft Teams, including managing channel types, creating private channels, messaging policies, and moderation.\u003c\/p\u003e\n\u003cp\u003e\u003cb\u003eBy the end of this module, you will be able to:\u003c\/b\u003e\u003c\/p\u003e\n\u003cul type=\"disc\"\u003e\n\u003cli\u003eManage the creation of private channels\u003c\/li\u003e\n\u003cli\u003eControl the email integration of teams\u003c\/li\u003e\n\u003cli\u003eOrganize the file-sharing functions from the Teams client\u003c\/li\u003e\n\u003cli\u003eCreate and modify messaging policies\u003c\/li\u003e\n\u003cli\u003eUnderstand how to set up channel moderation in Teams\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003c\/div\u003e\u003cdiv\u003e\n\u003ch4\u003eModule 11: Manage apps for Microsoft Teams\u003c\/h4\u003e\n\u003cp\u003eLearn about different settings and policies to manage Teams apps, including which apps are allowed to install, which apps are pinned to users' app bar, and whether users can upload custom apps.\u003c\/p\u003e\n\u003cp\u003e\u003cb\u003eBy the end of this module, you will be able to:\u003c\/b\u003e\u003c\/p\u003e\n\u003cul type=\"disc\"\u003e\n\u003cli\u003eDescribe apps, bots, and connectors in Microsoft Teams\u003c\/li\u003e\n\u003cli\u003eExplore admin settings for Teams apps\u003c\/li\u003e\n\u003cli\u003eManage app permission policies\u003c\/li\u003e\n\u003cli\u003eConfigure app setup policies\u003c\/li\u003e\n\u003cli\u003eManage custom app policies and settings\u003c\/li\u003e\n\u003cli\u003ePublish a custom app in Microsoft Teams\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003c\/div\u003e\u003cdiv\u003e\n\u003ch4\u003eModule 12: Introduction to Teams meetings and calling\u003c\/h4\u003e\n\u003cp\u003eThis module provides an overview of Microsoft Teams communication and collaboration options: Teams phones, auto attendants, call queues, meeting room devices, and different meetings types. It covers the benefits and limitations of Teams Phone while highlighting the importance of Teams devices in modern workplaces.\u003c\/p\u003e\n\u003cp\u003e\u003cb\u003eUpon completion of this module, you'll be able to:\u003c\/b\u003e\u003c\/p\u003e\n\u003cul type=\"disc\"\u003e\n\u003cli\u003eDescribe Teams meetings and events\u003c\/li\u003e\n\u003cli\u003eDescribe Teams Phone\u003c\/li\u003e\n\u003cli\u003eDescribe auto attendants and call queues\u003c\/li\u003e\n\u003cli\u003eDescribe Microsoft Teams Rooms, Teams meeting room devices, and Teams phones\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003c\/div\u003e\u003cdiv\u003e\n\u003ch4\u003eModule 13: Manage meetings and events experiences\u003c\/h4\u003e\n\u003cp\u003eLearn about different meeting solutions in Microsoft Teams, various settings and policies for Teams meetings and live events, and configuration for Audio Conferencing.\u003c\/p\u003e\n\u003cp\u003e\u003cb\u003eBy the end of this module, you will be able to:\u003c\/b\u003e\u003c\/p\u003e\n\u003cul type=\"disc\"\u003e\n\u003cli\u003eUnderstand meetings and events in Microsoft Teams\u003c\/li\u003e\n\u003cli\u003eSet up conference bridges\u003c\/li\u003e\n\u003cli\u003eManage meeting policies\u003c\/li\u003e\n\u003cli\u003eConfigure meeting settings\u003c\/li\u003e\n\u003cli\u003eManage Live events policies\u003c\/li\u003e\n\u003cli\u003eConfigure Live events settings\u003c\/li\u003e\n\u003cli\u003eExplain Live events in Microsoft 365\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003c\/div\u003e\u003cdiv\u003e\n\u003ch4\u003eModule 14: Plan for Microsoft Teams Rooms and Surface Hub\u003c\/h4\u003e\n\u003cp\u003eTeams Meeting Rooms and Surface Hubs are a great way to collaborate with coworkers in and outside your organization. It lets you join scheduled meetings comfortably without logging in to the room device's compute unit. To get started with Microsoft Teams Rooms, you need to understand the differences and potential use cases of the different Teams Room devices, how these devices are technically managed, which licenses are needed and what is essential for a user-friendly physical room installation.\u003c\/p\u003e\n\u003cp\u003e\u003cb\u003eUpon completion of this module, you'll be able to:\u003c\/b\u003e\u003c\/p\u003e\n\u003cul type=\"disc\"\u003e\n\u003cli\u003eUnderstand the main differences between Microsoft Teams Room for Android and Microsoft Teams Rooms for Windows\u003c\/li\u003e\n\u003cli\u003eExplain which accessories, components and peripherals are mandatory\u003c\/li\u003e\n\u003cli\u003eUnderstand the advantages of Surface Hub\u003c\/li\u003e\n\u003cli\u003eUnderstand the difference between the licensing options\u003c\/li\u003e\n\u003cli\u003ePlan and review a physical room layout\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003c\/div\u003e\u003cdiv\u003e\n\u003ch4\u003eModule 15: Configure, deploy, and manage Teams devices\u003c\/h4\u003e\n\u003cp\u003eTeams devices provide a familiar experience and are essential for a hybrid workspace. Learn how to provision and manage devices and associated device accounts.\u003c\/p\u003e\n\u003cp\u003e\u003cb\u003eAt the end of this module, you'll be able to:\u003c\/b\u003e\u003c\/p\u003e\n\u003cul\u003e\n\u003cli\u003eUnderstand scenarios for using Teams phones, Teams displays, and Microsoft Teams Rooms with voice services.\u003c\/li\u003e\n\u003cli\u003eDifferentiate between the different options for deployment and management of devices.\u003c\/li\u003e\n\u003cli\u003eDeploy Teams phones and Teams displays.\u003c\/li\u003e\n\u003cli\u003eConfigure Teams Phone for Microsoft Teams Rooms.\u003c\/li\u003e\n\u003cli\u003eManage Teams devices in the Teams admin center and Teams Rooms Pro Management Portal.\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003c\/div\u003e\u003cdiv\u003e\n\u003ch4\u003eModule 16: Plan for Teams Phone\u003c\/h4\u003e\n\u003cp\u003eLearn about Microsoft Teams Phone and what is needed to make and receive phone calls, and plan for Teams Phone devices, features, and cloud voicemail.\u003c\/p\u003e\n\u003cp\u003e\u003cb\u003eAt the end of this module, you'll be able to:\u003c\/b\u003e\u003c\/p\u003e\n\u003cul type=\"disc\"\u003e\n\u003cli\u003ePlan for a basic Teams Phone deployment.\u003c\/li\u003e\n\u003cli\u003ePlan for advanced Teams Phone calling options.\u003c\/li\u003e\n\u003cli\u003ePlan for Teams phones and devices\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003c\/div\u003e\u003cdiv\u003e\n\u003ch4\u003eModule 17: Configure and deploy Teams Phone\u003c\/h4\u003e\n\u003cp\u003eBefore Microsoft Teams Phone users can make or receive calls and use advanced features, phone numbers must be assigned, and Microsoft Calling plans or Operator Connect must be configured.\u003c\/p\u003e\n\u003cp\u003e\u003cb\u003eAt the end of this module, you'll be able to:\u003c\/b\u003e\u003c\/p\u003e\n\u003cul type=\"disc\"\u003e\n\u003cli\u003eConfigure emergency calling addresses\u003c\/li\u003e\n\u003cli\u003eManage Microsoft Calling Plan numbers\u003c\/li\u003e\n\u003cli\u003eSetup and manage Operator Connect and Teams Phone Mobile\u003c\/li\u003e\n\u003cli\u003eUnderstand Teams Phone policies and configuration options\u003c\/li\u003e\n\u003cli\u003eConfigure Audio Conferencing and Communication Credits\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003c\/div\u003e\u003cdiv\u003e\n\u003ch4\u003eModule 18: Configure and manage voice users\u003c\/h4\u003e\n\u003cp\u003eOngoing management is required as new employees start or if their needs change. Learn how to manage voice user configuration, including enabling voice services and adjusting voice configuration.\u003c\/p\u003e\n\u003cp\u003e\u003cb\u003eAfter completing this module, you'll be able to:\u003c\/b\u003e\u003c\/p\u003e\n\u003cul type=\"disc\"\u003e\n\u003cli\u003eEnable users for Teams Phone using Calling Plans and Teams Phone Mobile or Operator Connect if configured for your tenant.\u003c\/li\u003e\n\u003cli\u003eEnable users for Direct Routing.\u003c\/li\u003e\n\u003cli\u003eManage per-user options for Teams Phone.\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003c\/div\u003e\u003cdiv\u003e\n\u003ch4\u003eModule 19: Configure auto attendants and call queues\u003c\/h4\u003e\n\u003cp\u003eUnderstand how auto attendants and call queues in Microsoft Teams can interact with callers to ensure they connect your agents as quickly as possible. You'll also learn how to set up auto attendants and call queues.\u003c\/p\u003e\n\u003cp\u003e\u003cb\u003eAt the end of this module, you'll be able to:\u003c\/b\u003e\u003c\/p\u003e\n\u003cul type=\"disc\"\u003e\n\u003cli\u003eDescribe the differences between auto attendants and call queues.\u003c\/li\u003e\n\u003cli\u003eDesign an auto attendant to gather information from callers.\u003c\/li\u003e\n\u003cli\u003eExplain how to set up auto attendants to implement your plan.\u003c\/li\u003e\n\u003cli\u003eDemonstrate how to plan call queues to manage many callers.\u003c\/li\u003e\n\u003cli\u003eDescribe how to configure call queues to alert agents and route calls.\u003c\/li\u003e\n\u003cli\u003eExplain how to plan licensing for auto attendants and call queues.\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003c\/div\u003e\u003cdiv\u003e\n\u003ch4\u003eModule 20: Troubleshoot audio, video, and client issues\u003c\/h4\u003e\n\u003cp\u003eLearn about the troubleshooting approaches for audio, video, and client issues in Teams, including collecting appropriate logs and identifying problems with different reports and dashboards.\u003c\/p\u003e\n\u003cp\u003e\u003cb\u003eBy the end of this module, you will be able to:\u003c\/b\u003e\u003c\/p\u003e\n\u003cul\u003e\n\u003cli\u003eDescribe key aspects of Teams troubleshooting\u003c\/li\u003e\n\u003cli\u003eIdentify call quality issues with call analytics\u003c\/li\u003e\n\u003cli\u003eIdentify call quality issues with the Call Quality Dashboard\u003c\/li\u003e\n\u003cli\u003eIdentify call quality issues with the Direct Routing Health Dashboard\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003c\/div\u003e","brand":"Microsoft","offers":[{"title":"269B46US \/ 2026-09-01T09:00:00 \/ Herndon, VA","offer_id":47534222311643,"sku":"US-8567-IL","price":2512.0,"currency_code":"USD","in_stock":true},{"title":"267D20US \/ 2026-07-21T09:00:00 \/ Herndon, VA","offer_id":48216561975515,"sku":"US-8567-IL","price":2512.0,"currency_code":"USD","in_stock":true},{"title":"26BB21US \/ 2026-11-17T09:00:00 \/ Herndon, VA","offer_id":48216562008283,"sku":"US-8567-IL","price":2512.0,"currency_code":"USD","in_stock":true},{"title":"271B24US \/ 2027-01-26T09:00:00 \/ Herndon, VA","offer_id":48216562041051,"sku":"US-8567-IL","price":2512.0,"currency_code":"USD","in_stock":true},{"title":"273B04US \/ 2027-03-30T09:00:00 \/ Herndon, VA","offer_id":48523465228507,"sku":"US-8567-IL","price":2512.0,"currency_code":"USD","in_stock":true},{"title":"276B10US \/ 2027-06-01T09:00:00 \/ Herndon, VA","offer_id":48823756718299,"sku":"US-8567-IL","price":2512.0,"currency_code":"USD","in_stock":true}]},{"product_id":"microsoft-365-key-tools-for-personal-productivity-and-collaboration","title":"Microsoft 365: Key Tools for Personal Productivity and Collaboration","description":"\u003cdiv\u003e\n\u003cp\u003eThis Microsoft Office 365 productivity training course focuses on the collaborative benefits of Microsoft Office 365 – a cloud-based service providing access to desktop applications, mobile apps, and browser-based versions of Microsoft Outlook, Office, SharePoint, OneDrive, and Teams – available anywhere you have an internet connection.\u003c\/p\u003e\r\n\u003cp\u003eLearn how to easily connect and carry out real-time document editing, file sharing, and video conferencing with remote employees from anywhere, using your browser, your phone, or your computer.\u003c\/p\u003e\n\u003c\/div\u003e\u003cdiv\u003e\n\u003ch3\u003eMicrosoft 365: Key Tools for Personal Productivity and Collaboration Benefits\u003c\/h3\u003e\n\u003cul\u003e\n\u003cli\u003e\n\u003cp\u003e\u003cstrong\u003eIn this course, you will learn how to:\u003c\/strong\u003e\u003c\/p\u003e\n\u003cul\u003e\n\u003cli\u003eIncrease your productivity by applying best practice configurations with Microsoft Outlook.\u003c\/li\u003e\n\u003cli\u003eEasily and efficiently manage large quantities of emails, appointments and shared calendars.\u003c\/li\u003e\n\u003cli\u003eUse OneDrive to securely store and access any files, images, or presentations anywhere you have Internet access.\u003c\/li\u003e\n\u003cli\u003eUse a digital notebook to collate text, images, video and handwritten notes in OneNote.\u003c\/li\u003e\n\u003cli\u003eApply SharePoint to collaborate with your colleagues, taking advantage of real-time updating to the same document, spreadsheet, or presentation version.\u003c\/li\u003e\n\u003cli\u003eEnable mobile access to business data and automate processes using Power Apps and Power Automate.\u003c\/li\u003e\n\u003cli\u003eCollaborate inside and outside your organization via chat and voice or video calls using Yammer and Microsoft Teams.\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003c\/li\u003e\n\u003cli\u003e\n\u003cp\u003e\u003cstrong\u003ePrerequisites\u003c\/strong\u003e\u003c\/p\u003e\n\u003cp\u003eNone.\u003c\/p\u003e\n\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003c\/div\u003e\u003cdiv\u003e\u003ch3\u003eKey Tools for Personal Productivity Course Outline\u003c\/h3\u003e\u003c\/div\u003e\u003cdiv\u003e\n\u003ch4\u003eModule 1: Office 365: What, Why, Where, When and How?\u003c\/h4\u003e\n\u003cp\u003eIn this Module, you will learn about:\u003c\/p\u003e\n\u003cul\u003e\n\u003cli\u003eDesktop, web, and mobile access\u003c\/li\u003e\n\u003cli\u003eCore applications and services\u003c\/li\u003e\n\u003cli\u003eMake the best use of Office 365 Plans\u003c\/li\u003e\n\u003cli\u003eOffice 365 administration\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003c\/div\u003e\u003cdiv\u003e\n\u003ch4\u003eModule 2: Personal Information Management\u003c\/h4\u003e\n\u003cp\u003eIn this Module, you will learn about:\u003c\/p\u003e\n\u003cul\u003e\n\u003cli\u003eOutlook Everywhere\u003c\/li\u003e\n\u003cli\u003eDesktop, Web, or Mobile. Which to use?\u003c\/li\u003e\n\u003cli\u003eManage your time and focus effectively with Outlook\u003c\/li\u003e\n\u003cli\u003eCalendar: Plan out your day\u003c\/li\u003e\n\u003cli\u003eTasks: Review and prioritize\u003c\/li\u003e\n\u003cli\u003eMail: Tips to manage the overwhelm\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003c\/div\u003e\u003cdiv\u003e\n\u003ch4\u003eModule 3: OneDrive: Personal Document Management\u003c\/h4\u003e\n\u003cp\u003eIn this Module, you will learn about:\u003c\/p\u003e\n\u003cul\u003e\n\u003cli\u003eAccessing your documents from anywhere, anytime! Automatically synchronize your files\u003c\/li\u003e\n\u003cli\u003eOffice applications: Desktop, web, and mobile\u003c\/li\u003e\n\u003cli\u003eCreate and update documents in OneDrive\u003c\/li\u003e\n\u003cli\u003eCollate digital notes in OneNote\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003c\/div\u003e\u003cdiv\u003e\n\u003ch4\u003eModule 4: SharePoint: Document and Information Management\u003c\/h4\u003e\n\u003cp\u003eIn this Module, you will learn about:\u003c\/p\u003e\n\u003cul\u003e\n\u003cli\u003eSharePoint structure and management\u003c\/li\u003e\n\u003cli\u003eBuilding a modern intranet with hub sites\u003c\/li\u003e\n\u003cli\u003eWhen to use Team sites v Communication sites\u003c\/li\u003e\n\u003cli\u003eCreating custom lists v list templates\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003c\/div\u003e\u003cdiv\u003e\n\u003ch4\u003eModule 5: Build Mobile and Web Business Apps with Power Apps\u003c\/h4\u003e\n\u003cp\u003eIn this Module, you will learn about:\u003c\/p\u003e\n\u003cul\u003e\n\u003cli\u003eWhat kind of apps can you build?\u003c\/li\u003e\n\u003cli\u003eWho can build them?\u003c\/li\u003e\n\u003cli\u003eWhat do you need?\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003c\/div\u003e\u003cdiv\u003e\n\u003ch4\u003eModule 6: Automating Business Processes with Power Automate\u003c\/h4\u003e\n\u003cp\u003eIn this Module, you will learn about:\u003c\/p\u003e\n\u003cul\u003e\n\u003cli\u003eBuilding blocks of a Flow\u003c\/li\u003e\n\u003cli\u003eEvents\u003c\/li\u003e\n\u003cli\u003eActions\u003c\/li\u003e\n\u003cli\u003eConditions\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003c\/div\u003e\u003cdiv\u003e\n\u003ch4\u003eModule 7: Microsoft Teams: Intelligent Collaboration and Communication\u003c\/h4\u003e\n\u003cp\u003eIn this Module, you will learn about:\u003c\/p\u003e\n\u003cul\u003e\n\u003cli\u003eWhat is Microsoft Teams?\u003c\/li\u003e\n\u003cli\u003eScheduling and managing video meetings\u003c\/li\u003e\n\u003cli\u003eCreating a Team\u003c\/li\u003e\n\u003cli\u003eAdding members to a team\u003c\/li\u003e\n\u003cli\u003eAdding channels and tabs\u003c\/li\u003e\n\u003cli\u003eUsing @mentions, notifications, and checking activity\u003c\/li\u003e\n\u003cli\u003eTeams best practices\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003c\/div\u003e","brand":"Learning Tree","offers":[{"title":"269B30US \/ 2026-09-01T09:00:00 \/ Herndon, VA","offer_id":47534222377179,"sku":"US-978-IL","price":2512.0,"currency_code":"USD","in_stock":true},{"title":"26CA92US \/ 2026-12-01T09:00:00 \/ Herndon, VA","offer_id":48216564957403,"sku":"US-978-IL","price":2512.0,"currency_code":"USD","in_stock":true},{"title":"273A97US \/ 2027-03-02T09:00:00 \/ Herndon, VA","offer_id":48310907273435,"sku":"US-978-IL","price":2512.0,"currency_code":"USD","in_stock":true},{"title":"276B02US \/ 2027-06-01T09:00:00 \/ Herndon, VA","offer_id":48823756161243,"sku":"US-978-IL","price":2512.0,"currency_code":"USD","in_stock":true}]},{"product_id":"automating-excel-with-macros-training","title":"Automating Excel with Macros Training","description":"\u003cdiv\u003e\n\u003cp\u003eEnhance your existing knowledge of Excel with the power of macros. In this Excel Macro training course, you will learn how to create a macro in Excel, then modify and enhance it to automate repetitive Excel-related tasks. You also learn how to troubleshoot code errors in existing macros, log data changes into multiple tables, implement code from the web, and design simple user interfaces to vastly improve your productivity.\u003c\/p\u003e\r\n\u003cp\u003e\u003c\/p\u003e\r\n\u003cul\u003e\u003c\/ul\u003e\r\n\u003cul\u003e\r\n\u003cli style=\"list-style-type: none;\"\u003e\r\n\u003cul\u003e\r\n\u003cli\u003e\r\n\u003c\/li\u003e\n\u003c\/ul\u003e\r\n\u003c\/li\u003e\r\n\u003c\/ul\u003e\r\n\u003cp\u003e\u003c\/p\u003e\r\n\u003cp\u003e\u003c\/p\u003e\r\n\u003cul\u003e\r\n\u003cli\u003eThis course is applicable to all versions of Excel, from Excel 97 to Excel 2016\u003c\/li\u003e\r\n\u003c\/ul\u003e\r\n\u003cp\u003e\u003c\/p\u003e\n\u003c\/div\u003e\u003cdiv\u003e\n\u003ch3\u003eAutomating Excel with Macros Training Benefits\u003c\/h3\u003e\n\u003cul\u003e\n\u003cli\u003e\n\u003cp\u003e\u003cstrong\u003eIn this course, you will be able to:\u003c\/strong\u003e\u003c\/p\u003e\n\u003cul\u003e\n\u003cli\u003eDevelop macros to automate repetitive workbook processes\u003c\/li\u003e\n\u003cli\u003eTranslate statements from Visual Basic for Applications into Excel actions\u003c\/li\u003e\n\u003cli\u003eDebug code in the Visual Basic Editor\u003c\/li\u003e\n\u003cli\u003eModify code so that it can refer to dynamic ranges\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003c\/li\u003e\n\u003cli\u003e\n\u003cp\u003e\u003cstrong\u003ePrerequisites\u003c\/strong\u003e\u003c\/p\u003e\n\u003cul\u003e\n\u003cli\u003eKnowledge of Excel at the level of Course 1361, Microsoft Excel Training Course\u003c\/li\u003e\n\u003cli\u003eExperience at the level of Course 195, Excel Data Analysis Course\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003c\/div\u003e\u003cdiv\u003e\u003ch3\u003eExcel Macro Course Outline\u003c\/h3\u003e\u003c\/div\u003e\u003cdiv\u003e\n\u003ch4\u003eOutline\u003c\/h4\u003e\n\u003cul\u003e\n\u003cli\u003eCreating, modifying and enhancing macros\u003c\/li\u003e\n\u003cli\u003eEnriching macro execution with controls\u003c\/li\u003e\n\u003cli\u003eTroubleshooting code errors in existing macros\u003c\/li\u003e\n\u003cli\u003eLogging data changes into multiples tables\u003c\/li\u003e\n\u003cli\u003eImplementing code from the web\u003c\/li\u003e\n\u003cli\u003eSimplifying code execution with variables\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003c\/div\u003e","brand":"Learning Tree","offers":[{"title":"268A11US \/ 2026-08-18T09:00:00 \/ Online","offer_id":47469817233627,"sku":"US-4612-IL","price":716.0,"currency_code":"USD","in_stock":true},{"title":"26BA24US \/ 2026-11-30T09:00:00 \/ Online","offer_id":48050329813211,"sku":"US-4612-IL","price":716.0,"currency_code":"USD","in_stock":true},{"title":"273A02US \/ 2027-03-04T09:00:00 \/ Online","offer_id":48316157165787,"sku":"US-4612-IL","price":716.0,"currency_code":"USD","in_stock":true},{"title":"276A01US \/ 2027-06-01T09:00:00 \/ Online","offer_id":48823759896795,"sku":"US-4612-IL","price":716.0,"currency_code":"USD","in_stock":true}]},{"product_id":"dynamics-365-business-central-training-mb-800","title":"Manage business solutions with Microsoft Dynamics 365 Business Central (MB-800)","description":"\u003cdiv\u003e\u003cp\u003eThis comprehensive \u003cstrong\u003eMicrosoft Dynamics 365 Business Central course \u003c\/strong\u003eequips participants with the skills to configure, customize, and use Business Central effectively across core business functions. Through a blend of functional and technical learning paths, you’ll explore system setup, financial management, sales and purchasing, inventory and warehouse operations, reporting, data management, and process automation with Power Apps and Power Automate. Whether you are a functional consultant, developer, business analyst, or business user, this training provides the practical knowledge needed to streamline operations, improve decision-making, and maximize the value of Dynamics 365 Business Central in your organization.\u003c\/p\u003e\u003c\/div\u003e\u003cdiv\u003e\n\u003ch3\u003eManage business solutions with Microsoft Dynamics 365 Business Central (MB-800) Benefits\u003c\/h3\u003e\n\u003cul\u003e\n\u003cli\u003e\n\u003cp\u003eIn this hands-on course, you will gain the skills to implement, configure, and support Microsoft Dynamics 365 Business Central for a variety of business needs. You will learn how to:\u003c\/p\u003e\n\u003cul type=\"disc\"\u003e\n\u003cli\u003eIdentify and apply the right Business Central modules for specific business scenarios\u003c\/li\u003e\n\u003cli\u003eSet up and configure core Business Central functionality\u003c\/li\u003e\n\u003cli\u003eConfigure and manage Financials\u003c\/li\u003e\n\u003cli\u003eConfigure and manage Sales and Purchasing processes\u003c\/li\u003e\n\u003cli\u003eConfigure and optimize Operations\u003c\/li\u003e\n\u003cli\u003eIntegrate Business Central with other Microsoft solutions and automate processes with Power Platform tools\u003c\/li\u003e\n\u003cli\u003eExtend your learning with after-course one-on-one instructor coaching to tackle real-world challenges\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003c\/li\u003e\n\u003cli\u003e\n\u003cp\u003e\u003cstrong\u003ePrerequisites\u003c\/strong\u003e\u003c\/p\u003e\n\u003cp\u003eA Dynamics 365 Business Central consultant needs in-depth knowledge of the software, including financial management, sales, purchasing, and inventory.\u003c\/p\u003e\n\u003cp\u003eFamiliarity with industry standards and Microsoft 365\/Dynamics 365 suites is also important.\u003c\/p\u003e\n\u003c\/li\u003e\n\u003cli\u003e\n\u003cp\u003e\u003cstrong\u003eExam Information \u003c\/strong\u003e\u003c\/p\u003e\n\u003cp\u003eThis course can help you prepare for the following Microsoft role-based certification exam — \u003ca href=\"https:\/\/docs.microsoft.com\/en-us\/certifications\/exams\/mb-800\" target=\"_blank\" rel=\"nofollow noopener\" title=\"Exam MB-800: Microsoft Dynamics 365 Business Central Functional Consultant\"\u003eMB-800: Microsoft Dynamics 365 Business Central Functional Consultant\u003c\/a\u003e.\u003c\/p\u003e\n\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003c\/div\u003e\u003cdiv\u003e\u003ch3\u003eDynamics 365 Business Central Functional Consultant Training Outline\u003c\/h3\u003e\u003c\/div\u003e\u003cdiv\u003e\n\u003ch4\u003eLearning Objectives\u003c\/h4\u003e\n\u003cul\u003e\n\u003cli\u003eDeploy and configure Microsoft Dynamics 365 Business Central\u003c\/li\u003e\n\u003cli\u003eUse journals in Microsoft Dynamics 365 Business Central\u003c\/li\u003e\n\u003cli\u003eBuild reports for Microsoft Dynamics 365 Business Central\u003c\/li\u003e\n\u003cli\u003eDevelop using Power Apps and Power Automate for Dynamics 365 Business Central\u003c\/li\u003e\n\u003cli\u003eConfigure Sales and Purchasing\u003c\/li\u003e\n\u003cli\u003eReconcile bank accounts in Microsoft Dynamics 365 Business Central\u003c\/li\u003e\n\u003cli\u003eSet up financial management in Microsoft Dynamics 365 Business Central\u003c\/li\u003e\n\u003cli\u003eGet started with Trade in Microsoft Dynamics 365 Business Central\u003c\/li\u003e\n\u003cli\u003eProcess customer and vendor payments in Microsoft Dynamics 365 Business Central\u003c\/li\u003e\n\u003cli\u003eGet started with inventory management in Microsoft Dynamics 365 Business Central\u003c\/li\u003e\n\u003cli\u003eSet up warehouse management in Microsoft Dynamics 365 Business Central\u003c\/li\u003e\n\u003cli\u003eSell items and services in Microsoft Dynamics 365 Business Central\u003c\/li\u003e\n\u003cli\u003eWork with the Microsoft Dynamics 365 Business Central user interface\u003c\/li\u003e\n\u003cli\u003eSet up Microsoft Dynamics 365 Business Central for reporting\u003c\/li\u003e\n\u003cli\u003eWork like a pro with data in Business Central\u003c\/li\u003e\n\u003cli\u003ePurchase items and services in Microsoft Dynamics 365 Business Central\u003c\/li\u003e\n\u003cli\u003eReturn items in Microsoft Dynamics 365 Business Central\u003c\/li\u003e\n\u003cli\u003eAssemble items in Microsoft Dynamics 365 Business Central\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003c\/div\u003e","brand":"Microsoft","offers":[{"title":"267A47US \/ 2026-07-06T09:00:00 \/ Herndon, VA","offer_id":47534206320859,"sku":"US-8663-IL","price":2512.0,"currency_code":"USD","in_stock":true},{"title":"271B65US \/ 2027-01-04T09:00:00 \/ Herndon, VA","offer_id":48216583405787,"sku":"US-8663-IL","price":2512.0,"currency_code":"USD","in_stock":true}]},{"product_id":"excel-data-analysis-course","title":"Excel Data Analysis Course","description":"\u003cdiv\u003e\n\u003cp\u003eThis hands-on \u003cstrong\u003eExcel data analysis course\u003c\/strong\u003e will expand your ability to analyze large amounts of data and professionally present your results. Gain the knowledge and skills to build more sophisticated spreadsheets, perform What-If analyses, apply functions, manipulate PivotTables, and use the advanced features of Excel to make and present better business decisions. \u003c\/p\u003e\r\n\u003cp\u003eIn this excel data analysis course, you use advanced Excel techniques to build sophisticated spreadsheets. You learn to perform \"What-If\" analyses, leverage features and apply functions, manipulate PivotTables to analyze large amounts of data, and present your results to make better business decisions for planning and budgeting. You also learn how to automate processes and enhance worksheet models. \u003c\/p\u003e\n\u003c\/div\u003e\u003cdiv\u003e\n\u003ch3\u003eExcel Data Analysis Course Benefits\u003c\/h3\u003e\n\u003cul\u003e\n\u003cli\u003e\n\u003cp\u003e\u003cstrong\u003eIn this Excel Data Analysis course, you will learn to:\u003c\/strong\u003e\u003c\/p\u003e\n\u003cul\u003e\n\u003cli\u003eLeverage features of Microsoft Excel to facilitate business decisions.\u003c\/li\u003e\n\u003cli\u003eDevelop intelligent worksheets to identify KPIs quickly.\u003c\/li\u003e\n\u003cli\u003ePerform \"What-If\" analyses for developing budget and project plans.\u003c\/li\u003e\n\u003cli\u003eSummarize and analyze large amounts of data using PivotTables and Excel features.\u003c\/li\u003e\n\u003cli\u003eAutomate Excel processes.\u003c\/li\u003e\n\u003cli\u003eContinue learning and face new challenges with after-course one-on-one instructor coaching.\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003c\/li\u003e\n\u003cli\u003e\n\u003cp\u003e\u003cstrong\u003eExcel Data Analysis Course Prerequisites\u003c\/strong\u003e\u003c\/p\u003e\n\u003cp\u003eYou should have experience with Excel fundamentals at the level of Microsoft Excel Training Course.\u003c\/p\u003e\n\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003c\/div\u003e\u003cdiv\u003e\u003ch3\u003eExcel Data Analysis Instructor-Led Course Outline\u003c\/h3\u003e\u003c\/div\u003e\u003cdiv\u003e\n\u003ch4\u003eModule 1: Troubleshooting and Enhancing Professional Workbooks\u003c\/h4\u003e\n\u003cul\u003e\n\u003cli\u003eDeciphering and correcting functions for data integrity \u003c\/li\u003e\n\u003cli\u003eAccurately interpreting calculations \u003c\/li\u003e\n\u003cli\u003eImplementing Names to enhance your workbook model \u003c\/li\u003e\n\u003cli\u003eMonitoring KPIs (key performance indicators) using conditional formatting \u003c\/li\u003e\n\u003c\/ul\u003e\n\u003c\/div\u003e\u003cdiv\u003e\n\u003ch4\u003eModule 2: Analyzing Data with Functions\u003c\/h4\u003e\n\u003cp\u003eSummarizing business data with functions  \u003c\/p\u003e\n\u003cul\u003e\n\u003cli\u003eIdentifying the correct statistical function to aid analysis \u003c\/li\u003e\n\u003cli\u003eApplying basic financial functions \u003c\/li\u003e\n\u003cli\u003eDifferentiating serial dates and date presentations \u003c\/li\u003e\n\u003cli\u003eCalculating the number of working days \u003c\/li\u003e\n\u003c\/ul\u003e\n\u003cp\u003eControlling calculations and nested formulas  \u003c\/p\u003e\n\u003cul\u003e\n\u003cli\u003eInterpreting data variations with the IF function \u003c\/li\u003e\n\u003cli\u003eStreamlining calculations with referencing \u003c\/li\u003e\n\u003cli\u003eDeveloping nested functions for multiple conditions \u003c\/li\u003e\n\u003cli\u003eCapturing information with lookup functions \u003c\/li\u003e\n\u003cli\u003eApplying techniques to implement and troubleshoot nested calculations \u003c\/li\u003e\n\u003c\/ul\u003e\n\u003c\/div\u003e\u003cdiv\u003e\n\u003ch4\u003eModule 3: Optimizing Workbook Models with \"What-If\" Analysis\u003c\/h4\u003e\n\u003cp\u003ePlanning for contingencies  \u003c\/p\u003e\n\u003cul\u003e\n\u003cli\u003eManaging variables in worksheets with Scenarios \u003c\/li\u003e\n\u003cli\u003eComparing and contrasting different data sets with Scenarios reports \u003c\/li\u003e\n\u003c\/ul\u003e\n\u003cp\u003eQuantifying variables in a workbook model  \u003c\/p\u003e\n\u003cul\u003e\n\u003cli\u003eDetermining the magnitude of a variable with Goal Seek to achieve an end value \u003c\/li\u003e\n\u003cli\u003eCalculating the optimum variable values in a worksheet model with Solver \u003c\/li\u003e\n\u003c\/ul\u003e\n\u003c\/div\u003e\u003cdiv\u003e\n\u003ch4\u003eModule 4: Summarizing Business Information\u003c\/h4\u003e\n\u003cp\u003eOrganizing workbooks and links  \u003c\/p\u003e\n\u003cul\u003e\n\u003cli\u003eArranging multiple workbooks with Workspaces \u003c\/li\u003e\n\u003cli\u003eManaging external links \u003c\/li\u003e\n\u003c\/ul\u003e\n\u003cp\u003eConsolidating ranges  \u003c\/p\u003e\n\u003cul\u003e\n\u003cli\u003eBuilding 3D formulas to analyze worksheet data \u003c\/li\u003e\n\u003cli\u003eSummarizing multiple sources of Excel information into one worksheet \u003c\/li\u003e\n\u003c\/ul\u003e\n\u003c\/div\u003e\u003cdiv\u003e\n\u003ch4\u003eModule 5: Formulating Decisions from Database Information\u003c\/h4\u003e\n\u003cp\u003eDistilling data sets for data analysis  \u003c\/p\u003e\n\u003cul\u003e\n\u003cli\u003eDefining the architecture of an Excel data set \u003c\/li\u003e\n\u003cli\u003eManaging multiple data sets on a single worksheet with the Table feature \u003c\/li\u003e\n\u003cli\u003eExtracting unique lists of records from an Excel data set with the Advanced Filter \u003c\/li\u003e\n\u003cli\u003eAnalyzing data sets with filters and aggregation \u003c\/li\u003e\n\u003c\/ul\u003e\n\u003cp\u003eInterpreting and refining data with PivotTables  \u003c\/p\u003e\n\u003cul\u003e\n\u003cli\u003eDefining data summaries interactively \u003c\/li\u003e\n\u003cli\u003eSummarizing data sets with grouping and aggregation \u003c\/li\u003e\n\u003cli\u003eComparing related totals dynamically \u003c\/li\u003e\n\u003c\/ul\u003e\n\u003cp\u003eVisualizing and exploring PivotTable reports  \u003c\/p\u003e\n\u003cul\u003e\n\u003cli\u003eFiltering details with Report Filters and Slicers \u003c\/li\u003e\n\u003cli\u003ePresenting PivotTable reports effectively with Pivot Charts \u003c\/li\u003e\n\u003cli\u003eExamining data patterns with Sparklines \u003c\/li\u003e\n\u003c\/ul\u003e\n\u003c\/div\u003e\u003cdiv\u003e\n\u003ch4\u003eModule 6: Enhancing Excel Usage with Macros\u003c\/h4\u003e\n\u003cp\u003eAutomating repetitive tasks  \u003c\/p\u003e\n\u003cul\u003e\n\u003cli\u003eSimplifying complex tasks and reducing errors \u003c\/li\u003e\n\u003cli\u003eBulletproofing routine editing and formatting \u003c\/li\u003e\n\u003cli\u003eInvoking macros with Form controls \u003c\/li\u003e\n\u003c\/ul\u003e\n\u003c\/div\u003e","brand":"Learning Tree","offers":[{"title":"267A83US \/ 2026-07-13T09:00:00 \/ Herndon, VA","offer_id":47534175322331,"sku":"US-195-IL","price":1640.0,"currency_code":"USD","in_stock":true},{"title":"269A19CN \/ 2026-09-28T09:00:00 \/ Ottawa","offer_id":47634346541275,"sku":"US-195-IL","price":1640.0,"currency_code":"USD","in_stock":true},{"title":"266A67CN \/ 2026-06-29T09:00:00 \/ Online","offer_id":48216539005147,"sku":"US-195-IL","price":1640.0,"currency_code":"USD","in_stock":true},{"title":"26AB30US \/ 2026-10-05T09:00:00 \/ Austin","offer_id":48216539037915,"sku":"US-195-IL","price":1640.0,"currency_code":"USD","in_stock":true},{"title":"26BB56US \/ 2026-11-24T09:00:00 \/ Herndon, VA","offer_id":48216539070683,"sku":"US-195-IL","price":1640.0,"currency_code":"USD","in_stock":true},{"title":"272A07CN \/ 2027-02-01T09:00:00 \/ Ottawa","offer_id":48216539103451,"sku":"US-195-IL","price":1640.0,"currency_code":"USD","in_stock":true},{"title":"273B26US \/ 2027-03-01T09:00:00 \/ Austin","offer_id":48309393981659,"sku":"US-195-IL","price":1640.0,"currency_code":"USD","in_stock":true},{"title":"274B13US \/ 2027-04-26T09:00:00 \/ Herndon, VA","offer_id":48669350756571,"sku":"US-195-IL","price":1640.0,"currency_code":"USD","in_stock":true}]}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0691\/4143\/0491\/collections\/cPCV86SA2BdAlJOkA32H_327b8b21-f49e-429d-a747-11b90d67cf32.webp?v=1780655634","url":"https:\/\/learningtreeinternational-dirinfosec-hhs.myshopify.com\/collections\/dynamics.oembed","provider":"Learning Tree International","version":"1.0","type":"link"}