Loading...

Microsoft Courses

* Courses listed below can also be customized based on user demandDon't see a course that you are looking for?
Click Here to Request It.

20768: Developing SQL Data Models

This course teaches students how to implement both multidimensional and tabular data models by using SQL Server Analysis Services. Students will also learn how to create cubes, dimensions, measures, and measure groups as well as the components, architecture and nature of a BI solution.

  • In-class
  • Instructor Led Online

20778: Analyzing Data with Power BI

The main purpose of the course is to give students a good understanding of data analysis with Power BI. The course includes creating visualizations, the Power BI Service, and the Power BI Mobile App.

  • In-class
  • Instructor Led Online

EXC16L3: Microsoft Excel 2016 – Level 3/Advanced

This course teaches students how to analyze and report data frequently as well as work in collaboration with others to deliver actionable insights. Students will learn how to keep and maintain workbooks for all purposes, as well as automate complex or repetitive tasks, and use conditional logic to construct and apply elaborate formulas and functions that will put the power of Excel at their fingertips. Students will also learn how to perform advanced data analysis, and automate workbook functionality.

  • In-class
  • Instructor Led Online

EXCL1: Microsoft Excel – Level 1/Intro (2010, 2013, 2016)

This course teaches students the foundations of Microsoft Office Excel. Students will gain the knowledge and skills to easily create and work with electronic spreadsheets. Students will learn to create, format, and enhance simple spreadsheets, as well as the skills to perform calculations and analyze the data that is critical to the success of their organization.

  • In-class
  • Instructor Led Online

EXCL2: Microsoft Excel – Level 2/Med (2010, 2013, 2016)

This course teaches students some of the higher-level functionality in Excel to analyze and present data. Students will learn how to use formulas and advanced functions, create and format tables, sort and filter, add and format graphics, and protect and finalize their work. Students will also learn to work with functions and lists, create advanced formulas, and work with the custom view. Students will be able to leverage the power of data calculations and presentation in order to make informed, intelligent organizational decisions.

  • In-class
  • Instructor Led Online

PPPQ16: Power Pivot and Power Query for Excel 2016

This course teaches students the add-ins that expand and combine the features and capabilities of Excel. Students will learn PowerPivot, Power Query, Power View, 3D maps and their features. Students will also learn how to import, manipulate and work with large amounts of data from a variety of data sources both inside and outside Excel. Students will learn the techniques for manipulating querying data, the structure of DAX functions, ways to distribute and visualize data using Pivot Charts, Slicers, Sparklines, Timelines, Power View and 3D maps.

  • In-class
  • Instructor Led Online