Udemy course Microsoft Excel Data Analysis: Pivot Tables and Formulas by James Nissen
Microsoft Excel Data Analysis: Pivot Tables and Formulas is the best Udemy course on the market. With this offer they will be able to greatly improve their knowledge and become more competitive within the Business category. Therefore, if you are looking to improve your Business skills we recommend that you download Microsoft Excel Data Analysis: Pivot Tables and Formulas udemy course.
Here you can see Udemy courses linked to: Business.
Course data:
- Author: James Nissen
- Course rating: 4.7
- Category: Business
- Modality: Online
- Status: Available
- Idiom: English
Abouth James Nissen
James Nissen is a Data Analyst with experience in the B2B, E-Commerce, and Social Media industries. He specializes in cleaning & organizing messy data sets, advanced text/lookup functions , and data visualization.
What the udemy Microsoft Excel Data Analysis: Pivot Tables and Formulas course teaches?
What you’ll learn How to create Pivot Tables to quickly summarize data How to use VLOOKUP and INDEX/MATCH to pull out specific info from large data sets How to use basic math/statistical functions like SUM, AVERAGE, COUNTIFS, and more… How to build conditional statements using the IF() function How to organize data to be scalable and easily used other data analysts How to move around Excel quickly and efficiently How to sort and filter data based on specific criteria How to streamline your data analysis workflow in Excel
Learn Data Analysis, Formulas, and Pivot Tables. Data Analysis in Microsoft Excel for Beginners and Intermediate users
More information about the course Microsoft Excel Data Analysis: Pivot Tables and Formulas
This course will teach you to go from level up from beginner to intermediate in Excel in around 2 hours. You’ll learn a wide variety of important Excel features, including Pivot Tables, sorting and filtering, keyboard shortcuts, as well as intermediate functions like VLOOKUP, INDEX & MATCH, IF statements, and many more (2016 PC Version used in course). Sample data sets provided for you to follow along and learn as you watch!
