KEY FEATURES

This course will build on the skills learned in the beginners' course and expand their essential Excel toolkit. Students will learn how to create intermediate-level formulas, clean and analyze data using PivotTables and Pivot Charts, control data input with validation rules, make decisions with WhatIf analysis tools as well as learn the golden rules of spreadsheet design. That’s just scratching the surface! Students will also get to experience all the new functions and features available in Excel 2021, the latest standalone version of Excel from Microsoft.

Excel 2021 Intermediate is designed for students who have a beginner-level knowledge of Excel and are looking to build on those skills. It’s also perfect for students who have beginner to intermediate-level skills in an older version of Excel and are looking to update their skills.

• Access 84 lectures & 9.5 hours of content 24/7
• Design better spreadsheets & control user input
• Use logical functions to make better business decisions
• Construct functional & flexible lookup formulas
• Use Excel tables to structure data & make it easy to update
• Extract unique values from a list
• Explore the exciting world of dynamic array functions & learn how to use XLOOKUP, XMATCH, FILTER and so much more

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

• Microsoft Excel 2016, 2019, 365
• Basic understanding of how to use Microsoft Excel

THE EXPERT

Simon Sez IT
Since 2008, individuals, small businesses, and Fortune 500 companies with thousands of employees have benefited from the easy and hands-on software training offered by Simon Sez IT. With over 9,000 video tutorials on a range of software programs, Simon Sez IT ensures stress-free eLearning and enhanced employee productivity - no matter whether you are implementing new software or a technological upgrade for your workplace. With over 750,000 Udemy students in over 180 countries, Simon Sez IT is the preferred online learning choice for individuals and businesses everywhere.

KEY FEATURES

Ever tried learning Excel on a Mac with a course designed for a PC? Well, it looks completely different. Luckily Stream Skill's got you covered. If you’ve used Excel before but never on a Mac, then this comprehensive Beginners Excel for Mac course is for you. If you’re brand new to Excel and you’re using the Mac version, then this course is definitely for you. This course was recorded using Excel for Mac 2019 but much of what is taught is still relevant if you’re using a different version.

• Access 57 lectures & 5 hours of content 24/7
• Create, open & save new workbooks in Excel Mac
• Understand the basics of how Excel for Mac works including relative references & order of operations
• Set up workbooks & print the right thing in Excel
• Move data around in Excel for Mac
• Know basic formulas & functions work

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
• Have questions on how digital purchases work? Learn more here

Requirements

• Office 2019 & 2016

THE EXPERT

Simon Sez IT
Since 2008, individuals, small businesses, and Fortune 500 companies with thousands of employees have benefited from the easy and hands-on software training offered by Simon Sez IT. With over 9,000 video tutorials on a range of software programs, Simon Sez IT ensures stress-free eLearning and enhanced employee productivity - no matter whether you are implementing new software or a technological upgrade for your workplace. With over 750,000 Udemy students in over 180 countries, Simon Sez IT is the preferred online learning choice for individuals and businesses everywhere.

KEY FEATURES

If you want to master Excel, you need to know how formulas work together to accomplish complex tasks. In this Advanced Formulas in Excel course, you'll focus on a set of Excel formulas, functions, and tools that enable you to perform complex tasks and analyses. The course will look at how to filter a dataset and sort using formulas. After that, you'll learn how to create multi-dependent drop-down lists, 2-way lookups, text extraction, dynamic chart titles, and so much more! We end by looking at how to use XLOOKUP.

• Access 12 lectures & 2.5 hours of content 24/7
• Filter a dataset using a formula
• Sort a dataset using formulas & defined variables
• Create multi-dependent dynamic drop-down lists
• Perform a 2-way lookup
• Make decisions with complex logical calculations
• Extract parts of a text string
• Create a dynamic chart title
• Find the last occurrence of a value in a list
• Look up information with XLOOKUP
• Find the closest match to a value

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

• Microsoft Excel 2016, 2019, 365
• Basic understanding of how to use Microsoft Excel

THE EXPERT

