KEY FEATURES
In this comprehensive course, you’ll learn how to unleash the full potential of Microsoft Excel with dynamic array functions. These functions make it easy to manipulate and analyze data, allowing you to quickly sort, filter, and extract unique values from large datasets. You’ll also learn how to use sequence and array functions to automate tasks and generate random data. With hands-on projects and expert guidance, you’ll master these powerful tools and take your Excel skills to the next level.
- Access 27 lectures & 2 hours of content 24/7
- Create more advanced formulas
- Convert, sort, filter & manage lists
- Insert & modify illustrations in a worksheet
- Learn to use conditional formatting & styles
NOTE: Software NOT included
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
- Experience level required: beginner
- Updates included
- Certificate of Completion ONLY
- Have questions on how digital purchases work? Learn more here
Requirements
- Office 365 or Excel 2021
- Experience with basic Excel formulas is strongly recommended
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.
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 144 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
NOTE: Software NOT included
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
- Experience level required: beginner
- Updates included
- Certificate of Completion ONLY
- Have questions on how digital purchases work? Learn more here
Requirements
- Any device with basic specifications
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.
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
NOTE:
- Software NOT included
- Mac users are welcome, but note that the user experience will be significantly different across platforms
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
- Experience level required: beginner
- Updates included
- Certificate of Completion ONLY
- Have questions on how digital purchases work? Learn more here
Requirements
- Microsoft Excel (ideally 2016 for PC)
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.
KEY FEATURES
If you’re looking to become a power Excel user and absolutely supercharge your analytics, this course is the A-Z guide you’re looking for.
The course kicks things off by introducing the “Power Excel” landscape and explores what these tools are all about and why they are changing the world of self-service business intelligence. From there, you’ll dive into Data Modeling 101, and cover the fundamentals of database design and normalization (including table relationships, cardinality, hierarchies, and more). You’ll then move on with Power Pivot and DAX to explore and analyze your data model. If you’re ready to take your Excel game to new heights and join the leading edge of analytics & business intelligence, this course is for you.
★ ★ ★ ★
★
- Access 91 lectures & 7 hours of content 24/7
- Get up & running with Excel’s game-changing data modeling & business intelligence tools
- Use Power Query, Power Pivot & DAX to revolutionize your workflow in Excel absolutely
- Master unique tips, tools & case studies
- Explore fun, interactive & highly effective lessons
- Get lifetime access to project files, quizzes and homework exercises & 1-on-1 expert support
- Build pro-quality business intelligence solutions to blend & analyze data from multiple sources
NOTE: Software NOT included
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
- Experience level required: all levels
- Certificate of Completion ONLY
- Have questions on how digital purchases work? Learn more here
Requirements
- Version of Excel that is compatible with Power Pivot (Excel 2013/2016 Standalone, Office 365 Pro Plus, Enterprise E3/E5, Office Professional 2016, etc.)
- This course is designed for PC users (Power Pivot is currently unavailable with Excel for Mac)
- Experience with Excel Pivot Tables and cell formulas & functions is strongly recommended
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.
KEY FEATURES
Welcome to the most COMPREHENSIVE Excel course, which teaches every single Excel feature from scratch and how to program, in Excel using Visual Basic for Applications & Macros.
In this course, you will learn all of the common functions in Excel and introduce you to programming using Visual Basic for Applications (VBA) & Macros. You will learn the basic skills required to program in Excel, including inserting images and data, creating advanced pivot tables, and working with formulas. With this comprehensive course, you’ll have the knowledge needed to create amazing dashboards and reports.
Over 1.5M students and counting!
★ ★ ★ ★
★
- Access 200+ lectures & 13 hours of content 24/7
- Discover how to use Excel functions from basic to advanced
- Understand basic functions & formulas
- Create Excel charts (from basic to advanced level)
- Generate Datasets and Data visualizations in Microsoft Excel
- Learn how to create a pivot table
- Automate your day-to-day Excel tasks by mastering the power of Macros & VBA
- Learn how to use & change defined names
- Learn how to program & insert images
NOTE: Software NOT included.
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
- Experience level required: intermediate
- Have questions on how digital purchases work? Learn more here
Requirements
- No prior Excel or programming experience is required to take this course
- Microsoft Excel 2016, 2019, 365
THE EXPERT
Chris Haroun | Award Winning MBA Professor, Venture Capitalist and Author
★ ★ ★ ★
★
Chris Haroun is an award-winning business school professor, venture capitalist, MBA graduate from Columbia University and former Goldman Sachs employee. He has raised/managed over $1bn in his career. He also has work experience at hedge fund giant Citadel, consulting firm Accenture, and several firms that he has started, including an investment firm that had a venture capital / private investment in Facebook several years before the Facebook IPO. He is the founder and CEO of Haroun Education Ventures.
KEY FEATURES
Unlock the power of your data with pivot tables in Microsoft Excel! This exclusive tool is a game-changer when it comes to managing large amounts of data. In this course, you’ll learn how to create and use pivot tables with easy-to-follow lessons and examples. Organize your data and create easy-to-read tables in just a few clicks, saving you valuable time and effort. Whether you’re a business owner, analyst, or student, pivot tables are an invaluable tool for analyzing and presenting data in a meaningful way. Enroll now and take your data analysis skills to the next level!
★ ★ ★ ★
★
- Access 9 lectures & 0 hours of content 24/7
- Learn how to create pivot tables
- Learn how to use pivot tables
- Organize data ready to create pivot tables
- Add conditional formatting to your pivot table
- Prepare Microsoft Excel data for PivotTable reporting
- Create & manage PivotTable calculations
- Format PivotTables for presentations
- Update PivotTable source data
- Create & manage data relationships
NOTE: Software NOT included
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
- Experience level required: beginner
- Updates included
- Certificate of Completion ONLY
- Have questions on how digital purchases work? Learn more here
Requirements
- Microsoft Excel
THE EXPERT
Kathryn Tilley | Online Excel Instructor</b.
★ ★ ★ ★
★
Kathryn Tilley has been using Excel for many years & have used her expertise to create online courses to help her students to learn all about Excel and how it can make your life easier. Her courses are aimed to help beginners how to use spreadsheets to streamline their business & make things run much more smoothly.
KEY FEATURES
Excel can be the most awkward of all Microsoft programs if not, the most awkward programs of all time! And although 750 million people have Excel installed on their computer, 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. It’s designed to help you get up to speed as fast as possible, you can expect to be at a capable level within the first hour of lectures, then you will have the opportunity to explore more great features, functions, and tools as you progress further through the course.
★ ★ ★ ★
★
- Access 92 lectures & 8 hours of content 24/7
- Acquire critical Excel knowledge
- Create workbooks & spreadsheets everyone will be jealous of
- Learn all about: tables, charts, formatting, formulas & functions, macros, pivot tables/charts, and much more!
- Calculate with the IF Function & apply conditional formatting
- Use the PMT Function to explore monthly & yearly compounding
- Use Google Drive to collect data
NOTE: Software NOT included.
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
- Experience level required: all levels
- Have questions on how digital purchases work? Learn more here
Requirements
- Any version of Excel. Including Excel in Microsoft Office 365
THE EXPERT
Warrick Klimaytys | Computer Technician
★ ★ ★ ★
★
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 he 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.
https%3A%2F%2Fstacksocial.com%2Fsales%2Fthe-2023-premiere-microsoft-excel-certification-training-bundle%3Faid%3Da-7z5mx0lp%26utm_campaign%3Dfeed%26utm_medium%3DRSS%26utm_source%3Dwww
Source link
