Class Level:
Advanced
Discover Classes. Earn Rewards.
Thankfully we have 4 other Excel Classes for you to choose from. Check our top choices below or see all classes for more options.
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.
In this three-hour session for Windows and Mac users, you will learn to write complex formulas using Excel's built-in functions and array formulas. You will expand your library of functions to include financial, text parsing, logical, lookup and database functions. You will also learn to write array formulas, which are capable of performing multiple calculations in a single result. Finally, you will gain essential formula auditing and troubleshooting skills.
Prerequisites
This class is ideally suited for those who have attended the Excel Beginning 2: Simple Formulas class or who are already comfortable creating basic formulas like SUM, AVERAGE, COUNT, LEFT, MID, RIGHT and PMT.
Class Outline
Advanced Formulas using Functions
Still have questions? Ask the community.
Cancellations made 3 or more days in advance will receive a full credit for a rescheduled date with this provider
----
You may cancel or reschedule a class registration at least seven days prior to the class without incurring any penalty. After seven days, we may charge a penalty of up to 100% of the registration cost.
Accelerate Computer Training
Long Beach, Other Suburbs/Cities
200 Pine Ave Ste 280
Btwn E 3rd St & E Broadway
Long Beach, California 90802 Long Beach, Other Suburbs/Cities
200 Pine Ave Ste 280
Btwn E 3rd St & E Broadway
Long Beach, California 90802
This class isn't on the schedule at the moment, but save it to your Wish List to find out when it comes back!
Accelerate Computer Training, based in Long Beach, California, provides hands-on computer training classes to Southern California, Los Angeles County, Orange County and the Inland Empire in accelerated small group, instructor-led classes. Through progressive, hands-on training exercises, you learn...
Read more about Accelerate Computer Training
This school has been carefully vetted by CourseHorse and is a verified LA educator.
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...
This hands-on beginner class is suitable for Excel...
Read moreMonday Jul 18th, 9am - 4:30pm Pacific Time
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...
This hands-on intermediate class is suitable for Excel...
Read moreTuesday Jul 19th, 9am - 4:30pm Pacific Time
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,...
This hands-on class is suitable for Excel 2013, 2016,...
Read moreWednesday Jul 20th, 9am - 4:30pm Pacific Time
at Training Connection - Downtown 915 Wilshire Blvd Ste 1800, Los Angeles, California 90017
This instructor-led course will help advanced Excel users to develop new skills to write and debug powerful VBA code to automate Excel operations such as inserting and formatting text, sorting and duplicating data, generating reports and more. You’ll also learn how to create interactive forms, insert calculations and handle run-time errors Live...
This instructor-led course will help advanced Excel...
Read moreThursday Jul 21st, 9am - 4:30pm Pacific Time
Know someone who would like this class but not sure of their schedule? (We recommend this!)
Know their schedule better than your own? Book a date and time directly.
Get it first. Sign up for up-to-the-minute offers, sales and news.
More in Microsoft Office
ALWAYS EARNING
We give you 5% back in rewards for every dollar spent on classes!
ALWAYS SAVING
Once you have $5 in reward points, you can apply them as a discount on future orders.
Questions? Contact us!
Get special date and rate options for your group. Submit the form below and we'll get back to you within 2 business hours with pricing and availability.
Ch Gift Card
Made in NYC