Microsoft Excel / Google Sheets Course

Learn Data Analytics & Data Visualization with Microsoft Excel/Google Sheets
Beginner-friendly comprehensive course that covers both, conceptual and hands-on learning
Hybrid Master Class with prerecorded online lectures
3 Free 1-on-1 30-minute sessions with the Instructor
Unlimited 24/7 Live Student support via phone, email, text and WhatsApp

Overview

This course covers data gathering, data analysis (exploratory data analysis), and data visualization using MS Excel, the most widely used tool across all industries. Designed by industry experts, this course will provide you with the most relevant conceptual and hands-on learning experience.

Free Info Session

We offer free info sessions where you can connect with the instructor to learn more about the course and ask any questions you may have. If you are unsure about anything, this would be a great option for you to get clarification and guidance.

What You Will Learn

Data Foundations
Data Gathering & Cleaning
Data Analysis (Descriptive & Diagnostic Analytics)
Data Visualization
Data Presentation
Pivot Tables, V-Lookups, If Statements etc.
Industry Best Practices
Quick Demo of other Data Tools (PowerBI)

1

Introduction to Data Analytics

In the first module, we start with laying a strong foundation going over all the important concepts that you need to learn to have a clear understanding of this field of Data Analytics and Data Science and other foundational concepts required to work with data. We cover everything from what this field is about to what your future could look like in this space.

You will learn all the basics that will gear you up for the next sets of modules and hands-on learning. This knowledge will also help you connect the dots on how all the different tools, concepts and techniques come together, what is the relationship between them and how to decide to choose one tool or technique over the other.

KEY SKILLS:

Types of Data Analytics
Commonly Used Terms
Descriptive Analytics
Diagnostic Analytics
Data Analytics Techniques
Exploratory Data Analysis (EDA)
Understanding Quality of Data

Difference between Data Analytics & Data Science

Understanding Modern Data Ecosystem

Your future in the field of Data Analytics & Data Science

2

Data Analysis & Data Insights

In this module, you will learn how to make sense of data and work with it using the complete data analysis process from start to finish. The starting point will be raw data and the end product will be a dashboard that tells an accurate, effective and compelling data story. You will grain a strong understanding of how to identify business problems and then how to solve them.

Data validation is also a strong component that is covered in this module to ensure you put forward accurate insights without any errors or misrepresentation.

KEY SKILLS:

Data Sourcing & Gathering
Data Cleaning
Exploratory Data Analysis (EDA)
Problem-Solving
Creating Dashboards using MS Excel
Advanced Excel (v-lookups, if statements etc.)
Pivot Tables
Data Validation
Data Normalization

Exploring Datasets using MS Excel

Problem-Solving & Data Analysis

Finding Accurate Data Insights

Organize and Optimize Data Sets

Industry Best Practices

3

Visualizing & Communicating Data Insights

They say a picture is worth a thousand words, we say a data visualization is worth a million data points! A meaningful and impactful data visualization can tell the data story in under 5 seconds and that is what this module will teach you. How to go from raw data to insightful data visualizations for effective communication.

KEY SKILLS:

Understanding your Audience

Building Accurate & Effective Data Visualizations

Clearly Communicating Data Insights

Tuition Cost

Visit Enrol Now page for tuition information.

Earn a LDA Data Analytics Certificate

Share your achievement with a Digital Certificate!

You can post yours on your LinkedIn profile and also include it in your resume or email signature. There are many options available to tell the world about your accomplishments!

STUDENT SUPPORT

We will be there every step of the way to help you!

You will have the ability to connect with the Instructor by booking an appointment. LDA Tableau Course comes with 3 free 1-on-1 appointments with the Instructor.

In addition to this, students also get free 24/7 Live Support via phone, email, text or WhatsApp.

LIVE, CERTIFIED & EXPERIENCED INSTRUCTOR

Learn from industry leading Instructors!

This course is designed by highly qualified professionals in an easy to understand manner. The instructors start by teaching the basics and gradually take the students to intermediate/advanced level learning depending on student's learning aptitude.

