Google Sheet Tutorial Basic Mathematical Functions & Formulas

Google Sheet Tutorial Basic Mathematical Functions and Formulas. Google Sheets is an online spreadsheet app that lets you create and format spreadsheets and work with other people. With Google Sheets, everyone can work together in the same spreadsheet at the same time. Use formulas, functions, and formatting options to save time and simplify common spreadsheet tasks. Google sheet is alternative to Microsoft Excel and have some facilities over Microsoft excel.

Referral links that will not charge you but help me earning commissions. Buy tubebuddy channel booster plugin for your channel: https://bit.ly/2HP5lJR

Please watch till the end of the video, I hope you will enjoy it. If you have enjoy the video, please go ahead and like it. Write us in comment how helpful this video for you. If you think this might be helpful for your friends, Please share the video with your friends.

If you have any question, regarding the video, Please write us through comments. Please join in our community through subscription of channel and subscription of video notification.

In triksbuddy channel, you will get different interesting tech stuffs that will help you enrich your technology knowledge. Please subscribe our channel to get updates of our videos. Subscription link: https://goo.gl/GE4g8v

Please subscribe in below link and like our video.

Subscription URL: https://goo.gl/GE4g8v

Channel URL: https://goo.gl/VYi58K

Most Recent Videos: https://goo.gl/hXFN4w

Most Popular Video: https://goo.gl/7u7B1x


Social:

Facebook: https://www.facebook.com/triksbuddy/

Linked in: https://www.linkedin.com/company/triksbuddy/

Blog: https://triksbuddy.blogspot.com/

Tumblr: https://imrulquaes89.tumblr.com/

RSS Feed:
https://www.youtube.com/feeds/videos.xml?channel_id=UCKFouta2JOolZmAmHeo3ZKw



 #GoogleSheetTutorial, #triksbuddy

How to Draw Usecase Diagram using Draw.io

Learn How to Draw Usecase Diagram using Draw.io. This video shows you how easily you can draw usecase uml diagram using www.Draw.io. 

Use cases are a way of describing interactions between users and a system using a graphical model and structured text. They were first introduced in the Objectory method and have now become a fundamental feature of the Unified Modeling Language (UML). In their simplest form, a use case identifies the actors involved in an interaction and names the type of interaction. You then add additional information describing the interaction with the system. The additional information may be a textual description or one or more graphical models such as the UML sequence or state charts.

Use cases identify the individual interactions between the system and its users or other systems. Each use case should be documented with a textual description. These can then be linked to other models in the UML that will develop the scenario in more detail.

There are many tools available in the market for drawing use case diagrams. Visio is one of the most popular tool from microsoft which is not free for use. As an alternative of visio, draw.io is a great tool that allows you free access along with free storage and integration with other cloud applications like google drive, dropbox etc for storing you drawings.

 

 

If you have enjoy the video and get it interesting, please hit like button.

Write us in comment how helpful this video for you. If you think this might be helpful for your friends, Please share the video with your friends.

If you have any question, regarding the video, Please write us through comments.

Please join in our community through subscription of channel and subscription of video notification. 

 

In triksbuddy channel, you will get different interesting tech stuffs that will help you enrich your technology knowledge. Please subscribe our channel to get updates of our videos. 

Subscription link: https://goo.gl/GE4g8v 

Please subscribe in below link and like our video. 

Subscription URL: https://goo.gl/GE4g8v 

Channel URL: https://goo.gl/VYi58K 

Most Recent Videos: https://goo.gl/hXFN4w 

Most Popular Video: https://goo.gl/7u7B1x 

Social:
Facebook: https://www.facebook.com/triksbuddy/ 

Linked in: https://www.linkedin.com/company/triksbuddy/ 

Blog: https://triksbuddy.blogspot.com/ 

Tumblr: https://www.tumblr.com/blog/imrulquaes89 

RSS Feed: https://www.youtube.com/feeds/videos.xml?channel_id=UCKFouta2JOolZmAmHeo3ZKw

 

Creating a Meeting in GSuite Google Calender - triksbuddy

This video will shows way of creating a meeting in GSuite Google
Calender. Google GSuite allows you to create a meeting call easily using
google calender. The application allows you to setup meeting
notification which will be shown to the participants before the given
period of time before the meeting. GSuite allows you to setup available
meeting rooms of your organization. You can invite internal and external
guest.

