Complete Excel Data Analysis Bootcamp For Beginners

Overview

Basic Data Processing, Data Visualisation and Analysis With Excel- Most Common Excel Procedures For Beginners What you'll learn:

Get started with using Excel for basic data processing and analysisCarry out analytical tasks in ExcelData visualisation in ExcelBasic statistical analysis in Excel If You Are…..A business intelligence (BI) practitionerData analystInterested in gaining insights from data (especially financial, geographic, demographic and socio-economic data)Excel Is Your Friend for Common Business Data Analysis TasksI’m Minerva Singh, and I’m an expert data scientist. I’ve graduated from 2 of the world's best universities:

an MPhil from Oxford University (Geography and Environment) and a PhD holder in Computational Ecology from Cambridge University.

I have several years of experience in data analytics and data visualization. My course aims to help you start with no prior/limited exposure to data analysis and become proficient in producing powerful visualizations and analyses with Microsoft Excel.

You don't need prior exposure to data analytics and visualization to start with MS Excel. So if you have struggled with Excel, worry no more.

After finishing my course, you will be able to:

Read in and clean messy data in MS Excel.Carry out common business data analytic tasks, including filteringCarry out pre-processing and data summarization to glean insights from the dataDevelop powerful visualisations with MS Excel Carry out basic statistical analysis using MS ExcelIf you take this course and it ever feels like a disappointment, feel free to ask for a refund within 30 days of your purchase, and you will get it at once. Become an expert in Data Analytics and Visualization with a new and powerful tool by taking up this course today!

Syllabus

• Introduction to Excel Data Analysis
Overview of Excel capabilities
Understanding the Excel interface
Setting up your analysis workspace
• Excel Basics
Entering and formatting data
Basic calculations and formulas
Cell referencing and ranges
• Data Cleaning and Preparation
Sorting and filtering data
Removing duplicates
Data validation techniques
• Basic Data Analysis Techniques
Using basic functions (SUM, AVERAGE, COUNT)
Conditional functions and logic (IF, AND, OR)
Text functions (LEFT, RIGHT, MID, CONCATENATE)
• Data Visualization
Creating and formatting charts
Sparklines and data bars
PivotTables basics
• Advanced Data Analysis with Excel Tools
Advanced PivotTables and PivotCharts
Using Excel Tables for data management
Introduction to Power Query
• Solving Problems with Excel
Goal Seek for solving equations
Using the Solver add-in
Scenario Manager for what-if analysis
• Introduction to Macros and Automation
Recording and running macros
Basic VBA for automation
• Final Project
Real-world data analysis project
Applying learned skills to solve data problems
Presenting your findings and insights
• Course Wrap-up
Recap of key concepts
Resources for further learning
Q&A session and course feedback

Taught by

Minerva Singh

Subjects

Business