The All-In-One Microsoft Excel Certification Training Bundle

In this course, you will take a quick dive into concepts such as Array Formulas and formula-driven developments. As you progress, you will see how each module builds from top to bottom. Also, you will be exposed to often overlooked features such as Excel's form controls, which can drive tremendous interactivity. At the same time, you will run through the rules of data visualization, making sure that what you build communicates its message. By the end of this course, you won't just be good at data visualization and dashboards, but also, you will become a master Excel builder.

• Access 85 lectures & 6 hours of content 24/7
• Learn advanced skills to create dashboards & data visualizations in Excel
• Quickly create dashboards, reports & interactive applications without macros
• Use Microsoft Excel with confidence
• Get downloadable Excel workbooks to practice on
• Attain personal Excel support from professional Excel trainers
• Become expert at creating interactive analysis
• Be more productive at using Microsoft Excel
• Increase your Microsoft Excel skills & knowledge within hours
• Test your skills with different real life quizzes, homework, practice activities, & assignments

If you're dealing with a bunch of data, sorting and organizing will help you a lot. This course will teach you how to use Google Sheets and organize your information into neat spreadsheets. You can use many of these skills in Excel too. Some of the topics that will be discussed here are as follow: working with Google Sheet's checkbox, sparklines for Dashboards, using slicer on a table, add pop-up calendar date picker, coloring raws based on a cell value, and more.

• Access 10 lectures & 1 hour of content 24/7
• Know the 5 ways to use Google Sheet’s Checkbox
• Use Sparklines for Dashboards
• Learn how to use Slicer on a table
• Create a “pop-up” Calendar Date Picker
• Create a Heatmap with Conditional Formatting
• Use AI Explore to create charts & reports

This course has been created to help you learn all the basics that are around the use of VBA with Microsoft Excel. With this course, you will first learn the power of Macros with Microsoft Excel. This will allow you to automate the majority of the task that you are currently doing on Microsoft Excel. Then, you will understand how to properly record your own macro, and learn all the programming behind a macro. Another important aspect of this course is that it will help you learn by practice. Each element enables you to sharpen your skills in Excel Macro and Excel VBA.

• Access 20 lectures & 4 hours of content 24/7
• Create plenty of small projects to learn the basics of VBA
• Learn the best way to write a VBA code on Excel
• Be able to automate different tasks with VBA on Excel
• Understand VBA programming structure & concepts
• Understand how to use the macro recorder
• Enhance your current Excel projects with VBA programming

NOTE: Software NOT included.

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. Here, you will learn about the Power Excel landscape, explore what these Excel tools are all about, and why they are changing the world of self-service business intelligence. Take your Excel game to new heights and join the leading edge of analytics and business intelligence

• 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

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 several ways. This is especially useful for including in your portfolio or resume, so future employers can feel confident in your skillset.

• Access 113 lectures & 8 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

If you're looking for a comprehensive, hands-on guide to learning Microsoft Power BI Desktop, you've come to the right place. Power BI is quickly becoming the world's most powerful self-service business intelligence platform, and an absolutely essential tool for data professionals and beginners alike. With Power BI you can connect to hundreds of data sources, build complex relational models, and design stunning, interactive dashboards from scratch.

• Access 116 lectures & 10 hours of content 24/7
• Build professional-quality business intelligence reports from the ground up
• Understand the business intelligence workflow from end-to-end
• Blend and transform raw data into beautiful interactive dashboards
• Design and implement the same B.I. tools used by professional analysts & data scientists

Pivot Tables are an essential tool for anyone who works with data in Excel. Pivots allow you to explore and analyze raw data quickly, revealing powerful insights and trends otherwise buried in the noise. In other words, they give you answers. Whether you're exploring product sales, analyzing marketing tactics, or wonder how Boston condo prices have trended over the past 15 years, Excel Pivot Tables provide fast, accurate, and intuitive solutions to even the most complicated questions. This course will give you a deep, 100% comprehensive understanding of Pivot Tables and Pivot Charts.

• Access 85 lectures & 5 hours of content 24/7
• Cover raw data structure, table layouts & styles
• Explore design & formatting options
• Understand sorting, filtering, & grouping tools
• Analyze data from a number of real-world case studies including San Diego burrito ratings, shark attack records, MLB team statistics, & more

Start a career in data science by learning how to combine your Excel knowledge with Python programming, machine learning, and data science. Take your spreadsheets to the next level by learning the essentials of coding specifically tailored for data science in Excel. Completely tailored for beginners, this is a life-changing course you don't want to miss.

• Access 46 lectures & 4 hours of content 24/7
• Understand basic machine learning concepts
• Get a quick introduction to Python
• Project track stocks in Excel
• Explore linear regression on stock data in Excel

It is a perfect course for you if you are about to start a new role or project, or perhaps you are preparing for or a fairly in-depth interview in the next few days and you want to spend a few evenings or the weekend to bolster your Excel skills! The course is presented by the highly experienced Andrew Dove an accounting professional from the UK and covers the most important Excel topics that professionals need to be accomplished in. This course will help you get the best out of Excel.

• Access 84 lectures & 6 hours of content 24/7
• Learn introductory topics such as the Excel interface, sheets, rows, columns & data types
• Get comfortable with Functions (Basic, Copying Functions, Named Ranges)
• Format the sheet, numbers, rows, cells & more Sort, filter, & validate data
• Learn advanced functions such as VLOOKUPS, INDEX, MATCH, IF, & more
• Consolidate data with Power Query
• Speed up your work by recording and tweaking Macros

The job of HR is not an easy task. Analytics is an essential part of the process of acquiring good talent, engaging them, and retaining them. Most of the processes involved are time-sensitive and repetitive. Hence, there is a dire need to automate such tasks. HR Analytics in Excel helps businesses make data-driven decisions in a meaningful way. This course will help you do just that. This course is self-paced to learn effective and interactive creation of Human Resource (HR) and Learning & Development (L&D) dashboards. Impress your management with the right data handling and report automation techniques.

• Access 8 lectures & 1 hour of content 24/7
• Create & use a Pivot table and charts effectively Learn how to analyze expense claims
• Do data cleaning for emails
• Analyze Google Forms survey
• Understand the working of different tools with real-life business problems