Excel Data Basics crayon mark

3d laptop illustration
SUGGESTED SUBSCRIPTION: $20/MONTH

Looking to develop the skills and knowledge needed to make data-driven decisions in business? Our course provides a conceptual, introductory, and explanatory approach to data analysis, statistical concepts, data visualization techniques, and business intelligence tools. With our expert guidance, you'll gain a foundational understanding of these essential concepts, empowering you to collect, analyze, and interpret data with confidence. Sign up now and take the first step towards making informed business decisions with data!

3d laptop illustration

Find analyzing data challenging?

  • Developing technical skills takes up too much of your time?

  • Managing big data confusing and hard to remember?

  • Interpreting complex data time-consuming and frustrating?

  • Don't know where to start in order ensure data accuracy?

  • Find presenting data insights frustrating or intimidating?

  • Keeping up with emerging technology feel daunting?

Break down barriers & Simplify your journey. Imagine...

  • Unlocking insights: Discovering patterns and trends in data

  • Driving innovation: Leveraging data to solve complex problems

  • Making an impact: Contributing to meaningful business decisions and outcomes

Visualize Your Success: Achieve Your Goals with This Course

  • AI Driven Training Videos

    Essential bite-sized but in-depth topics giving you a strong foundation of knowledge.

  • Practice Exercises

    Apply what you learn through practical exercises, case studies, and projects.

  • Engaging Delivery

    Avatars are engaging, interactive, and keeps you motivated throughout the course.

  • Access to Walter

    A private Slack channel where I will be answering your questions and providing insights

Course Curriculum:

What are Formulas and Functions in Excel

Why use Formulas and Functions in Excel

Understanding the syntax and structure of Formulas and Functions in Excel

SUM formula to add numbers

AVERAGE formula to find the average of numbers

COUNT formula to count the number of cells with numbers

MAX formula to find the largest number

MIN formula to find the smallest number

IF formula to perform conditional calculations

AND formula to check if multiple conditions are true

OR formula to check if at least one condition is true

NOT formula to reverse a logical value

CONCATENATE formula to join two or more text strings

LEFT, RIGHT, and MID formula to extract characters from a text string

LENGTH formula to find the number of characters in a text string

UPPER, LOWER, and PROPER formulas to change the case of text

NOW formula to insert the current date and time

TODAY formula to insert the current date

DATEDIF formula to calculate the difference between two dates

WEEKDAY formula to find the day of the week for a given date

MONTH and YEAR formulas to extract the month and year from a date

VLOOKUP formula to find data in a table based on a lookup value

HLOOKUP formula to find data in a table based on a lookup value

INDEX and MATCH formulas to perform complex lookups

ROW and COLUMN formulas to find the row and column numbers of a cell

ADDRESS formula to find the address of a cell based on its row and column numbers

SUMIF and SUMIFS functions to sum cells based on specific criteria

COUNTIF and COUNTIFS functions to count cells based on specific criteria

AVERAGEIF and AVERAGEIFS functions to find the average of cells based on specific criteri

Walter Shields:
Founder - Data no Doubt swoosh illustration

Walter Shields:
Founder - Data no Doubt swoosh illustration

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 10,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!

walter sitting on chair

Find WSDA Learners In

Unilever logo
NBCUniversal logo
Visa logo
Kpmg logo
Citi logo
Adobe logo
Airbnb logo
Jll logo
DellLogo
Loreal Logo

Transform Your Data Skills with WSDA Learning - Join the 10,000+ Students Who Have Succeeded with Our Data Courses

As a non-technical professional, this platform allowed me to become an analytics expert within the domain I worked in for 10 years, finance. I'm now a Finance Data Analyst!

- Jaden Leach

The sessions are in depth teaching of analyzing data. The AI lectures provide content that goes above and beyond to explain the concepts to your understanding.

It is one of the best decisions I have made towards learning how to analyze data.

- Alejandro Steele

What makes WSDA amazing is the attention they have pay to learners and their ability to communicate technical concepts in language that is digestible to all skill levels.

- Michael Tuffour

The training is just brilliant! The content is very well detailed, lectures are easy to understand with great examples and you get hands on practice with the real world projects.

- Amira Gardner

I needed an effective way to obtain data analytics skills to start my new career; with support from WSDA Learning.

I feel I am well on my way to accomplishing my goal as I develop my skills.

- Annabel Rocha

Frequently Asked Questions

We provide valuable content in Data Science and Data Analytics to beginner, intimidate and advanced learners. We're pleased to present this content in an offer based model. This is where you pay what you believe our content to be worth to you.

WSDA training programs all self paced, where you will learn the technical skills you need to get job-ready. You can request 1 on 1 training for a personalized program of study.

Yes. There are learners who complete our programs while working full-time. The program is 100% online and self paced. However we encourage hard work and dedication if you intend to join the program regardless of current work status.

We do everything we can to help you find a job. Our career-focused support include but are not limited to networking, technical landscape, resume and LinkedIn reviews, cover letter writing, negotiating, navigating the job search, and interview preparation

No. No prior knowledge in a particular field of study is required. We’ve learned that learners who are motivated, with grit, determination, and aptitude, regardless of previous knowledge or experience are successful.

The WSDA Learning Guarantee

We want you to be completely satisfied with your learning experience, so we offer hassle-free cancellation at any time. Your feedback is important to us, and we'll assess and incorporate your suggestions to improve our courses. Our goal is to provide you with the best possible education and help you achieve your goals.

kat sitting on wooden floor kat sitting on wooden floor kat sitting

Let's Get
Started

Start now