Thread by @niketkedia

Over the next few days I’ll sharing the learning path for the tools used in #datascience industry.
First and MUST HAVE skill if you want to break into #datascience is @msexcel
A thread 🧵

1. Enter Data and create basic Tables in @msexcel
#msexcel

2. Start with Building, Formatting, Editing, Proofing, Managing and Printing Worksheets in @msexcel
#msexcel

3. @msexcel basic features — Data types, Sorting, Filters & Grouping in
#msexcel

4. @msexcel Basic Formulas — Add, Subtract, Multiply & Divide
#msexcel

5. @msexcel Logical Functions  — IF, AND, OR, Nested IF & NOT
#msexcel

6. @msexcel advance formulas like -
a. Logical Functions and Error Trapping
b. Date and Time Formulas
c. Financial Formulas
d. Math and Statistical Formulas
e. Lookup, Information, and Text Formulas
f. SUMIF, COUNTIFs
#msexcel

7. Create Pivot Tables in @msexcel
#msexcel

8. @msexcel — Create Basic and Advanced Charts in Excel
#msexcel

9. Data Analysis tool in @msexcel
#msexcel

10. @msexcel Automation using Macros and VBA
#msexcel

Follow me for more contents on #datascience, #dataanalytics, #digitaltools, #automation , #data
Check out analytics-tuts.com for @msexcel tutorials