The Ultimate Microsoft Excel Bundle for $25

Expires January 11, 2023 23:59 PST

Buy now and get 97% off

Microsoft Excel: Advanced Excel Formulas & Functions

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 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.

Access 93 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

PRODUCT SPECS

Details & Requirements

Length of time users can access this course: lifetime
Access options: web streaming, mobile streaming
Certification of completion not included
Redemption deadline: redeem your code within 30 days of purchase
Experience level required: all levels
Microsoft Excel required

Compatibility

Internet required

THE EXPERT

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.

Microsoft Excel: Data Visualization, Excel Charts & Graphs

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 49 lectures & 4.5 hours of content 24/7
Explore each of the 20+ chart types that Excel 2016 has to offer
Dive into a series of 12+ advanced Excel demos guaranteed to turn you into a data visualization pro

PRODUCT SPECS

Details & Requirements

Length of time users can access this course: lifetime
Access options: web streaming, mobile streaming
Certification of completion not included
Redemption deadline: redeem your code within 30 days of purchase
Experience level required: all levels
Microsoft Excel 2016 required

Compatibility

Internet required

THE EXPERT

Microsoft Excel: Intro to Power Query, Power Pivot & DAX

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.

Access 86 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

Details & Requirements

Length of time users can access this course: lifetime
Access options: web streaming, mobile streaming
Certification of completion not included
Redemption deadline: redeem your code within 30 days of purchase
Experience level required: all levels
You need a version of Excel that is compatible with Power Pivot (Excel 2013/2016 Standalone, Office 365 Pro Plus, Enterprise E3/E5, Office Professional 2016, etc.)

Compatibility

Internet required

THE EXPERT

Microsoft Excel: Data Analysis with Excel Pivot Tables

KEY FEATURES

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 82 lectures & 6 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

Details & Requirements

Length of time users can access this course: lifetime
Access options: web streaming, mobile streaming
Certification of completion not included
Redemption deadline: redeem your code within 30 days of purchase
Experience level required: all levels
You need a version of Excel that is compatible with Power Pivot (Excel 2013/2016 Standalone, Office 365 Pro Plus, Enterprise E3/E5, Office Professional 2016, etc.)

Compatibility

Internet required

THE EXPERT

Master Microsoft Excel Macros and Excel VBA

KEY FEATURES

During this course, you will build a foundation of working with Excel Macros and VBA. You’ll engage in several projects that will build upon one another as you progress through the basic building blocks of automating tasks within Excel. Soon you’ll be ready to enter the world of Excel VBA, where you will experience a more dynamic, robust experience for yourself and your peers.

Access 57 lectures & 3.5 hours of content 24/7
Automate placing & formatting a title on a worksheet
Interact w/ the users of your Macros through input & message boxes
Clean up multiple Excel worksheets & prepare the data to be reported on
Create a report based on multiple sets of data found within multiple Excel worksheets
Automate the creation of Excel Formulas to SUM data up in your report

PRODUCT SPECS

Details & Requirements

Length of time users can access this course: lifetime
Access options: web streaming, mobile streaming
Certification of completion not included
Redemption deadline: redeem your code within 30 days of purchase
Experience level required: all levels
Microsoft Excel 2010, 2013, or 2016

Compatibility

Internet required

THE EXPERT

Kyle Pew is a Microsoft Certified Trainer (MCT) and a certified Microsoft Office Master Instructor and has been teaching and consulting for the past 10+ years on various computer applications, including:

Microsoft Office Suite 1997, 2000, XP, 2003, 2007, 2010, 2013
Excel, Word, PowerPoint, Outlook, Access and Visio
SharePoint End-User 2007, 2010, 2013
VBA (Excel and Access)
Adobe Suite
Photoshop, Illustrator, InDesign
Maya (Modeling and Animation)
Unity3d (Game Design)
HTML, CSS and JavaScript
Crystal Reports

