Classbaze

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

Excel PRO TIPS Part 1: Productivity

Welcome to Excel Pro Tips for Power Users! Please note that this is PART 1 of a 6-PART series, and that this is a limited version of the full course.To acces...
4.5
4.5/5
(15 reviews)
987 students
Created by

8.2

Classbaze Grade®

6.4

Freshness

8.5

Popularity

9.2

Material

Welcome to Excel Pro Tips for Power Users!
Platform: Skillshare
Video: 1h 45m
Language: English
Next start: On Demand

Best Business Analytics classes:

Classbaze Rating

Classbaze Grade®

8.2 / 10

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

Freshness

6.4 / 10
This course was last updated on 11/2018.

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.

Popularity

8.5 / 10
We analyzed factors such as the rating (4.5/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.

Material

9.2 / 10
Video Score: 7.8 / 10
The course includes 1h 45m 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.
The average video length is 2 hours 05 minutes of 319 Business Analytics courses on Skillshare.
Detail Score: 9.7 / 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: 10.0 / 10

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

This course contains:

0 article.
0 resource.
0 exercise.
0 tests or quizzes.

In this page

About the course

Welcome to Excel Pro Tips for Power Users!

Please note that this is PART 1 of a 6-PART series, and that this is a limited version of the full course. To access additional course materials (including quizzes, 1-on-1 support, and Excel project files), please visit courses.excelmaven.com.

__________

FULL COURSE DESCRIPTION:

This course is NOT an introduction to Excel.

It’s not about comprehensive, 101-style deep dives into Excel’s core capabilities, or about showing off cheesy, impractical “hacks”. It’s about featuring some of the most powerful and effective tools and techniques used by Excel professionals, and sharing them through crystal clear demos and unique, real-world case studies.

Unlike most courses, this one is non-linear, meaning that you can bounce around and explore individual lectures freely. Each video is designed to be an independent and self-contained demo, designed to help you learn these tools and techniques in quick, bite-sized lessons.

__________

The tips and techniques covered in the full course fall into six parts:

  • PART 1: Productivity Tips (navigation, flash fill, cell protection, advanced sorting & filtering, etc.)

  • PART 2: Formatting Tips (freeze panes, row/column grouping, custom number formats, etc.)

  • PART 3: Formula Tips (auditing tools, fuzzy lookups, uniques/duplicates, randomization, etc.)

  • PART 4: Visualization Tips (sparklines, filled maps, custom templates, form controls, etc.)

  • PART 5: PivotTable Tips (slicers & timelines, custom layouts, value calculations, etc.)

  • PART 6: Analytics Tips (outlier detection, simulation, forecasting, CUBE functions, etc.)

__________

While the level of difficulty varies considerably, the demos generally start simple and become progressively more complex within each section. There are no strict prerequisites for this course, but keep in mind that some demos may be challenging without a strong foundational knowledge of the underlying concepts (like PivotTables or advanced formulas, for example).

Students who have completed the full Excel Maven stack will be well-positioned to maximize the value from this course:

  • Advanced Excel Formulas & Functions

  • Data Visualization with Excel Charts & Graphs

  • Data Analysis with Excel PivotTables

  • Intro to Power Query, Power Pivot & DAX

__________

It’s time to start working smarter, not harder. If you’re looking to maximize your efficiency, supercharge your productivity, and become an absolute Excel POWER USER, this is the course for you.

See you in there!

-Chris (Founder, Excel Maven & Maven Analytics)

__________

NOTE: Most demos are compatible with Excel 2007-2016 or Office 365 (some may be unavailable for Mac or Excel Online)

What can you learn from this course?

You may follow along with the demos using the attached PDF file (Excel Pro Tips for Power Users). To access the Excel project files and source data, please consider enrolling in the full course at courses.excelmaven.com.

What you need to start the course?

Basic knowledge of Business Analytics is required to start this course, as this is an intermediate level course.

Who is this course is made for?

This course was made for intermediate-level students.

Are there coupons or discounts for Excel PRO TIPS Part 1: Productivity ? What is the current price?

You can enrol in this course with a Skillshare subscription that costs $8/month, but you start with a FREE 7-day trial. You can also enrol in thousands of courses on a variety of topics with your subscription, including several Business Analytics courses.
The average price is $4.8 of 319 Business Analytics courses. So this course is -100% more expensive than the average Business Analytics course on Skillshare.

Will I be refunded if I'm not satisfied with the Excel PRO TIPS Part 1: Productivity course?

There is no money-back guarantee with Skillshare, but you can start with a free one-week trial to learn without risk. With the subscription, you can download classes to your tablet or phone using the Skillshare app.

Are there any financial aid for this course?

At the moment we couldn't find any available scholarship forExcel PRO TIPS Part 1: Productivity, but you can access more than 30 thousand classes for $8/month on Skillshare, including this one!

Who will teach this course? Can I trust Chris Dutton?

Chris Dutton has created 18 courses that got 277 reviews which are generally positive. Chris Dutton has taught 12,107 students and received a 4.6 average review out of 277 reviews. Depending on the information available, we think that Chris Dutton is an instructor that you can trust.
Founder, Excel Maven
Founder, Excel Maven
Browse all courses by on Classbaze.

8.2

Classbaze Grade®

6.4

Freshness

8.5

Popularity

9.2

Material

Platform: Skillshare
Video: 1h 45m
Language: English
Next start: On Demand

Classbaze recommendations for you