By Maven Analytics | 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 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.
Important Details
Requirements
By Bryan Hong | in Online Courses
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.
Certifications
Important Details
Requirements
By Maven Analytics | in Online Courses
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.
Important Details
Requirements
By Maven Analytics | 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.
Important Details
Requirements
By Maven Analytics | 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. 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.
Important Details
Requirements
By Maven Analytics | in Online Courses
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.
Important Details
Requirements
By Maven Analytics | in Online Courses
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.
Important Details
Requirements
By Maven Analytics | in Online Courses
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.
Maven Analytics
Important Details
By Maven Analytics | 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. 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.
Important Details
Requirements
By Maven Analytics | in Online Courses
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.
Important Details
Requirements
By Maven Analytics | in Online Courses
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.
Important Details
Requirements
By Jordan Goldmeier | in Online Courses
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.
Important Details
Requirements