Excel Training Courses and Workshops

Schools providing training courses, certificates, diplomas or degree programs of Microsoft Excel




Total 800 training courses and degree programs available around the world.

United States - United Kingdom - Canada - Australia - India

Popular courses:
Excel 2007
Excel
Excel 2010
microsoft excel
MS Excel
Microsoft Excel 2010


Microsoft Excel VBA - Level 1

Course Format: Classroom
School/Trainer: ISInc
Training Center(s)/Venue(s): Sacramento, United States
  V

This course is intended for advanced Microsoft Excel users that need to automate Excel spreadsheet tasks using Visual Basic for Applications (VBA). The course covers Excel Versions 2007, 2010, 2013.

Learn how manual tasks in Excel can be programmed with VBA for greater speed, efficiency and accuracy.

Microsoft Excel 2013 PivotTables

Course Format: Classroom
School/Trainer: ISInc
Training Center(s)/Venue(s): Sacramento, United States
  V

Upon successful completion of this 3 hour instructor-led course, you will be able to use Excel 2013 advanced PivotTable functionality to analyze your raw data.

Advances in technology have made it possible to store ever increasing amounts of data. Along with this, the need to analyze that data and gain actionable insight is greater than ever. You already have experience working with Excel and creating basic PivotTables to summarize data. But, Excel is capable of doing so much more. Being able to harness the power of advanced PivotTable features and create PivotCharts will help you to gain a competitive edge. You will not only be able to summarize data for you to analyze, but also organize the data in a way that can be meaningfully presented to others. This leads to data-driven business decisions that have a better chance for success for everyone involved.

Microsoft Excel 2016 Level 1

Course Format: Classroom
School/Trainer: ISInc
Training Center(s)/Venue(s): Sacramento, United States
  V

During this one day instructor-led course, students will learn how to perform calculations, create and modify a worksheet, and print and manage workbooks.

Prerequisites

Students should be familiar with using personal computers and have used a mouse and keyboard. You should be comfortable in the Windows environment and be able to use Windows to manage information on your computer. Specifically, you should be able to launch and close programs, navigate to information stored on the computer, and manage files and folders.

Microsoft Excel 2016 Level 2

Course Format: Classroom
School/Trainer: ISInc
Training Center(s)/Venue(s): Sacramento, United States
  V

Students will learn how to use intermediate features of Excel, including the use of advanced functions, sorting and filtering data, and analyzing data using pivot tables and charts. Learn all about Excel Sparklines.

Prerequisites

Completion of the following course or equivalent knowledge and skills is recommended:
-Microsoft Excel 2016 Level 1

Microsoft Excel VBA Level 2

Course Format: Classroom
School/Trainer: ISInc
Training Center(s)/Venue(s): Sacramento, United States
  V

This course is intended for advanced Microsoft Excel users that need to automate Excel spreadsheet tasks using Visual Basic for Applications (VBA).
Learn how manual tasks in Excel can be programmed with VBA for greater speed, efficiency and accuracy

Become a true Excel power user. Learn how to program Excel&,#146,s newest chart and pivot table object modes, manipulate the user interface with User Forms and embedded Form and ActiveX controls to customize the look and feel of a project. Learn how to utilize message boxes, input boxes and loops to yield customized, logical results and manipulate Word, Access, PowerPoint and Outlook from Excel.

Microsoft Excel 2016 Level 3

Course Format: Classroom
School/Trainer: ISInc
Training Center(s)/Venue(s): Sacramento, United States
  V

Students will explore advanced Excel concepts, including validating data, setting up formulas across multiple files and use many �what-if?scenarios in Excel. Students will also be introduced to the use of macros in automating processes.

Prerequisites

Students should be familiar with basic and intermediate concepts of Microsoft Excel. This includes being able to build basic formulas and functions, charts, and pivot tables.

Completion of the following courses or equivalent knowledge and skills is recommended:
-Microsoft Excel 2016 Level 1
-Microsoft Excel 2016 Level 2

Excel 2016 Level 4

Course Format: Classroom
School/Trainer: ISInc
Training Center(s)/Venue(s): Sacramento, United States
  V

Students will learn advanced features of pivot tables, functions, charts, macros, and will also round out their knowledge of Microsoft Excel.

Prerequisites

For this course, you should have the equivalent knowledge of the first three courses in the Microsoft Excel series. This involves your knowing how to build Excel files, enter formulas both for basic and complex calculations, format Excel files, sort and filter data, build charts, record macros, and run data analysis tools, such as pivot tables.

Completion of the following courses or equivalent knowledge and skills is recommended:
-Excel 2016 Level One
-Excel 2016 Level Two
-Excel 2016 Level Three

Power BI for Excel 2016 - Report Builders, Power BI Tools, Data Model Designers, and DAX Functions

Course Format: Online
School/Trainer: Intertech, Inc.
Training Center(s)/Venue(s): Eagan, United States
  V

