Microsoft Excel for Beginners
Ideal for: Beginners who have inherited or need to create a workbook from start to finish.
1 Day $295
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 $295
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 $295
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 and Visualization with Microsoft Excel
Ideal for: This course is designed for those who already have foundational knowledge and skills in Excel.
2 Days $590
Learn to perform robust and advanced data and statistical analysis with Microsoft Excel using PivotTables, and the Analysis ToolPak to analyze data, and visualize data and insights using advanced visualizations in charts and dashboards in Excel.
Ideal for: This course will bring you up to speed on the latest features of Excel.
2 Days $700
The main purpose of the course is to review the essential skills across all topics such as charting, database features, pivot tables, multiple worksheets, advanced functions and even an introduction to Macros.
Data Analysis Using Pivot Tables
Ideal for: Intermediate and Advanced Users interact with internal and external data.
1 Day $450
You will: Learn to Get, Clean and Transform Data. Create tables, slicers and lists to prepare data for visual and interactive activity.
A Day of Excel Tips and Tricks
Ideal for: All levels of Excel users will benefit from the time saving and widely popular tips.
1 Day $400
ExecuTrain instructors built this course from start to finish. Using their Excel expertise and classroom experience - you'll get their collaboration and secrets. This class is more than a class - it's an experience!
Create Powerful Excel® Dashboards
Ideal for: Seminar attendees will learn how to create an Excel Dashboard, along with the best practices to maximize this invaluable resource.
1 Day $495
Microsoft Excel Dashboards extract the most essential information from a spreadsheets. Learn to track complex data sets, as well as referencing KPIs and getting data-backed views to help make insightful decisions.
Introduction Pivot Tables
Ideal for: Anyone who wants to use Excel advanced PivotTable functionality to analyze your raw data.
3 Hours $295
You will: Prepare data for PivotTable reporting and create PivotTables from various data sources. Analyze Data Using PivotTables.
Excel PowerPivot & Interactive Visualizations
Ideal for: This course is for individuals whose job responsibilities include complex Excel reports and advanced analytics.
2 Days $1,000
The new analytics tools in Excel make it easy to conduct manipulate and gain insights from big data. PowerPivot extends the use of pivot tables with a data model and offers improved data summary and cross-tabulation and advanced calculations. Power Query retrieves data from a variety of sources can be cleaned up before being added to data model. Power View create interactive dashboards. Power Map is a 3D visualization tool to create map charts and interactive tours. These tools bring the power of advanced analytics to the average Excel user.
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 $1,100
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.
Ideal for: anyone who works with data, regardless of analytical background.
2 Days $1,400
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.