Microsoft Excel Training Courses in Portland ME, ME

(Click on the course title to view the class syllabus and full list of class dates.)

Microsoft Excel 2016 Introduction (Level 1) -- Our introductory course helps students become familiar with the Excel 2016 program. The course covers all the fundamental functions and operations in Excel 2016 including: creating spreadsheets, working with rows, columns and cells, formatting worksheets and performing basic calculations. This a great class for those who need a refresher in Excel 2016 or are looking to build fundamental skills in the program. View available Excel 2016 Introduction course details.

Excel 2016 Charts Formatting and Reporting The Excel 2016 Charts, Formatting and Reporting course covers the basics of visuals in Excel: creating charts, using styles and templates, and creating advanced formatting. Creating a chart in Word or PowerPoint, Creating Custom Views, Managing Conditional Formatting Rules, Creating a Template, Modifying and Merging Cell Styles, Formatting Chart Elements, and Changing the Chart Type will all be covered in this course. This class is perfect for those whose job responsibilities include creating visuals and managing formatting and have an Excel 2013 or 2016 Introduction or equivalent background. Excel 2016 Charts Formatting and Reporting Course Details

Excel 2016 Database Functions and Pivot Tables The Excel 2016 Database Functions and PivotTables course focuses on managing data and creating PivotTables in Excel. This class will cover the following topics: Using Lists, Formatting a Table, Creating a Slicer, Importing Data from a Text File, Using Database Functions, Creating and Working with PivotTables, Using a Timeline, and Creating a Calculated Field. This class is fitting for students who have a background in either Excel 2013 or 2016 Introduction skills. Excel 2016 Database Functions and Pivot Tables Course Details

Excel 2016 Large Workbooks, Formulas and Functions The Excel 2016 Large Workbooks, Formulas and Functions course is perfect for those who are responsible for managing and creating large worksheets and models in Excel and have Excel 2013 or 2016 Introduction skills mastered. The following topics will be covered in this course: Viewing, Renaming, and Color-coding Worksheets, Using 3-D References, Creating and Using an Absolute Named Range, Using Financial Functions, Creating a Forecast Sheet, Protecting Workbooks and Worksheets, Creating Scenarios, and Using Table Lookup Functions (VLookup & HLookup). Excel 2016 Large Workbooks, Formulas and Functions Course Details

Excel Power User

Excel Macros

Excel 2016 Programming with VBA Our Excel 2016 VBA course helps the use learn how to program in Excel in order to automate repetative tasks, analyze data and integrate Excel 2016 with other Office applications, such as Access 2016. Users should be well versed in the Introductory and Advanced Excel course material before taking this class. The course focuses on the following areas: Working with Procedures and Functions, Understanding Objects, Expressions, Variables, Intrinsic Functions, Controlling Program Execution, Working with Forms, Controls and the Pivot Table Object, Code Debugging and Error Handling. Microsoft Excel 2016 Programming with VBA Training Courses.

Microsoft Excel 2013 Introduction (Level 1) -- Our introductory course helps students become familiar with the Excel 2013 program. The course covers all the fundamental functions and operations in Excel 2013 including: creating spreadsheets, working with rows, columns and cells, formatting worksheets and performing basic calculations. This a great class for those who need a refresher in Excel 2013 or are looking to build fundamental skills in the program. View available Excel 2013 Intro training classes.

Microsoft Excel 2013 Intermediate (Level 2) -- Our intermediate course in Excel 2013 builds on the introductory class. The course covers topics such as Creating and Applying Templates, Creating and Modifying Charts, Calculating with Advanced Formulas, and Sorting and Filtering Data. This is the perfect class for those who know the basics of Excel 2013 and want to become more productive with the software. View available Excel 2013 Intermediate training classes.

Microsoft Excel 2013 Advanced (Level 3) -- Our advanced Excel 2013 course helps students become proficient in the most challenging areas Excel. The course covers all the advanced features and functionality of Excel 2013 including: creating and using macros, importing and exporting data, data formatting, linking workbooks and advanced data analysis. This is an ideal course for Excel power users who want to fully leverage all features Excel 2013 has to offer. View available Excel 2013 Advanced training classes.

