Excel Lookups, Functions and Macros is unfortunately unavailable

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

Excel Lookups, Functions and Macros

at AcademyX - Downtown

(63)
Course Details
Price:
$350
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:
Downtown, Downtown/Northeast
915 Wilshire Blvd Ste #1800
Near Francisco St
Los Angeles, California 90017
(Map)
Purchase Options
Save to WishList

2 people saved this class

Book Private Class
Description
Class Level: Advanced
Age Requirements: 18 and older
Average Class Size: 4

What you'll learn in this excel class:

Macros, collaboration, security are the foundations of this advanced Excel class. You will learn about different scenarios and how to use what if analysis. 

Advanced functions and much more are also covered:

  • Using IF, SUMIF, and COUNTIF to process data based on rules
  • Using the VLOOKUP, INDEX and MATCH functions to find data in related worksheets
  • Auditing: how to find errors using tracing, IFERROR, and other functions
  • Defining arrays and using array functions to work with groups of data
  • Advanced functions for manipulating dates, times, text
  • Statistical and financial functions
  • Importing external data from the web
  • Scenarios using goal seek, scenario manager and input data tables
  • Using the Analysis Toolpack for correlations and histograms
  • Recording and replaying macros and basic VBA code
  • Creating a form with buttons to add interactivity to your spreadsheet

This course builds on the concepts and skills of our Excel Intermediate course to provide advanced tools for solving real-worl problems in Excel: lookup and decision-making functions, auditing and error-handling, array functions, date and text functions, importing and exporting, the Power Pivot Data Model, what-if analysis, and macros.

You will benefit the most from this course if you want to use Excel to perform real-world tasks such as getting information from large amounts of data from sources inside and outside of Excel, creating output that varies according to conditions, manipulating dates and text, and automating repetitive tasks.

Logical and Lookup Functions

  • Decision-Making Functions
  • Lookkup and Reference Functions

Advanced Formulas

  • Auditing And Error-Trapping
  • Formula Options

Special Functions

  • Date And Time Functions
  • Text Functions
  • Other Functions

Importing And Exporting

  • The Power Pivot Data Model
  • Exploring Data

Analysis

  • What-If Analysis
  • The Analysis Toolpak

Macros And Forms

  • Recording Macros
  • Running Macros
  • Forms

Internationalization And Accessibility

  • Preparing Workbooks For Internationalization And Accessibility

Prerequisites:

  • Excel Intermediate or the equivalent in work experience.

Still have questions? Ask the community.

Refund Policy
If you need to reschedule or cancel a class, it's usually no problem. We will move you to a different session, or give you a full refund as long as you give us at least 7 days' notice. If, however, you notify us less than one week before the class (a "late-cancellation"), we do not offer a refund and you only qualify for a late-reschedule. We charge $25 for any reschedule, $50 for reschedules with fewer than 72 hours' notice, and $100 for reschedules with fewer than 24 hours' notice (or no-shows)
Students may withdraw from any course (except when they have late-rescheduled) after instruction has started within 2 hours and receive a full refund, provided the reason for their withdrawal is dissatisfaction with the course. In the case of multi-day and multi-evening courses, students may withdraw after any session before the course's half-way point and receive pro-rated refund for the unused portion of the tuition.

Map

Google Map

AcademyX

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 3500 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 AcademyX (63)

(63 Reviews)
Excel Lookups, Functions and Macros
Reviewed by Anonymous on 4/22/2016
Excellent instructor. Class materials were just right.
Excel Lookups, Functions and Macros
Reviewed by Anonymous on 4/22/2016
Excel Lookups, Functions and Macros
Reviewed by Anonymous on 4/22/2016
Excel Lookups, Functions and Macros
Reviewed by Anonymous on 5/29/2015
loading...

School: AcademyX

AcademyX

AcademyX offers hands-on, instructor-led training in MS Office, Adobe web and graphic design apps, web technologies, programming languages and servers.  In business since 2000, we have trained over 15,000 students. We use contract trainers that practice in the field when they're not teaching classes....

Read more about AcademyX

CourseHorse Approved

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

Want to take this class?

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

67 Top Choices

Excel for Business Fundamentals

This class is temporarily being offered remotely.

at NYIM Training - Midtown 185 Madison Ave 3rd Floor, New York, New York 10016

