Filter by Topic
Filter by Vendor
Get Going With QuickBooks 2021 for Windows
Course Description First-time QuickBooks users will learn the basic features …
Get Smart With QuickBooks 2021 for Windows
Course Description First-time QuickBooks users will learn the basic features …
55049-A: PowerPivot, Power View and SharePoint 2013 Business Intelligence Center for Analysts
Course Description: This two-day instructor-led course concentrates on PowerPivot and …
What you'll learn
Successfully log into their virtual machine.
Use PowerPivot 2013 in Excel.
Work with DAX.
Create Power View visualizations.
Understand data models.
Save to SharePoint.
Surface on SharePoint.
Work with the SharePoint Business Intelligence Center.
Create dedicated apps in SharePoint for PowerPivot and Power View.
Use PowerPivot within Excel to import a table from SQL Server.
Use PowerPivot within Excel to import a table from SQL Server Analysis Services.
Hide columns they don’t want reflected in the resulting PivotTable.
View the relationships existing within the imported tables from SQL Server and then import an additional table and configure a relationship between it and the existing.
Create a PivotTable within an existing worksheet.
Navigate and successfully use Power View.
Create a table.
Create a chart.
Save and share their work.
Create a BI semantic model.
Explore the options and settings available within the new SharePoint 2013 Central Administration and Excel Services.
Access and review the Secure Store.
Create a new web application and business intelligence site while exploring the features of both.
Create custom apps to store visualizations and/or workbooks in SharePoint 2013 Business Intelligence Center.
55164-A: Quick Powerful Graphics with Power View, PowerPivot, Power Query, Power Map and Power BI
Course Description: This is a 2-days course designed to teach …
What you'll learn
Navigate the Power View interface.
Utilize Power View reports.
Work with tables.
Understand aggregations.
Utilize matrix.
Configure drill through.
Use cards as a visualization.
Apply filters.
Create charts.
Utilize tiles.
Add slicers to reports.
Utilize themes.
Navigate the PowerPivot interface.
Examine and configure relationships.
Configure calculated columns are calculated fields.
Create PivotTables.
Understand and utilize DAX.
Work with hierarchies.
Manage perspectives.
Navigate the Power Query interface.
Merge datasets.
Manage modifications.
Perform data cleaning.
Navigate the Power Map interface.
Use Bing maps.
Examine map data.
Configure tours, scenes, and layers.
Add time to a presentation.
Navigate the Power BI interface.
Utilize data sources.
Understand querying with natural language.
Successfully log into their virtual machine.
Have a full understanding of what the course intends to cover.
55121-A: Microsoft Project 2013
Course Description: This two-day instructor-led course is intended for IT …
What you'll learn
Understand the terminology.
Understand project management basics.
Understand and utilize the Microsoft Project 2013 Interface.
Create and configure calendars.
Configure scheduling.
Utilize and navigate views.
Create tasks.
Modify tasks.
Delete tasks.
Create resources.
Assign tasks to resources.
Monitor resources and their tasks.
Delete resources.
Track project progress.
Create and configure reports.
Accurately troubleshoot a project.
Close a project.
Share the project using OneDrive.
Share the project using Project Server 2013 or Project Online.
Share and sync the project using SharePoint 2013.
55298-A: Introduction to SharePoint 2019
Course Description: This Introduction to SharePoint 2019 class is for …
What you'll learn
Learn to navigate a SharePoint 2019 Team Site.
Learn to create SharePoint lists.
Learn to customize SharePoint Lists.
Learn to create SharePoint libraries.
Learn to manage library document versions.
Learn to create SharePoint list and library views.
Learn to integrate Office Outlook and Excel applications with SharePoint 2019.
Understand the versions of SharePoint
Understand the SharePoint site hierarchy.
Understand Team Site layout.
Understand navigation with a Team Site.
Understand List Templates.
Work with default lists in a Team Site.
Create a new list from a List Template.
Create a custom list.
Add columns to a list.
Control and validate input into list fields.
Create new libraries using library templates.
Add columns to a library.
Check out documents for editing.
Delete and restore documents from document libraries.
Enable versioning on a library.
Revert a library document to an earlier version.
Use default views built into lists and libraries.
Create shared views.
Configure views.
Set the default view for a list or library.
Create a list from an Excel spreadsheet.
Create an alert in Outlook.
Understand what Site Templates are.
Understand different types of Site Templates that come “Out of the Box” with different versions
Create a new site using Site Templates.
Create a Project site.
Create a Team site.
Create a Community site.
Create a Blog site.
Manage the sites listed in the Top Link Bar.
Microsoft Office OneNote 2016
Course Description: In our fast-paced digital world, the need to …
What you'll learn
In this course, you will develop digital note-taking skills by creating, modifying, and managing OneNote notebooks that work with other Microsoft Office programs.
Navigate and customize the OneNote interface and environment.
Add and format text, images, audio, links, and drawing objects to a notebook.
Embed Excel spreadsheets and attach other files to a notebook.
Categorize, organize, and search notebook content.
Check spelling in, print, and password-protect notebooks.
Use Outlook and OneDrive to send and share notebook content.
Export notebook content and manage notebook history and backups.
Featured
Microsoft Office Word 2019: Part 3
Course Description: Microsoft® Word enables you to do far more …
What you'll learn
Use images in a document.
Create custom graphic elements.
Collaborate on documents.
Add reference marks and notes.
Secure a document.
Create and manipulate forms.
Create macros to automate tasks.