Excel 2013/2016 Programming with VBA Our Excel 2013 VBA course helps the use learn how to program in Excel in order to automate repetative tasks, analyze data and integrate Excel 2013 with other Office applications, such as Access 2013. Users should be well versed in the Introductory and Advanced Excel 2013 course material before taking this class. The course focuses on the following areas: Working with Procedures and Functions, Understanding Objects, Expressions, Variables, Intrinsic Functions, Controlling Program Execution, Working with Forms, Controls and the Pivot Table Object, Code Debugging and Error Handling. Microsoft Excel 2013/2016 Programming with VBA Training Courses.

Data Analysis Fundamentals Using Excel

Analyzing Data with Excel

Essential Data Preparation Skills for Data Mining Using Power Query and M

Excel Forecasting and What-If Analysis

Excel 2016 Data Models with PowerPivot

Essential Report Building Skills Using DAX

Analyzing Data with Power BI

Excel BI Tools with Power Pivot, Power Query, Power View and Power Map

Power BI Advanced Analytics with R

Microsoft Excel 2010 Introduction (Level 1) -- Our introductory course helps students become familiar with the Excel 2010 program. The course covers all the fundamental functions and operations in Excel 2003 including: creating spreadsheets, working with rows, columns and cells, formatting worksheets and performing basic calculations. This a great class for those who need a refresher in Excel 2010 or are looking to build fundamental skills in the program. View available Excel 2010 Intro training classes.

Microsoft Excel 2010 Intermediate (Level 2) -- Our intermediate course in Excel 2010 builds on the introductory class. The course covers topics such as Creating and Applying Templates, Creating and Modifying Charts, Calculating with Advanced Formulas, and Sorting and Filtering Data. This is the perfect class for those who know the basics of Excel 2010 and want to become more productive with the software. View available Excel 2010 Intermediate training classes.

Microsoft Excel 2010 Advanced (Level 3) -- Our advanced Excel 2010 course helps students become proficient in the most challenging areas Excel. The course covers all the advanced features and functionality of Excel 2010 including: creating and using macros, importing and exporting data, data formatting, linking workbooks and advanced data analysis. This is an ideal course for Excel power users who want to fully leverage all features Excel 2010 has to offer. View available Excel 2010 Advanced training classes.

Excel 2010 Programming with VBA Our Excel 2010 VBA course helps the use learn how to program in Excel in order to automate repetative tasks, analyze data and integrate Excel 2010 with other Office applications, such as Access 2010. Users should be well versed in the Introductory and Advanced Excel 2010 course material before taking this class. The course focuses on the following areas: Working with Procedures and Functions, Understanding Objects, Expressions, Variables, Intrinsic Functions, Controlling Program Execution, Working with Forms, Controls and the Pivot Table Object, Code Debugging and Error Handling. Microsoft Excel 2010 Programming with VBA Training Courses.

Microsoft Excel 2007 Introduction (Level 1) -- Our introductory course helps students become familiar with the Excel 2007 program. The course covers all the fundamental functions and operations in Excel 2003 including: creating spreadsheets, working with rows, columns and cells, formatting worksheets and performing basic calculations. This a great class for those who need a refresher in Excel 2007 or are looking to build fundamental skills in the program. View available Excel 2007 Introductory training classes.

Microsoft Excel 2007 Intermediate (Level 2) -- Our intermediate course in Excel 2007 builds on the introductory class. The course covers topics such as Creating and Applying Templates, Creating and Modifying Charts, Calculating with Advanced Formulas, and Sorting and Filtering Data. This is the perfect class for those who know the basics of Excel 2007 and want to become more productive with the software. View available Excel 2007 Intermediate training classes.

