#100 days of learning Data Analytics as a newbie

Oyin

Hey, friends!

I am putting this out to stay accountable and track my learning progress. If you are a data enthusiast like me, let's do this together. I am currently working with this resource - Link here

I will be giving an update of what I learnt every week with proofs.

Who's in for a data challenge? Let's build our data skills together!

thanni

This is awesome, Oyin! Rooting for you and others that join 💪🏾

Oyin

Thank you

Oyin

@Princess_26 Let's do this!

Oyin

@Pajo Let's crush this💪

Oyin

@Stephen here is it

Kcien

Wish to start a course like this soon…Rooting for you dear!

Oyin

Kcien Thank you🤗

Which course do you intend to start?

Oyin

This week, I started with a video on Excel for beginners. I learned and practiced the following: anatomy of a spreadsheet and their functions, how to enter cell values in Excel using autofill, how to use autocorrect features, how to insert new rows and columns, formulas in Excel, how to format numbers, text, font, cells, rows and columns, how to create and edit charts, and how to save and print in Excel.

I started with the book Excel 2019 Bible today.

Oyin

@Pajo @Princess_26 @Stephen

First week done

Oyin

Week 2

This week I started with some excel tutorial videos by Alex the analyst on YouTube, covering Pivot Tables, Formulas, XLOOKUP, Conditional Formatting, Charts and a project. I could not practice some of the things I learnt, somehow, I got confused and lost in some of his explanations.

I then moved to w3school to practice some exercises. I discovered they had some tutorials on excel. I completed all the exercises on excel formulas and I'm still working on the other tutorials, i have completed three of them already.

On reading, I started with the Excel 2019 Bible last week. I have not been consistent with reading. I only read 3 chapters this week.

Princess_26

I started with excel tutorial by Alex the analyst this week as well. I agree it can be confusing. I think you can rewatch it after practicing w3school exercise

Oyin

Princess_26

Thank you. I will definitely go back to it. Which resources are you using for learning?

Oyin

Week 3

I completed the excel tutorial on w3school where i learnt functions and formulas. I speed read over 20 chapters of the Excel 2019 Bible. It has 48 chapters. I intend to complete it this month. Also, I have completed all my excel tutorials, I will be working on some excel project next.

Oyin

Week 4

I did more of reading this week. I speed read another 20 chapter of Excel 2019 Bible. I am left with about 5 chapters. I also downloaded some datasets on kaggle to work with. I am currently working on one.

Oyin

Week 5

…………….

………….

😟😟😟

Solomon

Oyin What happened in Week 5🙂

Oyin

Solomon Just stuck 😆

But i will drop my first Excel project tomorrow!

Solomon

Oyin thought as much😄.
I am glad you've got something for tomorrow.
i'll come and see it.

Solomon

Oyin What is it about? I can't wait to see it!