Simon Sez IT
Since 2008, individuals, small businesses, and Fortune 500 companies with thousands of employees have benefited from the easy and hands-on software training offered by Simon Sez IT. With over 9,000 video tutorials on a range of software programs, Simon Sez IT ensures stress-free eLearning and enhanced employee productivity - no matter whether you are implementing new software or a technological upgrade for your workplace. With over 750,000 Udemy students in over 180 countries, Simon Sez IT is the preferred online learning choice for individuals and businesses everywhere.

KEY FEATURES

Get beyond the basics and supercharge your current skill level in Excel. With this expert-led video training course, you’ll gain an in-depth understanding of more advanced Excel features that delve into high-level consolidation, analysis, and reporting of financial information.

• Access 57 lectures & 8 hours of content 24/7
• Learn what’s new/different in Excel 2019
• Understand advanced charting & graphing in Excel
• Discover how to use detailed formatting tools
• Discuss financial functions including calculating interest & depreciation
• Connect to other workbooks & datasets outside of Excel
• Create awesome visualizations using sparklines & data bars

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: advanced
• Have questions on how digital purchases work? Learn more here

Requirements

• Microsoft Excel 2016, 2019, 365
• Basic understanding of how to use Microsoft Excel

THE EXPERT

Simon Sez IT
Since 2008, individuals, small businesses, and Fortune 500 companies with thousands of employees have benefited from the easy and hands-on software training offered by Simon Sez IT. With over 9,000 video tutorials on a range of software programs, Simon Sez IT ensures stress-free eLearning and enhanced employee productivity - no matter whether you are implementing new software or a technological upgrade for your workplace. With over 750,000 Udemy students in over 180 countries, Simon Sez IT is the preferred online learning choice for individuals and businesses everywhere.

KEY FEATURES

Excel 2021 is the latest stand-alone release from Microsoft and includes many of the features and functionalities currently available only in the subscription-based Excel 365. If you have no Excel experience whatsoever, then this course is the perfect starting point for you. Perhaps you have some basic Excel knowledge, and you want to upgrade from an older version of Excel or sharpen your skills. Well, this training will get you up to speed. The course is 11 hours, with 100 individual video lessons and exercises. It includes downloadable course files and exercise files, so you can follow along with the instructor and then practice what you have learned at the end of each section.

• Access 100 lectures & 11 hours of content 24/7
• Know what's new in Excel 2021
• Navigate the Excel 2021 interface
• Learn useful keyboard shortcuts to increase pro
• Effectively apply formatting to cells & use conditional formatting
• Work efficiently by using the cut, copy, & amp;paste options
• Analyze data using charts

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
• Have questions on how digital purchases work? Learn more here

Requirements

• Microsoft Excel 2016, 2019, 365
• Basic understanding of how to use Microsoft Excel

THE EXPERT

Simon Sez IT
Since 2008, individuals, small businesses, and Fortune 500 companies with thousands of employees have benefited from the easy and hands-on software training offered by Simon Sez IT. With over 9,000 video tutorials on a range of software programs, Simon Sez IT ensures stress-free eLearning and enhanced employee productivity - no matter whether you are implementing new software or a technological upgrade for your workplace. With over 750,000 Udemy students in over 180 countries, Simon Sez IT is the preferred online learning choice for individuals and businesses everywhere.

KEY FEATURES

The course is designed for individuals and professionals who are new to VBA and who are seeking practical ways to automate tasks in Microsoft Excel that are performed frequently. Through 4 hours of video lectures, exercise files, and an optional quiz, you'll learn the essentials you need to know to create powerful macros using VBA for Excel. When you complete this course, you'll be well on your way to using VBA macros in Excel to help you and others automate tasks and operations performed frequently.

• Access 32 lectures & 4 hours of content 24/7
• Find out how to use the VBA editor, VBA syntax, keywords, & comments
• Discover how to define & manage variables, set up subroutines, and create functions
• Also, find out how to use input boxes & message boxes to interact with end users
• Learn practical methods for using macro errors to improve your VBA code

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
• Have questions on how digital purchases work? Learn more here

Requirements

