Microsoft Excel for Beginners

Ideal for:   Beginners who have inherited or need to create a workbook from start to finish.

1 Day

This course aims to provide you with a foundation for Excel knowledge and skills, which you can build upon to eventually become an expert in data manipulation.   
               Microsoft Excel Beyond the Basics

Ideal for: Students who already have created spreadsheets and are ready to take advantage of lists, charts, pivot tables and functions

1 Day

Upon successful completion of this course, you will be able to leverage the power of data analysis and presentation in order to make informed, intelligent organizational decisions. 

Microsoft Excel Advanced

Ideal for:  Students who are experienced Excel users and have a desire or need to advance their skills in working with some of the more advanced Excel features.

1 Day

To ensure success,  students should be able to perform include: creating formulas and using Excel functions; creating, sorting, and filtering datasets and tables; presenting data by using basic charts; creating and working with PivotTables, slicers, and PivotCharts; and customizing the Excel environment.
                 Data Analysis with Pivot Tables

Ideal for: Anyone who wants to use Excel advanced PivotTable functionality to analyze your raw data.

1 Day

You will: Prepare data for PivotTable reporting and create PivotTables from various data sources. Analyze Data Using PivotTables. Work with PivotCharts.
Data Analysis with Power Pivot
Ideal for: Upon successful completion of this course, you will be able to use Power Pivot along with Excel  to analyze data from a variety of sources.

1 Day

You will: Get started with Power Pivot. Visualize Power Pivot data. Work with advanced functionality in Power Pivot.

                 Tableau Introduction    
Ideal for:  anyone who works with data, regardless of analytical background.  

2 Days

This course is for the beginning Tableau user. You'll learn important Tableau Desktop concepts, techniques for simple and complex visualizations and interactive dashboards in preparation for your exam. Skills are taught in two days of in-class instruction plus additional self-paced eLearning.

                 Tableau Prep 
Ideal for:  people who have 3-6 months experience in Tableau Desktop and are somewhat familiar with writing calculations.  

2 Days

This course is designed to provide you with the tools and knowledge of how to prepare and shape data in Tableau Prep. Throughout the course, our instructors will take you from conceptual data preparation material to creating useful Tableau Prep flows that can be output to Tableau Desktop for analysis.

Programming and Data Wrangling with VBA and Excel

Ideal for:   experienced Excel users who may also want to learn how to create custom worksheet functions to streamline worksheet formulas and make complex worksheets easier to support, maintain, and understand.

3 Days

This course is primarily designed for students who want to gain the skills necessary to use VBA to automate tasks in Excel such as collecting data from external sources, cleaning, and manipulating data.
Data Model Design

Ideal for:   Those who have completed Excel levels 1, 2 & 3, including PivotTable & Pivot Chart skills; plus a basic understanding of database concepts. Power BI for Excel: Report Builder.

1 Day

This course is designed for Power BI for Excel Designers who are ready to create custom data models for themselves and for other Power BI Designers. 
               20779 Analyzing Data 
Ideal for:  Students who are experienced with analyzing data with
Excel  and who wish to add BI techniques. The course will likely be

attended by SQL Server report creators who are interested

in alternative methods of presenting data.

5 Days

After completing this course, students will be able to: Explore and extend a classic Excel dashboard. Explore and extend an Excel data model. Pre-format and import a .CSV file. Import data from a SQL Server database Import data from a report. Create measures using advanced DAX functions. Create data visualizations in Excel. Create a Power BI dashboard with Excel.

BI Tools: Get and Transform Data
Ideal for:  Excel power-users, Power BI BI professionals, and Excel power-users who have a general familiarity with Power Query but need more knowledge and experience to take it to its full potential. 

1 Day

This course takes an in-depth approach to the Power Query and will provide an introduction to the M language, allowing you to replay a series of transformations. This is helpful when readying data on a weekly, monthly or quarterly basis, saving you time on these repetitive tasks. M Code will also allow you to manipulate data using features that are not accessible via keyboard commands.

               10994 Data Analysis Fundamentals 

Ideal for: Anyone who wants to take the data analysis technologies beyond formulas, and add more advanced capabilities, such as dashboards, hierarchies, and relationships.

2 Days

The main purpose of the course is to give students the ability to add analysis capabilities to Excel spreadsheets and to provide students with a foundation to learn about more advanced data analytics with Excel or Power BI.

Tables, Pivot Tables and Conditional Formatting
1/2  Day

You will analyze Excel data, create PivotTables, Pivot Charts as well as Analyzing Pivot Tables.

                 Data Analysis Professional    
Ideal for:  Designed for professionals in a variety of job roles who are currently using desktop or web-based data-management tools perform numerical or general data analysis. 

3 Days

Power BI was built to connect to a wide range of data sources, and it enables users to quickly create visualizations of connected data to gain insights, show trends, and create reports. Power BI's data connection capabilities and visualization features go far beyond those that can be found in spreadsheets, enabling users to create compelling and interactive worksheets, dashboards, and stories that bring data to life and turn data into thoughtful action.

Formulas and Charts

Ideal for:  students who want to be able to create formulas and charts.

1 Day

In This Course, students will analyze Excel data, create Formulas, Charts and Data to Support Excel Spreadsheets and Workbooks.