Most popular
Intermediate
55164-A: Quick Powerful Graphics with Power View, PowerPivot, Power Query, Power Map and Power BI
$1,590.00
55164-A: Quick Powerful Graphics with Power View, PowerPivot, Power Query, Power Map and Power BI
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.
55299-A: SharePoint 2019 Site Owner Training
What you'll learn
Learn to navigate a SharePoint 2019 Team Site.
Learn to create and edit web page content.
Learn to create site columns and content types.
Learn to integrate Office applications with SharePoint 2019.
Learn to manage basic permissions
Understand what Site Templates are.
Understand the different Tpes of Site Templates that come “Out of the Box”
Creating 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.
Understand what site pages are.
Understand what wiki pages are.
Understand what Web Parts are.
Understand how to add content to the Site Home page.
Understand how to create a wiki page library.
Understand how to add Web Parts.
Understand how to manage Web Parts.
Understand Site Columns.
Understand Content Types.
Understand how to create Site Columns.
Understand how to create Content Types.
Understand how to create a document template for a Content Type.
Understan how to assign a Content Type to a list or library.
Understand how to create new items based on a custom Content Type.
Understand SharePoint groups.
Understand how to create SharePoint groups.
Understand how to assign permission in SharePoint.
Understand how to view permission levels.
Understand how to manage permission inheritance at the site level.
Understand how to manage permission inheritance at the list or library level.
Understand how to edit a personal profile.
Microsoft Project 2016: Level 1
What you'll learn
Upon successful completion of this course, you will be able to perform advanced data analysis, collaborate on workbooks with other users, and automate workbook functionality.
Identify project management concepts and navigate the Project 2016 environment.
Create and define a new project plan.
Create and organize tasks.
Manage resources in a project plan.
Finalize a project plan.
Microsoft Visio 2019: Part 1
What you'll learn
In this course, you will design, modify, and manage basic diagrams.
Identify the basic elements of Visio and their use.
Create a workflow diagram.
Build organization charts.
Design a floor plan.
Build a cross-functional flowchart.
Design a network diagram.
Style a diagram.
Developing SQL Data Models
What you'll learn
Components, architecture, and nature of a BI solution
Create a multidimensional database with analysis services
Implement dimensions in a cube
Implement measures and measure groups in a cube
Use MDX syntax
Customize a cube
Implement a tabular database
Use DAX to query a tabular model
Use data mining for predictive analysis
55054-A: Mastering Microsoft Project 2013
What you'll learn
Understand the discipline of project management as it applies to using Microsoft Project 2013.
Create a Work Breakdown Structure.
Identify Task Types & Relationships.
Define Resources within Project.
Make Work Package Estimates.
Create an Initial Schedule.
Create a Resource Leveled Schedule.
Create Projects from templates, Excel files.
Create Global templates.
Create formulas and graphical indicators.
The steps to record a macro.
Format Output and Print Reports.
Integrate Multiple Projects.
Set up a Project with a Calendar, Start date, and scheduling method.
Understand Manually Schedule vs. Auto Schedule.
Manage multiple projects.
Be able to create a master project list with shared resources.
Have a fundamental understanding of how Microsoft Project will help them track their projects.
Understand what is new in Project 2013 and how it will increase their productivity.
Learn how the ribbon will help them get the most of out of this productivity tool.
Learn how to quickly change views and see what is going on with their projects.
Understand the 5 essential steps in building a successful project plan.
Prepare a new project plan and set the date and other basic information.
Enter detailed project information.
Understand how to sequence tasks.
Understand and define basic resource types.
Assign resources to tasks.
Understand the benefits of baselining a project or specific tasks.
Understand the basics of how to track project progress.
Create a new project using a template, Excel, a SharePoint Tasks List or a new Project file.
Establish one or more calendars to constrain resource availability.
Configure Microsoft Project to calculate the schedule from the Start Date forward or from the Finish Date backward.
Understand how to turn on Manually Schedule and Auto Schedule.
Understand when to use Manually Schedule.
Understand the limitations of Manually Scheduling.
Build and use summary and subordinate tasks.
Understand and use milestones.
How to organize the WBS.
How to format the WBS.
Develop WBS outlines.
Assign completion criteria.
Evaluate the WBS.
Understand and use WBS outlines.
Understand how to link Project artifacts to their projects.
Understand how to create notes on tasks.
Understand the different types of task relationships.
Understand and use various methods to create relationships.
Determine and display task sequence.
Understand how to use Lag, Lead and Delay.
Define the different types of resources.
Define individual resources that will be used on the project.
Record the cost(s) of using each type of resource.
Record the limit of availability for each type of resource by establishing a resource calendar and defining the maximum units of that resource.
Assign values for resources, duration and work.
Understand task types.
Understand Effort Driven scheduling.
Understand material resources and their costs to a project plan.
Identify the critical path.
Understand difference between slack and slippage.
Calculate float.
How to leverage constraints.
How to get the benefit from the Task Inspector, and the impact of changes on a project schedule.
Adjust a project schedule to account for limited resources.
View the overall cost and schedule of a project.
Identify resources that are over- allocated for a project schedule.
Use multiple ways to adjust tasks and assignments to remove over- allocation for any resource.
Set a baseline.
Enter and manage project performance data.
Pick a tracking method.
Perform variance analysis.
Sync Projects results with SharePoint.
Create standardized views, with the power of sorting, filtering and grouping.
Customize a variety of standard reports.
Learn how to use Visual Reports.
Export reports in a variety of formats.
Use common resources among multiple projects.
Link tasks between multiple projects.
Create a consolidated view of multiple projects and shared resources.
Take advantage of the advance features of Microsoft Project 2013.
Be able to create a Macro.
Share common settings among all future projects.
Featured
Microsoft Office Excel (2019-2016-2013): Basic
What you'll learn
Get started with Microsoft Office Excel.
Perform calculations.
Modify a worksheet.
Format a worksheet.
Print workbooks.
Manage workbooks.
Microsoft Project 2016: Level 2
What you'll learn
Upon successful completion of this course, you will be able to perform advanced data analysis, collaborate on workbooks with other users, and automate workbook functionality.
Update a project plan to reflect progress as you execute the project.
Monitor project progress in the project plan.
Adjust the project plan to control constraints.
Create project reports to share project status.
Customize project settings and share customizations with other projects.
Microsoft Visio 2019: Part 2
What you'll learn
In this course, you will examine advanced features to make you more efficient and effective.
Design advanced plans and diagrams.
Enhance the look of drawings.
Create shapes, stencils, and templates.
Connect drawings to external data.
Leverage development tools.
Share drawings.
Featured
55315: Introduction To SQL Databases
What you'll learn
Describe key database concepts in the context of SQL Server
Describe database languages used in SQL Server
Describe data modelling techniques
Describe normalization and denormalization techniques
Describe relationship types and effects in database design
Describe the effects of database design on performance
Describe commonly used database objects
Trending
Intermediate
55164-A: Quick Powerful Graphics with Power View, PowerPivot, Power Query, Power Map and Power BI
$1,590.00
55164-A: Quick Powerful Graphics with Power View, PowerPivot, Power Query, Power Map and Power BI
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.
55299-A: SharePoint 2019 Site Owner Training
What you'll learn
Learn to navigate a SharePoint 2019 Team Site.
Learn to create and edit web page content.
Learn to create site columns and content types.
Learn to integrate Office applications with SharePoint 2019.
Learn to manage basic permissions
Understand what Site Templates are.
Understand the different Tpes of Site Templates that come “Out of the Box”
Creating 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.
Understand what site pages are.
Understand what wiki pages are.
Understand what Web Parts are.
Understand how to add content to the Site Home page.
Understand how to create a wiki page library.
Understand how to add Web Parts.
Understand how to manage Web Parts.
Understand Site Columns.
Understand Content Types.
Understand how to create Site Columns.
Understand how to create Content Types.
Understand how to create a document template for a Content Type.
Understan how to assign a Content Type to a list or library.
Understand how to create new items based on a custom Content Type.
Understand SharePoint groups.
Understand how to create SharePoint groups.
Understand how to assign permission in SharePoint.
Understand how to view permission levels.
Understand how to manage permission inheritance at the site level.
Understand how to manage permission inheritance at the list or library level.
Understand how to edit a personal profile.
Microsoft Project 2016: Level 1
What you'll learn
Upon successful completion of this course, you will be able to perform advanced data analysis, collaborate on workbooks with other users, and automate workbook functionality.
Identify project management concepts and navigate the Project 2016 environment.
Create and define a new project plan.
Create and organize tasks.
Manage resources in a project plan.
Finalize a project plan.
Microsoft Visio 2019: Part 1
What you'll learn
In this course, you will design, modify, and manage basic diagrams.
Identify the basic elements of Visio and their use.
Create a workflow diagram.
Build organization charts.
Design a floor plan.
Build a cross-functional flowchart.
Design a network diagram.
Style a diagram.
Developing SQL Data Models
What you'll learn
Components, architecture, and nature of a BI solution
Create a multidimensional database with analysis services
Implement dimensions in a cube
Implement measures and measure groups in a cube
Use MDX syntax
Customize a cube
Implement a tabular database
Use DAX to query a tabular model
Use data mining for predictive analysis
55054-A: Mastering Microsoft Project 2013
What you'll learn
Understand the discipline of project management as it applies to using Microsoft Project 2013.
Create a Work Breakdown Structure.
Identify Task Types & Relationships.
Define Resources within Project.
Make Work Package Estimates.
Create an Initial Schedule.
Create a Resource Leveled Schedule.
Create Projects from templates, Excel files.
Create Global templates.
Create formulas and graphical indicators.
The steps to record a macro.
Format Output and Print Reports.
Integrate Multiple Projects.
Set up a Project with a Calendar, Start date, and scheduling method.
Understand Manually Schedule vs. Auto Schedule.
Manage multiple projects.
Be able to create a master project list with shared resources.
Have a fundamental understanding of how Microsoft Project will help them track their projects.
Understand what is new in Project 2013 and how it will increase their productivity.
Learn how the ribbon will help them get the most of out of this productivity tool.
Learn how to quickly change views and see what is going on with their projects.
Understand the 5 essential steps in building a successful project plan.
Prepare a new project plan and set the date and other basic information.
Enter detailed project information.
Understand how to sequence tasks.
Understand and define basic resource types.
Assign resources to tasks.
Understand the benefits of baselining a project or specific tasks.
Understand the basics of how to track project progress.
Create a new project using a template, Excel, a SharePoint Tasks List or a new Project file.
Establish one or more calendars to constrain resource availability.
Configure Microsoft Project to calculate the schedule from the Start Date forward or from the Finish Date backward.
Understand how to turn on Manually Schedule and Auto Schedule.
Understand when to use Manually Schedule.
Understand the limitations of Manually Scheduling.
Build and use summary and subordinate tasks.
Understand and use milestones.
How to organize the WBS.
How to format the WBS.
Develop WBS outlines.
Assign completion criteria.
Evaluate the WBS.
Understand and use WBS outlines.
Understand how to link Project artifacts to their projects.
Understand how to create notes on tasks.
Understand the different types of task relationships.
Understand and use various methods to create relationships.
Determine and display task sequence.
Understand how to use Lag, Lead and Delay.
Define the different types of resources.
Define individual resources that will be used on the project.
Record the cost(s) of using each type of resource.
Record the limit of availability for each type of resource by establishing a resource calendar and defining the maximum units of that resource.
Assign values for resources, duration and work.
Understand task types.
Understand Effort Driven scheduling.
Understand material resources and their costs to a project plan.
Identify the critical path.
Understand difference between slack and slippage.
Calculate float.
How to leverage constraints.
How to get the benefit from the Task Inspector, and the impact of changes on a project schedule.
Adjust a project schedule to account for limited resources.
View the overall cost and schedule of a project.
Identify resources that are over- allocated for a project schedule.
Use multiple ways to adjust tasks and assignments to remove over- allocation for any resource.
Set a baseline.
Enter and manage project performance data.
Pick a tracking method.
Perform variance analysis.
Sync Projects results with SharePoint.
Create standardized views, with the power of sorting, filtering and grouping.
Customize a variety of standard reports.
Learn how to use Visual Reports.
Export reports in a variety of formats.
Use common resources among multiple projects.
Link tasks between multiple projects.
Create a consolidated view of multiple projects and shared resources.
Take advantage of the advance features of Microsoft Project 2013.
Be able to create a Macro.
Share common settings among all future projects.
Featured
Microsoft Office Excel (2019-2016-2013): Basic
What you'll learn
Get started with Microsoft Office Excel.
Perform calculations.
Modify a worksheet.
Format a worksheet.
Print workbooks.
Manage workbooks.
Microsoft Project 2016: Level 2
What you'll learn
Upon successful completion of this course, you will be able to perform advanced data analysis, collaborate on workbooks with other users, and automate workbook functionality.
Update a project plan to reflect progress as you execute the project.
Monitor project progress in the project plan.
Adjust the project plan to control constraints.
Create project reports to share project status.
Customize project settings and share customizations with other projects.
Microsoft Visio 2019: Part 2
What you'll learn
In this course, you will examine advanced features to make you more efficient and effective.
Design advanced plans and diagrams.
Enhance the look of drawings.
Create shapes, stencils, and templates.
Connect drawings to external data.
Leverage development tools.
Share drawings.
Featured
55315: Introduction To SQL Databases
What you'll learn
Describe key database concepts in the context of SQL Server
Describe database languages used in SQL Server
Describe data modelling techniques
Describe normalization and denormalization techniques
Describe relationship types and effects in database design
Describe the effects of database design on performance
Describe commonly used database objects
Featured Courses
Featured
55315: Introduction To SQL Databases
Course Description This three-day instructor-led course is aimed at people …
55315: Introduction To SQL Databases
What you'll learn
Describe key database concepts in the context of SQL Server
Describe database languages used in SQL Server
Describe data modelling techniques
Describe normalization and denormalization techniques
Describe relationship types and effects in database design
Describe the effects of database design on performance
Describe commonly used database objects
Featured
55316: Administering A SQL Database
Course Description This instructor-led course provides students who manage SQL …
55316: Administering A SQL Database
What you'll learn
Authenticate and authorize users
Assign server and database roles
Authorize users to access resources
Use encryption and auditing features to protect data
Describe recovery models and backup strategies
Backup and Restore SQL Server databases
Automate database management
Configure security for the SQL Server agent
Manage alerts and notifications
Managing SQL Server using PowerShell
Trace access to SQL Server
Monitor a SQL Server infrastructure
Troubleshoot a SQL Server infrastructure
Import and export data
Featured
Microsoft Office Word 2019: Part 3
Course Description: Microsoft® Word enables you to do far more …
Microsoft Office Word 2019: Part 3
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.
Featured
Microsoft Office Word 2019: Part 2
Course Description: After you master the basics of creating, editing, …
Microsoft Office Word 2019: Part 2
What you'll learn
Organize content using tables and charts.
Customize formats using styles and themes.
Insert content using Quick Parts.
Use templates to automate document formatting.
Control the flow of a document.
Simplify and manage long documents.
Use mail merge to create letters, envelopes, and labels.
Featured
Microsoft Office Word 2019: Part 1
Course Description: These days, most people take electronic word processing …
Microsoft Office Word 2019: Part 1
What you'll learn
Navigate and perform common tasks in Word, such as opening, viewing, editing, saving, and printing documents, and configuring the application.
Perform repetitive operations efficiently using tools such as Find and Replace, Format Painter, and Styles.
Enhance lists by sorting, renumbering, and customizing list styles.
Insert graphic objects into a document, including symbols, special characters, illustrations, pictures, and clip art.
Create and format tables.
Format text and paragraphs.
Format the overall appearance of a page through page borders and colors, watermarks, headers and footers, and page layout.
Use Word features to help identify and correct problems with spelling, grammar, readability, and accessibility.
Featured
Microsoft Office PowerPoint 2019: Part 2
Course Description: Meetings, instruction, training, pitches; these are all a …
Microsoft Office PowerPoint 2019: Part 2
What you'll learn
Customize design templates.
Use ink to hand draw elements.
Add tables.
Add charts.
Work with media.
Build advanced transitions and animations.
Finalize a presentation.
Customize presentation navigation.
Secure and distribute a presentation.
Featured
Microsoft Office PowerPoint 2019: Part 1
Course Description: It’s hard to imagine a day going by …
Microsoft Office PowerPoint 2019: Part 1
What you'll learn
Identify the basic features and functions of PowerPoint.
Develop a PowerPoint presentation.
Perform advanced text editing operations.
Add graphical elements.
Format graphical elements.
Prepare to deliver your presentation.
Featured
Microsoft Office Excel (2019-2016-2013): Advanced
Course Description: Clearly, you use Excel a lot in your …
Microsoft Office Excel (2019-2016-2013): Advanced
What you'll learn
Work with multiple worksheets and workbooks.
Share and protect workbooks.
Automate workbook functionality.
Use Lookup functions and formula auditing.
Forecast data.
Create sparklines and map data.
Featured
Microsoft Office Excel (2019-2016-2013): Intermediate
Course Description: Whether you need to crunch numbers for sales, …
Microsoft Office Excel (2019-2016-2013): Intermediate
What you'll learn
Work with functions.
Work with lists.
Analyze data.
Visualize data with charts.
Use PivotTables and PivotCharts.
Featured
Microsoft Office Excel (2019-2016-2013): Basic
Course Description: Organizations the world over rely on information to …
Microsoft Office Excel (2019-2016-2013): Basic
What you'll learn
Get started with Microsoft Office Excel.
Perform calculations.
Modify a worksheet.
Format a worksheet.
Print workbooks.
Manage workbooks.
All Microsoft Courses
Microsoft Online Training Courses - Live
CCS Learning Academy is an official Microsoft Gold partner!
Search here for available courses. If you would like to purchase training for a large group, please contact us for custom pricing. View Certification
Filter by Topic
Filter by Vendor
-38%
AZ-900T00-A:Microsoft Azure Fundamentals Training Certification
Demonstrate Your Fundamental Knowledge Of Cloud Concepts With Azure Our …
What you'll learn
Describe cloud computing
Describe the benefits of using cloud services
Describe cloud service types
Describe the core architectural components of Azure
Describe Azure compute and networking services
Describe Azure storage services
Describe Azure identity, access, and security
Describe cost management in Azure
Describe features and tools in Azure for governance and compliance
Describe features and tools for managing and deploying Azure resources
Describe monitoring tools in Azure
-38%
DP-900T00: Microsoft Azure Data Fundamentals
Course Description: In this course, students will learn the fundamentals …
What you'll learn
Describe core data concepts in Azure.
Explain concepts of relational data in Azure
Identify components of a modern data warehouse in Azure
DP-080T00: Querying Data with Microsoft Transact-SQL
Course Description This course will teach you how to use …
What you'll learn
Introduction to Transact-SQL
Sort and filter results in T-SQL
Combine multiple tables with JOINs in T-SQL
Write Subqueries in T-SQL
Use built-in functions and GROUP BY in Transact-SQL
Modify data with T-SQL
AI-900T00: Microsoft Azure AI Fundamentals
Course Description: AI-102 Designing and Implementing an Azure AI Solution …
What you'll learn
Describe Artificial Intelligence workloads and considerations.
Describe fundamental principles of machine learning on Azure.
Describe features of computer vision workloads on Azure
Describe features of Natural Language Processing (NLP) workloads on Azure
Describe features of conversational AI workloads on Azure
Microsoft Project 2016: Level 2
Course Description: Welcome to Microsoft Project 2016: Level 2 This …
What you'll learn
Upon successful completion of this course, you will be able to perform advanced data analysis, collaborate on workbooks with other users, and automate workbook functionality.
Update a project plan to reflect progress as you execute the project.
Monitor project progress in the project plan.
Adjust the project plan to control constraints.
Create project reports to share project status.
Customize project settings and share customizations with other projects.
Microsoft Project 2016: Level 1
Course Description: Welcome to Microsoft Project 2016: Level 1 This …
What you'll learn
Upon successful completion of this course, you will be able to perform advanced data analysis, collaborate on workbooks with other users, and automate workbook functionality.
Identify project management concepts and navigate the Project 2016 environment.
Create and define a new project plan.
Create and organize tasks.
Manage resources in a project plan.
Finalize a project plan.
Microsoft Office 365 Online (With Teams)
Course Description: This course is an introduction to Microsoft Office …
What you'll learn
Sign in, navigate, and identify components of the Office 365 environment
Create, edit, and share documents with team members using the Office Online apps, SharePoint, OneDrive for Business, and Delve
Collaborate and work with colleagues using the Yammer and Planner apps
Use email and manage contacts with Outlook on the web
Collaborate using Teams
Configure Teams
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.