Get started in Excel with this fundamental Excel course. Get comfortable using Excel and learn to boost your productivity with formulas, charts, and formatting techniques. Master the core Excel functions in this one-day course. Learn calculations and data entry. Apply formatting to text and cells to make your spreadsheet scannable and visually appealing....

Wednesday Dec 9th, 10am - 5pm Eastern Time

Intermediate Excel for Business

This class is temporarily being offered remotely.

at NYIM Training - Midtown 185 Madison Ave 3rd Floor, New York, New York 10016

Go from beginner to experienced professional: summarize data with Pivot Tables, write advanced functions including VLOOKUP, and learn techniques to expedite your workflow. Split and join text, create drop-down menus, and sort and filter data. Use statistical formulas like COUNTIFS and SUMIFS to learn more about your data. At the end of this class,...

Thursday Dec 10th, 10am - 5pm Eastern Time

Advanced Excel for Business

This class is temporarily being offered remotely.

at NYIM Training - Midtown 185 Madison Ave 3rd Floor, New York, New York 10016

Master advanced Excel techniques in this hands-on training. Learn how to use the more advanced tools in Excel like What-If Analysis, INDEX-MATCH, macros, and more. Advance your career with this essential course for professionals that use Excel daily. You'll make functions more flexible, take Pivot Tables to the next level, and automate tasks with...

Monday Dec 7th, 10am - 5pm Eastern Time

Intermediate Microsoft Excel

This class is temporarily being offered remotely.

at NYC Career Centers - Midtown 185 Madison Ave 3rd Floor, New York, New York 10016

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 time-saving tricks like Paste Special, keyboard...

Thursday Dec 10th, 10am - 5pm Eastern Time

Microsoft Excel Essentials

This class is temporarily being offered remotely.

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

This live instructor-led hands-on course will cover basic to intermediate topics in Excel. All students will be given a computer to follow along and a custom training manual with all the steps and description of Excel functions. The topics covered in this course can be applied to Excel 2007, 2010, 2013, 2016 & 2019. This course is great for someone...

Monday Jan 11th, 10am - 6pm Eastern Time

Microsoft Excel Expert (Level 3)

This class is temporarily being offered remotely.

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

Wednesday Jan 13th, 10am - 6pm Eastern Time

Excel Bootcamp

This class is temporarily being offered remotely.

at General Assembly - Online Online Class
Livestream, New York, New York 00000

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

Friday Dec 11th, 11am - 5pm Eastern Time

Financial & Statistical Applications in Microsoft Excel

This class is temporarily being offered remotely.

at Baruch College - CAPS - Online 00000

This course is designed for Excel users who would like develop their quantitative skills for managerial decision making. Students will learn how to use present value, Internal Rate of Return, Standard Deviation and more. It features a mix of case studies, individual exercises and group activities. This course is appropriate for all students who wish...

Saturday Dec 5th, 9:30am - 5:30pm Eastern Time

Microsoft Excel Level 1

This class is temporarily being offered remotely.

at Training Connection - Downtown 915 Wilshire Blvd Ste 1800, Los Angeles, California 90017

This hands-on beginner class is suitable for Excel 2010, 2013 and 2016 users. You will learn to create, modify, format and print Excel worksheets and workbooks. You will learn basic formulas and functions, how to manipulate data, and how to add charts. Live face-to-face instructor. No minimum class size - all classes guaranteed to run! This course...

Monday Dec 7th, 9am - 4:30pm Pacific Time

Advanced Excel Training

This class is temporarily being offered remotely.

at General Assembly - Online Online Class
Livestream, New York, New York 00000

Virtually everyone who works with data could benefit by gaining a better understanding of Microsoft Excel. This class will extend beyond the simple addition of data and will put participants in a position where Excel is no longer a chore, but a powerful tool to assist in manipulating data efficiently. You’ll learn various functions to help you organize...

Monday Dec 7th, 9pm - 11:55pm Eastern Time

Excel Bootcamp

This class is temporarily being offered remotely.

at General Assembly - Online Online Class Livestream, Online, Massachusetts 00000

If you know the basics of Microsoft Excel and want to take your knowledge to the next level, then this hands-on bootcamp is for you. Whether you are in business, management, or simply interested in getting more organized, this Excel bootcamp will cover the tools and functions you need to automate or enhance the way you analyze and restructure your...