Supervised, Unsupervised and Semi-supervised Learning Algorithm - Machine Learning Tutorial-02

This video demonstrates Supervised Learning, Unsupervised Learning and Semi-supervised Machine Learning Algorithm. Welcome to Introduction to Machine Learning - Machine Learning Tutorial.

Supervised Learning: In supervised learning, label data or output or supervisor data or teacher data is given in training data. Supervised learning must contain label data during training phase.
Supervised Learning Algorithms are:
- Nearest Neighbor (NN)
- K-Nearest Neighbor (KNN)
- Artificial Neural Network (ANN)
- Support Vector Machine (SVM)
- Decision Tree (DT) ex: ID3, C4.5
- Apriori Algorithm
- Hidden Markov Model (HMM)
- Logistic Regression
- Naive Bayes Classifier

Unsupervised Learning: In unsupervised learning only input data is given in training data. No label data or supervisor data is given. Unsupervised Learning separate data into clusters.

Un-Supervised Learning Algorithms are:
- K-Means Clustering
- Modified K-Means Clustering
- Hierarchical Clustering
- SOM (Self Organizing Map)
- Fuzzy C-Mean Clustering

Semi-Supervised Learning: In semi-supervised learning for some data label data is given and for some data label data is missing. Input data that are not labelled have to be labelled using labelled input training data. Then apply testing data for intelligent decision.

Please watch till the end of the video to get a clear concept of machine learning algorithms, I hope you will enjoy it.

Introduction to Machine Learning - Machine Learning Tutorial-01

Welcome to Machine Learning tutorial. This is introduction to machine learning which is the first video of this series.

In this video I have given a very easy definition of Machine Learning, shown application of Machine Learning in different sectors and different types of Machine Learning techniques.

In next video, I will discuss about different Machine Learning types in broader details.

The content of this video is primarily focused for computer science  undergraduate and graduate level students who wants to make clear understanding of machine learning algorithms with solving mathematical problems using machine learning algorithm. However any other interested learners who have high interest on learning Machine Learning can watch and join the community.

*Subscribe the channel and get in touch.
*If you have any query regarding Machine Learning concept please write in comments.
*If you think this video might be helpful for others, please keep sharing.

Learn Project Management For Free from Top Universities and Organizations

There are huge resource online to learn about project management. Following is a short list of free project management learning resources over there in online that are very helpful for your study:

Edx:

• Project Management Life Cycle: https://www.edx.org/course/project-management-life-cycle-2
• Best Practices for Project Management Success: https://www.edx.org/course/best-practices-for-project-management-success-2
• International Project Management: https://www.edx.org/course/international-project-management-2
• Introduction to Project Management: https://www.edx.org/course/introduction-project-management-adelaidex-project101x-1
• Applied Scrum for Project Management: https://www.edx.org/course/applied-scrum-for-project-management
• Managing Projects with Microsoft Project: https://www.edx.org/course/managing-projects-with-microsoft-project-5

Coursera:

• Project Management: The Basics for Success: https://www.coursera.org/learn/project-management-basics
• Introduction to Project Management Principles and Practices Specialization: https://www.coursera.org/specializations/project-management
• IT Project Management: https://www.coursera.org/learn/it-project-management

 Udemy: 

• Introduction to Project Management:https://www.udemy.com/course/project-management/
• PMP Exam Prep: Project Management Certification: https://www.udemy.com/course/pmp-exam-prep-project-management-certification-pmbok-5/
• Introduction to Project Management | PM101 Training Session: https://www.udemy.com/course/project-management-101-pm101/

Alison:

• Fundamentals of Project Management: https://alison.com/course/fundamentals-of-project-management-revised-2017
• Diploma in Project Management: https://alison.com/course/diploma-in-project-management-revised-2017

FutureLearn:

• Business Fundamentals- Project Management: https://www.futurelearn.com/courses/project-management

Youtube:

• Getting Started in Project Management: https://www.youtube.com/watch?v=8x7msPfjASo&list=PL395944B4606C1909
• Project Management: https://www.youtube.com/watch?v=d8_gaRIrrUw&list=PLF1064CD7B0A98261&index=3
• PMP Training: https://www.youtube.com/watch?v=DxRrG4pAdJ0
• Fundamentals of Project Management: https://www.youtube.com/watch?v=JIKyxfZrsx4

 

Introduction to Project Management: Definition of Project, Characteristics of Project

What is a Project? What are the characteristics of Project?

