Excel 2010 Intermediate is unfortunately unavailable

Thankfully we have 56 other Excel Classes for you to choose from. Check our top choices below or see all classes for more options.

Excel 2010 Intermediate

at ONLC Training Centers - Murray Hill

(5)
Course Details
Price:
$295
Start Date:

This class isn't on the schedule at the moment, but save it to your Wish List to find out when it comes back!
If you're enrolled in an upcoming date, this simply means that date has now sold out.

Location:
Murray Hill, Manhattan
275 Madison Ave 14th Fl
At E 40th St
New York, New York 10016
(Map)
Share:
Important:
All classes are live, hands-on training via remote instructor.
Purchase Options
Description
Class Level: Intermediate
Age Requirements: 18 and older
Average Class Size: 7

What you'll learn in this excel class:

In this course, you will work with Microsoft® Office Excel® 2010 create charts and tables. You will learn handy formatting and tools for error checking. You will create formulas to that use built-in functions to do advanced analysis. You will also learn to create shared workbooks and to track changes in shared workbooks. 

This course is designed for students who are interested in going beyond basic skills and need to chart and format using Microsoft® Office Excel® 2010.

Prerequisites
Excel 2010 Introduction or equivalent skills. Must be able to create, open, save, format and print a worksheet. Should be able to use formulas and the SUM function. The ability to copy, move and delete values and formulas is required.

Working with Worksheets
  • Viewing, Renaming, and Color-coding Worksheets
  • Editing a Group
  • Manipulating Worksheets
  • Creating Linked Formulas
  • Using 3-D References
Working with Functions
  • Using Absolute Cell References
  • Creating and Using Named Ranges
  • Creating a Relative Named Range
  • Using Custom Zoom
  • Using Functions
  • Working with Insert Function
  • Using Financial Functions
  • Using Date Functions
Working with Formatting and Data Validation
  • Applying Conditional Formatting
  • Using Data Validation
  • Creating and Using Custom Formats
  • Working with Auditing and Error Checking Tools
Working with Charts
  • Creating Charts
  • Changing the Chart Location and Size
  • Changing the Chart Type
  • Modifying Chart Elements
  • Formatting Chart Elements
  • Adding and Removing Data Series
  • Printing Charts
  • Creating and Using a Chart Template
  • Creating a Sparkline
Using Table Features
  • Creating a Table
  • Using AutoComplete
  • Sorting a Table
  • Filtering a Table
  • Working with the Total Row
  • Creating a Calculated Column
  • Formatting a Table
Using Styles and Templates
  • Working with Cell Styles
  • Merging Styles
  • Using Templates
  • Creating Templates
Using Protection and Shared Workbook Features
  • Protecting Workbooks and Worksheets
  • Protecting a Workbook
  • Protecting a Worksheet
  • Allowing Users to Edit Ranges
  • Working with Shared Workbooks
  • Configuring a Workbook for Shared Use
  • Highlighting Tracked Changes
  • Creating the History Report
  • Reviewing Shared Workbook Changes
  • Merging Workbooks

Still have questions? Ask the community.

Refund Policy
Student cancellation requests made 14 calendar days or less before the class starts will be charged 100% of the course fee and are not entitled to a refund. The student has one (1) opportunity to use our Make-Up policy to have those funds applied to a later class date.

Map

Google Map

ONLC Training Centers

All classes at this location

Start Dates (0)

This class isn't on the schedule at the moment, but save it to your Wish List to find out when it comes back!

Similar Classes

Benefits of Booking Through CourseHorse

Booking is safe. When you book with us your details are protected by a secure connection.
Lowest price guaranteed. Classes on CourseHorse are never marked up.
This class will earn you 2950 points. Points give you money off your next class!
Questions about this class?
Get help now from a knowledge expert!
Questions & Answers (0)

Get quick answers from CourseHorse and past students.

Reviews of Classes at ONLC Training Centers (2)

School: ONLC Training Centers

ONLC Training Centers

ONLC Training Centers was founded in 1983 when Jim Palic and Andy Williamson left their positions as mainframe programmers with the Dupont Company to start one of the industry's first computer training companies.

Over thirty years and still growing, ONLC Training Centers is one of the the largest privately...

Read more about ONLC Training Centers

CourseHorse Approved

This school has been carefully vetted by CourseHorse and is a verified NYC educator.

Want to take this class?

Save to Wish List
Booking this class for a group? Find great private group events here

56 Top Choices

Intermediate Excel for Business

at NYIM Training - Murray Hill 185 Madison Ave 11th Fl, New York, New York 10016

