Expires October 06, 2119 23:59 PST
Buy now and get 98% off
Intro to Excel
KEY FEATURES
Get started with Excel, the industry-standard in spreadsheet tools. With Excel, you will boost your business data processing with one of the world's most popular productivity tools. Used for storing, organizing, and analyzing your data, Excel allows you to turn your data into insights, making it highly useful in your professional life. This course covers the foundations of Excel – from creating your first spreadsheet and visualizing your data, to the shortcuts that will help you to increase your productivity.- Access 9 lectures & less than an hour of content 24/7
- Create, format & group new spreadsheets
- Visualize your data on tables & charts
- Use shortcuts to speed up your work
- Master autofill functions
- Paste data dynamically in multiple ways
PRODUCT SPECS
Important Details
- Length of time users can access this course: lifetime
- Access options: web & mobile streaming
- Certification of completion included
- Redemption deadline: redeem your code within 30 days of purchase
- Updates included
- Experience level required: beginner
Requirements
- Microsoft Excel
- PC or Mac
THE EXPERT
Instructor
Trusted by 400,000+ learners and developers, Zenva provides world-class training on in-demand programming skills covering game development, machine learning, virtual reality, and full-stack web development. Their e-learning platform Zenva Academy is the leading place to upskill, learn and gain key tech skills for the innovation economy.Visualize Data with Excel Charts
KEY FEATURES
Master data presentation and learn to create functional and beautiful charts in Microsoft Excel. Through one of the world's most popular productivity tools, you can not only increase your business efficiency but make good first impressions with professional colleagues. Using sales data, you will create bar charts, combo charts, interactive charts, and more – all while learning to expertly format them in various layouts. This knowledge will allow you to benefit from the comprehensive and meaningful insights that can be gained through data visualization.- Access 11 lectures & less than an hour of content 24/7
- Create basic charts from data in a spreadsheet
- Format chart elements, labels & overall appearance
- Utilize chart templates to speed up chart creation
- Combine chart types into a single chart
- Build a dropdown to interactively display different charts
- Use Sparklines to quickly analyze data trends
PRODUCT SPECS
Important Details
- Length of time users can access this course: lifetime
- Access options: web & mobile streaming
- Certification of completion included
- Redemption deadline: redeem your code within 30 days of purchase
- Updates included
- Experience level required: beginner
Requirements
- Basic working knowledge of Excel
THE EXPERT
Instructor
Trusted by 400,000+ learners and developers, Zenva provides world-class training on in-demand programming skills covering game development, machine learning, virtual reality, and full-stack web development. Their e-learning platform Zenva Academy is the leading place to upskill, learn and gain key tech skills for the innovation economy.Working with Excel Text Functions
KEY FEATURES
Begin manipulating text data within Microsoft Excel using native functions. With one of the world's most popular productivity tools, you can learn to handle any sort of data with ease and impress those in your professional life with your newfound skills. Whether you need to combine, split, or analyze various text-based values from different columns, this course will help you to implement text functions that work with both numbers and strings. Through these, you will transform your text-based worksheets and more efficiently manage your addresses, dates, order information, and more.- Access 12 lectures & less than an hour of content 24/7
- Merge multiple columns w/ text content into one column
- Use the TEXTJOIN function for advanced concatenation
- Extract & alter text data from a cell
- Manipulate text from irregular strings w/ FIND & SEARCH
- Use the SUBSTITUTE function to dynamically replace text
- Convert a string/text value into a number value
PRODUCT SPECS
Important Details
- Length of time users can access this course: lifetime
- Access options: web & mobile streaming
- Certification of completion included
- Redemption deadline: redeem your code within 30 days of purchase
- Updates included
- Experience level required: beginners
Requirements
- Basic knowledge of using Microsoft Excel & formulas
THE EXPERT
Instructor
Trusted by 400,000+ learners and developers, Zenva provides world-class training on in-demand programming skills covering game development, machine learning, virtual reality, and full-stack web development. Their e-learning platform Zenva Academy is the leading place to upskill, learn and gain key tech skills for the innovation economy.Statistical Formulas for Excel Data Analysis
KEY FEATURES
Add a variety of statistics to your spreadsheets using Excel’s statistical formulas. Whether you need to find the average of a product’s sales or the count of certain items, this course will teach you all the functions needed to automatically calculate these values. Not only can you increase your business' productivity through automated calculations, but you can delve further into the popular productivity tool of Excel to increase the efficiency of your professional life. Take the next step in your career and improve your data analysis techniques.- Access 10 lectures & less than an hour of content 24/7
- Use the SUMIF, COUNTIF & AVERAGEIF functions for basic, statistical calculations
- Reference cell values for criteria
- Handle multiple conditions within the formulas
- Utilize wildcards to dynamically match data
- Implement the SUMPRODUCT function
- Combine SUMPRODUCT w/ arrays & other statistical formulas
PRODUCT SPECS
Important Details
- Length of time users can access this course: lifetime
- Access options: web & mobile streaming
- Certification of completion included
- Redemption deadline: redeem your code within 30 days of purchase
- Updates included
- Experience level required: beginner
Requirements
- Basic working knowledge of Excel
THE EXPERT
Instructor
Trusted by 400,000+ learners and developers, Zenva provides world-class training on in-demand programming skills covering game development, machine learning, virtual reality, and full-stack web development. Their e-learning platform Zenva Academy is the leading place to upskill, learn and gain key tech skills for the innovation economy.Intro to Excel Data Tools & Data Management
KEY FEATURES
Master advanced data management and boost your productivity with Excel’s data tools. With Excel, one of the world's most popular productivity tools on the market, you can master a variety of skills to handle data for your business or professional life. From dynamically organizing your data, to simplifying your methods for data processing and analysis, you will learn techniques that will help you to gain invaluable insights into your projects.- Access 12 lectures & 1 hour of content 24/7
- Set up data validation rules to prevent bad data
- Separate text in a column
- Quickly remove duplicate data from a list
- Utilize flash fill to fill in data w/ a single click
- Seek values by testing what-if scenarios for formulas
- Utilize data tables & data types for more complex analysis
PRODUCT SPECS
Important Details
- Length of time users can access this course: lifetime
- Access options: web & mobile streaming
- Certification of completion included
- Redemption deadline: redeem your code within 30 days of purchase
- Updates included
- Experience level required: beginner
Requirements
- Basic working knowledge of Excel
THE EXPERT
Instructor
Trusted by 400,000+ learners and developers, Zenva provides world-class training on in-demand programming skills covering game development, machine learning, virtual reality, and full-stack web development. Their e-learning platform Zenva Academy is the leading place to upskill, learn and gain key tech skills for the innovation economy.Lookup Functions for Excel
KEY FEATURES
Explore your Excel spreadsheet data professionally by learning to use lookup functions. With these tools, you will be able to look up any data of your choosing through a variety of methods and store that data easily in cells. Additionally, you will also master one of the world's most popular productivity tools and learn skills to benefit your business's large amount of data. Level-up your knowledge of Excel, manage your data efficiently and learn even more functionality for your needs.- Access 10 lectures & less than an hour of content 24/7
- Use VLOOKUP & HLOOKUP to lookup data in columns and rows
- Match data in various ways, including exact match
- Handle errors gracefully & in more user-friendly ways
- Utilize column index numbers for better lookup functionality
- Pair INDEX & MATCH functions for combined lookup efforts
PRODUCT SPECS
Important Details
- Length of time users can access this course: lifetime
- Access options: web & mobile streaming
- Certification of completion included
- Redemption deadline: redeem your code within 30 days of purchase
- Updates included
- Experience level required: beginner
Requirements
- General familiarity with Excel
- Intermediate understanding of Excel formulas
THE EXPERT
Instructor
Trusted by 400,000+ learners and developers, Zenva provides world-class training on in-demand programming skills covering game development, machine learning, virtual reality, and full-stack web development. Their e-learning platform Zenva Academy is the leading place to upskill, learn and gain key tech skills for the innovation economy.Explore Conditional Excel Formatting
KEY FEATURES
Add more clarity and aesthetic appeal to your spreadsheets by using conditional formatting. Through one of the world's most popular productivity tools, Excel, you can efficiently make professional-looking spreadsheets while saving time with automation. With this course, you will learn how to apply rules against your data so Excel can automatically format the appearance of your spreadsheet. Make Excel work for you and increase your productivity with these techniques.- Access 10 lectures & less than an hour of content 24/7
- Create & manage conditional formatting rules
- Highlight, change colors, bold text & more through established rules
- Set up data bars, heat map & icon sets for more advanced visual aids
- Automatically format entire rows w/ your rulesets
- Utilize multiple sets of criteria for your conditions
PRODUCT SPECS
Important Details
- Length of time users can access this course: lifetime
- Access options: web & mobile streaming
- Certification of completion included
- Redemption deadline: redeem your code within 30 days of purchase
- Updates included
- Experience level required: beginner
Requirements
- asic understanding of Excel formulas & general Excel tasks
THE EXPERT
Instructor
Trusted by 400,000+ learners and developers, Zenva provides world-class training on in-demand programming skills covering game development, machine learning, virtual reality, and full-stack web development. Their e-learning platform Zenva Academy is the leading place to upskill, learn and gain key tech skills for the innovation economy.Excel Logic Functions for Beginners
KEY FEATURES
Learn smart decision making with Excel and analyze your data with increased speed and efficiency. Not only will you increase the productivity of data handling in your professional life, but you'll step further into the world of Excel and master this immensely popular tool. Through this course, you will learn how to use a variety of advanced logic functions that let Excel decide how to display your data and cells.- Access 9 lectures & less than an hour of content 24/7
- Implement “if” functions to test number, text & date values for conditions
- Use “and” & “or” to increase or decrease passing conditions
- Nest “if” functions to create even more complicated formulas
- Set up switch functions to easily test multiple criteria
PRODUCT SPECS
Important Details
- Length of time users can access this course: lifetime
- Access options: web & mobile streaming
- Certification of completion included
- Redemption deadline: redeem your code within 30 days of purchase
- Updates included
- Experience level required: beginner
Requirements
- Microsoft Excel
- Basic familiarity with Excel
- PC or Mac
THE EXPERT
Instructor
Trusted by 400,000+ learners and developers, Zenva provides world-class training on in-demand programming skills covering game development, machine learning, virtual reality, and full-stack web development. Their e-learning platform Zenva Academy is the leading place to upskill, learn and gain key tech skills for the innovation economy.Discover Excel Formulas
KEY FEATURES
Study new Excel skills by implementing formulas and functions for automatic calculations. With these simple techniques in this immensely popular productivity tool, you can make more time for your business and let Excel handle all the math work for you. This course will get you started in manipulating your data in more dynamic, calculative ways, whether you need to work with numerical values or dates. Make Excel work for you and analyze your data fast and efficiently.- Access 10 lectures & 1 hour of content 24/7
- Set up basic & advanced mathematical operations, including working w/ percentages
- Use absolute references for easy auto-filling
- Access basic functions, such as averaging values
- Reference other sheets for formulas & functions
- Manipulate dates using formula logic
- Deal w/ named ranges when setting up formulas
PRODUCT SPECS
Important Details
- Length of time users can access this course: lifetime
- Access options: web & mobile streaming
- Certification of completion included
- Redemption deadline: redeem your code within 30 days of purchase
- Updates included
- Experience level required: beginner
Requirements
- Microsoft Excel
- Windows or Mac
THE EXPERT
Instructor
Trusted by 400,000+ learners and developers, Zenva provides world-class training on in-demand programming skills covering game development, machine learning, virtual reality, and full-stack web development. Their e-learning platform Zenva Academy is the leading place to upskill, learn and gain key tech skills for the innovation economy.Manage Large Excel Spreadsheets
KEY FEATURES
Learn the ins and outs of data manipulation for large spreadsheets in Excel. With one of the world's most popular productivity tools, you can impress those in your professional life by handling any amount of data with ease. This course will walk you through how to view your massive quantities of data easily and how to manage your data for quick comparisons. Further your Excel skills and manipulate your data like a professional.- Access 9 lectures & less than an hour of content 24/7
- Freeze & split panes to compare data across large distances
- Sort list data by single & multiple columns
- Filter lists by a variety of criteria
- Hide & unhide columns
- Set up your spreadsheet for printing based on your needs
PRODUCT SPECS
Important Details
- Length of time users can access this course: lifetime
- Access options: web & mobile streaming
- Certification of completion included
- Redemption deadline: redeem your code within 30 days of purchase
- Updates included
- Experience level required: beginner
Requirements
- PC or Mac
- Microsoft Excel
- Basic familiarity with Excel
THE EXPERT
Instructor
Trusted by 400,000+ learners and developers, Zenva provides world-class training on in-demand programming skills covering game development, machine learning, virtual reality, and full-stack web development. Their e-learning platform Zenva Academy is the leading place to upskill, learn and gain key tech skills for the innovation economy.Excel Advanced Functions & Formulas Course Introduction
KEY FEATURES
Microsoft Excel contains hundreds of built-in functions, such as SUM, AVERAGE, MIN, IF, VLOOKUP and many more. As you participate in this course, you'll go through a series of exercises tailored to give you the greatest exposure and step-by-step instruction as you learn to harness the power of Excel's INDEX() and MATCH() functions. After you master these building block concepts, you'll then dive into several real-world scenarios and the finer points of creating dynamic and robust formulas.- Access 42 lectures & 3 hours of content 24/7
- Understand the fundamental building blocks of creating complex calculations
- Learn & implement the INDEX and MATCH functions
- Create dynamic LOOKUPS by combining functions
- Create ARRAY functions w/ INDEX & IF functions
- Combine INDEX/MATCH & MIN to return associated data points
- Build complex conditional formatting w/ calculations
PRODUCT SPECS
Important Details
- Length of time users can access this course: lifetime
- Access options: web & mobile streaming
- Certification of completion included
- Redemption deadline: redeem your code within 30 days of purchase
- Updates included
- Experience level required: beginner
Requirements
- PC or Mac
- Internet access required
THE EXPERT
Instructor
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 & Visio
- SharePoint End-User 2007, 2010, 2013
- VBA (Excel & Access)
- Adobe Suite
- Photoshop, Illustrator, InDesign
- Maya (Modeling & Animation)
- Unity3d (Game Design)
- HTML, CSS & JavaScript
- Crystal Reports
Microsoft Excel Data Analysis & Dashboard Reporting
KEY FEATURES
By participating in this Microsoft Excel Data Analysis and Dashboard Reporting course you'll gain the widely sought after skills necessary to effectively analyze large sets of data using Excel. Once the data has been analyzed, clean and prepared for presentation, you will learn how to present the data in an interactive dashboard report. This 3-hour course will also cover some of the most popular data analysis Excel functions and Dashboard tools including VLOOKUP, INDEX/MATCH, TEXT functions, and more. This course comes with over 30 videos to follow along, downloadable exercise files, instructor support, and a real-world Excel dashboard.- Access 40 lectures & 3 hours of content 24/7
- Understand & identify the principles of data analysis
- Use effective design principles when creating & presenting data
- Build interactive dashboard reports
- Learn Data Mine using Excels array functions
- Streamline & analyze data w/ Excel PivotTables and Pivot Charts
PRODUCT SPECS
Important Details
- Length of time users can access this course: lifetime
- Access options: web & mobile streaming
- Certification of completion included
- Redemption deadline: redeem your code within 30 days of purchase
- Updates included
- Experience level required: beginner
Requirements
- Experience working w/ Microsoft Excel on a Windows system
- Excel 2010, 2013, 2016
THE EXPERT
Instructor
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 & Visio
- SharePoint End-User 2007, 2010, 2013
- VBA (Excel & Access)
- Adobe Suite
- Photoshop, Illustrator, InDesign
- Maya (Modeling & Animation)
- Unity3d (Game Design)
- HTML, CSS & JavaScript
- Crystal Reports
Advanced Excel & VBA for Financial Modeling
KEY FEATURES
Excel is a programming language in and of itself. In this power-packed course, you'll use Excel and Visual Basic for Apps (VBA) for some serious financial number-crunching. You'll cover risk modeling, factor analysis, numerical optimization, and linear and logistic regression in your quest to become a competent financial modeler.- Access 97 lectures & 11 hours of content 24/7
- Model risk using covariance matrices & historical returns
- Understand principal components, Eigen values & Eigen vectors
- Apply PCA to explain the returns of a technology stock like Apple
- Study various extensions to the Simplex method, including K-of-N constraints & quadratic objective functions
- Interpret regression results & avoid common pitfalls
PRODUCT SPECS
Important Details
- Length of time users can access this course: lifetime
- Access options: web & mobile streaming
- Certification of completion included
- Redemption deadline: redeem your code within 30 days of purchase
- Updates included
- Experience level required: beginner
Requirements
- PC or Mac
- Internet access required
THE EXPERT
Instructor
Loonycorn is comprised of two individuals—Janani Ravi and Vitthal Srinivasan—who have honed their respective tech expertise at Google and Flipkart. The duo graduated from Stanford University and believes it has distilled the instruction of complicated tech concepts into funny, practical, engaging courses, and is excited to be sharing its content with eager students.Microsoft Excel Master Class for Business Managers
KEY FEATURES
Whether you're new to Excel or you've played around with it but want to get more comfortable with its advanced features, this course will be great for you. This course covers everything you need to crack Excel in the professional workplace from mathematical functions and formulas up to tables and charts. By the end of this course, your confidence in using Excel will soar. You'll have a thorough understanding of how to use Microsoft Excel for study or as a career opportunity.- Access 30 lectures & 3 hours of content 24/7
- Become proficient in Excel data tools like Sorting, Filtering, Data validations & Data importing
- Visually enchant viewers using Bar charts, Scatter Plots, Histograms, Waterfall charts & more
- Become competent in using advanced Analytics techniques in Excel such as Regression, Goal Seek & Solver
- Make great presentations using the Conditional & Table formatting options
PRODUCT SPECS
Important Details
- Length of time users can access this course: lifetime
- Access options: web & mobile streaming
- Certification of completion included
- Redemption deadline: redeem your code within 30 days of purchase
- Updates included
- Experience level required: beginner
Requirements
- PC or Mac
- Internet access required
- Any version of Excel
THE EXPERT
Instructor
Abhishek Bansal worked as an Acquisition Process owner in a leading telecom company before moving on to learning and teaching technologies like Machine Learning and Artificial Intelligence.Pukhraj Parikh worked as an Acquisition Process owner in a leading telecom company before moving on to learning and teaching technologies like Machine Learning and Artificial Intelligence.