Microsoft Excel Data Analysis: Pivot Tables and Formulas Course
Microsoft Excel Data Analysis: Pivot Tables and Formulas Course
Learn Data Analysis, Formulas, and Pivot Tables. Data Analysis in Microsoft Excel for Beginners and Intermediate users
What you’ll learn
Microsoft Excel Data Analysis: Pivot Tables and Formulas Course
- 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
- Learn 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
- Learn 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
Requirements
- Microsoft Excel for PC (2013 or later recommended. Some features may not be available in earlier versions)
- Some prior knowledge of Excel will be helpful.
Description
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!
Who this course is for:
- Job seekers who want to add “Microsoft Excel” as a skill on their resume or Linkedin Profile
- Aspiring Data Analysts, Managers, or employees that anticipate using MORE data in the future
- Anyone already in a job/career that involves data who wants to level up their skills in Excel
- Who wants to learn how to cut hours off of their weekly reporting tasks
- Anyone who wants to learn how to learn excel for budgeting, side projects, or as an additional skill
- Last updated 3/2020
![Learn To Create JARVIS AI [Mark-I] Android App Using JAVA](https://courseforfree.net/wp-content/plugins/accelerated-mobile-pages/images/SD-default-image.png)
![Learn To Create JARVIS AI [Mark-I] Android App Using JAVA](https://courseforfree.net/wp-content/uploads/2022/12/Learn-To-Create-JARVIS-AI-Mark-I-Android-App-Using-JAVA-220x134.jpg)
Recent Posts
- Blog
Earn Money from Areena Course
In today's digital age, opportunities for earning money have expanded significantly. One avenue that has… Read More
- Blog
Best Earning Apps
Earning apps have become increasingly popular as people look for ways to make money conveniently… Read More
- Blog
How to Earn Money From Markaz App
In today's fast-paced digital world, opportunities to earn money online have become increasingly popular. One… Read More
- All Tutorials
Full Web Ethical Hacking Course
Full Web Ethical Hacking Course Learn all about web application penetration testing! What you'll learn… Read More
- All Tutorials
Build Chatbots Using Javascript
Build Chatbots Using Javascript Build Chatbots Using Javascript From Scratch What you'll learn Build Chatbots… Read More
- All Tutorials
Basic Learning about Linux Daily use commands
Basic Learning about Linux Daily use commands Basic knowledge to get you started What you'll… Read More