Intermediate Excel for Business Intermediate Excel for Business covers the essential applications of Excel used frequently by business professionals. This course is perfect for those with familiarity with basic formulas and functions, charts, and workbook management techniques. In this intermediate-level course, you will learn Pivot Tables, database...

Monday Oct 21st, 10am - 5pm

Excel Programming with VBA

at NYIM Training - Murray Hill 185 Madison Ave 11th Fl, New York, New York 10016

The Excel Power Programming with VBA concentrates on how to automate repetitious Excel tasks and reports. By the end of this course, you will feel confident in writing macros to automate your Excel tasks, even if the data is not consistently formatted, creating custom Excel applications and environments, and creating custom Excel Add-ins to increase...

Tuesday Oct 29th, 9am - 5pm

  (2 sessions)
$595

2 sessions

Intermediate Microsoft Excel 2016

at NYC Career Centers - Midtown 185 Madison Ave Ste 1104, New York, New York 10016

Intermediate Microsoft Excel 2016 Class Overview The intermediate Excel class focuses on more advanced functions (including VLOOKUP, COUNTIFS and SUMIFs), Sort & Filter, and Pivot Tables. You'll also learn crucial text-related features like splitting and joining text, removing duplicates, and data validation. Embedded in the course are pivotal...

Monday Oct 21st, 10am - 5pm

Excel for Business Fundamentals

at NYIM Training - Murray Hill 185 Madison Ave 11th Fl, New York, New York 10016

Excel for Business Fundamentals covers the essential applications of Excel used frequently by business professionals. In this introductory course, you will learn basic and multi-input functions, absolute references, charts and tables. We will help you produce polished and presentable work with formatting and printing techniques, while learning crucial...

Thursday Oct 24th, 10am - 5pm

Beginner Microsoft Excel 2016

at NYC Career Centers - Midtown 185 Madison Ave Ste 1104, New York, New York 10016

Microsoft Excel Training Course Overview - Level 1 The Career Center, hands on, instructor-led, Beginner Excel training class in New York City will teach you to organize, calculate, analyze, revise, and present your data. Our basic Excel training course is classroom based instruction, with a live instructor, to introduce the basic look and feel...

Thursday Oct 24th, 10am - 5pm

Microsoft Excel Expert (Level 3)

at Technical Institute of America - Hell's Kitchen 545 8th Ave 4th Fl, New York, New York 10018

We are offering a Microsoft Excel Expert Course. The class will teach you how to create Marco's, conditional formatting, securing your workbooks, expert functions, auditing worksheets, analyzing data, and importing, exporting data.  This course is perfect for someone who uses Microsoft Excel already, or took our Excel essentials course and wants...

Thursday Oct 24th, 10am - 6pm

Advanced Excel for Business

at NYIM Training - Murray Hill 185 Madison Ave 11th Fl, New York, New York 10016

Advanced Excel for Business Advanced Excel for Business covers the advanced applications of Excel used frequently by business professionals. This course is perfect for those with strong working knowledge and practice in Excel looking to apply more complex Excel features. In this advanced course, you will learn Goal Seek, Data Tables, advanced functions,...

Monday Oct 28th, 10am - 5pm

Excel for Mac Level 1

at NYIM Training - Murray Hill 185 Madison Ave 11th Fl, New York, New York 10016

Excel for Mac covers the essential applications of Excel used frequently by business professionals. In this introductory course, you will learn basic and multi-input functions, absolute references, charts and tables. We will help you produce polished and presentable work with formatting and printing techniques, while learning crucial tricks to facilitate...

Thursday Oct 24th, 10am - 5pm

Microsoft Excel Essentials

at Technical Institute of America - Hell's Kitchen 545 8th Ave 4th Fl, New York, New York 10018

We are offering a Microsoft Excel Course. The class will teach you how to create and modify worksheets, enter complex formulas, create Pivot tables and Charts, inserting objects, and working with tables. Our Small classes allow everyone more time to interact with the instructor, learn faster, and more effectively.  This is a great course for...

Wednesday Oct 23rd, 10am - 6pm

Intermediate Excel: Formulas & Functions

at General Assembly - Flatiron 10 E 21st St 3rd Fl, New York, New York 10010

The Intermediate Excel: Formula and Functions workshop is designed for students who have mastered the material from the Excel at Excel workshop and are looking to build upon those skills. Given that there lacks an enforceable prerequisite, the workshop does review a few topics from the Excel at Excel workshop, including conditional math functions and...

Monday Oct 28th, 6:30pm - 9:30pm

Excel Genius Class 5: Pivot Tables

