Class Central is learner-supported. When you buy through links on our site, we may earn an affiliate commission.

Microsoft Excel Beginner and Intermediate with Certificate

via Udemy

Overview

Learn how to use Excel for Mac and PC with this beginner and intermediate excel certificate class. Top Rated Training.

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

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

Taught by

Startup Saturdays

Reviews

Start your review of Microsoft Excel Beginner and Intermediate with Certificate

Never Stop Learning!

Get personalized course recommendations, track subjects and courses with reminders, and more.