Microsoft Excel and PowerPoint Training With Certificate
4.1 (165 ratings)
Course Ratings are calculated from individual students’ ratings and a variety of other signals, like age of rating and reliability, to ensure that they reflect course quality fairly and accurately.
1,678 students enrolled

Microsoft Excel and PowerPoint Training With Certificate

Learn the most essential and valuable skills for personal and professional success
4.1 (165 ratings)
Course Ratings are calculated from individual students’ ratings and a variety of other signals, like age of rating and reliability, to ensure that they reflect course quality fairly and accurately.
1,678 students enrolled
Created by Startup Saturdays
Last updated 12/2014
English
English [Auto-generated]
Current price: $13.99 Original price: $19.99 Discount: 30% off
5 hours left at this price!
30-Day Money-Back Guarantee
This course includes
  • 9.5 hours on-demand video
  • 1 article
  • 20 downloadable resources
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
Training 5 or more people?

Get your team access to 4,000+ top Udemy courses anytime, anywhere.

Try Udemy for Business
What you'll learn
  • 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
Requirements
  • This a combination of Microsoft Excel and Powerpoint training
  • No Prerequisites
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.

Who this course is for:
  • Beginner and Intermediate
Course content
Expand all 43 lectures 09:40:17
+ Introduction: Microsoft Excel Training With Certificate
2 lectures 08:40

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.

Preview 07:50
+ Excel Layout: Standard Tool Bar
1 lecture 12:49

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

Standard Tool Bar
12:49
Standard Tool Bar Quiz
5 questions
+ Excel Layout: Formatting Toolbar
1 lecture 08:02

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

Formatting Toolbar
08:02
Formatting Toolbar Quiz
5 questions
+ Excel Layout: Home Tab
1 lecture 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
23:01
Home Tab Quiz
5 questions
+ Excel Layout: Layout Tab
1 lecture 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
14:26
Layout Tab Quiz
5 questions
+ Excel Layout: Tables Tab
1 lecture 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
09:20
Tables Tab Quiz
4 questions
+ Excel Layout: Charts Tab - Part 1
1 lecture 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
18:22
Charts Tab - Part 1 Quiz
4 questions
+ Excel Layout: Charts Tab - Part 2
1 lecture 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
26:55
Charts Tab - Part 2 Quiz
5 questions
+ Excel Layout: Smart Art, Formulas, Data and Review
1 lecture 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
21:55
Smart Art, Formulas, Data and Review Quiz
5 questions
+ Excel Functions: Sum, Average, Max, Min and Count
1 lecture 10:29

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

Preview 10:29
Functions: Sum, Average, Max, Min and Count - Quiz
5 questions