FREE certification course from Google:
1. Learn programming with JavaScript
https://t.co/pi5MdgRmgk
2. Google's Python Class
https://t.co/aSyM51bU86
3. Machine Learning Crash Course
https://t.co/3FCh90IfB4
4. Fundamentals of Digital Marketing
https://t.co/1WXhEKwOnU
5. Data Science with Python
https://t.co/9zrTaQBN1x
6. Google Cloud Computing Foundations
https://t.co/PGGXSe7onX
7. Introduction to Google Cloud Essentials\
https://t.co/NGx8crGJw4
8. Introduction to Baseline: Data, ML, AI
https://t.co/H5Zh6rBtiJ
Follow @Kanojiyaaakash1 for such free resources.
Microsoft Excel has 1 Billion users and is used by 99% of the World's businesses, so here are 20 must-know Excel functions that everyone should learn:
1) =VLOOKUP: This function allows you to search for a value in a table and then return a corresponding value from the same row.
2) =INDEX/MATCH: These functions allow users to perform advanced lookups and retrieve data from a table or range of cells.
3) =INDEX: This function allows you to return the value of a cell in a specified row and column.
4) =MATCH: This function looks for a specified value in a range of cells and returns the position of the value within that range.
5) =IF: This function allows you to specify a logical test and then take different actions based on whether the test is true or false.
6) =SUM: This function allows you to quickly add up a range of cells.
7) =SUMIF: This function sums the values in a range, if it meets a certain criteria
8) =SUMIFS: This function sums the values in a range that meet multiple criteria. Use SUMIF you want the sum of two different criteria, for example, both "Sales" and "June"
9) =COUNT: This function counts the number of cells in a range that contain numbers.
10) =COUNTIF: This function allows users to count the number of cells that meet specified criteria.
11) =COUNTIFS: This function counts the number of times a criteria is met. For example, it counts the number of times that both "Sales" and prices ">$10" are mentioned
12) =DATEDIF: This function calculates the number of (1) days, (2) months, or (3) years between two different dates.
13) =AVERAGE: This function calculates the average of a range of cells.
14) =MAX: This function returns the largest value in a range of cells.
15) =MIN: This function returns the smallest value in a range of cells.
16) =CONVERT: This function converts one unit of measurement to another. There are multiple conversions that you can do. An example is meters to feet, or Celsius to Fahrenheit.
17) =CONCATENATE: This function allows you to combine multiple text strings into one string.
18) =TRIM: This function helps to remove the extra spaces in data. TRIM can be useful in removing irregular spacing from imported data
19) SPARKLINES: This function allows you to insert charts inside any cell and provides a visual representation of data. Sparklines can show trends or patterns in data.
20) GOAL SEEK: This function is also known as What-if-Analysis. Goal Seek uses trial & error to back-solve a problem, by plugging in guesses until it arrives at the correct answer.
Data Analysis is the most wanted skill for every business today.
Still, +80% businesses use Excel to Analyze Data.
Here are the Most Common Excel Functions used by Data Analysts.
- Thread -
You don't need to go to a Film School to learn Video Editing.
I learnt everything from YouTube and created a Video Editing Agency just through that.
Here are 8 YouTube Videos that Helped me make Thousands Of Dollars:
As a YouTube Video Editor
It's my responsibility to make my Clients' Videos Look Professional.
Here are 11 Secret AI Tools/Websites You can use to Video Edit like a Pro:
A Free State ambulance overturned while transporting a 9-month-old baby and her mother after it hit a pothole on the N8 near Tweespruit.
https://t.co/1bG8FJ3kcG
Strong core muscles are essential for maintaining good balance, preventing back injuries, and living a long and healthy life.
7 exercises to build core strength and stability from home:
@FlightCentreRSA Yes. For the umpteenth time, we will be the ones making the calls and sending email communication. Unfortunately no basic customer service exists which ensures that you revert to your customers because of your errors.
@FlightCentreRSA do you really take nearly two months to revert to your clients regarding flight ticket refunds? When the client arrived at the airport the flight was not booked and nobody has been forthcoming with them about their refund? This is so disappointing
@FlightCentreRSA It's the fact that the refund process hasn't even begun. Nearly 2 months later, while the client is the one who has to make contact with flight centre to follow up on the case, not the other way around. Seems like poor customer service to me.
As part of my growth journey, my business coach set me this target of pursuing an impact metric that is aligned to people BEYOND the business profitability.
So, as we have been rebuilding the businesses and brands, I have been very intentional about diversifying my teams across the businesses, various go-to-market brands & product centers.
One of the most glaring things I have noted (and this is purely my first hand experience, not supported by imperical data) is that women of colour are paid WAAAY BELOW the value of the skillset or even their scale.
Dear entrepreneur: Pay people what they are worth. Pay them based on the value they add NOT based on what they were earning prior to joining your firm.
#equity #equalpayforequalwork
VT
I've used Microsoft Excel for 20 years and these 10 shortcuts will make you an Excel Guru in 5 minutes & maximize your productivity 100x:
🧵 Don't use Excel without knowing these 10 shortcuts:
Microsoft Excel is a must-have skill in today's job market. If you found this thread helpful:
• RT the FIRST tweet🔁
• Follow me @FluentInFinance
• Sign-up for my FREE newsletter to learn valuable skills: https://t.co/0pElxsPaXr!