Most popular
Intermediate
55049-A: PowerPivot, Power View and SharePoint 2013 Business Intelligence Center for Analysts
$1,195.00
55049-A: PowerPivot, Power View and SharePoint 2013 Business Intelligence Center for Analysts
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.
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.
AI-900T00: Microsoft Azure AI Fundamentals
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
Featured
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.
55321: SQL Server Integration Services
What you'll learn
Create sophisticated SSIS packages for extracting, transforming, and loading data
Use containers to efficiently control repetitive tasks and transactions
Configure packages to dynamically adapt to environment changes
Use Data Quality Services to cleanse data
Successfully troubleshoot packages
Create and Manage the SSIS Catalog
Deploy, configure, and schedule packages
Secure the SSIS Catalog
MS-700T00-A: Managing Microsoft Teams
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): 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.
AZ-305T00: Designing Microsoft Azure Infrastructure Solutions
What you'll learn
Design a governance solution.
Design a compute solution.
Design an application architecture.
Design storage, non-relational and relational.
Design data integration solutions.
Design authentication, authorization, and identity solutions.
Design network solutions.
Design backup and disaster recovery solutions.
Design monitoring solutions.
Design migration solutions.
Featured
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.
Free
Implementing A SQL Data Warehouse
What you'll learn
Describe the key elements of a data warehouse solution
Considerations for building a data warehouse
Implementing a logical design for a data warehouse
Implement a physical design for a data warehouse
Create Columnstore indexes
Implementing an Azure SQL Data Warehouse
Describe the key features of SSIS
Implement a data flow by using SSIS
Implement control flow by using tasks and precedence constraints
Create dynamic packages that include variables and parameters
Debug SSIS packages
Describe the considerations of implement an ETL Solution
Implement Data Quality Services
Implement a Master Data Service model
Describe how you can use custom components to extend SSIS
Deploy SSI projects
Describe BI and common BI scenarios
Trending
Intermediate
55049-A: PowerPivot, Power View and SharePoint 2013 Business Intelligence Center for Analysts
$1,195.00
55049-A: PowerPivot, Power View and SharePoint 2013 Business Intelligence Center for Analysts
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.
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.
AI-900T00: Microsoft Azure AI Fundamentals
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
Featured
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.
55321: SQL Server Integration Services
What you'll learn
Create sophisticated SSIS packages for extracting, transforming, and loading data
Use containers to efficiently control repetitive tasks and transactions
Configure packages to dynamically adapt to environment changes
Use Data Quality Services to cleanse data
Successfully troubleshoot packages
Create and Manage the SSIS Catalog
Deploy, configure, and schedule packages
Secure the SSIS Catalog
MS-700T00-A: Managing Microsoft Teams
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): 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.
AZ-305T00: Designing Microsoft Azure Infrastructure Solutions
What you'll learn
Design a governance solution.
Design a compute solution.
Design an application architecture.
Design storage, non-relational and relational.
Design data integration solutions.
Design authentication, authorization, and identity solutions.
Design network solutions.
Design backup and disaster recovery solutions.
Design monitoring solutions.
Design migration solutions.
Featured
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.
Free
Implementing A SQL Data Warehouse
What you'll learn
Describe the key elements of a data warehouse solution
Considerations for building a data warehouse
Implementing a logical design for a data warehouse
Implement a physical design for a data warehouse
Create Columnstore indexes
Implementing an Azure SQL Data Warehouse
Describe the key features of SSIS
Implement a data flow by using SSIS
Implement control flow by using tasks and precedence constraints
Create dynamic packages that include variables and parameters
Debug SSIS packages
Describe the considerations of implement an ETL Solution
Implement Data Quality Services
Implement a Master Data Service model
Describe how you can use custom components to extend SSIS
Deploy SSI projects
Describe BI and common BI scenarios
Featured Courses
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.
Popular Topics
Data Analyst
Microsoft Azure
Administering A SQL Database
SQL Server Performance Tuning
Microsoft Azure Data Fundamentals
SQL Server Performance Optimization
Microsoft Office 365 Online
SQL Data Models
SQL Server Integration
SQL Data Warehouse
Azure AI Fundamentals
Azure SQL Solutions
Azure Infrastructure Solutions
Microsoft Power BI Data Analyst
Azure AI Solution
PL-600 Power Platform Solution Architect
Microsoft Azure Administrator
Microsoft Azure for SAP Workloads
Microsoft Azure Fundamentals Training Certification
SharePoint End User
SQL Database Infrastructure
Microsoft Azure Certification
Microsoft PoerShell
Microsoft Project 2016 Level 1
Microsoft Project 2016: Level 2
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
Microsoft Office Outlook 2019: Part 2
Course Description: Every day, millions of email messages are exchanged …
What you'll learn
In this course, you will use Outlook’s advanced features to customize and manage your email communications, including using advanced features to organize emails; managing calendar settings and options; managing contact information; scheduling tasks; and managing Outlook archives and data file settings.
Insert objects in messages, and modify properties and global options.
Organize, search, and manage messages.
Protect your mailbox and manage its size.
Use rules and Quick Steps to automate message management.
Work with advanced calendar settings.
Import and forward contacts.
Manage activities by assigning tasks to others.
Delegate access to and share Outlook items with others.
Archive and back up Outlook items using data files.
Optimize query performance in Azure SQL
Course Description: Analyze individual query performance and determine where improvements …
AZ-204T00-A: Developing Solutions for Microsoft Azure
Course Description: This course teaches developers how to create end-to-end …
AZ-040: Automating Administration with PowerShell
This course provides students with the fundamental knowledge and skills …
AZ-900T00-A:Microsoft Azure Fundamentals Training Certification
Our one-day Microsoft azure fundamentals training certification program is for …
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
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
AZ-104T00-A: Microsoft Azure Administrator
Course Description: This course teaches IT Professionals how to manage …
PL-300: Microsoft Power BI Data Analyst
This course will discuss the various methods and best practices …
