Discover Classes. Earn Rewards.

Analyzing Data with Excel is unfortunately unavailable

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

Effectively Communicating in The Moment

American Management Association @ 2345 Crystal Dr , Arlington, VA

Discover how to confidently navigate impromptu communication situations and respond in the moment with this course at the American Management Association. Learn strategies for managing stress, organizing your thoughts, and using impactful nonverbal behaviors. Develop the skills to handle challenging questions, workplace situations, and mediated communication with professionalism and ease.

(5) All levels 21 and older
$2,695

2 sessions

Gift it!

Getting started in Real Estate Photography

Capital Photography Center

Are you ready to excel in the dynamic field of Real Estate Photography? Join our comprehensive class at Capital Photography Center and learn essential lighting techniques, composition theory, and more. Enroll now and take your skills to the next level!

(10) Beginner 16 and older
See all Excel classes Washington, D.C.

Analyzing Data with Excel

  • Intermediate
  • 18 and older
  • $2,650
  • 13650 Dulles Technology Dr, Herndon, VA
  • 22 hours & 30 minutes over 3 sessions
Analyzing Data with Excel
Sold Out

Start Dates (0)

  • $2,650
  • Herndon Education and AnyWare Center @ 13650 Dulles Technology Dr Ste #175, Herndon, VA 20171
  • 22 hours & 30 minutes over 3 sessions
  • Course 8433
Showing 10 of 0

Class Description

Description

What you'll learn in this excel class:

This official Microsoft Analyzing Data with Excel (20779) course and learn to add BI techniques to Excel data analysis. The course goes beyond the capabilities of tables and charts and uses Pivot Charts, the Excel Data Model, and Power BI.

Plus, this course will prepare you for Microsoft exam 70-779, a core requirement for the MCSA: BI Reporting certification.

You Will Learn How To:

  • Explore and extend a classic Excel dashboard
  • Explore and extend an Excel data model
  • Pre-format and import a .CSV file
  • Import data from a SQL Server database
  • Import data from a report
  • Create measures using advanced DAX functions
  • Create data visualizations in Excel
  • Create a Power BI dashboard with Excel

Requirements: Before attending this course, students must have:

  • Basic knowledge of the Microsoft Windows operating system and its core functionality
  • Extensive knowledge of Excel spreadsheets including formulas, charts, filtering, sorting, and sub-totals
  • Working knowledge of relational databases
  • Basic knowledge of data analytics equivalent to having attended course 10994

Note: This course is eligible for Microsoft Software Assurance Training Voucher (SATV) redemption.


Course Outline:

  • Module 1: Data Analysis in Excel
  • Module 2: The Excel Data Model
  • Module 3: Importing Data from Files
  • Module 4: Importing Data from Databases
  • Module 5: Importing Data from Excel Reports
  • Module 6: Creating and Formatting Measures
  • Module 7: Visualizing Data in Excel
  • Module 8: Using Excel with Power BI

Refund Policy

If a customer would like to cancel or transfer their course, they must notify Coursehorse prior to 3 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 3 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 3 weeks prior to the start of the class or within seven days of registration, we will refund 95% of any prepaid course tuition for that enrollment.
  • If a customer does need to transfer or cancel a course within 3 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.

In the event that an instructor or the school needs to cancel at the last minute, students will receive a refund less a 5% non-refundable registration fee.

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.

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 26500 points. Points give you money off your next class!

Questions & Answers (0)

Get quick answers from CourseHorse and past students.

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 Washington, D.C. educator.

Learning Tree International

Learning Tree International

All classes at this location

Google Map

Give This Course as a Gift Card

  • Thousands of classes
  • No expiration
  • Unique and memorable gifts for any occasion
  • Personalized
  • Explore a passion, gain a new skill, discover a new hobby, engage in a memorable experience
  • Instant delivery
  • Lock in a price with the Inflation Buster Gift Card Price Adjuster™

Buy a Gift Card

Book this Class as a 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.

CourseHorse Gift Cards

  • Creative & unique gift for any occasion
  • Thousands of classes & experiences
  • No expiration date
  • Instant e-delivery (or choose a date)
  • Add a personalized message
  • Lock in a price with the Inflation Buster Gift Card Price Adjuster™
Buy a Gift Card
gift card with the CourseHorse logo gift card with the CourseHorse logo
Loading...