Microsoft Excel Training Courses in Buffalo, NY

Learn Excel from a Professional Instructor and take your skills to the next level

Microsoft Excel is a spreadsheet development software application used to organize, manipulate, and analyze data.

Business Computer Skills now offers Microsoft Excel training classes in Buffalo, NY. Get the professional training you need to take your Excel skills to the next level.

Whether you want to learn the basics, become a master of pivot tables and formulas, or working towards an Excel certification, we have the right course for you.

Learn How To:

Navigate the Excel Environment

Format in Excel

Work with Formulas and Functions

Create Charts and Tables

Create and Enhance Pivot Tables

Work with Lookup and Reference Functions (VLOOKUP)

Work with Financial, Date and Logical Functions

Excel Programming and VBA topics

Compare our pricing and variety of course offerings to our competitors like New Horizons, Netcom Learning, Certstaff and Ed2Go and you will see that Business Computer Skills is your best option.

Local CoursesOn-Site TrainingOn-Demand TrainingLocations

Excel Course List

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

Excel 2016 Courses

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 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.

Excel 2013 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.

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.

Excel 2007 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.

Excel Self-Paced Online 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 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

Total Cost for 18 students: $3100/day (Flat Rate)

Excel Self-Paced Training

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