Office [Udemy] Microsoft Excel Beginner and Intermediate with Certificate

[tttx]

​

DESCRIPTION:

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

Requirements:

• Microsoft Excel

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:

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

SALES PAGE:

Авторизуйтесь, чтобы посмотреть скрытый контент

DOWNLOAD:

Авторизуйтесь, чтобы посмотреть скрытый контент