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
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
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
Torrent Download (Please seed after downloading)
Mirror 1 || Mirror 2
Source: https://www.udemy.com/course/microsoft-excel-beginner-and-intermediate-certificate-class