Disclosure: when you buy through links on our site, we may earn an affiliate commission.

Excel 2019 Advanced

Unlock the true potential of Excel with powerful tools like lookups, error-handling, macros, and scenario analysis
0.0
0.0/5
(0 reviews)
1 students
Created by

9.8

CourseMarks Score®

10.0

Freshness

N/A

Feedback

9.1

Content

Platform: Udemy
Video: 1h 32m
Language: English
Next start: On Demand

Top Excel courses:

Detailed Analysis

CourseMarks Score®

9.8 / 10

CourseMarks Score® helps students to find the best classes. We aggregate 18 factors, including freshness, student feedback and content diversity.

Freshness Score

10.0 / 10
This course was last updated on 5/2022.

Course content can become outdated quite quickly. After analysing 71,530 courses, we found that the highest rated courses are updated every year. If a course has not been updated for more than 2 years, you should carefully evaluate the course before enrolling.

Student Feedback

We analyzed factors such as the rating (0.0/5) and the ratio between the number of reviews and the number of students, which is a great signal of student commitment.

New courses are hard to evaluate because there are no or just a few student ratings, but Student Feedback Score helps you find great courses even with fewer reviews.

Content Score

9.1 / 10
Video Score: 7.8 / 10
The course includes 1h 32m video content. Courses with more videos usually have a higher average rating. We have found that the sweet spot is 16 hours of video, which is long enough to teach a topic comprehensively, but not overwhelming. Courses over 16 hours of video gets the maximum score.
Detail Score: 10.0 / 10

The top online course contains a detailed description of the course, what you will learn and also a detailed description about the instructor.

Extra Content Score: 9.5 / 10

Tests, exercises, articles and other resources help students to better understand and deepen their understanding of the topic.

This course contains:

0 article.
1 resources.
0 exercise.
0 test.

Table of contents

Description

After you’ve mastered formatting tables of data, creating formulas between cells, using built-in functions, and creating charts, there is a standard set of more powerful features you’ll eventually need. Whether you’re looking at someone else’s spreadsheet and wondering “how did they do that?” or simply lacking enough firepower to get your own spreadsheets to do what you want, this class will probably solve that problem.
Database Features – You may be thinking “I use spreadsheets, not databases!” — but there are a few indispensable Excel features that mirror the most useful of features from the world of databases: lookups and aggregate functions. A “lookup” in Excel is when your formula looks up values in a secondary worksheet (just like a database!) and puts them in the primary worksheet: for example, looking up in worksheet B the inventory amount adjacent to a cell containing a particular SKU, and putting it in worksheet A, adjacent to the cell containing that same SKU. Likewise, the SUMIF(), COUNTIF(), and similar Excel functions are counterparts of “aggregate data” calculations in databases – useful, for example, if you wanted to sum up the order values shipped to a particular zip code.
Errors – You’ve probably encountered your fair share of errors that Excel has vociferously pointed out with: “#N/A” and “#NUM!” It turns out there’s an easy way to deal with these errors, either by intercepting them and providing a backup value, or by auditing and fixing them once and for all. We’ll show you the two surefire methods of handling these errors.
Finding the Right Value(s) – Sometimes you need to measure variations in a single cell value, like product price, to optimize the value of another cell, like profits. Other times, you need to optimize multipleinterconnectedcells, like price, volume, and inventory – to find the optimal value for profits. These two what-if scenarios are handled by the “Goal Seek” and “Solver” functions in Excel. Get ready to impress your boss.
Macros – These are recorded steps that can be memorized for later playback. For example, if you find yourself splitting text into columns along a delimiter and then conditionally formatting certain rows, you might want to record those steps and then instantly reapply them to a new table. These steps are saved in Excel’s internal programming language, VBA (Visual Basic for Applications). Once you’ve recorded your steps, you can dive into the behind-the-scenes VBA code that activates those steps and customize them even further.
Pro Techniques – On your way to becoming an Excel pro, you’ll need a toolkit of useful standard tips, tricks, and techniques. Among these, you’ll probably find that functions such as LEFT(), MID(), and Excel’s Text-To-Columns and Consolidating Data features are the ones you’ll use the most often. We’ll show you why those are so popular and how to use them.
This is course 3 of 3 in Learnit Anytime’s Excel 2019 training series.

You will learn

✓ Use database functions like VLOOKUP(), SUMIF(), and AVERAGEIF()
✓ Fix errors using auditing or handle inevitable errors with backup values
✓ Apply data cleanup and isolation/consolidation techniques
✓ Find optimal values for a single cell or a set of inter-related cells
✓ Create and run basic macros to automate repetitive tasks
✓ Add macros to the Excel ribbon

Requirements

• Familiarity with Excel’s primary features
• Recommended: Completion of our Excel 2019 Intermediate course

This course is for

• Users with a good amount of Excel experience looking to gain high-level knowledge
• Advanced Excel users looking for a quick refresher

How much does the Excel 2019 Advanced course cost? Is it worth it?

The course costs $14.99. And currently there is a 25% discount on the original price of the course, which was $49.99. So you save $35 if you enroll the course now.

Does the Excel 2019 Advanced course have a money back guarantee or refund policy?

YES, Excel 2019 Advanced has a 30-day money back guarantee. The 30-day refund policy is designed to allow students to study without risk.

Are there any SCHOLARSHIPS for this course?

Currently we could not find a scholarship for the Excel 2019 Advanced course, but there is a $35 discount from the original price ($49.99). So the current price is just $14.99.

Who is the instructor? Is Learnit Anytime a SCAM or a TRUSTED instructor?

Learnit Anytime has created 27 courses that got 9,024 reviews which are generally positive. Learnit Anytime has taught 31,083 students and received a 4.5 average review out of 9,024 reviews. Depending on the information available, Learnit Anytime is a TRUSTED instructor.
Self-Paced Online Training Videos
Learnit Anytime is an online training provider with over 27 years of experience teaching to millions of students, including industry leaders. Our self-paced E-Learning helps you gain new skills, quickly and conveniently. If you’re serious about learning, we’re serious about providing you with the best content for your learning needs.

9.8

CourseMarks Score®

10.0

Freshness

N/A

Feedback

9.1

Content

Platform: Udemy
Video: 1h 32m
Language: English
Next start: On Demand

Students are also interested in

Review widget (for course creators):

Excel 2019 Advanced rating
Code for the widget (just copy and paste it to your site):
<a href="https://coursemarks.com/course/excel-2019-advanced-2/" target="_blank" title="Excel 2019 Advanced on Coursemarks.com"><img border="0" src="https://coursemarks.com/widget/98.svg" width="200px" alt="Excel 2019 Advanced rating"/></a>