Microsoft Excel in 75 minutes – Part 5

Learn the most valuable features of Microsoft Excel in under 75 minutes. Get 100% completion on this class.
4.2 (12 ratings) Instead of using a simple lifetime average, Udemy calculates a
course's star rating by considering a number of different factors
such as the number of ratings, the age of ratings, and the
likelihood of fraudulent ratings.
812 students enrolled
$19
$20
5% off
Take This Course
  • Lectures 14
  • Length 1 hour
  • Skill Level All Levels
  • Languages English
  • Includes Lifetime access
    30 day money back guarantee!
    Available on iOS and Android
    Certificate of Completion
Wishlisted Wishlist

How taking a course works

Discover

Find online courses made by experts from around the world.

Learn

Take your courses with you and learn anywhere, anytime.

Master

Learn and practice real-world skills and achieve your goals.

About This Course

Published 4/2016 English

Course Description

About the class:

This is part 5 of a series of classes on how to use Microsoft Excel. The objective of the series is to break the study of Microsoft Excel into small manageable pieces that can easily be completed in under 75 minutes. You can complete this class in a single session. Take advantage of this opportunity to learn Microsoft Excel.

What is Microsoft Excel?

Microsoft excel is a software that allows its users the ability to find a simple solution to daily data related problems. Excel can be utilized to access most problems in a mathematical spreadsheet format. For example: Let’s say you want to manage your finances. Excel offers a solution by which a user can make a list of expenses and maintain an ongoing log of incurred expenses.

Excel offers a drawing board for daily challenges in a spreadsheet format. Excel allows its users the ability to enter data in a table format. After arranging the data in an excel sheet users are then able to perform calculations on this data for the purpose of data analysis. The type of calculations that needed to be made over hundreds of pages of paper can now be made in a single spreadsheet through Microsoft Excel.

Why learn Microsoft Excel?

There is a very valid and compelling business reason for learning Excel. However more compelling than the business reason is the value excel brings into our personal lives. Excel can serve as a decision making tool as well as a personal life management tool. Management of personal finances becomes significantly easier with the help of Microsoft Excel. Other very common uses of Excel in person life include job application management, weight management, vacation budget management, market analysis and decision analysis. On the business end, excel is essential for all business success. Microsoft Excel lies at the core of all business decision making. The charting feature of excel allows for the representation of data in a colorful format that plays an integral role in business communication. Microsoft Excel is driving Global business decisions in all types of business ranging from large corporations to small privately owned companies. Most all professionals come across Microsoft Excel at some point in their careers.

Who is this class for?

This is a beginner and intermediate level class.

Class outline: 

1. Functions: Vertical and Horizontal Lookup ~ 23 minutes

Vlookup and Hlookup Part 1 ~ 4 minutes

Vlookup and Hlookup Part 2 ~ 5 minutes

Vlookup and Hlookup Part 3 ~ 5 minutes

Vlookup and Hlookup Part 4 ~ 6 minutes

Vlookup and Hlookup Part 5 ~ 4 minutes

2. Functions: Vertical and Horizontal Lookup with Index ~ 9 minutes

3. Functions: SumIf and AverageIf ~ 38 minutes

 Functions: SumIf and AverageIf Part 1 ~ 7 minutes

 Functions: SumIf and AverageIf Part 2 ~ 7 minutes

 Functions: SumIf and AverageIf Part 3 ~ 4 minutes

 Functions: SumIf and AverageIf Part 4 ~ 7 minutes

 Functions: SumIf and AverageIf Part 5 ~ 7 minutes

 Functions: SumIf and AverageIf Part 6 ~ 6 minutes

What are the requirements?

  • No prior knowledge required
  • Microsoft Excel 2011 or later

What am I going to get from this course?

  • Know the Vlookup and Hlookup functions
  • Know Vertical and Horizontal Lookup with Index
  • Fully understand SumIf and AverageIf functions

What is the target audience?

  • Beginner and intermediate level class
  • Something for everyone

What you get with this course?

Not for you? No problem.
30 day money back guarantee.

