A thread 🧵on Resources-for-preparation-Of-Placements (Lecture video links)

Excel is one of the most important skills for your career ✅

Become an expert in Excel with these courses 📈

A thread 🧵👇🏻

1. Excel Skills for Business

2. Excel for Everyone Professional

3. Microsoft Excel - Excel from Beginner to

4. Excel Basics Free

Excel has 100s of functions. Most them are not useful in day to day business setting. Here are the 10 most useful functions based on my 15 years of regular usage.
🧵

1) SUMIFS
Use it to add up values that meet one or more conditions.
=SUMIFS(A1:A100, B1:B100, "NZ", C1:C100, ">20") adds up all values in A1:A100 where column B is NZ and column C is more than 20.

2) XLOOKUP*
Use it to lookup a value and get corresponding value.
=XLOOKUP("Widget10", A1:A100, B1:B100)
looks the code Widget10 in column A and returns the price in column B.
* Works in Excel 365 / Web only

3) FILTER*
Use it to filter a list or range based on the conditions. Returns a range of values and automatically spills the values into next cells!
=FILTER(A1:C100, B1:B100="NZ")
returns the entire range of A1:C100 where column B has NZ.

4) COUNTIFS
Use it to count items that meet one or more criteria.
=COUNTIFS(B1:B100, "NZ", C1:C100, ">20")
tells us how many items have column B as NZ and column C more than 20.

I have been writing software for over a decade.

My 5 best advices for developers

that will save you 1000+ hours (🧵):

⚡️ On writing code

Solve the problem *before* writing code.

Clear code >>>> Clever code

Always optimize code for readability

and THEN efficiency (if required)

Remember:

You are not bad at coding.
You just need more practice.

⚡️ On debugging code

Code doesn’t do what you expect

it does what you tell it to do.

Be ready to spend hours bridging the gap.

When debugging:
• Pay attention to error messages
• Use debuggers
• Ask for help when stuck

Prefer refactoring buggy code

over adding new code.

⚡️On testing code

Developers today are expected to:
• write software quickly
• without shipping bugs

Know that some tests are more important than the others.

Start with ad-hoc tests…

But use test automation as much as possible.

Test less. But smarter.

⚡️ On writing documentation

Good code is self-documenting
but you should document tradeoffs
and decisions of your code.

Some tips:
• Automate doc generation
• Document just enough
• Use tests as documentation

Just remember that..
no documentation >> incorrect documentation

Master Java for FREE.

🧵

Videos:

1. Programming with Mosh

🔗

2. Telusko

🔗

3. Edureka

🔗

Websites:

1.