Welcome to our Excel Full Course for Data Analysis with Projects! In this in-depth tutorial, we explore the powerful capabilities of Excel for data analysis, providing you with valuable skills to excel in the world of data-driven decision-making. With a runtime of 2 hours, this tutorial covers essential techniques and features, along with hands-on projects to reinforce your learning. Whether you're a beginner or looking to enhance your Excel skills, join us for this comprehensive Excel tutorial in 2024 and unlock the potential of data analysis.
Acquire our latest Data Analytics Mastery Course now: https://forms.gle/dVf8wAbUCkaWVV9JA
Take a look at the module for the course: https://drive.google.com/file/d/1TcZGAMy1RuSQu6-YT03iJNnukHTjA43R/view
Datasets: https://github.com/Ayushi0214/PowerBI-Datasets
Power BI Full Course - FREE - https://youtu.be/-iu90bMENig
WsCube Tech is a leading Web, Mobile App & Digital Marketing company, and institute in India.
We help businesses of all sizes to build their online presence, grow their business, and reach new heights.
For Digital Marketing services (Brand Building, SEO, SMO, PPC, SEM, Content Writing), Web Development and App Development solutions, visit our website: https://www.wscubetech.com/
Want to learn new skills and improve existing ones with in-depth and practical sessions? Enroll in our advanced online courses now and make yourself job-ready: https://courses.wscubetech.com/s/store
All the courses are job-oriented, up-to-date with the latest algorithms and modules, fully practical, and provide you hands-on projects.
Want to learn and acquire skills in English? Visit WsCube Tech English channel: https://bit.ly/2M3oYOs
Video Chapters
00:00:00 - Excel Introduction
00:01:28 - Introduction to MS Excel and Beginner's Guide
00:12:01 - Basic Functions of Excel
00:16:24 - Basics of Formatting in Excel
00:21:11 - Sorting Data in Excel - Different Methods to Sort
00:27:57 - Filtering Data in Excel
00:33:56 - Basics of Formula/Functions
00:39:22 - Text Functions in Excel
00:49:43 - sIf, AND and OR Functions in Excel
00:57:08 - Date & Time Functions in Excel
01:04:01 - COUNTIF, COUNTIFS, SUMIF, SUMIFS - Functions in Excel
01:10:38 - Data Validation in Excel
01:18:42 - Vlookup in Excel
01:28:43 - Hlookup in Excel
01:30:51 - Lookup in Excel
01:37:07 - Xlookup in Excel
01:44:25 - Index+Match in excel
01:49:14 - Using Conditional Formatting
01:56:32 - Macros in Excel
02:01:08 -Summarizing Data with Pivot Tables
02:07:33 - Working with Slicers
02:11:52 - Power Query in Excel
02:21:50 - Power Pivot in Excel
02:33:14 - Visualizing Data with Charts
02:39:31 - Excel Dashboard
For more info about the courses, call us: +91-7878985501, +91-9269698122
CONNECT WITH THE FOUNDER (Mr. Kushagra Bhatia) -
Instagram - https://www.instagram.com/kushagrabhatiaofficial
LinkedIn - https://www.linkedin.com/in/kushagra-bhatia
Facebook - https://www.facebook.com/kushagrawscubetech
Connect with WsCube Tech on social media for the latest offers, promos, job vacancies, and much more:
Facebook: https://www.facebook.com/wscubetech.india
Twitter: https://twitter.com/wscubetechindia
Instagram: https://www.instagram.com/wscubetechindia/
LinkedIn: https://www.linkedin.com/company/wscubetechindia/
Youtube: http://bit.ly/wscubechannel
Website: http://wscubetech.com
--------------------------------------| Thanks |---------------------------
#exceltutorial #dataanalysis #excel