Excel-for-beginners

I'll be documenting my progress in Excel here.

Day 1.

I started using Excel for Data analysis today by creating a Payroll. While doing this, I learnt how to

1. Navigate through Spreadsheets
2. Create formulas
3. How to use Absolute and Relative references
4. Saving Excel files in CSV

I learnt all this from FreeCodeCamp You should check it out too.

See you tomorrow!

---

Day 2 and 3.

I did a continuation from yesterday's video. I did a Grade Book and a Decision Table. While doing these, I learnt about

1. Making Decisions using excel
2. Creating charts
3. Using Conditional Formating
4. 'OR' statements
5. More on Absolute and Relative referencing.

I learnt all this from FreeCodeCamp You should check it out too.

See you tomorrow!

---

Day 4.

Today, I work on a downloaded sales Database. I wlearnt about the following things

1. Using 'IF' Statements.
2. Using Text to column
3. Using 'SUMIF' Function
4. How to sort data
5. How to Filter Data
6. I also learnt how to use Pivot Tables
7. Then did a little Data Visualization with pie charts.

I learnt all this from FreeCodeCamp You should check it out too.

See you tomorrow!

Day 5 and 6

Today, I worked on

1. Importing 'txt' files into excel
2. Formulas to Split cells (=LEFT, =MID, =RIGHT)
3. VLOOKUP Formular
4. IF formula
5. =CONCATENATE Formula
6. Pivot Tables
7. Charts

I learnt all this from FreeCodeCamp You should check it out too.

See you tomorrow!

Also, I did Solving problems with Excel.

Click Here to Try