Discover Classes. Earn 10% Rewards.

Excel for Data Analytics

Bring professional rigor to how you organize and interpret data in this hands-on course. You'll work through advanced Excel techniques for sorting, filtering, grouping, and visualizing data, leaving with stronger analytics skills for better reporting.

  • All levels
  • 18 and older
  • Earn 10% Rewards
  • Price Lock

    Secure your booking now and we'll match any price drop within 48 hours across all booking platforms, ensuring you never miss out on savings!

  • 185 Madison Ave, New York, NY & Virtually Online

Express Checkout – $595


Proceed to Checkout

No Booking Fees. Lowest Price Guaranteed. Earn 10% Rewards.

Give as a Gift

Start Dates (12) $595/person

Show all 3 sessions
  • Mon, Nov 09 at 10:00am - 5:00pm
  • Tue, Nov 10 at 10:00am - 5:00pm
  • Wed, Nov 11 at 10:00am - 5:00pm
20 left
Book
Show all 3 sessions
  • Tue, Jan 05 at 10:00am - 5:00pm
  • Wed, Jan 06 at 10:00am - 5:00pm
  • Thu, Jan 07 at 10:00am - 5:00pm
20 left
Book
Show all 6 sessions
  • Tue, Jan 05 at 6:00pm - 9:00pm
  • Thu, Jan 07 at 6:00pm - 9:00pm
  • Tue, Jan 12 at 6:00pm - 9:00pm
  • Thu, Jan 14 at 6:00pm - 9:00pm
  • Tue, Jan 19 at 6:00pm - 9:00pm
  • Thu, Jan 21 at 6:00pm - 9:00pm
20 left
Book
Show all 3 sessions
  • Sun, Jan 10 at 10:00am - 5:00pm
  • Sun, Jan 17 at 10:00am - 5:00pm
  • Sun, Jan 24 at 10:00am - 5:00pm
20 left
Book
Show all 3 sessions
  • Tue, Mar 02 at 10:00am - 5:00pm
  • Wed, Mar 03 at 10:00am - 5:00pm
  • Thu, Mar 04 at 10:00am - 5:00pm
20 left
Book
Showing 1 – 5 of 12

Book a Private Group Event

Booking this class for a group? Find great private group events

Or see all Excel Group Events

Explore group events and team building activities ranging from cooking, art, escape rooms, trivia, and more.

Class Description

Description

Unlock the full power of Excel's data analytical capabilities. Master database functions, analytic tools, and other advanced techniques that you can apply to professionally organize and visualize data for meaningful insights.

Applying Excel to Data Analytics Work:

If you want to develop Excel skills and venture into data analytics, this course is perfectly suited for you. You will learn to leverage Excel for professional-level analytical work.

Build Practical Skills Through Hands-On Projects:

To develop efficient data analysis capabilities, you will complete projects under the mentorship of an experienced instructor. This practical approach ensures you can apply what you learn directly to real-world scenarios.

Master Core Functions and Advanced Formulas:

You will study advanced techniques to sort, filter, group, and visualize data effectively within Excel. These skills form the foundation for becoming proficient in data analysis.

Course Prerequisite:

  • Participants must have beginner-level Excel skills equivalent to our Excel Fundamentals course, including knowledge of basic functions and formulas, printing, formatting, basic chart creation, and working with data tables.

Learn more about Excel for Data Analytics at Noble Desktop.

Syllabus

Excel Level I: Fundamentals

  • Learn how to use functions to speed up your workflow
  • Add formatting and other visual effects
  • Turn data into visual charts, including line, column, and pie charts
  • Learn tips and tricks for easy workbook management

Excel Level II: Intermediate

  • Learn to split and join text, add data validation, and named ranges
  • Use database functions and logical statements
  • Create Pivot Tables to quickly summarize large databases
  • Create advanced combo charts from multiple charts

Excel Level III: Advanced

  • Cell management, including cell locking, auditing, and hot keys
  • Special formatting for calculating dates
  • Use advanced functions and advanced analytical tools
  • Record macros and relative reference macros for ad hoc reporting

Refund Policy

  • Students may cancel up to 14 days before the class/program start date and receive a refund, less the registration fee (10% of the undiscounted course price). 
  • Cancellations within 14 days are not permitted, but students may reschedule up to three business days before the class start date.
  • For cancellations and reschedules, please email us at [email protected]

In any event where a customer wants to cancel their enrollment and is eligible for a full refund, a 5% processing fee will be deducted from the refund amount.

Reviews of Classes at Noble Desktop (452)

(4.6-star rating across 452 reviews)

This class: 5.0 out of 5 from 1 review

  • Excel for Data Analytics

See reviews for other classes at Noble Desktop
loading...
Hide Reviews

Similar Classes

Noble Desktop

Noble Desktop is a reputable New York-based training institute known for offering a wide range of creative and technical courses, including web development, design, coding, and digital marketing. With a strong emphasis on hands-on learning and industry-relevant skills, Noble Desktop equips individuals with the knowledge and expertise needed to excel in today's competitive job market.

View school profile
Noble Desktop
Vetted by CourseHorse

A verified Brooklyn educator.

CourseHorse’s Choice 4.6 out of 5 · 452 reviews
Loading...