Microsoft Excel 2007 Advanced (Level 3) -- Our advanced Excel 2007 course helps students become proficient in the most challenging areas Excel. The course covers all the advanced features and functionality of Excel 2007 including: creating and using macros, importing and exporting data, data formatting, linking workbooks and advanced data analysis. This is an ideal course for Excel power users who want to fully leverage all features Excel 2007 has to offer. View available Excel 2007 Advanced training classes.

Excel 2007 Programming with VBA Our Excel 2007 VBA course helps the use learn how to program in Excel in order to automate repetative tasks, analyze data and integrate Excel 2007 with other Office applications, such as Access 2007. Users should be well versed in the Introductory and Advanced Excel 2007 course material before taking this class. The course focuses on the following areas: Working with Procedures and Functions, Understanding Objects, Expressions, Variables, Intrinsic Functions, Controlling Program Execution, Working with Forms, Controls and the Pivot Table Object, Code Debugging and Error Handling. Microsoft Excel 2007 Programming with VBA Training Courses.

Microsoft Excel Self Paced Classes -- Our self paced Excel courses are ideal for students who like to learn at their own pace. The course covers all the fundamental functions and operations in Excel including: creating spreadsheets, working with rows, columns and cells, formatting worksheets and performing basic calculations. This a great class for those who want to learn Excel at their own speed. View available Excel Self-Paced Classes.

• An experienced, professional instructor will come to your office and train your students
• Up to 6 students can attend the class for the flat rate course price of $1600/day (over 10% off our Individual Training rates)
• Additional students can be added for $150/person/day
• Each student receives a Course Manual with Practice Files (Materials will be shipped before the class date)
• Course is scheduled based on dates you provide (Subject to instructor availability)
• We usually require about 2-weeks lead time to arrange a training session
• Training is completed in a convenient 1-day session (Start at 9am and Finish at 4:30pm)
• Two 15 minute breaks and one hour long break for lunch

---

• An experienced, professional instructor will come to your office and train your students
• Up to 12 students can attend the class for the flat rate course price of $2400 (over 33% off our Individual Training rates)
• Additional students can be added for $125/person/day
• Each student receives a Course Manual with Practice Files (Materials will be shipped before the class date)
• Course is scheduled based on dates you provide (Subject to instructor availability)
• We usually require about 2-weeks lead time to arrange a training session
• Training is completed in a convenient 1-day session (Start at 9am and Finish at 4:30pm)
• Two 15 minute breaks and one hour long break for lunch

---

• An experienced, professional instructor will come to your office and train your students
• Up to 18 students can attend the class for the flat rate course price of $3100/day (over 42% off our Individual Training rates)
• Additional students can be added for $100/person/day
• Each student receives a Course Manual with Practice Files (Materials will be shipped before the class date)
• Course is scheduled based on dates you provide (Subject to instructor availability)
• We usually require about 2-weeks lead time to arrange a training session
• Training is completed in a convenient 1-day session (Start at 9am and Finish at 4:30pm)
• Two 15 minute breaks and one hour long break for lunch

Self Paced Online Excel Courses: - Our Excel online training classes are perfect for students who are comfortable with self-directed learning. The self-paced classes cover similar material as the instructor led courses, and are accessable to students 24-7 for a 6 or 12-month license period.

Students are able to review the material as many times as they need to learn the subject matter, and select the topics they want to study. Click here to learn more about Self Paced Online Classes

• Microsoft Excel 2013 Online Training Course
• Microsoft Excel 2016 Online Training Course
• Microsoft Office Value Pack (Best Deal)!!!

We hold our Excel instructor-led training classes for the Portland ME area at the following location:

Portland ME Training Center
477 Congress Street
5th Floor
Portland, ME 4101

This location also serves the following areas around Portland ME, Maine: Bailey Island, Bar Mills, Bustins Island, Buxton, Cape Elizabeth, Chebeague Island, Cliff Island, Cumberland Center, Cumberland Foreside, Falmouth, Gorham, Long Island, North Yarmouth, Ocean Park, Old Orchard Beach, Peaks Island, Saco, Scarborough, South Freeport, South Portland, South Windham, Westbrook, Windham, Yarmouth