search
Description

This course will teach students advanced concepts and formulas in Microsoft Excel 365. Students will learn functions such as SUMIF, AVERAGEIF, and COUNTIF, advanced lookup functions, and complex logical and text functions. Additionally, students will experiment with auditing formulas and error checking, use the What-If Analysis tools, learn the options for worksheet and workbook protection, review advanced use of PivotTables and PowerPivot add-in, work with Macros, use form controls, and ensure data integrity in their worksheets and workbooks. Students will also learn about Excel's many collaboration features and import and export data to and from their workbooks.

What you will learn?
Advanced concepts and formulas and collaboration features in Excel 365.
Learn functions such as SUMIF, AVERAGEIF, and COUNTIF.
Explore advanced lookup functions, and complex logical and text functions.
Experiment with auditing formulas and error checking.
Use the What-If Analysis tools.
Learn the options for worksheet and workbook protection.
Learn the options for worksheet and workbook protection.
Learn how to ensure data integrity in worksheets and workbooks.
Import and export data to and from workbooks.
schedule Duration
5 hours
emoji_events Certificate
Available
bar_chart Level
Advanced
error_outline Prerequisites
  • Excel 365 Introduction and Intermediate courses or equivalent experience.
check_circle Preparation
No
lock Access
One year

attach_money Price
US$95

emoji_events 100% moneyback guarantee
If you cancel within 10 days and you’re not completely satisfied, we’ll give you all your money back. No questions asked.

Features

emoji_events
Verifiable
We make it easy for you to stay compliant with your organization's requirements by providing completion certificates that you can download anytime.
monitor
Online
You're busy - we get that. That's why we've recruited the top experts in your field to provide courses that you can take on your own schedule.
smart_display
Anytime
Learn at your leisure. You can start, pause, and restart the courses whenever you like. They are mobile optimized for extra convenience.
Learn the Easy Way
Access the course for a full year
Start and finish on your own schedule
Download completion certificates
Share your certificate on LinkedIn
Curriculum
schedule 5
hours
1
Guide
|
1
Quiz
|
83
Video
Curriculum
1 Guide
1 Quiz
83 Video
schedule 5
hours
guide
Section 1. Introduction-Part1
videocam Video
1 m
Introduction
Section 2. Customizing Excel-Part1
videocam Video
9 m
Customizing the Ribbon

videocam Video
6 m
Customizing the Quick Access Toolbar

videocam Video
4 m
Customizing the General and Formula Options

videocam Video
3 m
Customizing the AutoCorrect Options

videocam Video
4 m
Customizing the Save Defaults

videocam Video
3 m
Customizing Advanced Excel Options
Section 3. Analyzing Data with Logical Functions-Part1
videocam Video
3 m
Working with the Most Common Logical Functions

videocam Video
6 m
Understanding IF Functions

videocam Video
5 m
Evaluating Data with the AND Function

videocam Video
3 m
Evaluating Data with the OR Function

videocam Video
5 m
Creating a Nested IF Function

videocam Video
3 m
Using the IFS Function

videocam Video
3 m
Summarizing Data with SUMIF

videocam Video
2 m
Summarizing Data with AVERAGEIF

videocam Video
2 m
Summarizing Data with COUNTIF

videocam Video
3 m
Summarizing Data with MAXIFS and MINIFS

videocam Video
3 m
Using the IFERROR Function
Section 4. Working with Lookup Functions-Part1
videocam Video
3 m
What are Lookup Functions?

videocam Video
8 m
Using VLOOKUP

videocam Video
3 m
Using HLOOKUP

videocam Video
4 m
Using VLOOKUP with TRUE

videocam Video
2 m
Using HLOOKUP with TRUE

videocam Video
3 m
Using the INDEX Function

videocam Video
3 m
Using the MATCH Function

videocam Video
4 m
Combining INDEX and MATCH

videocam Video
2 m
Comparing Two Lists with VLOOKUP

videocam Video
4 m
Comparing Two Lists with VLOOKUP and ISNA

videocam Video
7 m
Using the New XLookup Function

videocam Video
6 m
Using Dynamic Array Functions

videocam Video
4 m
Other New Functions
Section 5. Using Text Functions-Part1
videocam Video
1 m
What are Text Functions?