• Microsoft Excel 2016, 2019, 365
• Basic understanding of how to use Microsoft Excel

THE EXPERT

Simon Sez IT
Since 2008, individuals, small businesses, and Fortune 500 companies with thousands of employees have benefited from the easy and hands-on software training offered by Simon Sez IT. With over 9,000 video tutorials on a range of software programs, Simon Sez IT ensures stress-free eLearning and enhanced employee productivity - no matter whether you are implementing new software or a technological upgrade for your workplace. With over 750,000 Udemy students in over 180 countries, Simon Sez IT is the preferred online learning choice for individuals and businesses everywhere.

KEY FEATURES

This advanced Excel course will look at three crucial advanced Excel features Power Pivot, Power Query, and DAX. This Excel function suite allows you to manipulate, analyze, and evaluate millions of rows of data from Excel or other databases. You'll first learn how to bring your data together, merge, and clean it using Power Query. You'll then perform calculations on your data model using DAX, and finally, look at displaying your analysis using PivotTables and PivotCharts. This course also includes practice exercises and follow-along files to build your data models as you learn.

• Access 44 lectures & 3.5 hours of content 24/7
• Get started with Power Query
• Connect Excel to multiple workbooks
• Merge & append queries using Power Query
• Set up & manage relationships in a data model
• Create a PivotTable to display your data
• Use functions such as CALCULATE, DIVIDE, DATESYTD in DAX

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: advanced
• Have questions on how digital purchases work? Learn more here

Requirements

• Microsoft Excel 2016, 2019, 365
• Basic understanding of how to use Microsoft Excel

THE EXPERT

Simon Sez IT
Since 2008, individuals, small businesses, and Fortune 500 companies with thousands of employees have benefited from the easy and hands-on software training offered by Simon Sez IT. With over 9,000 video tutorials on a range of software programs, Simon Sez IT ensures stress-free eLearning and enhanced employee productivity - no matter whether you are implementing new software or a technological upgrade for your workplace. With over 750,000 Udemy students in over 180 countries, Simon Sez IT is the preferred online learning choice for individuals and businesses everywhere.

KEY FEATURES

Microsoft Excel remains one of the best tools for Data Analysis. In this course, you'll learn the specific functions, formulas, and tools that Excel has to help conduct business or data analysis. You'll take a look at raw data, tools, functions, and advanced techniques. This course also includes practice exercises to immediately put into practice the new data analysis techniques that you learn.

• Access 55 lectures & 7 hours of content 24/7
• Merge data from different sources using VLOOKUP, HLOOKUP, INDEX MATCH, & XLOOKUP
• Use IF, IFS, IFERROR, SUMIF, & COUNTIF to apply logic to your analysis
• Split data using text functions SEARCH, LEFT, RIGHT, MID
• Standardize & clean data ready for analysis
• Use the PivotTable function to perform data analysis
• Use slicers to draw out information
• Display your analysis using Pivot Charts
• Learn about forecasting & using the Forecast Sheets
• Conduct a Linear Forecast & Forecast Smoothing
• Use Conditional Formatting to highlight areas of your data
• Use Goal Seek, Scenario Manager, & Solver to fill data gaps

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: advanced
• Have questions on how digital purchases work? Learn more here

Requirements

• Microsoft Excel 2016, 2019, 365
• Basic understanding of how to use Microsoft Excel

THE EXPERT

Simon Sez IT
Since 2008, individuals, small businesses, and Fortune 500 companies with thousands of employees have benefited from the easy and hands-on software training offered by Simon Sez IT. With over 9,000 video tutorials on a range of software programs, Simon Sez IT ensures stress-free eLearning and enhanced employee productivity - no matter whether you are implementing new software or a technological upgrade for your workplace. With over 750,000 Udemy students in over 180 countries, Simon Sez IT is the preferred online learning choice for individuals and businesses everywhere.

KEY FEATURES

In this third course of the Excel 2021 series, students will build on the skills learned in the beginner and intermediate courses and take their functional expertise to new heights. Students will be introduced to six brand-new dynamic array functions, learn how to build advanced Excel formulas, analyze data with advanced PivotTable skills, create macros to automate tasks, import and clean data with Power Query, forecast data, and so much more!

