Posts Tagged with “Excel Certificate”

Free Microsoft Excel Training With Certificate

Microsoft Excel Training With Certificate

Get Free Microsoft Excel Training With Certificate , Learn how to use Excel for Mac and PC with this beginner and intermediate excel certificate class.

Microsoft Excel Training With Certificate

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

[xyz-ihs snippet=”Ad-Media-VideoStripe-14-day-375-250″]

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

What am I going to get from this course?

  • 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

Free Microsoft Excel Training Here