Master C++ for Free.

Thread 🧵

1. Programming with mosh

🔗

2. freeCodeCamp

🔗

3. Fireship

🔗

4.

Master Python for Free.

Thread: 🧵

1. Programming with Mosh

🔗

2. Complete Playlist by Telusko.

🔗

3. FreeCodeCamp

🔗

4. Edureka

🔗

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 learned python by spending $0 on Online

Here are 5 Free Courses that will teach you python better than the paid ones

A thread 🧵 👇

1 - CS50: Introduction to Computer Science

This is one of the best python courses available online and if you're looking for web development,this might be the

2 - Crash Course on Python

This course is part of the Google IT Automation with Python Professional Certificate and every beginner can try

3 - Kaggle Python Course

If you are a newbie looking to learn Data Science, None other is better than the course from Kaggle itself also, Data viz procedures can be followed

4 - Introduction to Python Programming

In this course by the University of Pennsylvania, Students are introduced to core programming concepts like data structures, conditionals, loops, variables, and

Master Java for FREE.

🧵

Videos:

1. Programming with Mosh

🔗

2. Telusko

🔗

3. Edureka

🔗

Websites:

1.

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

Learn HTML & CSS - By Playing Games.

15+ Games: 🧵

Note: Don't just save it, Try to explore the tools.

1. CSS

2. Flexbox

3.

Power BI is an important tool for a Data Analyst 📊

Become a Power BI expert with these resources 📈

A thread 🧵👇🏻

1.

2.

3.

4.

React Roadmap for Beginners in 2022.

Thread: 🧵

➪ Before Jumping into React make sure that you're good at Javascript Fundamentals.

⇝ Fundamentals ⇜

➙ Create React app
➙ Function Components
➙ Class Components
➙ JSX
➙ Props
➙ State
➙ useState and useEffect Hooks
➙ Conditional Rendering
➙ Lists and Keys
➙ Building Simple Forms
➙ Composition and Inheritance

⇝ Advanced Topics ⇜

➪ HTTP Requests
➙ Context Refs
➙ Refs
➙ Error Boundaries
➙ Portals

➙ GET
➙ POST

➪ Hooks
➙ useContext
➙ useReducer
➙ useRef
➙ useMemo
➙ useCallback
➙ Custom Hooks

➙ Higher-Order Components
➙ Render Props
➙ Reconciliation

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

Smart people get ahead of the future.

The other 99% miss out.

Here are 10 fields with careers that will make you a success in 2030 (and beyond):

1/ Artificial Intelligence

Tech roles:

•Machine learning engineer
•Computer vision engineer
•Data scientist
•Data engineer
•Algorithm engineer

•Research

Non-tech roles:

• Human Resources
• Artificial Intelligence Writers
• Virtual Assistants and Chatbots designers
• Conversation Designer
• User Experience Designer
• User Interface Designer

AI And Machine Learning Full Course |

2/ Internet of Things

Tech roles:

•IoT/Cloud Software Developer
•IoT Infrastructure Architect
•IoT Systems Administrator
•Vulnerability/Cyber Engineer
•Test

Non-tech roles:

• Product Managers
• IoT Solution Architect
• IoT System Design
• Project Management
• Marketing
• Sales

IoT Tutorial for Beginners | Full Course |

Created a Github Repository for all the Code Solutions to all Competitive Programming Problems that I solve

Initialized it with some recent CSES problems and a standard C++ Template i follow for Competitive Programming 👇

Will be updating it will every problem I solve in the future .

A Must Learn Tool For Everyone🧑‍💻🈯️

Power BI is nothing but advanced version of excel

A Thread 🧵

Retweet For Benefit Of All ⚡️

1. Power BI is a cloud-based visualization tool from Microsoft

It allows user to create interactive reports and dashboards using simple interface

Eventually it will help user to take better decision in their business.

2. What is BI?

In Simple words,

Collect data from different sources, modify as per requirement and show them in pictorial form.

Collect Data --> Analyze Data -->Visualize Data

3. Power BI categorized into 4 types

Power BI Desktop

Power BI Service

Power BI Mobile

Power BI Server

4. Power BI Desktop: You collect data from different sources and work in power bi desktop

👇

Publish the worked data in power bi service.