First day topics covered include an overview of PowerPivot, creating effective and professional reports, creating hierarchies, effectively applying different chart styles, and creating report templates. Second day topics include creating Power Views with Excel, Power Map, and Power Query. Third day topics include database design concepts, how to build both general purpose and customized data models, and how to use basic DAX language and functionality to extend the capabilities of data models for in-depth and customized analysis of information. Fourth and fifth day topics covered in this class include Relational functions, Date functions, Banding, Ranking, advanced Slicer techniques, plus using DAX as a query language for customized analysis.

Excel 2013

Course Format: Classroom
School/Trainer: GTC Economic Development and Corporate Training
Training Center(s)/Venue(s): Greenville, Simpsonville, Taylors, United States

Learn the foundations of Excel 2013 in order to work with and analyze the data within your spreadsheets. Learn to perform simple calculations, how to create and modify worksheets, basic formatting techniques, printing and workbook management.

Microsoft Excel

Course Format: Classroom
School/Trainer: Anne Arundel Community College
Training Center(s)/Venue(s): Annapolis, Arnold, Baltimore, Edgewater, Gambrills, Hanover, Laurel, Severn, United States
  V

Create, organize and analyze data and information more easily, more quickly, and more efficiently using Microsoft Excel. To make you more productive working with your spreadsheets, Excel puts the commands you use most often in plain sight on your work surface allowing you to analyze, share, and manage information more effectively.

Excel 2013

Course Format: Classroom
School/Trainer: Anne Arundel Community College
Training Center(s)/Venue(s): Annapolis, Arnold, Baltimore, Edgewater, Gambrills, Hanover, Laurel, Severn, United States

Excel 2013 Level 1 Explore the basic functions and features of Excel 2013 including terminology, entering and editing text, values and formulas, and simple function and formatting techniques. Create and modify charts. Manage workbooks.

Excel for Accounting

Course Format: Classroom
School/Trainer: Globe University - Wisconsin
Training Center(s)/Venue(s): Appleton, Eau Claire, La Crosse, Madison, Wausau, United States

The course
teaches students how to use the spreadsheet program, Microsoft Excel, to
practice accounting procedures. Students use the application for concepts
emphasized in financial accounting and managerial accounting.

Excel for Accounting

Course Format: Classroom
School/Trainer: Globe University Sioux Falls Campus
Training Center(s)/Venue(s): Sioux Falls, United States

The course
teaches students how to use the spreadsheet program, Microsoft Excel, to
practice accounting procedures. Students use the application for concepts
emphasized in financial accounting and managerial accounting.

Excel for Accounting

Course Format: Classroom
School/Trainer: Minnesota School of Business & Globe University
Training Center(s)/Venue(s): Blaine, Minneapolis, Richfield, Rochester, Woodbury, United States

The course
teaches students how to use the spreadsheet program, Microsoft Excel, to
practice accounting procedures. Students use the application for concepts
emphasized in financial accounting and managerial accounting.

Master Data Services, Data Quality Services with SQL 2012-2014 and Excel

Course Format: Classroom
School/Trainer: Global Knowledge USA Microsoft Training Centers
Training Center(s)/Venue(s): Arlington, Atlanta, Cary, Irving, Morristown, New York City, Santa Clara, Schaumburg, Seattle, United States
  V

Studies show that data decays at about 2% a month all organizations need to work from reliable information while ensuring that the integrity of information and consistency of data is constant across different applications. Microsoft SQL Server 2012-2014 Master Data Services is a powerful feature designed to help an organization create a structure and hierarchy for data, so that data collected and used across multiple departments, silos and databases is standardized and aligned. This ensures that different databases are interoperable. When combined with Data Quality Services and Excel a complete end to end system is available.

After completing this course, students will be able to:

Have a basic understanding of the concepts behind master data management.

Configure Master Data Services.

Create models and entities.

Add attributes including domain-based attributes.

Add a member via the web interface.

Reverse a transaction.

Create and configure attribute groups.

Create and configure derived hierarchies.

Create and configure collections.

Create a leaf member ... [Read More]

Data Mining, Predictive Analytics with Microsoft Analysis Services and Excel PowerPivot

Course Format: Classroom
School/Trainer: Global Knowledge USA Microsoft Training Centers
Training Center(s)/Venue(s): Arlington, Atlanta, Cary, Irving, Morristown, New York City, Santa Clara, Schaumburg, Seattle, United States
  V

This three-day instructor-led course will introduce the students to the concepts of data mining, machine learning and predictive analytics utilizing the Microsoft toolsets including SQL Server Analysis Services and Excel with PowerPivot and the Data Mining Add-ins.

After completing this course, students will be able to:

Have a firm understanding of the concept of data mining.

Explore the user interface.

Use offline mode and immediate mode.

Create and configure a data source.

Create and configure data view.

Explore data.

Create and configure named calculation.

Create and configure named queries.

Walk-through a project to completion.

Explore the models.

Compare mining structures.

Use cross validation.

Create reports using Reporting Services.

Save queries.

Save results to the database.

Create multiple nested tables off of a case table.

Use Microsoft Association Rules Algorithm.

Use Microsoft Sequence Clustering Algorithm.

