Udemy
    •  
    •  
    •  
    •  
    •  
    •  
    •  
    •  
Turn what you know into an opportunity and reach millions around the world.
Learn More
Your cart is empty.
Keep shopping
Microsoft Excel Beginner and Intermediate with Certificate
Rating: 3.9 out of 5(273 ratings)
12,257 students

Microsoft Excel Beginner and Intermediate with Certificate

Learn how to use Excel for Mac and PC with this beginner and intermediate excel certificate class. Top Rated Training.
Last updated 12/2014
English

What you'll learn

  • To educate on Microsoft Excel
  • Layout: Standard Toolbar​
  • Layout: Formatting Toolbar
  • Layout: Home Tab
  • Layout: Layout Tab
  • Layout: Tables Tab
  • Layout: Charts Tab
  • Layout: Smart Art
  • Layout: Formulas
  • Layout: Data
  • Layout: Review
  • Functions: Sum
  • Functions: Average
  • Functions: Max
  • Functions: Min
  • Functions: Count
  • Functions: Vertical and Horizontal Lookup
  • Functions: Vertical and Horizontal Lookup with Index
  • Functions: Sumif and Averageif
  • Functions: The IF statement
  • Functions: The nested IF statement
  • Functions: Vlookup nested inside an IF Statement

Course content

28 sections34 lectures7h 18m total length
  • Class intro7:50

    About the class: 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 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.

    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.

    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.

    Microsoft Excel is an essential tool for all success. Learn the art of using Excel to enhance personal, professional and business performance. The skills learned in this class are essential for utilizing Microsoft Excel for all purposes. This is a vide based training program with lessons delivered online. Students learn at their own pace by re-visiting classes as needed. Students have access to all course material for up to 1 year from date of purchase. This is a beginner and intermediate level class and requires no prior understanding of Microsoft Excel. Enhance your personal and professional performance with this amazing online training.

Requirements

  • Microsoft Excel

Description

This is a beginner and intermediate Microsoft Excel training class that requires no prior knowledge of Excel. The training provided in this class covers MAC and PC. Ideal for students who use a MAC and just as applicable to students who use a PC.

The class starts be describing the interface and then explains different functions a user can utilize to perform a variety of analysis.

This is a beginner and intermediate level class, no prior excel experience necessary.

Following is a list of topics covered in class:

Layout

  • Standard Toolbar
  • Formatting Toolbar

  • Home Tab

  • Layout Tab

  • Tables Tab

  • Charts Tab

  • Smart Art

  • Formulas

  • Data

  • Review

Functions

  • Sum
  • Average
  • Max
  • Min
  • Count
  • Vertical and Horizontal Lookup

  • Vertical and Horizontal Lookup with Index

  • SumIf and AverageIf

  • The IF Statement

  • Nested IF Statement

  • Vlookup nested inside an if statement

Who this course is for:

  • Beginner
  • Intermediate
  • Advanced
  • Anyone interested in harnessing the power of Microsoft Excel
  • Mac users