Home

Data Analysis with Excel - 6 Dec

- December 2, 2021

The WithYouWithMe Data Analysis with Excel Bootcamp expands into some intermediate level skills using Microsoft excel. 

Take the initiative, register your interest below and boost your analytics skills over this 4 day, one hour a day course!

Register your interest below and get the zoom link right away! Be sure to save it in your calendar for the day


What you will learn

This bootcamp will take you through the intermediate stages of the WYWM Data course while providing additional insights and practical walkthroughs. 

What are Bootcamps? 

A WithYouWithMe Bootcamp is designed to accelerate your learning and progress through our signature courses by using live, instructor-led sessions over the course of just ONE week.  

When is it? 

6-9 Dec, 9:00am - 10:30am daily (Sydney, Australia time/UTC+11)
Convert this into your time - click here

How do I join? 

It is all online so you can join us on Zoom at the above time to join the class.

Register above to receive the zoom link.

Requirements and expectations

We take great pride in our Bootcamps, most of all in ensuring you can get the most out of them.

To accomplish this, we require you to adhere to our student expectations:

  • Turn up on time ⌚️
  • Turn your camera ON 📷
  • Attend all sessions👨‍🎓
  • Participate actively in discussions 🙋 
  • Be able to screen share 🖥
  • Do assigned tasks 📖
Who should undertake this course? 

Students who want to better analyse their world, operations and automate tasks through the utility of data should undertake this course.

Course Outline 

SessionContent Covered
1: Introduction and data transformation
Cleaning data​
Dealing with missing or incomplete values​
Text manipulation​
Joining data in Excel
.
2: Exploratory analysis
How to:
- Discover patters
- Spot anomolies
- Test hypothesis
- Check assumptions
.
3: Quartiles
Boxplot​
Classifications​
Percentiles​
IQR
.
4: Standard deviation
Histograms
Measures of Skew​
Using STD Deviation​
Detecting Outliers
.

Contact Information

For any further enquiries please contact how head instructor Lachlan Vaughan-Taylor

Email: lachlan.vaughantaylor@withyouwithme.com

In the mean time, join our data community on Discord!

If you want to break into the tech industry then sign up to our platform and begin your training today.

Leave a Reply

Your email address will not be published. Required fields are marked *

Join our community

We have a Discord server where you’ll be able to chat with your instructors and cohort. Stay active in your learning!
Join discord