Friday Dec 11th, 11am - 5pm Eastern Time

Microsoft Excel Level 2

This class is temporarily being offered remotely.

at Training Connection - Downtown 915 Wilshire Blvd Ste 1800, Los Angeles, California 90017

This hands-on intermediate class is suitable for Excel 2010/2013/2016 users. You will learn to share data across multiple worksheets and workbooks, work with named ranges, filter and sort data, use PivotTables and PivotCharts, conditional formatting, advanced charting, and how collaborating with others.  Live face-to-face instructor. No minimum...

Tuesday Dec 8th, 9am - 4:30pm Pacific Time

Microsoft Excel Level 3

This class is temporarily being offered remotely.

at Training Connection - Downtown 915 Wilshire Blvd Ste 1800, Los Angeles, California 90017

This hands-on class is suitable for Excel 2013, 2016, 2019 and 365 users. On this class you will learn advanced functions including LOOKUPS, Date and Time Functions, Text Functions, Statistical Functions, and Financial Functions. You will learn how to import and export data using the Power Pivot Data model and analysis data using What-If Analysis,...

Wednesday Dec 9th, 9am - 4:30pm Pacific Time

Online Excel Genius 5: Pivot Tables

This class is temporarily being offered remotely.

at The New York Public Library (Tech) - NYPL Online Classroom

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.  To participate hands-on in this class, it is advised that you have one of the following versions of Excel: PC...

Monday Dec 7th, 2pm - 4pm Eastern Time

Free

Advanced Excel Training

This class is temporarily being offered remotely.

at General Assembly - Online Online Class Livestream, San Francisco, California 00000

Virtually everyone who works with data could benefit by gaining a better understanding of Microsoft Excel. This class will extend beyond the simple addition of data and will put participants in a position where Excel is no longer a chore, but a powerful tool to assist in manipulating data efficiently. You’ll learn various functions to help you organize...

Monday Dec 7th, 6pm - 9pm Pacific Time

Advanced Excel Training

This class is temporarily being offered remotely.

at General Assembly - Online Online Classroom, Los Angeles, California 00000

Virtually everyone who works with data could benefit by gaining a better understanding of Microsoft Excel. This class will extend beyond the simple addition of data and will put participants in a position where Excel is no longer a chore, but a powerful tool to assist in manipulating data efficiently. You’ll learn various functions to help you organize...

Monday Dec 7th, 6pm - 9pm Pacific Time

Advanced Excel Training

This class is temporarily being offered remotely.

at General Assembly - Online Remote Online , Denver, Colorado 00000

Virtually everyone who works with data could benefit by gaining a better understanding of Microsoft Excel.  This class will extend beyond the simple addition of data and will put participants in a position where Excel is no longer a chore, but a powerful tool to assist in manipulating data efficiently. You’ll learn various functions to help...

Monday Dec 7th, 7pm - 10pm Mountain Time

Advanced Excel Training

This class is temporarily being offered remotely.

at General Assembly - Online Online Class, Houston, Texas 00000

Virtually everyone who works with data could benefit by gaining a better understanding of Microsoft Excel. This class will extend beyond the simple addition of data and will put participants in a position where Excel is no longer a chore, but a powerful tool to assist in manipulating data efficiently. You’ll learn various functions to help you organize...

Monday Dec 7th, 8pm - 11pm Central Time

Advanced Excel Training

This class is temporarily being offered remotely.

at General Assembly - Online GA Washington D.C. (Remote Online), Washington, District of Columbia 00000

Virtually everyone who works with data could benefit by gaining a better understanding of Microsoft Excel. This class will extend beyond the simple addition of data and will put participants in a position where Excel is no longer a chore, but a powerful tool to assist in manipulating data efficiently. You’ll learn various functions to help you organize...

Monday Dec 7th, 9pm - 11:55pm Eastern Time

Advanced Excel Training

This class is temporarily being offered remotely.

at General Assembly - Online Online Class Livestream, Atlanta, Georgia 00000

Virtually everyone who works with data could benefit by gaining a better understanding of Microsoft Excel. This class will extend beyond the simple addition of data and will put participants in a position where Excel is no longer a chore, but a powerful tool to assist in manipulating data efficiently. You’ll learn various functions to help you organize...

Monday Dec 7th, 9pm - 11:55pm Eastern Time