Forever yours.
Lifetime access.

Learn on the go.
Desktop, iOS and Android.

Get rewarded.
Certificate of completion.

Curriculum

Section 1: Microsoft Excel in 75 minutes – Part 5
Introduction
Preview
01:49
Functions: Vlookup and Hlookup part 1
Preview
04:07
Functions: Vlookup and Hlookup part 2
Preview
04:26
Functions: Vlookup and Hlookup part 3
04:40
Functions: Vlookup and Hlookup part 4
06:06
Functions: Vlookup and Hlookup part 5
04:09
Functions: Vertical and Horizontal Lookup with Index
08:53
Functions: SumIf and AverageIf – Part 1
07:20
Functions: SumIf and AverageIf – Part 2
06:32
Functions: SumIf and AverageIf – Part 3
04:08
Functions: SumIf and AverageIf – Part 4
06:39
Functions: SumIf and AverageIf – Part 5
07:26
Functions: SumIf and AverageIf – Part 6
05:38
Review – Microsoft Excel in 75 minutes – Part 5
00:37

Students Who Viewed This Course Also Viewed

  • Loading
  • Loading
  • Loading

Instructor Biography

Startup Saturdays, Thought leaders in entrepreneurship and business

Startup Saturdays is empowering the global community through offerings that instill and enhance leadership, entrepreneurship and technical skills. Individuals empowered through Startup Saturdays are able to explore new business and career opportunities that lead to a better quality of life and higher earnings.

Explore new pathways for your life by attending one of our classes. We are here to assist individuals with personal growth and help eliminate unsightly hurdles that may be arising from a lack of knowledge.

The skills taught by Startup Saturdays are in Global demand; your goal might be to start a company or to attain better paying employment. Startup Saturdays has offerings that will help you with these goals. Our trainings are practical, exercise based and come from experienced instructors. Classes take place in a professional conference room setting with individual attention.

The premise of our existence is that we would like to share knowledge with you and encourage you to achieve greatness in your careers and business along with all other aspects of your life.

Leadership and Management Training: The cornerstone of any action is leadership and management. It is the leader within us that drives us to achieve all our goals ranging from getting up in the morning to becoming what ever we desire to become in life.

Startup Saturdays has a series of offerings that help harness this inner leader and polish management skills. Operating in any environment (public or private) is hinged on a set of very necessary skills that need constant maintenance. If nurtured properly these skills can bear sweet fruit and if left unattended these skills can lead to the demise of any individual. These skills make the difference between winning and losing in life.

Technology: A student who has taken a technology class at Startup Saturdays will have a better understanding of technology. This may lead into the student building a new technology product or attaining a new position that requires technical skills the student did not have before. Anyone who has had to deal with building a technology can attest to this challenge. We are here to help you take the right steps. Don’t let the lack of understanding of technology be your handicap.

Having a good grasp of technology can result in more earning and increased employment opportunities.

Finance: The fuel that powers the economy determines how individuals and businesses survive. An integral part of business and life that can’t be ignored and a driving force behind the circumstances of most people and businesses in the World; the classes on Finance offered by Startup Saturdays are eye opening and targeted towards building a smarter financial brain.

Marketing: The greatest challenge for any business is marketing. An individual who can alleviate marketing pains is very valuable to any business. Marketing is an evolving challenge and requires constant attention. The rate with which marketing strategies become obsolete is comparable to the rate with which technologies become obsolete. Ignoring marketing needs can result in the failure of many qualified products and people. A business is incomplete without marketing and will miss out on opportunities along with possibly never reaching scale in its lifetime.

Marketing classes taught through Startup Saturdays focus on practical solutions and strategy building that can be implemented for initial traction or long term growth.

Information Technology Sales: Startup Saturdays offers training that teaches technology sales; a solution valuable to technical entrepreneurs and anyone interested in making money. Technical sales are very different from traditional sales. Technical sales require a good understanding of technology and traditional sales training can’t be used as a substitute to technical sales training.

Startup Saturday’s Technical Sales Training is available to individuals and corporations alike.

Ready to start learning?
Take This Course