The Premium A to Z Microsoft Excel Bundle Ft. Alan Jarvis & Chris Dutton

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

• Access 21 lectures & 1 hour of content 24/7
• Learn & practice Excel's productivity tools using keyboard shortcuts, autofill & flash fill, and data validation
• Easily sort your data using cell protection, named ranges, multi-level storing, advanced filters & more
• Supercharge your productivity & improve your Excel workflow

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

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

• Access 18 lectures & 1 hour of content 24/7
• Explore Excel's most powerful visualization tools
• Know about Excel's unique features like filled maps, sparklines, custom templates. dynamic visuals, interactive form controls & more
• Create clear & effective charts and graphs as well as interactive reports and dashboards

"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

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

• Access 20 lectures & 1 hour of content 24/7
• Understand the use of Excel slicers, table layouts & field list options
• Learn grouping values, enabling multiple filters, reviving source data from the cache, defining custom sort lists & more
• Slice, dice & filter data like a PivotTable pro
• Practice & master PivotTables techniques used by professionals

"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

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

• Access 103 lectures & 6 hours of content 24/7
• Easily build dynamic tools & Excel dashboards to filter, display, & analyze your data
• Go rogue & design your own formula-based formatting rules
• Join datasets from multiple sources in seconds w/ lookup, index, & match functions
• Pull real-time data from APIs directly into Excel
• Manipulate dates, times, text, & arrays
• Automate tedious & time-consuming analytics tasks using cell formulas and functions in Excel

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

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

• Access 90 lectures & 7 hours of content 24/7
• Use sample data from a fictional supermarket chain to get hands-on w/ Power Query
• Practice shaping, blending, & exploring project files
• Cover the fundamentals of database design & normalization
• Explore & analyze your data model using Power Pivot & DAX
• Cover basic DAX syntax & learn some of the most powerful and commonly used functions

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

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

• Access 56 lectures & 3 hours of content 24/7
• Understand the most widely used business software in the world
• Build your own simple to complex formulas & use some of Excel's built-in functions
• Build your own spreadsheets from scratch & actually understand how they work

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

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

• Access 97 lectures & 8 hours of content 24/7
• Learn the fastest way to create powerful dynamic templates
• Build a fully functional complex relational database
• Create dynamic named ranges
• Create Macros & use them to automate your work
• Make project management simple w/ Gantt charting

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

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

• Access 181 lectures & 14 hours of content 24/7
• Learn to program in VBA from scratch
• Fully automate Excel using Visual Basic for Applications
• Understand coding & the thought process behind it
• Develop complex full-blown applications from scratch

Note: Software NOT included.

"Good, practical examples. Gaining experience through making mistakes. Real-life examples added from participants questions" – Andrew Hubbard

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

• Access 96 lectures & 1 hour of content 24/7
• Learn to use formulas & functions
• Convert, sort, filter & manage lists
• Insert & modify illustrations in a worksheet
• Learn to use conditional formatting & styles

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

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

• Access 78 lectures & 1 hour of content 24/7
• Create pivot tables & charts
• Learn to trace precedents & dependents
• Convert text & validate and consolidate data
• Collaborate w/ others by protecting worksheets & workbooks
• Create, use, edit & manage macros
• Import & export data

Note: Software NOT included.

"The class was very practical and relatable. The instructor created a positive atmosphere." – Jennifer Araujo-Bray