Excel 2021 Advanced is designed to take advantage of the latest updates from Microsoft including the game-changing LET and LAMBDA functions. These exciting functions allow students to create their own variables and even their own Excel functions. This course is designed to help students tackle problem-solving differently and combine Excel's myriad functions to complete practical tasks.

• Use the NEW dynamic array functions to perform tasks
• Create advanced & flexible lookup formulas
• Use statistical functions to rank data & to calculate the MEDIAN and MODE
• Produce accurate results when working with financial data using Math functions
• Create variables and functions with LET and LAMBDA
• Analyze data with advanced PivotTable & PivotChart hacks
• Create interactive reports & dashboards by incorporating form controls
• Import & clean data using Power Query
• Predict future values using forecast functions & forecast sheets
• Record & run macros to automate repetitive tasks
• Understand & make minor edits to VBA code
• Combine functions to create practical formulas to complete specific tasks

Note: Software is 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
• Updates included
• Certificate of Completion ONLY
• Have questions on how digital purchases work? Learn more here

Requirements

• MS Excel 2021
• Intermediate-level application knowledge

THE EXPERT

Simon Sez IT
Since 2008, individuals, small businesses, and Fortune 500 companies with thousands of employees have benefited from the easy and hands-on software training offered by Simon Sez IT. With over 9,000 video tutorials on a range of software programs, Simon Sez IT ensures stress-free eLearning and enhanced employee productivity - no matter whether you are implementing new software or a technological upgrade for your workplace. With over 750,000 Udemy students in over 180 countries, Simon Sez IT is the preferred online learning choice for individuals and businesses everywhere.

KEY FEATURES

Unlock the power of data analytics using Microsoft Excel! Dive into essential Excel features, from basic spreadsheet layout to advanced data analysis techniques. Learn to leverage Excel's built-in tools for data cleaning, formula exploration, and visualization. This course guides you through the intricacies of Excel charts, helping you depict data patterns and forecast outcomes. Discover the potential of the Analysis ToolPak add-in, mastering what-if scenarios and solving real-world business challenges. Acquire in-demand skills and become a proficient data analyst.

• Access 38 lectures & 4.3 hours of content 24/7
• Describe the fundamentals of Excel spreadsheets, from their layout to the applications
• View, enter, & format data types in Excel
• Understand and apply Excel formulas & functions
• Import file data & remove duplicates
• Identify data attributes
• Sort data & apply filters, including advanced filtering techniques
• Apply Concatenation & Sum-if formulas to analyze data sets
• Create problem statements to tackle complicated “or” criteria
• Create Pivot tables & charts
• Work with Excel charts, including clustered columns, line graphs, & waterfalls
• Utilize database functions created specifically to work with large datasets
• Apply techniques to recognize & avoid formula errors
• Understand & use the What-If Analysis toolkit which includes the Scenario Manager, Goal Seek, and Data Table functions
• Use the Analysis ToolPak to calculate basic statistical concepts such as correlation & covariance
• Compute descriptive statistics & moving averages and apply exponential smoothing techniques
• Utilize rank & percentile options and generate histograms

Note: Software is 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
• Basic knowledge of Microsoft Excel is helpful but not required

THE EXPERT

Simon Sez IT
Since 2008, individuals, small businesses, and Fortune 500 companies with thousands of employees have benefited from the easy and hands-on software training offered by Simon Sez IT. With over 9,000 video tutorials on a range of software programs, Simon Sez IT ensures stress-free eLearning and enhanced employee productivity - no matter whether you are implementing new software or a technological upgrade for your workplace. With over 750,000 Udemy students in over 180 countries, Simon Sez IT is the preferred online learning choice for individuals and businesses everywhere.

KEY FEATURES

This course teaches you how to create your first Macros and edit them using the Excel programming language, VBA (Visual Basic for Applications). It starts by giving an overview of Marcos. After that, you'll move on to some VBA basics and how to edit and debug Macros. Finally, you'll look at creating a Macro from scratch using VBA and how to create a custom Macro ribbon. This course includes follow-along instructor files so you can immediately practice what you learn. This is an advanced level Excel course, an intermediate knowledge of Excel is required to get the most from this course.

