Microsoft Excel and PowerPoint Training With Certificate

Learn the most essential and valuable skills for personal and professional success
4.3 (34 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.
1,292 students enrolled
$19
$20
5% off
Take This Course
  • Lectures 43
  • Length 9.5 hours
  • 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 6/2014 English

Course Description

About the class:

This is a combined certificate training of Microsoft Excel and Microsoft Powerpoint. This training encompasses all the training from "Microsoft Excel Training With Certificate" and "Microsoft Powerpoint Training with Certificate". This is an online video training class. The best way to benefit from this class is to view all the lectures in full screen and sit through all the lectures at least once. All lectures are video lectures.

What is Microsoft Powerpoint?

Microsoft Powerpoint is a software that is used for making presentations. This class teaches how to make a Microsoft Powerpoint Presentation. Microsoft Powerpoint is the most commonly used software for the creation of presentations. Knowing how to make a presentation is very valuable in the communication of ideas. Corporations around the World rely on Microsoft Powerpoint for communicating their ideas and messages to mass audiences. At the core of every international meeting lies a Powerpoint Presentation. This class teaches you how to think in Powerpoint. The ability to communicate your ideas to the World is your greatest asset. We are here to show the tools you have access to for achieving this goal.

Why learn Microsoft Powerpoint?

There will be many circumstances throughout your career and personal life when you will have to educate an audience or communicate a message in a formalized manner. Powerpoint is the tool that will allow you to achieve this goal. Powerpoint can be used for communicating ideas of all levels of complexity. It is very commonly utilized by University Professors, Executives and heads of states to make presentations. Whatever your goal may be, knowing Powerpoint will help you achieve your goal.

Who is this class for?

This is a beginner and intermediate level class.

Topics covered in class?

Interface components of Powerpoint are covered. Sample presentations are made to show the functionality of Powerpoint. The features of Powerpoint are implemented on these sample presentations. Most commonly used features of Power Point are highlighted and visited several times throughout the class.

~~~~~~~~~~
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.

Topics covered in class?

The class covers the layout of the Excel interface. During this process many of the interface features are shown in action. After the interface components are covered, the next part of the class focuses on a few of the key formulas used by Excel and the final part of the class is an example of the utilization of Excel.

Most of the components are covered during the layout overview. The overview shows how each one of these components works independently. The charting feature of excel is studied in detail with 2 chapters dedicated to this feature. The formulas portion of the class covers some of the most widely used Excel formulas.

Best way to learn from this class?

The best way to learn from this class is by revisiting the lectures and watching the lectures in full screen.

Certificate?

A certificate for this class can be earned through the completion of all the modules of the class. Certificate is delivered through email.

Time Commitment?

Students do not need to watch the complete class in a single sitting. Students have the ability to return to lectures and re-visit lectures.

What are the requirements?

  • This a combination of Microsoft Excel and Powerpoint training
  • No Prerequisites

What am I going to get from this course?

  • Microsoft Excel Training With Certificate
  • Excel Layout: Standard Tool Bar
  • Excel Layout: Formatting Toolbar
  • Excel Layout: Home Tab
  • Excel Layout: Layout Tab
  • Excel Layout: Tables Tab
  • Excel Layout: Charts Tab
  • Excel Layout: Smart Art, Formulas, Data and Review
  • Functions: Sum, Average, Max, Min and Count
  • Functions: Vertical and Horizontal Lookup
  • Functions: Vertical and Horizontal Lookup with Index
  • Functions: SumIf and AverageIf
  • Functions: The IF Statement
  • Functions: Nested IF Statement
  • Functions: Vlookup nested inside an if statement
  • Making a simple presentation with Powerpoint
  • Slide Master
  • Home Tab - 1 - Insert Image – PPT
  • Home Tab - 2 - Paragraph Options – PPT
  • Home Tab - 3 - Adding Clip Art – PPT
  • Home Tab - 4 - Insert Options

What is the target audience?

  • Beginner and Intermediate

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: Introduction: Microsoft Excel Training With Certificate
07:50

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.

Topics covered in class?

The class covers the layout of the Excel interface. During this process many of the interface features are shown in action. After the interface components are covered, the next part of the class focused on a few of the key formulas used by Excel and the final part of the class is an example of the utilization of Excel.

Most of the components are covered during the layout overview. The overview shows how each one of these components works independently. The charting feature of excel is studied in detail with 2 chapters dedicated to this feature. The formulas portion of the class covers some of the most widely used Excel formulas.

Before we begin
Preview
Article
Section 2: Excel Layout: Standard Tool Bar
12:49

Covers the components of the Standard Tool Bar. This is usually the top most toolbar in the Excel interface.

Standard Tool Bar Quiz
5 questions
Section 3: Excel Layout: Formatting Toolbar
08:02

Learn about the components of the Formatting Toolbar. This is found at the top of the Excel window.

Formatting Toolbar Quiz
5 questions
Section 4: Excel Layout: Home Tab
23:01

The home tab is a part of the ribbon feature of excel. Learn about the icons in the home tab.

This video showcases the Home tab. Please view in full screen.

Home Tab Quiz
5 questions
Section 5: Excel Layout: Layout Tab
14:26

The layout tab is a part of the ribbon feature of excel. Users are able to set sheet layout options from this tab.

This video showcases the Layout Tab. Please view in full screen.

Layout Tab Quiz
5 questions
Section 6: Excel Layout: Tables Tab
09:20

This tab allows the creation and formatting of a table for tables that do not have a custom format. It also implements the named range feature to tables.

Tables Tab Quiz
4 questions
Section 7: Excel Layout: Charts Tab - Part 1
18:22

The charts tab allows for the representation of data in chart form. Create a variety of chart types using this tab.

The supporting file for the charts tab part 1 and 2 is the same.

Charts Tab - Part 1 Quiz
4 questions
Section 8: Excel Layout: Charts Tab - Part 2
26:55

Part 2 of Charts Tab. The charts tab allows for the representation of data in chart form. Create a variety of chart types using this tab.

The supporting file for the charts tab part 1 and 2 is the same.

Charts Tab - Part 2 Quiz
5 questions
Section 9: Excel Layout: Smart Art, Formulas, Data and Review
21:55

The features of these tabs are combined in a single lesson. Features from this tab are also referred to throughout the course.

The features of these tabs are combined in a single lesson. Features from this tab are also referred to throughout the course. The Smart Art Tab offers the ability to make flow diagrams, the formula’s tab covers all pre functioned formulas in excel and the review tab allows for implementing features such as notes and spell check.

Smart Art, Formulas, Data and Review Quiz
5 questions
Section 10: Excel Functions: Sum, Average, Max, Min and Count
10:29

An explanation of some of the key standard formulas available in excel. Functions covered: Sum, Average, Max, Min and Count.

Functions: Sum, Average, Max, Min and Count - Quiz
5 questions
Section 11: Functions: Vertical and Horizontal Lookup
23:05

Vertical Lookup (Vlookup) and Horizontal Lookup (Hlookup) are features of excel that allow users to make a query on a data table. These are very useful functions that help in report making through data querying.

Vertical and Horizontal Lookup Quiz
5 questions
Section 12: Functions: Vertical and Horizontal Lookup with Index
08:53

The index function when combined with the Vlookup and Hlookup functions allows for the creation of dynamic reports. Index offers a quick solution for querying a table with vertical and horizontal reference points.

Vertical and Horizontal Lookup with Index Quiz
4 questions
Section 13: Functions: SumIf and AverageIf
13:40

The sum if and average if functions allow the application of the sum function and the average function based on a specific criterion. Values within a specific range can be summed based on a specific criterion using the SumIf function. Similarly, averages can be calculated within a specific range with the AverageIf function.

SumIf and AverageIf - Part 2
23:48
SumIf and AverageIf Quiz
5 questions
Section 14: Functions: The IF Statement
20:31

The IF statement is used to determine validity of a criterion. A cell is declared and the calculation is made to determine if this cell meets the criterion in IF statement. Pre determined outcomes can be implemented based on the statements validity.

The IF Statement Quiz
4 questions
Section 15: Functions: Nested IF Statement
14:11

The nested IF statement allows for multiple calculations to be made within a single IF statement. In a nested IF statement a secondary IF statement is tested for while within the initially setup IF statement. This video shows the nesting of an IF statement.

Nested IF Statement Quiz
4 questions
Section 16: Functions: Vlookup nested inside an if statement
12:38

The video in this chapter teaches how to nest a function within a function. The functions that are utilized can be different types of functions. In this particular example the Vertical lookup function is nested inside an IF statement.

Vlookup nested inside an if statement Quiz
4 questions
Section 17: Using Microsoft Excel for Personal Finance - Example
24:05

In this example we learn how to use Microsoft Excel for managing personal finances. A formula covered in this example is the payment calculation formula.

The setup for the formula is:

Payment = ( interest rate, compounding period, Present Value, Future Value, Type)

Interest rare = This is self explanatory. The interest you pay; its a percentage also refers to as Annual Percentage Rate

Compounding Period = If your loan is a 30 year loan compounding annually then your period is 30. More than likely the rate is compounded annually

Present Value = This is the amount of the loan

Future Value = This is usually 0, because you are bringing the amount to 0

Type = More than likely the type will be 0. The concept is based on if the loan compounds at the beginning of the year or at the end. Most loans compound at the end. 0 means end of the year and 1 means beginning of the year. More than likely you will use 0.

Using Microsoft Excel for Personal Finance - Part 2
Preview
19:40
Using Microsoft Excel for Personal Finance - Part 3
Preview
18:53
Section 18: Powerpoint: Making a simple presentation
20:32

Making a powerpoint is easy. Start out with turning on your Powerpoint software then follow the video.

In this chapter we create a simple Powerpoint presentation. In order to give ourselves a subject (premise), we are using the following example:

The objective of the sample presentation is to explain how to utilize the fundamentals of communication

Scenario:

You are making an invitation for a day long training for the Accounting Department. Make a presentation that shows the components of your invitation in light of effective communication.

The training will take place on Friday Nov 9th, 2014 from 9AM to 5PM. Several new employees have joined the Accounting Department since the last training that took place 3 years ago.

Making a simple presentation Quiz
3 questions
Section 19: Powerpoint: Slide Master
17:37

Slide Master is the main slide that determines the layout of your slide show. Here is where you can edit the template of your slide. What that means is that if you set the default for the format of every slide.

Some of the key values that can be set in Slide Master include Slide Background Color, Font Style, Default Font Sizes, Header and Footer Formats.

Slide Master Quiz
5 questions
Section 20: Powerpoint: Home Tab - Insert Image
21:53

In this chapter we start learning about the Home Tab.

Home Tab - Insert Image - Quiz
6 questions
Section 21: Powerpoint: Home Tab - Paragraph Options
23:10

This chapter looks at the features available within the paragraph options of the home tab. These features include text alignment, bullet points and indentation features.

Home Tab - Paragraph Options - Quiz
5 questions
Section 22: Powerpoint: Home Tab - Adding Clip Art
12:45

In this chapter we look at the extensive features of clip art. We learn how to insert clip art as well ash how to add clipart to our gallery.

Home Tab - Adding Clip Art - Part 2
10:40
Home Tab - Adding Clip Art - Part 3
11:07
Home Tab - Adding Clip Art - Quiz
5 questions
Section 23: Powerpoint: Home Tab - Insert Options
24:53

This chapter focuses on the Insert portion of the the Home Tab. Users can insert text boxes, word art, headers and footers.

Home Tab - Insert Options - Quiz
5 questions
Section 24: Excel 2013 - Add Subtract Multiply Divide
Add Subtract Multiply Divide
Preview
03:29
Section 25: 2013 Home Tab Clipboard
2013 Home Tab Clipboard
Preview
05:05
Section 26: 2013 Home Tab Clipboard Copy Paste
Home Tab Clipboard Copy Paste
13:41
Section 27: 2013 Fonts and related features
2013 Fonts and related features
05:43
Section 28: Excel 2013 Alignment
Excel 2013 Alignment
04:30
Section 29: Excel 2013 Currency Feature
Excel 2013 Currency Feature
Preview
07:13
Section 30: Excel 2013 Conditional Formatting
Conditional Formatting 1
11:31
Conditional Formatting 2
05:20
Conditional Formatting 3
08:17
Section 31: Excel 2013 Format Table and Cells Features
Excel 2013 Format Table and Cells Features
09:54
Section 32: Excel 2013 Edit Options in Home Tab
Excel 2013 Edit Options in Home Tab
Preview
08:48
Section 33: Pivot Table
Pivot Table
Preview
08:27
Insert Table and recommended Pivot Table
06:00
Section 34: Excel 2013 Illustrations
Excel 2013 Illustrations
06:18

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