The Ultimate Microsoft Excel Business Intelligence Certification Bundle

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 of transforming 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 your portfolio or resume so that future employers can feel confident in your skillset.

• Access 114 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 functions in Excel

If you want to improve your skills at Financial Modeling using Microsoft Excel so you can get a better paying job or get answers and insights from your data fast with Financial Models, then you are in the right place. Whether you are a financial modeling beginner or never used Excel before, you are sure to benefit from this quick course that goes through the must-know financial modeling foundations. In just 4 hours, you will walk away with your own financial model, knowledge about financial modeling, and more.

• Access 43 lectures & 4 hours of content 24/7
• Create your own financial model from scratch in just 4 hours
• Understand the essence of financial model components & see them in action
• See how financial modeling is used with real examples
• Understand how Revenue, Expense, Profit & Loss & Cashflow are used together

This course is part of the Excel Pro Tips series, designed to help everyday users develop expert-level skills by mastering the same tools and techniques used by top pros and Excel MVPs. In this course, you’ll dive into some of Excel’s advanced analytics tools, using a variety of unique, real-world demos and case studies. You’ll forecast stock prices and monthly temperatures, build our own outlier detection tools, solve complex optimization problems, design Monte Carlo simulation models, create reports using CUBE functions, and much more. It's time to start working smarter, not harder. If you're ready to step up your analytics game and see what Excel is really capable of, this is the course for you.

• Access 20 lectures & 2 hours of content 24/7
• Explore powerful analytics tools like forecasting, optimization, & monte carlo simulation
• Dive into some of Excel’s advanced analytics tools
• Use a variety of unique, real-world demos & case studies
• Forecast stock prices & monthly temperatures
• Build our own outlier detection tools
• Solve complex optimization problems
• Design Monte Carlo simulation models
• Create reports using CUBE functions

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.

• Access 22 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

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. Instead, you will be introduced to Excel's unique features like filled maps, sparklines, custom templates, dynamic visuals, interactive form controls, and much more. This course is for you if you want to create clear and effective charts and graphs and interactive reports and dashboards.

• Access 20 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

This course is part of the Excel Pro tips series, designed to help everyday users develop expert-level skills by mastering the same tools and techniques used by top pros and Excel MVPs. In this course, you’ll sample some of Excel’s most powerful formula tools, including basic options like calculation modes, line breaks, and auditing tools, as well as more complex use cases like detecting duplicates, creating dynamic workbook links, randomizing lists, and configuring many-to-many lookups. It's time to start working smarter, not harder. So if you're ready to ramp up your formula skills and take your Excel analytics game to the next level, this is the course for you.

• Access 23 lectures & 2 hours of content 24/7
• Sample some of Excel’s most powerful formula tools including basic options like calculation modes, line breaks & auditing tools
• Try Excel's more complex use cases like detecting duplicates, creating dynamic workbook links, randomizing lists, & configuring many-to-many lookups
• Develop expert-level skills by mastering the same tools & techniques used by top pros and Excel MVPs

With every data collection and analysis project, it is a must that your data is not just accurate but also clearly presented. This Excel Pro Tips: Formatting course will be focusing on Excel formats. More than cell fill and font colors, this course will teach you how to turn your plain old spreadsheets into downright beautiful and functional works of art. You’ll practice freezing panes, hiding text, defining formula-driven rules, creating advanced custom number formats, and much more. If you're ready to bring your workbooks to life and take your formatting game to the next level, this is the course for you.

• Access 22 lectures & 1 hour of content 24/7
• Learn to create clean & polished worksheets
• Turn plain spreadsheets into beautiful & functional works of art
• Practice freezing panes, hiding text, defining formula-driven rules, creating advanced custom number formats & much more

The Excel Pro Tips: Productivity Tools course will improve your current productivity. This 2-hour course will cover various 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.

• Access 23 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

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. You'll be introduced to the "Power Excel" landscape and explore what these Excel tools are all about and why they are changing the world of self-service business intelligence. Also, you'll walk through the Excel BI workflow and build an entire Excel data model from scratch.

• Access 91 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

Pivot Tables are an essential tool for anyone who works with data in Excel. Pivots allow you to quickly explore and analyze raw data, revealing powerful insights and trends otherwise buried in the noise. In other words, they give you answers. So 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
• Anaylze data from a number of real-world case studies including San Diego burrito ratings, shark attack records, MLB team statistics, & more

Ask people what comes to mind when they think of Excel, and odds are they'll say, "spreadsheets." However, Excel is an incredibly powerful, robust, and dynamic data visualization platform. This course will give you a deep, comprehensive understanding of Excel's latest data visualization tools and techniques. You'll learn when, why, and how to use each chart type, discover key data visualization best practices, and learn through interactive, hands-on demos and exercises every step of the way.

• Access 62 lectures & 4 hours of content 24/7
• Understand when, why & how to use 20+ chart types in Excel
• Learn advanced Excel tools like automated dashboards, scrolling charts, dynamic formats, & more
• Master unique tips, tools, and case studies that you won't find in any other Excel course
• Build 10+ Excel projects designed to take your data visualization skills to the next level

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