Discover Classes. Earn 10% Rewards.

Excel 2016: Part 3 is unfortunately unavailable

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

Microsoft Excel Level 1 - Introduction

Training Connection @ 915 Wilshire Blvd, Los Angeles, CA

Learn how to create, modify, format, and print Excel worksheets and workbooks in this hands-on beginner class at Training Connection. Discover basic formulas and functions, manipulate data, and add charts to your spreadsheets. Ideal for those new to Excel who need to produce reports, budgets, and lists.

(158) Beginner 14 and older
$395
Attend
+3950 pts
Gift it!

Microsoft Excel Level 2 - Intermediate

Training Connection @ 915 Wilshire Blvd, Los Angeles, CA

Enhance your Excel skills with this intermediate course that teaches you to share, filter, and sort data as well as create PivotTables, apply conditional formatting, and more. Join us for a live instructor-led class and take your Excel knowledge to the next level.

(158) Intermediate 14 and older
$395
Attend
+3950 pts
Gift it!

Microsoft Excel Level 3 - Advanced

Training Connection @ 915 Wilshire Blvd, Los Angeles, CA

Take your Excel skills to the next level with a hands-on course that covers advanced functions, data analysis, importing/exporting, and automation. Join us for a live, face-to-face class to learn from experienced instructors and enhance your proficiency in Excel 2013, 2016, 2019, or 365. No minimum class size - all classes are guaranteed to run!

(158) Advanced 14 and older
$395
Attend
+3950 pts
Gift it!

Microsoft Excel Level 4 - Macros & VBA

Training Connection @ 915 Wilshire Blvd, Los Angeles, CA

Enhance your Excel skills with this instructor-led course that will teach you how to write and debug powerful VBA code to automate Excel operations. Learn to create interactive forms, handle run-time errors, and more. Prerequisite: Completion of Excel Advanced or equivalent experience.

(158) Advanced 14 and older
$495
Attend
+4950 pts
Gift it!

Excel Introduction

ONLC Training Centers @ 10940 Wilshire Blvd, Santa Monica, CA

Gain the essential skills needed to create and format spreadsheets in Excel. Learn to enter data, use formulas, and format worksheets with ease in this comprehensive introductory course. Perfect for anyone looking to enhance their ability to create and manipulate basic spreadsheets.

(7) Beginner 18 and older
$295
Attend
+2950 pts
Gift it!
See all Excel classes Los Angeles

Excel 2016: Part 3

  • Advanced
  • 18 and older
  • $295
  • Earn 2,950 reward points
  • Virtual Class, Online, CA
  • 8 hours

Start Dates (0)

  • $295
  • 8 hours
Showing 10 of 0

Class Description

Description

What you'll learn in this excel class:

Excel is a powerhouse spreadsheet software used by companies small and large. Master this popular platform by completing the Excel 2016 - Part 3 course from New Horizons.

This advanced Excel course builds off learnings from Excel 2016 - Parts 1 & 2 and prepares you to complete difficult Excel tasks such as LOOKUPS, macros and more. The course also covers Microsoft Office Specialist exam objectives to help you prep for the certification exam.

Target Audience

If you’re proficient in Excel 2016 and looking to master more advanced features, this course is for you.

Course Objectives 

Once you complete Excel 2016 - Part 3, you’ll be able to perform advanced data analysis, collaborate on workbooks and automate workbook functionality.

This course empowers you to:

  • Refer to internal and external worksheets
  • Perform LOOKUPs and audit formulas
  • Share and protect workbooks
  • Automate workbook functionality using validation rules and macros
  • Create sparklines and map data
  • Forecast data

Prerequisites

  • Excel 2016 - Part 1
  • Excel 2016 - Part 2

Excel 2016 - Part 3 is an advanced course.

To get the most out of your Excel 2016 training, you should have completed Excel 2016 - Part 1 and Excel 2016 - Part 2 or have real-world experience creating and analyzing datasets using Excel 2016.

When enrolling in this course, you should also know how to work with functions and lists, build charts, create advanced formulas, manipulate datasets and tables, use PivotTables and PivotCharts and customize the Excel environment.

Course Outline
1 - WORKING WITH MULTIPLE WORKSHEETS & WORKBOOKS

  • Reference Cells and Groups of Cells Across Worksheets
  • Link Cells to External Worksheets
  • Consolidate Data Across Worksheets
  • 2 - USING LOOKUP FORMULAS AND FORMULA AUDITING
  • Search Rows or Columns Using LOOKUP Functions
  • Display Relationships Between Cells and Formulas with the Trace Command
  • Watch Cells and Formulas From the Watch Tool
  • 3 - SHARING AND PROTECTING WORKBOOKS
  • Collaborate on Workbooks
  • Apply Varying Levels of Workbook Access and Protections
  • 4 - AUTOMATING WORKBOOK FUNCTIONALITY
  • Create and Manage Validation Rules and Lists
  • Search for Invalid Data and Formulas with Errors
  • Record Macros to Automate Tasks
  • 5 - CREATING SPARKLINES AND MAPPING DATA
  • Create Sparklines to Show Trends
  • Map Data
  • 6 - FORECASTING DATA
  • Determine Potential Outcomes Using Data Tables and Scenarios
  • Solve for Desired Outputs with the Goal Seek Feature
  • Forecast Data Trends
  • Refund Policy

    For open enrollment classes, ten (10) business days' written notice is required to reschedule a class with no additional fees.

    In case of a no-show or a cancellation with less than ten (10) business days before class date: 100% of the class price will be due according to the date of original invoice or date of Term Net 30.

    Reviews of Classes at New Horizons Learning Group LA (1)

    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. Earn 10% back in reward points!

    Questions & Answers (0)

    Get quick answers from CourseHorse and past students.

    New Horizons Learning Group LA

    New Horizons Learning Group has been serving businesses and individuals in the Arizona, California and Nevada communities for over 35 years. With ten convenient locations we offer a wide range of technical, application and business skills courses. As the world of computer technology continues to evolve...

    Read more about New Horizons Learning Group LA

    CourseHorse Approved

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

    New Horizons Learning Group LA

    New Horizons Learning Group LA

    All classes at this location

    Before your course begins we will reach out to you and ensure your system is properly configured.

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