By Excel Maven | in Online Courses
The Excel Pro Tips: Productivity Tools course will improve your current productivity. This 2-hour course will cover a range of topics to help you save time and work more efficiently, including keyboard shortcuts, autofill and flash fill, data validation, cell protection, named ranges, multi-level sorting, advanced filters, and much more. By the end of this course, you'll be ready to supercharge your productivity and absolutely revolutionize your Excel workflow.
63,046 positive reviews from 248,923 students
Note: Software NOT included.
"I must say that I was extremely impressed with how well the course was presented. I was pleasantly surprised to see just how much was covered in this one course by an exceptional instructor. " – Daulton Brent Cotten
Important Details
Requirements
By Excel Maven | in Online Courses
This Excel Data Visualization course is all about bringing data to life, using some of Excel's most powerful visualization tools. The 18 lectures of this course won't be talking about your basic pie charts and line graphs. You will be introduced to Excel's unique features like filled maps, sparklines, custom templates, dynamic visuals, interactive form controls, and much more. If you want to create clear and effective charts and graphs and interactive reports and dashboards, this course is for you.
63,046 positive reviews from 248,923 students
"Yes, it was a good match for me. I enjoyed being able to practice applying what I was learning on the spreadsheets provided and that I had the ability to go at my own pace replaying sections if needed." – Jodi Ming
Important Details
Requirements
By Excel Maven | in Online Courses
This Excel Pro Tips: PivotTables course will be focusing on one of Excel's most powerful and flexible analytic tools—PivotTables. The 1-hour course will start with some common topics like slicers, table layouts, and field list options, then dive into more unique use cases like grouping values, enabling multiple filters, reviving source data from a cache, defining custom sort lists, and more. This course will help you work smarter and not harder. By the end of this course, you'll be ready to slice, dice, and filter your data like a PivotTable pro.
63,046 positive reviews from 248,923 students
"Everything you need to get started using Excel pivot tables (a little bit of pivot charts as well). The amount of content and pacing was perfect for me. The real gem is the last session where you use what you learned. " – Craig Day
Important Details
Requirements
By Excel Maven | in Online Courses
It's time to show Excel who's boss! Whether you're starting from square one or aspiring to become an absolute Excel wizard, this is the right place for you. This course will give you a deep understanding of the advanced formulas and functions that transform Excel from a basic spreadsheet program into a dynamic and powerful analytics tool. Through hands-on, contextual examples, you'll learn why these formulas are awesome and how they can be applied in a number of ways.
63,046 positive reviews from 248,923 students
Note: Software NOT included.
"In general the course is well organized in my opinion, the topics bring together all the necessary functions, and if one has willingness to learn deeper after the course all the other alternative functions will be quite easy to understand and apply." – Abuzar Talibov
Important Details
Requirements
By Excel Maven | in Online Courses
This course will introduce you to Microsoft Excel's powerful data modeling and business tools Power Query, Power Pivot, and Data Analysis Expressions (DAX). If you're looking to become a power Excel user and supercharge your analytics, then this is the A-Z guide that you're looking for.
63,046 positive reviews from 248,923 students
Note: Software NOT included.
"This has been an excellent course - Chris knows his stuff, and presents it well. I never knew there was so much power in Excel — I considered myself pretty good at Excel, but Power Query and the Data Model has blown me away." – Ian Watts
Important Details
Requirements
By Alan Jarvis | in Online Courses
Excel is the most commonly used and in-demand tool for making sense of data. When you can harness that power, you will be a sought after employee. If you run a business, being proficient in Excel can help you see your business in a completely different light. This is the level for Excel beginners, and all the Excel basics will be covered here. Getting to grips with Excel will give you a distinct advantage in whatever work you currently do, and can open the door to new opportunities.
14,230 positive reviews from 81,504 students
Note: Software NOT included.
"I needed Excel immediately for work and this course is about as perfect as can be as a beginner." – Sharon Goldzweig
Important Details
Requirements
By Alan Jarvis | in Online Courses
So, you have an understanding of the basics, but would you like to use Excel like the professionals? If so, this is the course for you. What you will learn in this course will supercharge your skills and your career. You will learn powerful and little known techniques to enable you to build your own powerful spreadsheet solutions. You will do this by creating multiple projects together, step-by-step, and in-depth to guarantee your understanding. Each project builds on the last, so your skills develop cumulatively. Each project in the course is designed to introduce a range of concepts that showcase the true power of Excel, and show you what is really possible.
14,230 positive reviews from 81,504 students
Note: Software NOT included.
"The course covers from basics to advanced material. Explanations are clear and easy to understand, despite the level of Excel one has." – Paula Yankova
Important Details
Requirements
By Alan Jarvis | in Online Courses
If you really want to harness the full power of Excel, then learning how to program in VBA (Visual Basic for Applications), the powerhouse, is essential. In this course, you will learn everything you need to know about coding in VBA, even if you've never looked at a line of code before! You will learn how to streamline your code for efficiency from the beginning. You'll then go on to create 6 separate projects using those very tools and techniques, where you will pull together all of your earlier learning, and give you the confidence to program your own solutions as soon as you finish the course!
14,230 positive reviews from 81,504 students
Note: Software NOT included.
"Good, practical examples. Gaining experience through making mistakes. Real-life examples added from participants questions" – Andrew Hubbard
Important Details
Requirements
By Webucator | in Online Courses
This Intermediate Microsoft Excel training class is meant for students using Excel 2019 or Excel 365 who want to advance their skill set by learning to work with advanced formulas, lists, and illustrations. Students will also work with charts and advanced formatting including styles. Learn to streamline and analyze data and to keep data organized by managing large data sets with lists and tables. Learn to use filters to save time, as well as great ways to group and summarize data.
9.3/10 rating based on 30,389 reviews
Note: Software NOT included.
"I have done an "at your own pace" and a live "on-line" course - both are excellent and I would highly recommend. Great instructors! – Debbi Doris
Important Details
Requirements
By Webucator | in Online Courses
Already comfortable using Microsoft Excel 2019 or Excel 365 and ready to become an Excel expert? Take your skills to the next level in this Advanced Excel course. Learn Excel's most powerful and advanced tools, including PivotTables, PivotCharts, Macros, and more. You will gain skills for better collaboration, including password protection and tracking changes, learn to audit worksheets, validate data to ensure consistency, and use other essential business tools in Microsoft Excel.
9.3/10 rating based on 30,389 reviews
Note: Software NOT included.
"The class was very practical and relatable. The instructor created a positive atmosphere." – Jennifer Araujo-Bray
Important Details
Requirements