videocam Video
4 m
Using CONCAT, CONCATENATE, AND TEXTJOIN

videocam Video
2 m
Using Text to Columns

videocam Video
3 m
Using LEFT, RIGHT, and MID Functions

videocam Video
2 m
Using UPPER, LOWER, and PROPER Functions

videocam Video
3 m
Using the LEN Function

videocam Video
1 m
Using the TRIM Function

videocam Video
2 m
Using the SUBSTITUTE Function
Section 6. Working with Date and Time Functions-Part1
videocam Video
2 m
What are Date and Time Functions?

videocam Video
3 m
Using TODAY, NOW, and DAY Functions

videocam Video
3 m
Using NETWORKDAYS and YEARFRAC Functions
Section 7. Formula Auditing-Part1
videocam Video
3 m
Showing Formulas

videocam Video
4 m
Tracing Precedents and Dependents

videocam Video
4 m
Adding a Watch Window

videocam Video
4 m
Error Checking
Section 8. What-If Analysis-Part1
videocam Video
7 m
Using the Scenario Manager

videocam Video
3 m
Using Goal Seek

videocam Video
4 m
Analyzing with Data Tables
Section 9. Worksheet and Workbook Protection-Part1
videocam Video
2 m
Understanding Protection

videocam Video
5 m
Encrypting Files with Passwords

videocam Video
2 m
Allowing Specific Worksheet Changes

videocam Video
3 m
Adding Protection to Selected Cells

videocam Video
3 m
Additional Protection Features
Section 10. Automating with Macros-Part1
videocam Video
3 m
What are Macros?

videocam Video
3 m
Displaying the Developer Tab

videocam Video
5 m
Creating a Basic Formatting Macro

videocam Video
3 m
Assigning a Macro to a Button

videocam Video
4 m
Creating Complex Macros

videocam Video
4 m
Viewing and Editing the VBA Code

videocam Video
3 m
Adding a Macro to the Quick Access Toolbar
Section 11. Working with Form Controls-Part1
videocam Video
2 m
What are Form Controls?

videocam Video
4 m
Adding a Spin Button and Check Boxes

videocam Video
7 m
Adding a Combo Box
Section 12. Ensuring Data Integrity-Part1
videocam Video
2 m
What is Data Validation?

videocam Video
2 m
Restricting Data Entry to Whole Numbers

videocam Video
4 m
Restricting Data Entry to a List

videocam Video
2 m
Restricting Data Entry to a Date

videocam Video
1 m
Restricting Data Entry to Specific Text Lengths

videocam Video
2 m
Composing Input Messages

videocam Video
3 m
Composing Error Alerts

videocam Video
2 m
Finding Invalid Data

videocam Video
1 m
Editing and Deleting Validation Rules
Section 13. Collaborating in Excel-Part1
videocam Video
3 m
Working with Comments

videocam Video
2 m
Printing Comments and Errors

videocam Video
4 m
Sharing a Workbook

videocam Video
2 m
Co-Authoring in Excel

videocam Video
3 m
Tracking Changes in a Workbook

videocam Video
3 m
Working with Versions

videocam Video
3 m
Sharing Files via Email
Section 14. Importing and Exporting Data to a Text File-Part1
videocam Video
4 m
Importing a Text File

videocam Video
1 m
Exporting Data to a Text File
Section 15. Conclusion-Part1
videocam Video
2 m
Course Recap

quiz Quiz
Review Questions
Learn from the best
Intellezy Trainers
Offering eLearning and Instructor-led Training at your fingertips!

Intellezy collaborates with organizations to help implement and adopt technology to its maximum potential. From our change management consulting to our learning and development services, Intellezy uses both culture and education to drive the ROI of any organization. Our online videos and quick reference guides are designed to educate and empower individuals, right when they nee...

Read More
Student Reviews
4.6 (39)
5 stars
29
4 stars
7
3 stars
2
2 stars
0
1 star
1
4.6 (39)
5 stars
29
4 stars
7
3 stars
2
2 stars
0
1 star
1
Start learning now
Course
Excel 365 - Advanced
Advanced concepts, formulas and collaboration tools
Format: Online
Level: Advanced
Certificate: Available
Duration: 5 hours
TOTAL
US$95
You’ll be charged this price and get immediate access to all learning materials. Taxes are calculated at checkout.
Frequently Asked Questions
Can't find the answer you are looking for? Contact our support team