at The New York Public Library - Fordham Heights 310 E Kingsbridge Rd, Bronx, New York 10458

This class will cover Pivot Tables, a powerful tool used to analyze relationships between data.  We will cover setting up data for use in Pivot Tables, how to format results, filtering techniques, and interactive elements.   Skills required: Know how to navigate menu options in Excel Understand formatting and conditional formatting

Monday Oct 21st, 1pm - 3pm

Free

Excel VBA Macros Level I

at NYC Career Centers - Midtown 185 Madison Ave Ste 1104, New York, New York 10016

Microsoft Excel VBA Macros Level I Class Overview Our VBA Excel Macro Classes will instruct you how to use basic Macros to automate Excel. You will be able to use your Excel knowledge more productively by incorporating Macros in your spreadsheets. This Excel Macro Course assumes no previous knowledge of Macros. Excel VBA Macros Level 1 course is...

Tuesday Oct 29th, 9am - 5pm

Excel Data Analysis Training

at Learning Tree International - Midtown 1601 Broadway 9th Fl, New York, New York 10019

Expand your ability to professionally present your results by applying the skills used in this course. With this training, you gain the knowledge and skills to build more sophisticated spreadsheets, perform “what-if” analyses, apply functions, manipulate PivotTables, and use the advanced features of Excel to aid in making and presenting business...

Monday Oct 21st, 9am - 4:30pm

  (2 sessions)
$1,590

2 sessions

Excel Bootcamp

at General Assembly - Flatiron 10 E 21st St 3rd Fl, New York, New York 10010

The bootcamp is designed to provide students with a general overview of Excel topics and specifically more knowledge of several different functions. It combines most of the material from the two workshops into an intense one-day session. Given the short timeframe and large amount of topics covered, students are expected to be able to learn quickly....

Thursday Oct 31st, 10am - 4pm

Microsoft Excel for Windows

at LaGuardia Community College - Sunnyside 3110 Thomson Ave, Long Island City, New York 11101

Learn the basic functions of Microsoft Excel for Windows, including the creation of spreadsheets, shortcut menus, sorting, Autosum and Autofill commands, cut/copy/paste, charts, linking workbooks, the "if" statement and printing. Please bring a USB flash drive to class.  Prerequisite: Computers and Internet Basics or equivalent experience. ...

Monday Oct 21st, 6pm - 9pm

  (8 sessions)
$285

8 sessions

Excel 2016 Fundamentals

at Corporate Training Group - New Jersey 120 S Wood Ave 4th Fl, Ste 405, Iselin, New Jersey 08830

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. Upon successful completion of this course, you will be able to: Create and develop Excel worksheets and workbooks in order to work with and analyze the data that is critical to the success...

Tuesday Oct 22nd, 9am - 4pm

Excel Level 2 (2016/2013/2010)

at NetCom Learning - Hell's Kitchen 519 8th Ave, New York, New York 10018

Whether you need to crunch numbers for sales, inventory, information technology, human resources, or other organizational purposes and departments, the ability to get the right information to the right people at the right time can create a powerful competitive advantage. After all, the world runs on data more than ever before and that's a trend not...

Tuesday Oct 22nd, 9am - 5pm

Excel 2013 Fundamentals

at Corporate Training Group - New Jersey 120 S Wood Ave 4th Fl, Ste 405, Iselin, New Jersey 08830

Organizations the world over rely on information to make sound decisions regarding all manner of affairs. But with the amount of available data growing on a daily basis, the ability to make sense of all of that data is becoming more and more challenging. Excel can help you organize, calculate, analyze, revise, update, and present your data in ways...

Tuesday Oct 22nd, 9am - 4pm

Excel Genius 8: LOOKUP and INDEX MATCH

at The New York Public Library (Tech) - Manhattan 188 Madison Ave, New York, New York 10016

Excel Genius is a new set of classes aimed at students who have taken the Beginner and Intermediate Excel courses, or who have good fundamental knowledge of Excel, and who would like to gain a deeper understanding of the world’s most popular spreadsheet application.  Each class will cover a topic in depth and then give students exercises that...

Tuesday Oct 22nd, 10:15am - 12:15pm

Free

Excel Level 3 (2016/2013/2010)

at NetCom Learning - Hell's Kitchen 519 8th Ave, New York, New York 10018

This course builds off of the foundational and intermediate knowledge presented in the Microsoft Office Excel: Level 1 and Level 2 courses to help you get the most of your Excel experience. The ability to collaborate with colleagues, automate complex or repetitive tasks, and use conditional logic to construct and apply elaborate formulas and functions...

Wednesday Oct 23rd, 9am - 5pm