Are you a data analyst looking to level up your Excel skills? In this video, I be covering the most common Excel operations that every data analyst should know.
We will work with messy data and learn to structure the data using text to columns. The next thing we will learn is to Remove duplicates to have a clean data set to work with. We will proceed to fix the data types and create new calculated columns using Formulas. You will learn to write a simple IF ELSE formula and also learn to handle strings in excel.
We will then proceed to creating pivot charts where we will views that provide Sales by Sub-Category, Product Managers, create a line chart and pie charts.
We will learn to create pivot charts and see how to edit them.
You will also learn the concepts of vlook ups that allow you to bring data from another spreadsheet and finally, you will create a sales dashboard with filters.
By the end of this video, you'll have a solid understanding of the most common Excel operations used in data analysis, and you'll be ready to take your Excel skills to the next level. So, whether you're new to Excel or just looking to brush up on your skills, this video is for you!
Don't forget to hit the like button and subscribe to our channel for more great content on data analysis and Excel tips and tricks. Let's get started!
You can download all the files here:
github.com/suj...
Entire SQL Playlist can be found here:
• Crash Course SQL Tutorial
If you liked this video, please check my ebook available on Gum Road.
Link: thenadcoder.gu...
The ebook contains
Commonly Used SQL Queries
Common Interview Questions
Resume and Linkedin Tips
Resume Template
Check out other my other videos on this channel
How to pass Tableau CRM / CRM Analytics Certification: tinyurl.com/ms...
How to pass Salesforce UX Designer Certification: tinyurl.com/2e...
How to Pass Business Analyst Certification: tinyurl.com/25...
Salesforce Business Analyst Certification: tinyurl.com/mr...
Day in the Life of a Salesforce Business Analyst: tinyurl.com/ym...
Tech Careers that do not require Coding Skills: tinyurl.com/4z...
Are you interested in learning CRM Analytics or Tableau CRM, then I have an entire playlist for you. You can learn CRM Analytics in 10 days.
Complete CRM Analytics Training Course: tinyurl.com/4d...
Connect with me:
Linkedin: / sujaynadkarni
Instagram: / thenadcoder
15 окт 2024