Each profession and regulatory body has its own requirement. These requirements are in a state of flux. As a result of the changing nature of professional development requirements it’s best to visit your association’s website.

Each course is created by instructor(s). The main part of each course is a set of videos that you can watch on-demand. Courses can also include quizzes, articles and supporting resources like PDF, Excel and other documents.

After completion of each course or package you will be able to download a certificate with the course title and number of hours. Certificates, as well as your study records, are stored for life and you can access them anytime.

The course starts as soon as you sign up - you will have full access to all course content and materials immediately and have up to 365 days to complete it.

Our Packages and Custom Package are subscription-based. That means after the end of the subscription period (usually a year) you will be automatically enrolled in a new Package with a new set of courses and charged the same amount. You can cancel the subscription anytime before the renewal date or within 10 days after the renewal and get a refund. No questions asked.

A Custom Package is a subscription-based service that allows you to select any courses from our platform within a specified number of total hours. Any courses that are available on the platform can be added to your Package. The Custom Package provides you with the freedom and flexibility of choosing courses for a discounted price compared to buying individual courses separately.

Unfortunately, we cannot share personal instructor information. If you have questions about a course please contact our support team.

Information is accurate as of the date the video was posted. We make every effort to ensure that videos are up to date.

In order to reset your password please use the following link: https://learnformula.com/forgetpassword. Enter the email address you used to sign up for our platform and a reset password email will be sent to this email address.

We strive to provide a broad range of content to professionals and are continually sourcing and publishing new content as it becomes available.

You will receive a “Certificate of Completion” upon viewing a course. We store your certificate on our database, so you don’t have to worry about losing it.

For your convenience, you can easily watch our videos on your phone and tablet as well as on your desktop or laptop computer. Anywhere you have an Internet connection can be a place to complete your professional development.

To register for a course, visit the course landing page, click ‘Add to Cart’. In your cart, enter your Payment Details, and click “Pay”. You can then view and access your purchased courses in the “My courses” tab in the top right header.

To be awarded the completion certificate, you must complete the course in its entirety, by viewing all videos, completing all interactive tasks and supplementary reading, and finishing all quizzes. Certain governing or accreditation bodies have further requirements. For example, to earn a IRS-registered certificate, you must complete all of the above, and additionally receive a minimum grade of 70% on the Final Exam. You should always check with your governing body to see specific requirements for your accreditation.

If you cancel within 10 days, and you’re not completely satisfied, we’ll give you all your money back. No questions asked. For more information regarding refund, complaint, and/or program cancellation policies please contact our offices at 888-987-0858. You may also reach out for support to Marionne Sumalinog at support@learnformula.com

Once you have completed all the sections of the course, the course progress will show as 100% complete, and will now appear under the Completed tab in your My Courses page. Under the course thumbnail, click "Get a certificate" to view your certificate and download it, if you wish. The certificate is also stored in our database so you don't have to worry about losing it. Certificates become available immediately after you complete the course, and are stored in our systems indefinitely.

Every course is arranged uniquely by the instructor, but they're all easy to navigate through. Once you click on your purchased course, you'll see the curriculum, made up of videos, quizzes, and/or supplementary materials. To begin the course, simply click on the first video. From there, you can click on ""Next Activity"" to move through the course, or navigate through the course using the left-hand menu. Please note that you must view all videos in their entirely, and complete all quizzes, final exams, and supplementary materials, as applicable, for the course to register as complete, and to receive your certificate.

To purchase a Team License, first, locate a package you wish to purchase for your team. This may be either a Regular Package, or a Custom Package, to allow each member of your team to curate their own package. Once you have selected a package to purchase, please enter your information and click "Sign Up". In your Shopping Cart, click "Team License (2+)" and select the number of team members you would like to purchase the package for. Enter any coupon codes, and proceed through Checkout as usual. Once you have purchased the Team License, invite all your team members! You can check up on your team's progress by clicking "Team Courses" in the top right corner of your screen.
Have Questions?
help_outline Requirements
We have compiled the requirements for various professional associations to help you identify the right courses for you.
chat Support Center
Still seeking your answer?
Let us help you directly.