LDA Student Feedback Survey

Anonymous, 2021

“Great workshop to get an overall picture in regards to Data analytics, like the pace and content is clear.”

Anonymous, 2021

“I like the simplicity with how it is explained and appreciate the follow up slides that are provided.”

Neha, 2021

“I am finding it very friendly to access zoom and google classroom, I am also satisfied w the course so far. online class sessions are very helpful. I enjoyed the live and recorded classroom sessions and interactive class work.”

Anonymous, 2021

“I think that the class was very helpful to me. I learned a lot during the course and I feel more confident using Excel, SQL and Tableau. The instructor was polite and informative and answered our questions well. The class is a bit fast paced but each lecture is recorded so, that you can watch it at a later time if you miss something. There is a lot of hands-on learning where you follow along and learn how to use the programs yourself. Overall I enjoyed the class and it was very informative.”

Anonymous, 2021

“Overall i found the course quite valuable in learning material about data analytics. It has given be great tools to apply in my daily work.”

Anonymous, 2021

“It was awesome. I learnt using new tools and more deeper usage of Excel and I was very happy to put my first dashboard together using Tableau and Excel. Now I feel confident using these tools.”

Momoh, 2021

“The delivery is excellent and the instructor is exceptional, she breaks down every piece of information on the slides. The content is loaded and this is what I have always hope for, getting a body that can really bring out data analytic skills and put it in me. This is actually my first time of using the google classroom and I think, I am loving it. I have already started preaching the news of LDA to friends. I am loving the choice I made choosing LDA for this training.”

Anonymous, 2022

“Gave me all the tools I needed to create Dashboards. The curriculum was strong, Hira was really knowledgeable. I appreciated that the teacher was so accessible. I had one-on-one time with her to help me with my questions and my final project. The class was also accommodating to my busy schedule and the teacher structured the course to be as flexible as possible.”

Anonymous 2022

“The instructor seems very passionate and clearly cares a lot about making sure her students learn the material. I like Google Classroom, that’s a useful tool and does a good job of organizing assignments and class content.”

Nitika, 2022

”My experience with LDA was awesome. The Data Analytics Certificate course exceeded my expectations. My tutor Hira Fatima was very knowledgeable & dedicated. Each & every session is like a gold mine of knowledge. Just want to say thank you to the entire team of LDA who made this learning process seamless for me. When I was searching for an institute to get enrolled myself in a Data Analytics course, the front desk team was able to guide me and answer all my inquiries in a very timely manner. I was looking to change my career and get into the field of Data Analytics. Before finishing my course I landed a role as a ” Associate Market Data Analyst” in a company. Honestly this was a big achievement for me and Hira helped a lot in providing me with every help and assistance which was required to crack the interviews and technical tests.

For my career growth I’ll be getting enrolled in other courses in future at LDA. Just want to say to all the aspiring students who are looking to make a big difference to their career path then LDA is the right place for you and you’re in safe hands.Thank you once again to the entire team of LDA and Kudos to all your hard work

“

BY THE END OF THIS COURSE

You will have a solid understanding of the main concepts, principles and techniques used for data analysis and data visualization with MS Excel. You will be able to confidently gather, analyze and visualize data, draw insights and tell compelling data stories. You will become a part of the Data Analytics community and be ready to have informed data conversations!

A SHOWCASE OF YOUR PROJECT

At the end of the course, you will have an MS Excel Report to share with the world!

You can include it on your resume, put it on LinkedIn and share it with prospective employers to showcase your insightful data story!

TABLEAU COURSE

Already know MS Excel & SQL and just want to focus on learning data analysis & data visualization with Tableau? This course will teach you all that plus how to make dashboards and tell data stories with Tableau.

SQL & DATABASES COURSE

This intro course will help you make sense of data and databases and learn how to write SQL queries.

Other Ways To Connect

By submitting your phone number, you agree to receive text messages from 1800-400-5321. If you do not wish to receive text messages, reply STOP.