According to the Project Management Institute:
 "A project is a temporary endeavor undertaken to create a unique product, service, or result." 

Let's break down this definition into its components to understand further what a project is (and what it is not) and try to understand project characteristics:

⇛ It is a temporary endeavor:- what does that mean? It means that it isn't endless; it has a start date and an end date. Projects do not go on indefinitely. Activities that go on indefinitely are typically known as processes or operations. So how do we understand when a project ends?

The project reaches to end when one or more of the following condition(s) met:

• The project’s objectives have been achieved;
• The objectives will not or cannot be met;
• Funding is exhausted or no longer available for allocation to the project;
• The need for the project no longer exists (e.g., the customer no longer wants the project completed, a change in strategy or priority ends the project, the organizational management provides direction to end the project);
• The human or physical resources are no longer available; or
• The project is terminated for legal cause or convenience.

⇛ It creates a unique product, service, or result:- which we call a deliverable. Unique means that it is unlike any other project. It may be similar to other projects but it is never identical to one. This is what distinguishes a project from a process. A project is unique; a process is repeatable and strives for consistency, standardization, and no deviation from a standard. Deliverable means that it has a tangible or intangible outcome: i.e. a new software product, a new drug, a new building, a merger of two companies, improved customer service, etc. The outcome may be a product, goods, or a service.

Fulfillment of project objectives may produce one or more of the following deliverables:

• A unique product that can be either a component of another item, an enhancement or correction to an item, or a new end item in itself (e.g., the correction of a defect in an end item);
• A unique service or a capability to perform a service (e.g., a business function that supports production or distribution);
• A unique result, such as an outcome or document (e.g., a research project that develops knowledge that can be used to determine whether a trend exists or a new process will benefit society); and
• A unique combination of one or more products, services, or results (e.g., a software application, its associated documentation, and help desk services).

 ⇛ It drive change in the Organization:- From a business perspective, a project is aimed
at moving an organization from one state to another state in order to achieve a specific objective. The term Current State, Future State, and Transition State are used to describe change in organization.  

• Current state: is the state of organization before the project begins.  
• Future state: is the desired or resulted state where the organization will be driven by the project. 
• Transition state: For large projects, if there are milestone deliverables, transition state refer to the state where organization reaches after each milestone is delivered.

⇛ It enables business value creation:- business value is the net quantifiable tangible, intangible, or both benefit to the stakeholders derived from a business endeavor. It is considered the return, in the form of elements such as time, money, goods, or intangibles in return for something exchanged.

Examples of tangible elements:

• Monetary assets,
• Stockholder equity,
• Utility,
• Fixtures,
• Tools, and
• Market share.

Examples of intangible elements:

• Goodwill,
• Brand recognition,
• Public benefit,
• Trademarks,
• Strategic alignment, and
• Reputation.

⇛ It initiated in some context:- projects are created in context of organizational factors by organizational leaders. Four fundamental categories of factors are there, which illustrates the context of initiating a project:

• Meet regulatory, legal, or social requirements;
• Satisfy stakeholder requests or needs;
• Implement or change business or technological strategies; and
• Create, improve, or fix products, processes, or services.

⇛ It has defined objectives:- The goals expected to be achieved. There can be technical goals (develop new technology), legal or political goals (to meet governmental regulations), and/or business goals (beating or eliminating competition). These objectives should be measurable.

⇛ It has scope:- All the work required to deliver the product or result and satisfy the objectives for which a project was undertaken at a level of quality expected by the customer. The scope includes all the deliverables required to meet the project objectives.

⇛ It has cot:- The planned cost of conducting the project; it includes human and physical resources.

⇛ It has Time/Schedule:- The planned time to complete the project, as well as the Milestones along the way. 

EXAMPLES OF PROJECTS:

• Building a house
• Developing a new pharmaceutical compound for market
• Building a mobile application
• Expanding a tour guide service
• Developing a new product
• Merging two organizations
• Improving a business process within an organization
• Improvement of a service (i.e. customer service, Six Sigma initiative)
• Modifying a computer software program used in an organization
• Conducting research to develop a new manufacturing process

EXAMPLES OF PROJECT OUTCOMES:

• Pyramids of Giza,
• Olympic games,
• Great Wall of China,
• Taj Mahal,
• Publication of a children’s book,
• Panama Canal,
• Development of commercial jet airplanes,
  Polio vaccine,