Kyle is a graduate of the San Francisco Art Institute in the Media Arts and Animation Program. He has worked as a Game Designer for Electronic Arts, designing on games such as Nerf N-Strike, Nerf N-Strike Elite, both for the Wii, and a Sims 3 Expansion Pack for the PC.

Kyle has facilitated courses that range from 1-on-1 interactions to large scale groups of 100+ participants, including; live in person classes, webinar style classes online and live online full courses. He is consistently ranked top in reviews for each of the courses he teaches.

Microsoft Excel from Beginner to Advanced

KEY FEATURES

More than 750 million people have Excel installed on their computer but most do not know how to use it. Whatever version of Excel you have, this course will show you how to build and prepare a workbook good enough for a Fortune 500 CEO, to a household budget, and everything in between.

Access 80 lectures & 6.5 hours of content 24/7
Get downloadable Excel workbooks which you can use to follow along
Learn how to install Microsoft Excel & work w/ formulas and functions
Calculate w/ the IF Function & apply conditional formatting
Use the PMT Function to explore monthly & yearly compounding
Use Google Drive to collect data

PRODUCT SPECS

Details & Requirements

Length of time users can access this course: lifetime
Access options: web streaming, mobile streaming
Certification of completion not included
Redemption deadline: redeem your code within 30 days of purchase
Experience level required: all levels
Microsoft Excel required

Compatibility

Internet required

THE EXPERT

Warrick Klimaytys has spent many years with all kinds of computers in many different situations around the world and is eager to share his knowledge and skills with the StackCommerce community.

Around a decade ago Warrick started his professional life in the military where experienced all kinds of computers and machines. Today, he could be referred to as just a Microsoft “Windows Warrior”. As a result of his past experience, he finds it best to deliver lessons in bite sized chunks.

DO YOU LIKE WHAT YOU'VE READ?

Join our subscription list and receive our content right in your mailbox. If you like to receive some Great deals our Freebies then subscribe now!

Our Sponsors

Become a Sponsor for $45.

Limit to 5 sponsors.

Company Name :

Email :

Website :

Description :

Upload Logo :