Use Microsoft Time Series Algorithm.... [Read More]

Excel 2016

Course Format: Classroom
School/Trainer: Global Knowledge USA Microsoft Training Centers
Training Center(s)/Venue(s): Arlington, Atlanta, Cary, Irving, Morristown, New York City, Santa Clara, Schaumburg, Seattle, United States
  V

This three days of Microsoft Word 2016 training class is designed for Excel users who want to learn the topics covered in 2016 interface.

Course Objectives

Create basic worksheets using Microsoft Excel 2016

Perform calculations in an Excel worksheet

Modify an Excel worksheet

Modify the appearance of data within a worksheet

Manage Excel workbooks

Print the content of an Excel worksheet

Learn how to use handy features new in 2016

Use bookmarks, add watermarks and customize the ribbon

Learn to use formulas and functions

Create and modify charts

Convert, sort, filter and manage lists

Insert and modify illustrations in a worksheet

Learn to work with tables

Learn to use conditional formatting and styles

Create pivot tables and charts

Learn to trace precedents and dependents

Convert text and validate and consolidate data

Collaborate with others by protecting worksheets and workbooks

Create, use, edit and manage macros

Import and export data

Master Data Services, Data Quality Services with SQL 2012-2014 and Excel

Course Format: Classroom
School/Trainer: Global Knowledge Canada Microsoft Training Centers
Training Center(s)/Venue(s): Halifax, Mississauga, Montreal, Ottawa, Toronto, Winnipeg, Canada
  V

Studies show that data decays at about 2% a month all organizations need to work from reliable information while ensuring that the integrity of information and consistency of data is constant across different applications. Microsoft SQL Server 2012-2014 Master Data Services is a powerful feature designed to help an organization create a structure and hierarchy for data, so that data collected and used across multiple departments, silos and databases is standardized and aligned. This ensures that different databases are interoperable. When combined with Data Quality Services and Excel a complete end to end system is available.

After completing this course, students will be able to:

Have a basic understanding of the concepts behind master data management.

Configure Master Data Services.

Create models and entities.

Add attributes including domain-based attributes.

Add a member via the web interface.

Reverse a transaction.

Create and configure attribute groups.

Create and configure derived hierarchies.

Create and configure collections.

Create a leaf member ... [Read More]

Data Mining, Predictive Analytics with Microsoft Analysis Services and Excel PowerPivot

Course Format: Classroom
School/Trainer: Global Knowledge Canada Microsoft Training Centers
Training Center(s)/Venue(s): Halifax, Mississauga, Montreal, Ottawa, Toronto, Winnipeg, Canada
  V

This three-day instructor-led course will introduce the students to the concepts of data mining, machine learning and predictive analytics utilizing the Microsoft toolsets including SQL Server Analysis Services and Excel with PowerPivot and the Data Mining Add-ins.

After completing this course, students will be able to:

Have a firm understanding of the concept of data mining.

Explore the user interface.

Use offline mode and immediate mode.

Create and configure a data source.

Create and configure data view.

Explore data.

Create and configure named calculation.

Create and configure named queries.

Walk-through a project to completion.

Explore the models.

Compare mining structures.

Use cross validation.

Create reports using Reporting Services.

Save queries.

Save results to the database.

Create multiple nested tables off of a case table.

Use Microsoft Association Rules Algorithm.

Use Microsoft Sequence Clustering Algorithm.

Use Microsoft Time Series Algorithm.... [Read More]

Excel 2016

Course Format: Classroom
School/Trainer: Global Knowledge Canada Microsoft Training Centers
Training Center(s)/Venue(s): Halifax, Mississauga, Montreal, Ottawa, Toronto, Winnipeg, Canada
  V

This three days of Microsoft Word 2016 training class is designed for Excel users who want to learn the topics covered in 2016 interface.

Course Objectives

Create basic worksheets using Microsoft Excel 2016

Perform calculations in an Excel worksheet

Modify an Excel worksheet

Modify the appearance of data within a worksheet

Manage Excel workbooks

Print the content of an Excel worksheet

Learn how to use handy features new in 2016

Use bookmarks, add watermarks and customize the ribbon

Learn to use formulas and functions

Create and modify charts

Convert, sort, filter and manage lists

Insert and modify illustrations in a worksheet

Learn to work with tables

Learn to use conditional formatting and styles

Create pivot tables and charts

Learn to trace precedents and dependents

Convert text and validate and consolidate data

Collaborate with others by protecting worksheets and workbooks

Create, use, edit and manage macros

Import and export data

Pages: 1 2 3 4 5 6 ...


Find Excel training courses, certificates, diplomas and degrees in Countries:



Australia - Canada - India - Indonesia - Ireland - Malaysia - New Zealand
Pakistan - Philippines - Singapore - South Africa - United Arab Emirates
United Kingdom - United States



Tips:
Want to find a place to stay close to the school? Or homestay in a different country? Try the house rental message board where you can search for roommates and post shared rooms or apartments for rent.



- Other Topics -
- Online/E-learning -
Excel
Ask for Training
Add Courses