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

Excel 2019 Intermediate

Expand your Excel knowledge - enhance your spreadsheets with Pivot Tables, advanced charts, and more
0.0
0.0/5
(0 reviews)
1 students
Created by

9.7

CourseMarks Score®

10.0

Freshness

N/A

Feedback

9.0

Content

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

Top Excel courses:

Detailed Analysis

CourseMarks Score®

9.7 / 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.0 / 10
Video Score: 7.8 / 10
The course includes 1h 30m 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: 9.8 / 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

Mastery of Excel is developed in stages: first you learn basic formatting, functions and formulas, and build a few spreadsheets yourself. Easy enough. But moving to the next level of proficiency is hard! To create truly professional-looking spreadsheets, you’ll need to know how to organize data into elegant, interactive tables that dynamically generate colorful charts and graphs. To bring you up to an intermediate-level usage of Excel, we’ll train you in how to use the following core features.
Advanced Tables – Beyond organizing data in rows and columns, we’ll show you how to create filters that display only certain rows: for example, all the rows where the “City” column is set to “New York.” You’ll also learn how to sort entire tables based on values in one or more columns: for example, sorting customers by annual revenue. You’ll learn how to instantly colorize, stripe, filter and subtotal a simple table of data using Excel’s ever-popular “Format As Table” feature.
Charts – Excel has 10 major chart types, everything from basic line charts to scatter plots. We’ll show you how to add impressive data visualizations to your spreadsheets: line charts, bar graphs, pie charts, and more.
Pivot Tables – One of Excel’s most powerful — and least understood — features, pivot tables auto-magically convert static rows and columns of data into a responsive table that will re-organize itself to instantly display subtotals, averages, or other aggregate functions — depending on which fields you choose. Instead of creating 3 different tables to see sales by customer rep, customers by city, and revenue by state, you’ll learn how to create a single pivot table to display all 3 sets of information in one place, based on your selection of different field groupings. You’ll also learn how to generate pivot charts from the data.
Tips & Tricks – The training also covers a few techniques we’ve selected as the most useful in your journey toward Excel mastery. These include “conditional formatting”: coloring cells based on their values (e.g., heat maps); removing duplicates (common in data cleanup); data validation: preventing anything except certain data types (e.g., dates) being entered in a cell; and cell protection: preventing accidental typing into a cell with a formula.
This is course 2 of 3 in Learnit Anytime’s Excel 2019 training series.

You will learn

✓ Make analyzing large data sets easier by creating tables and using table tools
✓ Display the exact data you are looking for with filters and sorting tools
✓ Create and customize visuals and charts
✓ Learn Pivot Tables to discover and display the most essential parts of your data
✓ Create Pivot Charts out of Pivot Tables for visual representations of reports
✓ Protect and lock worksheets and workbooks to restrict users

Requirements

• Fundamental Excel knowledge
• Recommended: Completion of our Excel 2019 Beginner course

This course is for

• Users with some Excel experience looking to gain Intermediate-level knowledge
• Experienced Excel users looking for a quick refresher

How much does the Excel 2019 Intermediate 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 Intermediate course have a money back guarantee or refund policy?

YES, Excel 2019 Intermediate 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 Intermediate 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.7

CourseMarks Score®

10.0

Freshness

N/A

Feedback

9.0

Content

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

Students are also interested in

Review widget (for course creators):

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