Walter Shields Data Academy

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 160,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

$9.99

Begin Your Journey Today!

Edit Template

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

    Walter Shields is a renowned data expert with over 25 years of experience managing data systems for start-ups, Fortune 500 companies, and organizations in industries ranging from law and healthcare to retail and beyond.

    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 160,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

    COST

    $9.99 USD

    COURSE

    Excel Essentials Training

    DURATION

    7 Weeks

    FORMAT

    Weekly Email

    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

    COST

    $9.99 USD

    COURSE

    Excel Essentials Training

    DURATION

    7 Weeks

    FORMAT

    Weekly Email

    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.

    Interactive Live Sessions

    Live Interactive Learning: Engage with Experts and Peers

    Alongside the weekly emailed content, the course includes live interactive sessions. These sessions, led by our expert instructor, provide hands-on learning experiences. They are scheduled once a week, offering real-time engagement and the opportunity to discuss concepts, ask questions, and interact with fellow learners.

    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.

    Premium Gold

    Excel Mastery - Engage with a Top-Rated Author in Interactive Live Sessions

    At $49.99/month, the Premium Gold plan immerses you in Excel excellence, featuring live, interactive weekly recaps by a distinguished instructor. These sessions ensure you grasp every concept fully, with opportunities to revisit topics and get your questions answered.

     

    Enroll Now

    Excel Essentials Email Course

    COST

    $9.99 USD

    COURSE

    Excel Essentials Training

    DURATION

    7 Weeks

    FORMAT

    Weekly Email

    Live Interactive Learning: Engage with Experts and Peers

    Engage Actively, not passive watch

    This course expands upon weekly lessons and practical projects.

    Interactive and hands-on approach

    Collaborate with fellow learners 

    Study alongside a peer group

    Connect with a community of individuals who share your passion for learning.

    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!

    Enroll Now

    Excel Essentials Email Course

    COST

    $9.99 USD

    COURSE

    Excel Essentials Training

    DURATION

    7 Weeks

    FORMAT

    Weekly Email