The 2021 Ultimate Microsoft Excel Business Intelligence Certification Bundle for $44 August 08, 2021 at 07:00PM
KEY FEATURES
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
PRODUCT SPECS
Important Details
- Length of time users can access this course: lifetime
- Access options: desktop & mobile
- Redemption deadline: redeem your code within 30 days of purchase
- Certificate of completion included
- Experience level required: intermediate
- Updates included
- Have questions on how digital purchases work? Learn more here
Requirements
- Microsoft Excel 2007 - 2019 or Office 365
THE EXPERT
Maven AnalyticsMaven Analytics transforms everyday people into data rockstars by streamlining, simplifying, and personalizing the online learning experience. Since 2014 we've helped students and teams across 150+ countries develop the most sought-after analytics and business intelligence skills, through on-demand courses, skills assessments, curated learning paths, and enterprise training.
Chris Dutton
Chris Dutton is a certified Microsoft Excel Expert, analytics consultant, and best-selling instructor with more than a decade of experience specializing in business intelligence, marketing analytics and data visualization. He founded Excel Maven in 2014 to provide high-quality, applied analytics training and consulting to clients around the world, and now mentors 25,000+ students in more than 150 countries. He has developed award-winning data analytics and visualization tools, featured by Microsoft, the New York Times, and the Society of American Baseball Research.
KEY FEATURES
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
PRODUCT SPECS
Important Details
- Length of time users can access this course: lifetime
- Access options: desktop & mobile
- Redemption deadline: redeem your code within 30 days of purchase
- Certificate of completion included
- Experience level required: beginner
- Updates included
- Have questions on how digital purchases work? Learn more here
Requirements
- Microsoft Excel 2016+ or Office 365
THE EXPERT
Maven AnalyticsMaven Analytics transforms everyday people into data rockstars by streamlining, simplifying, and personalizing the online learning experience. Since 2014 we've helped students and teams across 150+ countries develop the most sought-after analytics and business intelligence skills, through on-demand courses, skills assessments, curated learning paths, and enterprise training.
Chris Dutton
Chris Dutton is a certified Microsoft Excel Expert, analytics consultant, and best-selling instructor with more than a decade of experience specializing in business intelligence, marketing analytics and data visualization. He founded Excel Maven in 2014 to provide high-quality, applied analytics training and consulting to clients around the world, and now mentors 25,000+ students in more than 150 countries. He has developed award-winning data analytics and visualization tools, featured by Microsoft, the New York Times, and the Society of American Baseball Research.
KEY FEATURES
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
PRODUCT SPECS
Important Details
- Length of time users can access this course: lifetime
- Access options: desktop & mobile
- Redemption deadline: redeem your code within 30 days of purchase
- Certificate of completion included
- Experience level required: beginner
- Updates included
- Have questions on how digital purchases work? Learn more here
Requirements
- Microsoft Excel 2010-2019 or Office 365
- Basic knowledge with Excel functionality
THE EXPERT
Maven AnalyticsMaven Analytics transforms everyday people into data rockstars by streamlining, simplifying, and personalizing the online learning experience. Since 2014 we've helped students and teams across 150+ countries develop the most sought-after analytics and business intelligence skills, through on-demand courses, skills assessments, curated learning paths, and enterprise training.
Chris Dutton
Chris Dutton is a certified Microsoft Excel Expert, analytics consultant, and best-selling instructor with more than a decade of experience specializing in business intelligence, marketing analytics and data visualization. He founded Excel Maven in 2014 to provide high-quality, applied analytics training and consulting to clients around the world, and now mentors 25,000+ students in more than 150 countries. He has developed award-winning data analytics and visualization tools, featured by Microsoft, the New York Times, and the Society of American Baseball Research.
KEY FEATURES
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
PRODUCT SPECS
Important Details
- Length of time users can access this course: lifetime
- Access options: desktop & mobile
- Redemption deadline: redeem your code within 30 days of purchase
- Certificate of completion included
- Experience level required: beginner
- Updates included
- Have questions on how digital purchases work? Learn more here
Requirements
- Microsoft Excel (Excel 2013/2016/2019 Standalone, Office 365, Enterprise E3/E5, Office Professional 2016, etc.)
- Basic knowledge with Excel PivotTables, Formulas & Functions
THE EXPERT
Maven AnalyticsMaven Analytics transforms everyday people into data rockstars by streamlining, simplifying, and personalizing the online learning experience. Since 2014 we've helped students and teams across 150+ countries develop the most sought-after analytics and business intelligence skills, through on-demand courses, skills assessments, curated learning paths, and enterprise training.
Chris Dutton
Chris Dutton is a certified Microsoft Excel Expert, analytics consultant, and best-selling instructor with more than a decade of experience specializing in business intelligence, marketing analytics and data visualization. He founded Excel Maven in 2014 to provide high-quality, applied analytics training and consulting to clients around the world, and now mentors 25,000+ students in more than 150 countries. He has developed award-winning data analytics and visualization tools, featured by Microsoft, the New York Times, and the Society of American Baseball Research.
KEY FEATURES
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
PRODUCT SPECS
Important Details
- Length of time users can access this course: lifetime
- Access options: desktop & mobile
- Redemption deadline: redeem your code within 30 days of purchase
- Certificate of completion included
- Experience level required: beginner
- Updates included
- Have questions on how digital purchases work? Learn more here
- Microsoft Excel 2007-2019 or Office 365
- Basic knowledge with Excel Formulas & Functions
THE EXPERT
Maven Analytics
Maven Analytics transforms everyday people into data rockstars by streamlining, simplifying, and personalizing the online learning experience. Since 2014 we've helped students and teams across 150+ countries develop the most sought-after analytics and business intelligence skills, through on-demand courses, skills assessments, curated learning paths, and enterprise training.
Chris Dutton
Chris Dutton is a certified Microsoft Excel Expert, analytics consultant, and best-selling instructor with more than a decade of experience specializing in business intelligence, marketing analytics and data visualization. He founded Excel Maven in 2014 to provide high-quality, applied analytics training and consulting to clients around the world, and now mentors 25,000+ students in more than 150 countries. He has developed award-winning data analytics and visualization tools, featured by Microsoft, the New York Times, and the Society of American Baseball Research.
KEY FEATURES
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
PRODUCT SPECS
Important Details
- Length of time users can access this course: lifetime
- Access options: desktop & mobile
- Redemption deadline: redeem your code within 30 days of purchase
- Certificate of completion included
- Experience level required: beginner
- Updates included
- Have questions on how digital purchases work? Learn more here
Requirements
- Microsoft Excel 2007-2019 or Office 365 recommended
- Designed for Windows users (some tools may not be available for Mac)
THE EXPERT
Maven AnalyticsMaven Analytics transforms everyday people into data rockstars by streamlining, simplifying, and personalizing the online learning experience. Since 2014 we've helped students and teams across 150+ countries develop the most sought-after analytics and business intelligence skills, through on-demand courses, skills assessments, curated learning paths, and enterprise training.
Chris Dutton
Chris Dutton is a certified Microsoft Excel Expert, analytics consultant, and best-selling instructor with more than a decade of experience specializing in business intelligence, marketing analytics and data visualization. He founded Excel Maven in 2014 to provide high-quality, applied analytics training and consulting to clients around the world, and now mentors 25,000+ students in more than 150 countries. He has developed award-winning data analytics and visualization tools, featured by Microsoft, the New York Times, and the Society of American Baseball Research.
KEY FEATURES
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
PRODUCT SPECS
Important Details
- Length of time users can access this course: lifetime
- Access options: desktop & mobile
- Redemption deadline: redeem your code within 30 days of purchase
- Certificate of completion included
- Experience level required: beginner
- Updates included
- Have questions on how digital purchases work? Learn more here
Requirements
- Microsoft Excel
THE EXPERT
Maven AnalyticsMaven Analytics transforms everyday people into data rockstars by streamlining, simplifying, and personalizing the online learning experience. Since 2014 we've helped students and teams across 150+ countries develop the most sought-after analytics and business intelligence skills, through on-demand courses, skills assessments, curated learning paths, and enterprise training.
Chris Dutton
Chris Dutton is a certified Microsoft Excel Expert, analytics consultant, and best-selling instructor with more than a decade of experience specializing in business intelligence, marketing analytics and data visualization. He founded Excel Maven in 2014 to provide high-quality, applied analytics training and consulting to clients around the world, and now mentors 25,000+ students in more than 150 countries. He has developed award-winning data analytics and visualization tools, featured by Microsoft, the New York Times, and the Society of American Baseball Research.
KEY FEATURES
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
PRODUCT SPECS
Important Details
- Length of time users can access this course: lifetime
- Access options: desktop & mobile
- Redemption deadline: redeem your code within 30 days of purchase
- Certificate of completion included
- Experience level required: beginner
- Updates included
- Have questions on how digital purchases work? Learn more here
Requirements
- Microsoft Excel 2007-2019 or Office 365 recommended
- Designed for Windows users (some tools may not be available for Mac)
THE EXPERT
Maven AnalyticsMaven Analytics transforms everyday people into data rockstars by streamlining, simplifying, and personalizing the online learning experience. Since 2014 we've helped students and teams across 150+ countries develop the most sought-after analytics and business intelligence skills, through on-demand courses, skills assessments, curated learning paths, and enterprise training.
Chris Dutton
Chris Dutton is a certified Microsoft Excel Expert, analytics consultant, and best-selling instructor with more than a decade of experience specializing in business intelligence, marketing analytics and data visualization. He founded Excel Maven in 2014 to provide high-quality, applied analytics training and consulting to clients around the world, and now mentors 25,000+ students in more than 150 countries. He has developed award-winning data analytics and visualization tools, featured by Microsoft, the New York Times, and the Society of American Baseball Research.
KEY FEATURES
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
"Everything you need to get started using Excel pivot tables (a few 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
PRODUCT SPECS
Important Details
- Length of time users can access this course: lifetime
- Access options: desktop & mobile
- Redemption deadline: redeem your code within 30 days of purchase
- Certificate of completion included
- Experience level required: beginner
- Updates included
- Have questions on how digital purchases work? Learn more here
Requirements
- Microsoft Excel 2007-2019 or Office 365 recommended
- Designed for Windows users (some tools may not be available for Mac)
THE EXPERT
Maven AnalyticsMaven Analytics transforms everyday people into data rockstars by streamlining, simplifying, and personalizing the online learning experience. Since 2014 we've helped students and teams across 150+ countries develop the most sought-after analytics and business intelligence skills, through on-demand courses, skills assessments, curated learning paths, and enterprise training.
Chris Dutton
Chris Dutton is a certified Microsoft Excel Expert, analytics consultant, and best-selling instructor with more than a decade of experience specializing in business intelligence, marketing analytics and data visualization. He founded Excel Maven in 2014 to provide high-quality, applied analytics training and consulting to clients around the world, and now mentors 25,000+ students in more than 150 countries. He has developed award-winning data analytics and visualization tools, featured by Microsoft, the New York Times, and the Society of American Baseball Research.
KEY FEATURES
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
PRODUCT SPECS
Important Details
- Length of time users can access this course: lifetime
- Access options: desktop & mobile
- Redemption deadline: redeem your code within 30 days of purchase
- Certificate of completion included
- Experience level required: beginner
- Updates included
- Have questions on how digital purchases work? Learn more here
Requirements
- Microsoft Excel 2007-2019 or Office 365 recommended
- Designed for Windows users (some tools may not be available for Mac)
THE EXPERT
Maven AnalyticsMaven Analytics transforms everyday people into data rockstars by streamlining, simplifying, and personalizing the online learning experience. Since 2014 we've helped students and teams across 150+ countries develop the most sought-after analytics and business intelligence skills, through on-demand courses, skills assessments, curated learning paths, and enterprise training.
Chris Dutton
Chris Dutton is a certified Microsoft Excel Expert, analytics consultant, and best-selling instructor with more than a decade of experience specializing in business intelligence, marketing analytics and data visualization. He founded Excel Maven in 2014 to provide high-quality, applied analytics training and consulting to clients around the world, and now mentors 25,000+ students in more than 150 countries. He has developed award-winning data analytics and visualization tools, featured by Microsoft, the New York Times, and the Society of American Baseball Research.
KEY FEATURES
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
PRODUCT SPECS
Important Details
- Length of time users can access this course: lifetime
- Access options: desktop & mobile
- Redemption deadline: redeem your code within 30 days of purchase
- Certificate of completion included
- Experience level required: beginner
- Updates included
- Have questions on how digital purchases work? Learn more here
Requirements
- Excel for Windows 2007, 2010, 2013, 2016, 2019
- Office 365
- Excel for Mac 2011 and 2016
THE EXPERT
Bryan Hong | Data Analysis NinjaBryan Hong is the author of 101 Excel Series paperback books and is also an IT Software Developer for more than 10 years. His courses focus on Excel Formulas, Power Query, Power BI, Excel Charts, Macros and much more. His passion lies in helping his students in whatever means possible, whether it be reaching them via courses or by books.
Certifications
- Microsoft Certified Professional Developer (MCPD): Web Developer
- Microsoft Certified Technology Specialist (MCTS): Windows Applications
- Microsoft Certified Systems Engineer (MCSE)
- Microsoft Certified Systems Administrator (MCSA)
KEY FEATURES
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
PRODUCT SPECS
Important Details
- Length of time users can access this course: lifetime
- Access options: desktop & mobile
- Redemption deadline: redeem your code within 30 days of purchase
- Certificate of completion included
- Experience level required: advanced
- Updates included
- Have questions on how digital purchases work? Learn more here
Requirements
- Excel for Windows 2010, 2013, 2016, 2019
- Office 365
- Excel for Mac 2011 and 2016
THE EXPERT
Jordan Goldmeier | Chief Data AnarchistJordan Goldmeier is an internationally recognized analytics professional and data visualization expert, author and speaker. A former chief operations officer at Excel.TV, he has spent years in the data training trenches. He is the author of Advanced Excel Essentials and Dashboards for Excel, and currently working on this 3rd book, Becoming a Data Head (Wiley, 2021), on helping managers communicate, challenge, and understand data science with a common language and expectation.
Comments
Post a Comment