• Access 15 lectures & 2 hours of content 24/7
• See examples of Excel Macros
• Know what is VBA
• Record your first macro
• Record a macro using relative references
• Record a complex, multi-step macro, & assign it to a button
• Set up the VBA Editor
• Learn all about VBA Code
• Edit Macros in the VBA Editor
• Fix issues with macros using debugging tools
• Write your own macro from scratch
• Create a custom Macro ribbon & add all the Macros you've created

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
• Have questions on how digital purchases work? Learn more here

Requirements

• Microsoft Excel 2016, 2019, 365
• Basic understanding of how to use Microsoft Excel

THE EXPERT

Simon Sez IT
Since 2008, individuals, small businesses, and Fortune 500 companies with thousands of employees have benefited from the easy and hands-on software training offered by Simon Sez IT. With over 9,000 video tutorials on a range of software programs, Simon Sez IT ensures stress-free eLearning and enhanced employee productivity - no matter whether you are implementing new software or a technological upgrade for your workplace. With over 750,000 Udemy students in over 180 countries, Simon Sez IT is the preferred online learning choice for individuals and businesses everywhere.

KEY FEATURES

This 7-hour Microsoft Excel 2019 course is perfect for those brand new to Excel and who are using Excel 2019 or Excel 365 editions. In this course, your expert author gives you a solid grounding in the basics of Excel and guides you towards becoming more confident with spreadsheets.

• Access 95 lectures & 7.5 hours of content 24/7
• Know what's new in Excel 2019
• Enter text, numbers & working w/ dates
• Create & navigate workbooks
• Understand basic functions & formulas
• Know basic formatting 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
• Have questions on how digital purchases work? Learn more here

Requirements

• Microsoft Excel 2016, 2019, 365
• Basic understanding of how to use Microsoft Excel

THE EXPERT

Simon Sez IT
Since 2008, individuals, small businesses, and Fortune 500 companies with thousands of employees have benefited from the easy and hands-on software training offered by Simon Sez IT. With over 9,000 video tutorials on a range of software programs, Simon Sez IT ensures stress-free eLearning and enhanced employee productivity - no matter whether you are implementing new software or a technological upgrade for your workplace. With over 750,000 Udemy students in over 180 countries, Simon Sez IT is the preferred online learning choice for individuals and businesses everywhere.

KEY FEATURES

In this Advanced PivotTables in Excel course, you'll learn how to make the most of this powerful data analysis function. PivotTables are ideal if you are looking to perform data analysis tasks quickly and efficiently in Excel. You'll get a PivotTable refresher and move on to some of the advanced features of this tool including Advanced Sorting, Slicers, Timelines, Calculated Fields, Pivot Charts, and Conditional Formatting. This course is aimed at intermediate users of Excel who are comfortable using the PivotTable function.

• Access 49 lectures & 7.5 hours of content 24/7
• Do a PivotTable (a quick refresher)
• Combine data from multiple worksheets for a PivotTable
• Group, ungroup & deal with errors
• Format a PivotTable, including adjusting styles
• Use the Value Field Settings
• Learn Advanced Sorting & Filtering in PivotTables
• Use Slicers, Timelines on multiple tables
• Create a Calculated Field
• Learn all about GETPIVOTDATA
• Create a Pivot Chart & add sparklines and slicers
• Use 3D Maps from a PivotTable
• Update your data in a PivotTable & Pivot Chart
• Learn all about Conditional Formatting in a PivotTable
• Create a basic macro to refresh PivotTable 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: advanced
• Have questions on how digital purchases work? Learn more here

Requirements

• Microsoft Excel 2016, 2019, 365
• Basic understanding of how to use Microsoft Excel

THE EXPERT

StreamSkill.com
Stream Skill is part of the Simon Sez IT family and has been in business for 14+ years and taught over 1 million students at the time. They've created over 90 software training courses, and 5,000+ video tutorials, and have helped thousands of people across the world learn how to use Microsoft.

