21/09/2023
Learn Excel for Data Analysis for Free!
To access the course, simply visit the following link: https://youtu.be/TKszEkWXq80
Coursera's popular Excel Fundamentals for Data Analysis course is now available for free on YouTube. This is a great opportunity to learn the essential skills you need to clean, prepare, and analyze data for business insights.
The course covers a wide range of topics, including:
Introduction to MS-Excel
Joining, splitting, and combining text data
Cleaning data and changing case
Converting data types
Understanding dates and basic date functions
Generating valid dates
Calculating days between two dates
Calculating dates from a given date
Cell referencing and naming
Creating, naming and removing tables
Formatting and selecting in tables
Sorting and filtering tables
Performing calculations with structured references
Automating processes with named ranges and tables
Performing logical operations with IF
Applying advanced logical operations
Categorizing data with VLOOKUP
Matching data with VLOOKUP and XLOOKUP
Advanced data matching with INDEX & MATCH
By the end of the course, you'll be able to:
Clean and prepare data for analysis
Automate your analysis with named ranges and tables
Use logical and lookup functions to transform, link, and categorize data
Build a strong foundation in Excel fundamentals
The course also includes practice files, so you can follow along with the instructor and apply what you're learning in real time.
If you're serious about learning Excel for data analysis, I highly recommend checking out this course. It's a great way to learn the essential skills you need to succeed in this field, and it's completely free.
To access the course, simply visit the following link: https://youtu.be/TKszEkWXq80
Happy Learning!
