Categories Catagory jee
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.
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
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!
returns the entire range of A1:C100 where column B has NZ.
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.
Want to become a Google Certified Data Scientist?
Here are 4 free courses from Google you don't want to miss:
1. Learn Python basics for data analysis
This course is designed to teach you the fundamentals of the Python programming language, especially for the purpose of data analysis.
2. Introduction to Data Science
This course will give you a comprehensive introduction to Data Science and Analytics Landscape.
3. Data Science with Python
This Data Science with Python program provides learners with a complete understanding of data analytics tools & techniques.
This program is an ideal kickstarter for anyone looking to become a data scientist today.
4. Data Science with Python
Getting started with Python can help you gain knowledge on data analysis, visualization, NumPy, SciPy, web scraping, and natural language processing.
This program is an ideal kickstarter to become a data scientist today.
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
Learn about Linkedin, Tools, Websites, Css, Youtube, Business, Presentation, Copywriting... And much more 🧵
1️⃣ 10 Free websites that feel illegal to use:
Topics: Tools, Websites, Website, Productivity, Web.
By: Ben Kelly
10 Free websites that feel illegal to use:— Ben Kelly (@benkellyone) September 7, 2022
2️⃣ 9 CSS generators can save you from writing CSS Code...
Topics: Css, Frontend, Generators, Cssgenerators, Design.
9 CSS generators can save you from writing CSS Code \U0001f9f5:— Pratham (@Prathkum) September 6, 2022
3️⃣ Even the most well-informed internet user wouldn't...
Topics: Websites, Tools, Website, Useful, Sites.
By: Alex Brogan
Even the most well-informed internet user wouldn't know all of these 10 incredibly useful websites:— Alex Brogan (@_alexbrogan) September 10, 2022
4️⃣ CSS generators can save you a lot of time and...
Topics: Css, Tools, Dev, Webdev, Generators.
By: Marko ⚡ Denic
CSS generators can save you a lot of time and effort.— Marko \u26a1 Denic (@denicmarko) September 7, 2022
Here are the 10 most useful CSS generators:
From Computer Science to Artificial Intelligence.
Here are 5 courses you don't want to miss:
1. Introduction to Computer Science
This is the best course to start with CS.
You'll learn about all the basic concepts and fundamentals of programming to start into tech field.
2. Introduction to Game Development
Learn about the development of 2D and 3D interactive games in this hands-on course.
This course will help you to explore the design of games such as Super Mario Bros., Pokémon, Angry Birds, and more.
This course will help you to go deep into the design and programming concepts.
4. Mobile App Development with React Native
Learn about mobile app development.
**Programming Language Used : C++**
- Programming in C++ - (https://t.co/gTcLJEMzwx)
- TakeUForward - ( https://t.co/udOwgbpG6O )
- CodeHelp - ( https://t.co/iph5urO1Q3 )
- Ayushi Sharma - ( https://t.co/pJUyl8ViF7 )
- COMPETITIVE PROGRAMMING -
**Programming Language Used : JAVA**
- Programming in JAVA - (https://t.co/fUMecrGVwY)
- Data Structure and Algorithams
- Kunal Kushwaha - (https://t.co/Pkvr5ZMcJ7)
- Pepcoding - (https://t.co/yNoYkSTTfv)
- Durga Sir -
- Anuj Bhaiya - (https://t.co/jHFrsvnwCy)
**Programming Language Used : Python**
- Programming in Python - (https://t.co/6zz3S1MpUO)
- DSA in Python - (https://t.co/vQ1EteJGnm)
- DS-ALGO - (https://t.co/KXE7NZf0ZD)
- Tech With Tim -
- Python Engineer - (https://t.co/VmGtEjiBVE)
- C++ - (https://t.co/nCnLHi00BK)
- JAVA - (https://t.co/Pkvr5Zu3uZ)
- JAVA - (https://t.co/pScvzpmlYu)
- PYTHON -
- SYSTEM DESIGN
- Gaurav Sen - (https://t.co/rzNpoBlK3q)
- SudoCode -
- LOW LEVEL DESIGN
- Soumyajit bhattacharya - (https://t.co/PCc8ZQAL8i)
- Sandeep Kaul - (https://t.co/ZH9Jq9Ei3p)
- Crack the System DesigN Interview - (https://t.co/8rhrPZZm1F)
- System Design Interview — Alex Xu -
- Designing Data Intensive Applications - (https://t.co/OhkTqqCQPx)
- System Design Interview - (https://t.co/7QvMtVRGvf)
- System Design - (https://t.co/ytpm3oy0tL)
- Services Engineering - (https://t.co/JPxM5YntWz)
- Engineering Blogs -
**Git and Github**
- Git and GitHub for Poets - (https://t.co/DsXVNVtENy)
- WEB DEVELOPMENT - (https://t.co/w1cEHZFRQz)
- DATA SCIENCE - (https://t.co/SJfFP4U0z0)
- MACHINE LEARNING -
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)
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.
• 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.
• Automate doc generation
• Document just enough
• Use tests as documentation
Just remember that..
no documentation >> incorrect documentation
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.
Basic Programming and Computing Concepts
CS50 by Harvard
Probably the best free course for beginners and professionals alike. It goes through the very basics of programming and painlessly shifts to advance topics.
Programming with Python
CS50P by Harvard
Prerequisites: CS50 will help but not necessary.
Takes forward the best things of CS50 but in Python. Undoubtedly, the best Python Course you will find on the internet.
Artificial Intelligence (Theory Focused)
CS50's Introduction to Artificial Intelligence with Python by Harvard
This is a more theory and concept focused Course that will be your entry point to AI.
AI with Tensorflow
Tensorflow 2.0 Beginner Tutorial by Aladdin Persson
Prerequisites: CS50P and CS50 AI with Python
The best beginners tutorial on Tensorflow.
⇝ Fundamentals ⇜
➙ Create React app
➙ Function Components
➙ Class Components
➙ useState and useEffect Hooks
➙ Conditional Rendering
➙ Lists and Keys
➙ Building Simple Forms
➙ Composition and Inheritance
⇝ Advanced Topics ⇜
➪ HTTP Requests
➙ Context Refs
➙ Error Boundaries
➙ Custom Hooks
➙ Higher-Order Components
➙ Render Props
The other 99% miss out.
Here are 10 fields with careers that will make you a success in 2030 (and beyond):
1/ Artificial Intelligence
•Machine learning engineer
•Computer vision engineer
• 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
•IoT/Cloud Software Developer
•IoT Infrastructure Architect
•IoT Systems Administrator
• Product Managers
• IoT Solution Architect
• IoT System Design
• Project Management
IoT Tutorial for Beginners | Full Course |
Note: Choose one or two resources and concentrate on building projects.
Building projects are the one & only way to excel in web development.
1. How does Internet work?
2. What is HTTP?
3. How do Browsers Work?
4. What is Domain?
5. What is Hosting?
6. DNS and How it Works?