We use cookies on our website to improve our service to you, by continuing you agree to our use of cookies. However you are able to update your settings at any time.

Continue Cookie Settings

Cookie Policy

A cookie, also known as an HTTP cookie, web cookie, or browser cookie, is a piece of data stored by a website within a browser, and then subsequently sent back to the same website by the browser. Cookies were designed to be a reliable mechanism for websites to remember things that a browser had done there in the past, which can include having clicked particular buttons, logging in, or having read pages on that site months or years ago.

Strictly Necessary Cookies

These cookies cannot be disabled

These cookies are necessary for the website to function and cannot be switched off. They are normally set in response to your interactions on the website e.g. logging in etc.

Cookies:
  • .ASPXANONYMOUS
  • .DOTNETNUKE
  • __RequestVerificationToken
  • authentication
  • CV_Portal
  • CV_Store_Portal_Cart_0
  • CV_USER
  • dnn_IsMobile
  • language
  • LastPageId
  • NADevGDPRCookieConsent_portal_0
  • userBrowsingCookie

Performance Cookies

These cookies allow us to monitor traffic to our website so we can improve the performance and content of our site. They help us to know which pages are the most and least popular and see how visitors move around the site. All information these cookies collect is aggregated and therefore anonymous. If you do not allow these cookies we will not know when you have visited or how you navigated around our website.

Cookies:
  • _ga
  • _gat
  • _gid

Functional Cookies

These cookies enable the website to provide enhanced functionality and content. They may be set by the website or by third party providers whose services we have added to our pages. If you do not allow these cookies then some or all of these services may not function properly.

Cookies:

Currently we are not utilizing these types of cookies on our site.

Targeting Cookies

These cookies may be set through our site by our advertising partners. They may be used by those companies to build a profile of your interests and show you relevant adverts on other sites. They do not store directly personal information, but are based on uniquely identifying your browser and internet device. If you do not allow these cookies, you will experience less targeted advertising.

Cookies:

Currently we are not utilizing these types of cookies on our site.

  • 0
    Cart Summary
    {{item.Name}}
    		{{item.LineTotalFormatted}}
    {{cart.FormattedSubTotal}}
    View my Cart Checkout
    You do not currently have any items in your cart.
/Portals/0/NADevEventsImages/excel-256_80.png

Excel Guru I: Advanced Formulas & Functions

Date & Time:

Course Length: 2 hours

Average Rating: (6 reviews)

Course Tuition: $147.00 USD

Book Now

This power-packed course will teach you the most common, powerful functions that pros use everyday to make their spreadsheets easier to use and more functional. Learn how to use important functions such as IF, VLOOKUP, SUMIFS, and many more. Find out how to use Text and Date functions within your spreadsheets, and discover the marvel that FlashFill offers for managing text. This is the class that separates the kids from the adults when it comes to Excel. You must have at least intermediate skills in Excel to take this course.

  • Absolute References & Named Ranges
  • 3D Formulas
  • IF, SUMIFS, AVERAGEIFS, COUNTIFS
  • VLOOKUP & HLOOKUP
  • Text and Date Functions
  • Flash Fill
  • Text-to-Columns

When you take a course from us, you are getting a ton of cool and helpful resources to make your learning as easy and complete as possible!

You'll get:

  • A world-class, live online course delivered by a top instructor with years of experience
  • Hands-on exercises - you will not just be watching, but provided you have the software on your computer, you will also be doing the exercises too!
  • A downloadable training manual, customized just for the course you are taking - free!
  • An optional recording of your session for downloading within 24 hours of your session. You can play it back as many times as you wish!
  • Free repeat privileges for the course, FOREVER! Just contact us when you'd like to retake, and we'll set you up!
  • 100% money-back guarantee, for an entire YEAR!
  • Our commitment to you, that your experience will be the best you've ever had in a training session. Our instructors are caring, knowledgeable, funny, and they like people. You'll have fun too!

Why should I pay for something I get free on YouTube or other video training sites?

Excellent question.

For one thing, you can't get what we offer free on YouTube or even on video training websites.

Our training is much more than "just a webinar". See why our training solution offers you the best of all possible worlds - from our 1-year 100% money back guarantee, to our FREE REPEAT policy - you will be pleased with your results with us!

Click here to read all the benefits of training with us.

Barb Danson

Super class! If you're looking for a course to teach you the more advanced functions in Excel, this is it! Teacher was great, class materials good. Five stars!

Jerry Connors

Worth it. Thorough and clear teaching.

Jim Branson

A good overview of powerful functions that I didn't know about. Highly recommended.

Sally R.

The instructor took time to explain everything really clearly. I felt it was a good value for the money.

Sarah Hanson

This class helped me to understand more of the advanced functions in Excel. This is really going to help me in my job. Thanks.

Tim Johnson

Excellent presentation. I really learned a lot and will look for more classes.

Add a Review

Book Now Save To Calendar Save To PDF Add To My Wish List