• Human beings landing on the moon,
• Commercial software applications,
• Portable devices to use the global positioning system (GPS), and
• Placement of the International Space Station into Earth’s orbit.

Further reading on PMP:

1. Project Management Life Cycle
2. Project Management Certifications Questions with explanation.
3. Free PMP Certification Questions

Tell Me About Yourself - How to Answer Best way

Tell Me About Yourself / introduce yourself / Tell me something about yourself / tell me about yourself interview answers - Best Tricks To Answer the very common interview question.

Introduction:

“Tell me about yourself”.

The first Question in any job interview. This could be the most difficult question and disqualify you if you are not prepared for it.


Alternative forms of the question:

The interviewer can also ask you same questions in different ways like:

• Tell me something about yourself.
• Can you tell me a little about yourself?
• Briefly introduce yourself.
• Please tell us about your background.
• How would you describe yourself?

Asked in every interviews:

In every job interview it is universal that you will be asked the question:

“Tell me about yourself”.

Regardless of your industry, experience level or job type your interviewer will come up with the question, most frequently the first question of the interview. Since it’s often the first question to be asked in an interview, it’s your big chance to make a first impression.

This question is an opportunity for you to set the tone of the job interview and emphasize the points that you most want this potential employer to know about you.


Interviewer's Expectations and Perspectives:

So what your interviewer’s want to know by asking this question?

• His ultimate goal for this interview is to find out enough about you to decide if you’re a good fit for the job opening. In most cases, he wants to like you.
• Can you communicate comfortably?
• How potential candidate you are for the job?
• How your experience is pertinent to the job description you're interviewing?

Some Common Mistakes:

Now, let us talk about some common mistakes not to make while answering the question:

1. Don’t recitate your resume: Many candidates; respond by launching into a recitation of their resume; from the very beginning. This can turn into a very long monologue; that is probably the least relevant experience.
    
2. Avoid talking about personal details or life story: Avoid mentioning personal information such as marital status, children, political or religious affiliations, etc. These can be highly sensitive topics that might work against you as a candidate. No one is interest on it.
    
3. Don’t be too modest: Many candidates; make the mistake of being too modest. They reply with a humble or vague introduction; that fails to clearly communicate their strongest qualifications.

How to prepare yourself:

Now let us see some tips to prepare yourself:

• Your answer should be focused on your Top Qualities, Skills, Experiences, Achievements, Distinct Extra curricular activities.
• Short (usually than 1 minute, prepare for 2 minutes).
• Write down your answer and print it.
• Practice the answer again and again.

How to Answer:

Your answer should have three components:

1. Who You Are: Concisely summarizes diverse background. Your first sentence should be an introduction to who you are professionally, an overview statement that shows off your strengths and gives a little sense of your personality too.
2. Expertise Highlights: The emphasis here is on experience, enthusiasm, and proof of performance. Don’t assume that the interviewer has closely read your resume and knows your qualifications. Use your elevator pitch to briefly highlight 2-4 points that you think make you stand out.
3. Why You’re Here: Concise and positive. End by telling them you want the position and why.

Sample Good Answers:

An experienced HR Manager can answer, like:-

“Well, Thank you for giving me the opportunity to introduce myself.

I’m an innovative HR manager with 10 years of experience leading and managing all aspects of the Human Resource functions, — from recruiting to training to benefits — for large enterprises that have multi-cultural and diversified environment.

I have spent the last six years developing my skills as a customer service manager for Telenor Inc. where I have won several performance awards and been promoted twice. I love managing teams and solving customer problems.

Although I love my current role, I feel I’m now ready for a more challenging assignment and this position really excites me.”


An experienced software developer answers may be:

“Thank you for giving me the opportunity.

Well, I have more than five years of experience as a technical project manager at CMMI Level 5 certified Software Development companies.

In my current position I led the development of machine learning enabled IoT based Predictive Healthcare Information Management System and implemented in Savar, Bangladesh to keep track of health record of around 5000 villagers. This project won multiple awards along with national ICT award 2020.

I’m a person who thrives in a fast-paced environment and like to work for Health development. So, right now, I’m looking for an opportunity to apply my technical experience and my creative problem solving skills at an innovative software company that implement innovation in Health.”

Practicing your answer over and over will be the key to success.

Best of luck.

Top 50 HR Interview Questions

