Elevate Your Data Skills: Enroll in Our Excel Email Course for Just $9.99!
Master Excel at Your Own Pace - Enroll in Our Email Course Now!
Embark on an 7-week Excel journey. For only $9.99, this course provides a blend of expert knowledge and flexible learning. Join over 300,000 learners who have advanced their data skills. Ready to elevate your career with Excel proficiency?
Walter Shields
Best-Selling Author | MIT Data Scientist | LinkedIn Learning Instructor
INSTRUCTOR
Why Choose Our Email Course?
01
Comprehensive Curriculum: Our course covers everything from Excel basics to advanced techniques over 7 weeks, providing a thorough understanding of the subject.
02
Interactive Learning: Engage in weekly live sessions with our expert instructor, for a hands-on, interactive learning experience.
03
24/7 Support: Benefit from round-the-clock assistance to have your questions answered anytime, enhancing your learning process.
Key outcomes
- Master Excel's Data Management You'll learn the essentials of managing and organizing data , using Excel's diverse functions like UNIQUE, PivotTables, and Conditional Formatting
- Enhance Data Analysis Skills in Excel You'll gain proficiency in utilizing Excel's advanced features such as Dynamic Arrays, Flash Fill, and Power Query, enabling you to efficiently analyze and reorganize extensive datasets.
- Identify and Highlight Key Data Insights You'll learn how to apply Excel's capabilities to identify critical insights, such as spotting unique artists, analyzing album releases, and ensuring data integrity by removing duplicates in the music industry's database.
- Visualize Data for Impactful Decision-MakingYou'll master the art of data visualization using Excel, learning how to create dynamic charts, PivotTables, and dashboards that transform complex data into compelling, actionable visual narratives.
$9.99
Begin Your Journey Today!
CAN'T JOIN THIS TIME?
Be the first to know about the next cohort
See what people are saying
Great course! Concepts are nicely connected with ample relevant real life examples.
Highly recommend this course.
Emanuel Griffith
Business Analyst Reviewer Rating 5 out of 5
Very good practical method to Excel. Solid methodical approach with code demonstration step by step. Plenty of clearly explained examples.
The course contains clear task definition and helpful hints.
Serhii Pylypenko
Java Developer Reviewer Rating 5 out of 5
The pace of the course is superb for a beginner like me. Walter is clear and precise with his explanation. The best part I liked about this course is the practical examples and knowledge between each section. I will defiantly recommend this to me colleagues.
Kevin Richardson
Sr. Service Delivery Analyst
Excellent training for Excel Takes you from the basics to real world Excel. I highly recommend this course!
Malinda Samuels
Developer
Find WSDA Learners In
Best companies
Meet your instructor
Walter Shields
He is a passionate advocate for knowledge sharing and inclusion in the world of data, and the founder of the Walter Shields Data Academy – an educational platform that empowers learners with best practices in data analytics and data science.
As the bestselling author of the number one book on data analytics, ‘SQL Quickstart Guide’, Walter’s insights are sought after by learners around the globe. He is also a LinkedIn Learning course creator of top-rated data analytics courses and a professional in data science and machine learning from the prestigious Massachusetts Institute of Technology (MIT).
Over 300,000+ learners have already benefited from Walter’s guidance and expertise, as he helps them transform their data skills and achieve their goals. Join the Walter Shields Data Academy today and discover the power of data analytics and data science for yourself!
Enroll Now
Excel Essentials Email Course
Course syllabus
01
UNLEASHING DATA POTENTIAL WITH EXCEL
This module introduces you to Excel in the context of music industry data analysis, focusing on basic Excel functions and the structure of the WSDA Music data workbook:
- Introduction to Excel and its relevance in data analysis
- Overview of the WSDA Music Data Workbook
- Basic Excel functions and formulas
- Navigating through Excel sheets and data sets
02
DYNAMIC DATA ANALYSIS: UNIQUE INSIGHTS
Delve into specific Excel functions for data analysis, focusing on identifying unique artists and analyzing album data:
- Utilizing the UNIQUE function to identify distinct artists
- Creating PivotTables for album analysis
- Introduction to basic Excel data sorting and filtering techniques
- Hands-on exercises with WSDA Music data
03
DATA INTEGRITY AND CUSTOMER INSIGHTS
This module focuses on maintaining data integrity and extracting customer insights using Excel:
- Identifying and removing duplicate tracks and customer emails
- Using Conditional Formatting for data accuracy
- Insights into customer email data management
- Practical exercises with WSDA’s customer data
04
ADVANCED DATA MANAGEMENT: FLASH FILL AND DYNAMIC ARRAYS
Explore advanced Excel features for efficient data management:
- Mastering Flash Fill for data separation
- Implementing Dynamic Arrays for organized data
- Custom solutions for Mac users in data management
- Real-world scenarios using WSDA Music data
05
POWER QUERY AND DATA TRANSFORMATION
In-depth exploration of Excel’s Power Query and its application in data analysis:
- Utilizing Power Query for Windows and Mac users
- Advanced data transformation techniques
- Merging and appending data sets for comprehensive analysis
- Case studies with WSDA Music’s sales and inventory data
06
INTERACTIVE DASHBOARD CREATION AND DATA VISUALIZATION
This final module teaches you to create interactive dashboards and visualizations:
- Designing dynamic dashboards for data storytelling
- Advanced charting techniques for impactful visual narratives
- Using Sparklines and Conditional Formatting for micro-visuals
- Compiling a comprehensive analysis of the WSDA Music Database
07
FINAL EXCEL PROJECT
Capstone project to apply all learned skills in a real-world scenario:
- Data cleanup and preparation using Excel tools
- Comprehensive analysis of sales, artist popularity, and customer demographics
- Creating an interactive dashboard summarizing key findings
- Final report compiling insights and visual data storytelling
Enroll Now
Excel Essentials Email Course
Course schedule
1 email lesson each week for 7 weeks
Structured Weekly Content
Weekly Chapter Releases: Building Skills Step-by-Step
The course is organized into an 7-week timeline, delivering structured learning materials straight to your inbox. Each week, you’ll receive a new chapter or module, allowing you to progressively build your Excel knowledge from the basics to more advanced concepts.
Flexible Learning Pace
Learn at Your Leisure: Flexibility Meets Functionality
Despite the structured weekly releases and live sessions, the course is designed to accommodate your personal schedule. All live sessions are recorded, enabling you to catch up whenever it’s convenient. This flexibility ensures that you can balance learning Excel with your other commitments, making the course suitable for busy professionals, students, and anyone with a demanding schedule.
Our Plans
Basic Plan
Kickstart Your Excel Journey - Essentials Email Course for Only $9.99
This email course, designed by the bestselling author and the 4.9-star-rated LinkedIn Learning course instructor with over 170,000 learners, provides essential learning at an affordable price. Perfect for beginners seeking a comprehensive and cost-effective way to learn Excel.
Premium Silver
Advanced Excel Learning - 24/7 AI Support & Data Analytics Insights
Elevate your Excel proficiency with our Premium Silver package, priced at just $19.99/month. This plan boosts your learning journey with 24/7 AI support, featuring a GPT-4 system specifically trained on course content and the broader Excel domain for unparalleled assistance. Ideal for those desiring in-depth knowledge and continuous, enhanced guidance in Excel. Interactive Excel Network Access: Additionally, gain exclusive entry to a private forum for collaborative Excel learning. Connect with peers and experts, enhancing skills through community-driven insights. Perfect for networking and real-world Excel problem-solving.
Enroll Now
Excel Essentials Email Course
Frequently Asked Questions
In our 7-week course, you’ll learn everything from basic Excel to advanced data analysis techniques. The curriculum is designed to gradually build your skills, making you proficient in Excel by the end of the course.
The course is flexible to fit your schedule. We recommend dedicating 3-5 hours per week to fully grasp the concepts and participate in the live sessions, but you can pace your learning as per your convenience.
This course does not come with a certificate, but we recommend an excellent complementary course on LinkedIn Learning which does issue a certificate. Requires separate LinkedIn Learning subscription or LinkedIn Learning video course purchase.
Absolutely! Our course is tailored for beginners. With step-by-step guidance you’ll find the course easy to follow and understand, regardless of your prior knowledge.
Yes, we have weekly live sessions with an expert instructor, with a Premium Gold membership. These sessions are also recorded, so if you miss them, you can catch up at any time that suits you.
We provide 24/7 AI support for any queries or challenges you might face, with Premium Silver membership. Additionally, our dedicated support team is always ready to assist you. You’re never alone in your learning journey!