Excel Data Analysis Training is unfortunately unavailable

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

Excel Data Analysis Training
Sold Out
Questions about this class?
Get help now from a knowledge expert!

Excel Data Analysis Training

at Learning Tree International - Rockville

Course Details
Price:
$1,950
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:
Rockville
1801 Rockville Pike 2nd Fl
At Rollins Ave
Rockville, Maryland 20852
(Map)
Share:
Important:
Course 195
Description
Class Level: Intermediate
Age Requirements: 18 and older
Average Class Size: 16

What you'll learn in this excel class:

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

You Will Learn How To:
  • Leverage features of Microsoft Excel to facilitate business decisions
  • Develop intelligent worksheets to quickly identify KPIs
  • Perform "what-if" analyses for developing budget and project plans
  • Summarize and analyze large amounts of data using PivotTables and Excel features
  • Automate Excel processes
Requirements: Experience with Excel fundamentals at the level of:
Course 1361, Microsoft Excel Introduction

Software: This course is applicable to all versions of Excel, from Excel 97 to Excel 2016

Course Outline:
  • Troubleshooting and Enhancing Professional Workbooks
  • Analyzing Data with Functions
  • Optimizing Workbook Models with "What-If" Analysis
  • Summarizing Business Information
  • Formulating Decisions from Database Information
  • Enhancing Excel Usage with Macros

Still have questions? Ask the community.

Refund Policy
If a customer would like to cancel or transfer their course, they must notify Coursehorse prior to two weeks before the start date of the course or within seven days of registration. On-Demand Courses cannot be cancelled once purchased and are not eligible for refund.

If a customer transfers to another course prior to two weeks before the start date or within seven days of registration of the course in which originally enrolled, 100% of any prepaid course tuition will be applied toward the course tuition for the subsequent course.

If a customer needs to cancel an enrollment two weeks prior to the start of the class or within seven days of registration, we will refund 100% of any prepaid course tuition for that enrollment.

If a customer does need to transfer or cancel a course within two weeks of the start date of the course or after seven days from the date of registration, a fee equal to 50% of the price of the course will be assessed for any standard attendances. Attendances associated with a Learning Tree program will be assessed a $500 fee. Training Passports, Training Vouchers and Pay-As-You-Learn Vouchers cannot be used after their expiration dates, and a course cancellation or transfer by the customer will not extend a Training Passport, Training Voucher Pack or Pay-As-You-Learn Voucher Pack expiration date.

Map

Google Map

Learning Tree International

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

School: Learning Tree International

Learning Tree International

Established in 1974, Learning Tree International is a leading provider of IT training and management training to business and government organizations worldwide. In addition, Learning Tree provides IT Workforce Optimization Solutions – a modern approach that improves the adoption of skills, and accelerates...

Read more about Learning Tree International

CourseHorse Approved

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

Want to take this class?

Save to Wish List
Taking this class for work? Get exclusive perks & discounts for free.

7 Top Choices

Excel Data Analysis with PivotTables

at Certstaffix Training - Largo 1300 Caraway Ct Ste 200, Largo, Maryland 20774

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 much more.  Being able to harness...

Thursday Oct 10th, 10am - 2pm

Excel VBA Programming

at Certstaffix Training - Largo 1300 Caraway Ct Ste 200, Largo, Maryland 20774

This 3-day Excel VBA Programming course is designed to give experienced Microsoft Excel users proficiency in creating procedures that run in response to specific events, working with control structures, developing user forms to accept or display data, validating the data entry in user forms, debugging and handling errors in code, and much more! Excel...

Monday Oct 14th, 10am - 5pm

  (3 sessions)
$995

3 sessions

Excel Level 2

at Certstaffix Training - Largo 1300 Caraway Ct Ste 200, Largo, Maryland 20774

This course will teach students how to perform more advanced calculations and work with larger worksheets in Microsoft Excel. In this intermediate Excel course, you will learn how to:  Perform Calculations on Data Manage Worksheet Data Reorder and Summarize Data Combine Data from Multiple Sources Analyze Alternative Data Sets and Collaboration...

Tuesday Oct 8th, 10am - 5pm

Excel Level 3

at Certstaffix Training - Largo 1300 Caraway Ct Ste 200, Largo, Maryland 20774

This course will teach students advanced tasks in Microsoft Excel. In this advanced Excel course, you will learn about:  Alternative Data Sets Dynamic Worksheets with PivotTables Automating Repetitive Tasks with Macros Working with Other Microsoft Office Apps Business Intelligence Analysis and Forecasts and Visualizations Excel Versions...

Thursday Oct 17th, 10am - 5pm

Excel Bootcamp

at General Assembly - Penn Quarter 509 7th St NW 3rd Fl, Washington, District of Columbia 20004

This Bootcamp is designed to provide participants 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, participants are expected to be able to learn...

Saturday Oct 19th, 10am - 5pm

Excel Level 1

at Certstaffix Training - Largo 1300 Caraway Ct Ste 200, Largo, Maryland 20774

This course will introduce students to spreadsheets and the fundamentals concepts of Microsoft Excel. Learn these features of Microsoft Excel and get more done quickly.  Learn how to:  Quickly set up workbooks Enter data, and format it for easier viewing Perform calculations and find and correct errors Visualize data with charts and...

Tuesday Oct 15th, 10am - 5pm

Excel Dashboards

at Certstaffix Training - Largo 1300 Caraway Ct Ste 200, Largo, Maryland 20774

This course builds upon the foundation knowledge presented in the Excel - Level 1 course and will help start you down the road to creating advanced workbooks and worksheets that you can use to create a dashboard. The ability to analyze massive amounts of data, extract actionable intelligence from it, and present that information to decision makers...

Thursday Nov 14th, 10am - 5pm