Terms & Conditions : ACCEPTANCE OF TERMS This Agreement contains the complete terms and conditions that apply to your participation in our site. If you wish to use the site including its tools and services please read these terms of use carefully. By accessing this site or using any part of the site or any content or services hereof, you agree to become bound by these terms and conditions. If you do not agree to all the terms and conditions, then you may not access the site or use the content or any services in the site. MODIFICATIONS OF TERMS OF USE Amendments to this agreement can be made and effected by us from time to time without specific notice to your end. Agreement posted on the Site reflects the latest agreement and you should carefully review the same before you use our site. USE OF THE SITE You are prohibited to do the following acts, to wit: (a) use our sites, including its services and or tools if you are not able to form legally binding contracts, are under the age of 18, or are temporarily or indefinitely suspended from using our sites, services, or tools (b) posting of an items in inappropriate category or areas on our sites and services; (c) collecting information about users’ personal information; (d) maneuvering the price of any item or interfere with other users' listings; (f) post false, inaccurate, misleading, defamatory, or libelous content; (g) take any action that may damage the rating system. Registration Information For you to complete the sign-up process in our site, you must provide your full legal name, current address, a valid email address, member name and any other information needed in order to complete the signup process. You must qualify that you are 18 years or older and must be responsible for keeping your password secure and be responsible for all activities and contents that are uploaded under your account. You must not transmit any worms or viruses or any code of a destructive nature. Any information provided by you or gathered by the site or third parties during any visit to the site shall be subject to the terms of businesslegions.com’s Privacy Policy. Term This Agreement will remain in full force and effect while you use the Website. You may terminate your membership at any time for any reason by following the instructions on the “TERMINATION OF ACCOUNT” in the setting page. We may terminate your membership for any reason at any time. If you are using a paid version of the Service and we terminate your membership in the Service because you have breached this Agreement, you will not be entitled to any refund of unused subscription fees. Even after your membership is terminated, certain sections of this Agreement will remain in effect. NON-COMMERCIAL USE BY MEMBERS. Members on this website are prohibited to use the services of the website in connection with any commercial endeavors or ventures. This includes providing links to other websites, whether deemed competitive to this website or not. Juridical persons or entities including but not limited to organizations, companies, and/or businesses may not become Members of businesslegions.com and should not use the site for any purpose. LINKs & FRAMINGS Illegal and/or unauthorized uses of the Services, including unauthorized framing of or linking to the Sites will be investigated, and appropriate legal action may be taken. Some links, however, are welcome to the site and you are allowed to establish hyperlink to appropriate part within the site provided that: (i) you post your link only within the forum, chat or message board section; (ii) you do not remove or obscure any advertisements, copyright notices or other notices on the placed at the site; and (iii) you immediately stop providing any links to the site on written notice from us. However, you must check the copyright notice on the homepage to which you wish to link to make sure that one of our content providers does not have its own policies regarding direct links to their content on our sites. WARRANTY DISCLAIMER AND EXCLUSIONS / LIMITATIONS OF LIABILITY We make no express or implied warranties or representations with respect to the Program or any products sold through the Program (including, without limitation, warranties of fitness, merchantability, non-infringement, or any implied warranties arising out of a course of performance, dealing, or trade usage). In addition, we make no representation that the operation of our site will be uninterrupted or error-free, and we will not be liable for the consequences of any interruptions or errors. We may change, restrict access to, suspend or discontinued the site or any part of it at anytime. The information, content and services on the site are provided on an “as is” basis. When you use the site and or participate therein, you understand and agree that you participate at your own risk. INTELLECTUAL PROPERTY rights You hereby acknowledge that all rights, titles and interests, including but not limited to rights covered by the Intellectual Property Rights, in and to the site, and that You will not acquire any right, title, or interest in or to the site except as expressly set forth in this Agreement. You will not modify, adapt, translate, prepare derivative works from, decompile, reverse engineer, disassemble or otherwise attempt to derive source code from any of our services, software, or documentation, or create or attempt to create a substitute or similar service or product through use of or access to the Program or proprietary information related thereto. Confidentiality You agree not to disclose information you obtain from us and or from our clients, advertisers, suppliers and forum members. All information submitted to by an end-user customer pursuant to a Program is proprietary information of businesslegions.com. Such customer information is confidential and may not be disclosed. Publisher agrees not to reproduce, disseminate, sell, distribute or commercially exploit any such proprietary information in any manner. NON-ASSIGNMENT OF RIGHTS Your rights of whatever nature cannot be assigned nor transferred to anybody, and any such attempt may result in termination of this Agreement, without liability to us. However, we may assign this Agreement to any person at any time without notice. Waiver Failure of the businesslegions.com to insist upon strict performance of any of the terms, conditions and covenants hereof shall not be deemed a relinquishment or waiver of any rights or remedy that the we may have, nor shall it be construed as a waiver of any subsequent breach of the terms, conditions or covenants hereof, which terms, conditions and covenants shall continue to be in full force and effect. Severability of Terms. In the event that any provision of these Terms and Conditions is found invalid or unenforceable pursuant to any judicial decree or decision, such provision shall be deemed to apply only to the maximum extent permitted by law, and the remainder of these Terms and Conditions shall remain valid and enforceable according to its terms. Entire Agreement This Agreement shall be governed by and construed in accordance with the substantive laws of Australia , without any reference to conflict-of-laws principles. The Agreement describes and encompasses the entire agreement between us and you, and supersedes all prior or contemporaneous agreements, representations, warranties and understandings with respect to the Site, the contents and materials provided by or through the Site, and the subject matter of this Agreement. Choice of Law; Jurisdiction; Forum Any dispute, controversy or difference which may arise between the parties out of, in relation to or in connection with this Agreement is hereby irrevocably submitted to the exclusive jurisdiction of the courts of Australia , to the exclusion of any other courts without giving effect to its conflict of laws provisions or your actual state or Australia of residence.

Enter Captcha :

Accept our terms