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 Mastery II: Intro to Formulas & Functions

Date & Time:

Course Length: 2 hours

Average Rating: (5 reviews)

Course Tuition: $147.00 USD

Book Now

In this eye-opening session, you'll get insights into how to work with Excel formulas and functions, using best practices, taught by a teacher who has used Excel for over 30 years! You'll discover when to use a formula or a function, common pitfalls to avoid, and how to check your work for errors. You'll learn the most common functions that you'll use frequently, as well as how to easily copy formulas and functions using the AutoFill Handle. Take this foundational course that will set you up for super success in your number crunching career!

  • Introduction
  • The difference between formulas and functions
  • The Basic Rules of Match (PEMDAS) (and why you need to know them!)
  • The worst thing you can do in a formula or function
  • Best practices for making formulas and functions
  • How to check for errors in your formulas and functions
  • Common functions covered:
    • SUM
    • AVERAGE
    • COUNT
    • MIN
    • MAX
  • How to quickly copy your formulas and functions
  • Useful tips and tricks!
  • Q & A with your instructor
  • Live, hands-on training! (you won't just be watching!)

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.

Gary Barman

This class gave me a good foundation on how to work with Excel functions. Well paced and good instruction.

Jim Ackerman

Thorough and clear course. I learned a lot and brushed up on my skills too. Instructor was personable and answered questions. Recommended.

Nina Wallace

Super training! Loved the material, instruction was clear, and enjoyable. Will be taking the next class.

Sarah Brighton

I loved the class! Now I understand how formulas work much better. Thanks for great training!

Susan Truman

Great introduction to Excel formulas. I learned a lot of things I didn't know about Excel that will help me in my porjects. Thanks for a great class.

Add a Review

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