In HR interviews, you will face questions that are almost similar in all interviews that cover a set of areas that will help interviews to identify that you are the expected candidate and fit for the job. Here, we sorted out a list of top 50 HR Interview Questions that you will be frequently asked in interviews. You should practice and be prepared before you sit for the interview.

Questions:

1. Tell me something about yourself.
2. Why do you want to work in our company? Why are you interested in this job?
3. Why should we hire you? Why you are suited for this job? Why you do you fit for the job? Why do you think you deserve this job?
4. What is your role in your current position?
5. What are your strengths?
6. What are your weaknesses?
7. Where do you want to see yourself within the next 3 years?
8. What is our greatest achievement?
9. Why are you leaving your current company?
10. What is the top challenge you dealt in your current company?
11. Who are competitors and partners of your current company?
12. What is your current salary?
13. What is your expected salary?
14. Do you have any questions for us?
15. What do you like about this company?
16. Do you work well under pressure?
17. How do you make important decisions?
18. What is your leadership style? How do you manage?
19. On a scale of 1 to 10 how would you rate yourself as a leader?
20. Are you a team player?
21. What your colleagues say about you?
22. How do you resolve conflict between team members?
23. Did you have any conflict with your reporting manager?
24. How do you motivate team members?
25. Are you good at dealing with change?
26. Do you know anybody in our company?
27. Has your work ever been criticized?
28. What are your expectations from job?
29. Why have you been unemployed for a long time?
30. How long would you expect to work for us if hired?
31. Do you consider yourself successful?
32. What are the qualities of successful leader?
33. Are you willing to travel?
34. Are you willing to relocate?
35. How is your country?How is Bangladesh/Uganda?
36. What do you know about our country?
37. Why do you want to come to our country?
38. Do you have a driver's license?
39. Do you have a plan for further education? (Masters/Phd)
40. You don’t have any certifications yet. Why?
41. You have already jumped jobs too many times, Why?
42. If we call your current reporting manager, what will he say about you?
43. What did you do last year for your development?
44. What motivates you?
45. Tell me about you dream job.
46. What you have learned from mistakes on the job?
47. Are you willing to work overtime?
48. What are the most difficult decision to make?
49. How do you deliver bad news to your team?
50. How was your written and technical interview?
51. How do you hear about his position?
52. Describe a time when you had to listen to someone
53. Tell me about a skill you recently acquired or improved
54. Tell me three things about you, which are not found in your resume
55. Provide an example of a goal that you successfully attained

The Amazing Seychelles Islands paradise on earth from drone

The HD video shows the amazing islands country Seychelles which is know as paradise on earth from drone and sky. The Seychelles is an archipelago of 115 islands in the Indian Ocean, off East Africa. It's home to numerous beaches, coral reefs and nature reserves, as well as rare animals such as giant Aldabra tortoises. Mahé, a hub for visiting the other islands, is home to capital Victoria. It also has the mountain rainforests of Morne Seychellois National Park and beaches, including Beau Vallon and Anse Takamaka.

Seychelles is a member of the African Union, the Southern African Development Community, the Commonwealth of Nations, and the United Nations. After proclamation of independence from the United Kingdom in 1976, Seychelles has developed from a largely agricultural society to a market-based diversified economy, with agriculture being supplanted by rapidly rising service and public sectors as well as tourism.

The Seychelles’ pristine stretches of sand are regularly ranked among the most beautiful in the world. From aquatic adventures to lip-tingling Creole cuisine, local writer Glynn Burridge reveals six reasons to visit this tropical paradise.

The main island Mahé, has 65 beaches of its own. Topping the list are Anse Intendance, with its 2km strand and impressive breakers; laid-back Carana beach; Beau Vallon. God made the Seychelles with sailors in mind, and viewing these islands from the ocean is difficult to beat

Prince William and Kate Middleton’s choice of Seychelles for their honeymoon catapulted the islands to fame as the ultimate romantic getaway. With a wild, natural beauty and year-round tropical warmth, it’s difficult to imagine a more perfect destination for weddings, honeymoons, anniversaries or even an impromptu romantic break.

Most popular destinations in seychelles are:
Mahe, Sechelles
Praslin
La Digue
Victoria
Via Vallon
Grand Anse
Aldabra
Quatre Bornes

Watch the heaven on earth, Seychelles.

TravelEx channel shares travel videos of beautiful places in the world.

Please subscribe travelex channel for enjoying more interesting travel videos. If you like the video share with your friends.