KEY FEATURES

Dive into the world of financial forecasting with our course! Learn essential skills to predict a business's financial future. This hands-on program guides you through creating robust financial models using Microsoft Excel. Designed for entrepreneurs and professionals, to gain insights into effective resource allocation and decision-making. Basic Excel knowledge is required; to grasp accounting principles for optimal learning. Craft accurate forecasts for any business scenario and enhance your strategic acumen.

• Come to understand the basics of financial modeling & forecasting using Excel
• Know the purpose of financial forecasting
• Build your first financial forecasting model in Excel
• Learn how to build a sound financial model
• Know the role of forecasting in strategic planning
• Go through the three financial statements (balance sheet, income statement, and cash flow statement)
• Learn how to define your forecasting objectives
• Identify key variables & drivers
• Analyze financial forecasts using ratio analysis
• Learn about future trends in forecasting

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

• MS Excel
• A good understanding of Excel & Excel formulas
• Basic knowledge of accounting principles is beneficial

THE EXPERT

Simon Sez IT
Since 2008, individuals, small businesses, and Fortune 500 companies with thousands of employees have benefited from the easy and hands-on software training offered by Simon Sez IT. With over 9,000 video tutorials on a range of software programs, Simon Sez IT ensures stress-free eLearning and enhanced employee productivity - no matter whether you are implementing new software or a technological upgrade for your workplace. With over 750,000 Udemy students in over 180 countries, Simon Sez IT is the preferred online learning choice for individuals and businesses everywhere.

KEY FEATURES

This professionally produced video course shows anyone with some VBA experience how to supercharge Excel. You will learn more advanced procedures for automating tough and time-consuming Excel jobs with advanced micros. This course gives you a lot more power to fully customize VBA to do some pretty miraculous things. This is the training you need to improve your abilities with VBA. Make yourself more valuable at work or use these concepts for your own business or personal needs.

• Access 37 lectures & 4.5 hours of content 24/7
• Understand more advanced VBA language
• Learn advanced tools for doing just about anything you need with VBA
• Know how to use References & Libraries
• Practice what you've learned with included exercises & quiz

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

• Microsoft Excel 2016, 2019, 365
• Basic understanding of how to use Microsoft Excel

THE EXPERT

Simon Sez IT
Since 2008, individuals, small businesses, and Fortune 500 companies with thousands of employees have benefited from the easy and hands-on software training offered by Simon Sez IT. With over 9,000 video tutorials on a range of software programs, Simon Sez IT ensures stress-free eLearning and enhanced employee productivity - no matter whether you are implementing new software or a technological upgrade for your workplace. With over 750,000 Udemy students in over 180 countries, Simon Sez IT is the preferred online learning choice for individuals and businesses everywhere.

KEY FEATURES

Unlock the power of data analysis with Excel PivotTables! This course equips beginners with vital skills to navigate large datasets. Learn data cleansing techniques, essential for accurate results. Master PivotTable creation, customization, and visualization through Pivot Charts. Suitable for beginners and those with basic knowledge, this course offers hands-on learning with downloadable Excel files.

• Creating a basic PivotTable
• Using the PivotTable fields pane
• Adding fields & pivoting the fields
• Formatting numbers in PivotTable
• Using multiple fields & dimensions
• How to choose & lock the report layout
• Applying PivotTable styles
• Create pivot charts based on PivotTable data
• How to select the right chart for your data
• Adding slicers & timelines to your dashboards

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

• Basic knowledge of Microsoft Excel is beneficial but not required
• MS Excel

THE EXPERT

Simon Sez IT
Since 2008, individuals, small businesses, and Fortune 500 companies with thousands of employees have benefited from the easy and hands-on software training offered by Simon Sez IT. With over 9,000 video tutorials on a range of software programs, Simon Sez IT ensures stress-free eLearning and enhanced employee productivity - no matter whether you are implementing new software or a technological upgrade for your workplace. With over 750,000 Udemy students in over 180 countries, Simon Sez IT is the preferred online learning choice for individuals and businesses everywhere.