INTRO TO DATA ANALYTICS WITH EXCEL (NORTHERN TERRITORY) - $50 + GST per student


It is forecasted that the growth in artificial intelligence, data science, and big data analytics will create 2.7 million new jobs globally this year. Learn to solve complex business problems using data, create engaging stories with data visualisation, and automate processes using Macros.


About


Take your first step towards a Data Analyst role with Coder Academy's online Intro to Data Analytics with Excel course supported by the Northern Territory Government. This online course is designed for absolute beginners and a perfect entry point into data analysis for anyone who’s thinking of upskilling into this field. You must be a resident of the Northern Territory to join the course.

 
 
Banner


Course Outline
 

It is forecasted that the growth in artificial intelligence, data science, and big data analytics will create 2.7 million new jobs globally this year. Learn to solve complex business problems using data, create engaging stories with data visualisation, and automate processes using Macros.



What You Will Learn
 
  • Basic Excel & Intro to Statistics
  • Tables, Pivot Tables & Exploratory Data Analysis
  • Data Visualisation & Analysis
  • Macros
  • Advanced Data Visualisation (Dashboard Design)


Certification Obtained
  • Statement of attainment for BSBITU402 - Develop and Use Complex Spreadsheets.


What You'll Need
 

Computer with Excel 2016 installed
 

FAQ's

Is it possible to download the virtual classes and do them at another time?

Yes, the virtual classes will be recorded and you can watch them on your own time.

 

Is it necessary to join the class for the whole 2 hours every week, or how flexible is that?

You can join for as long as you are able to and watch the recorded version later on.

 

What is the expectation to check in at the weekly Q&A sessions?  Is it only required if I have questions?

It is not required to show up to any of the Q&A session. You can sign up for them anytime you'd like.

 

What is the expected workload outside of the virtual class attendance? E.g. hours per week.

Approximately 4 to 7 hours per week.


Timetable

Week Start - Date End - Date Type of learning Content Day and Time of Class
Week1 27-Jul-2020 2-Aug-2020 Self-pace / Webinar Intro to Excel Wed, July 29 from 5.30-7.30pm Darwin time
Week2 3-Aug-2020 9-Aug-2020 Self-pace / Webinar Intermediate Excel Wed, Aug 5 from 5.30-7.30pm Darwin time
Week3 10-Aug-2020 16-Aug-2020 Self-pace Intro to Statistics Self-paced
Week4 17-Aug-2020 23-Aug-2020 Self-pace / Webinar Tables & Pivot Tables Part 1 Wed, Aug 19 from 5.30-7.30pm Darwin time
Week5 24-Aug-2020 30-Aug-2020 Self-pace Tables & Pivot Tables Part 2 Self-paced
Week6 31-Aug-2020 6-Sep-2020 Self-pace Data Visualisation Part 1 Self-paced
Week7 7-Sep-2020 13-Sep-2020 Self-pace Introduction to Exploratory Data Analysis (EDA) Self-paced
Week8 - Live 14-Sep-2020 20-Sep-2020 Live Day 1 In-Depth Exploratory Data Analysis Sat, Sep 19 from 9am-3pm Darwin time
Week9 - Live 21-Sep-2020 27-Sep-2020 Live Day 2
Live Day 3
Dashboard Design
Macros Part 1
Wed, Sep 23 from 6-9pm Darwin time
Sat, Sep 26 from 9am-3pm Darwin time
Week10 28-Sep-2020 4-Oct-2020 Self-pace Recap of Live Sessions / Project Discussions Self-paced
Week11 5-Oct-2020 11-Oct-2020 Self-pace / Webinar Macros Part 2 Wed, Oct 7 from 5.30-7.30pm Darwin time
Week12 12-Oct-2020 18-Oct-2020 Self-pace Project work Self-paced
Week13 19-Oct-2020 25-Oct-2020 Self-pace / Webinar Macros Part 3 Wed, Oct 21 from 5.30-7.30pm Darwin time
Week14 26-Oct-2020 1-Nov-2020 Self-pace Project work Self-paced
Week15 2-Nov-2020 8-Nov-2020 Self-pace / Webinar Project work Self-paced
Week16 9-Nov-2020 15-Nov-2020 Self-pace Project Ends Self-paced

Benefits of Online Learning

This series of Marketing Technology courses will be delivered online through Canvas - a leading online learning platform that replicates the classroom environment. Canvas allows you to interact with your instructor and peers, just as you would if you were learning in a face-to-face class. It also provides access to learning resources, video, audio, real-time sharing of presentations – and includes collaborative features such as a live whiteboard, breakout rooms and discussion boards. 


Our Philosophy

We pride ourselves on our ability to cater to students who are racing ahead while supporting those who need more time to practise their skills. We aim to help students better understand the technological tools they have at their disposal, and how they can create rather than simply consume. Students are encouraged to adopt an experimental mindset, and think ‘What if?’ without giving in to a fear of breaking something. We believe that people with unique interests learn to code for different reasons, and there are many ways for students to engage with tech in a way they find exciting and encouraging.


Run by Coder Academy, proudly supported by the Northern Territory Government

These courses are being operated by Coder Academy (trading as the Academy of Information Technology Pty Ltd). The Northern Territory Government has kindly offered to fund a significant portion of these programs for any Northern Territory residents, resulting in a low $55 fee per participant. 

 



Attendees

Start Date

End Date

Monday, 16 Nov 2020

5:30 PM - 7:30 PM

Location

Access details will be sent to you shortly.

Check your inbox for more information.

View Map

Price

+ GST

Can't find what you're looking for?

ASK US