Microsoft Excel Beginner and Intermediate with Certificate
- 0.0
-
![]()
![]()
![]()
![]()
![]()
Brief Introduction
Learn how to use Excel for Mac and PC with this beginner and intermediate excel certificate class. Top Rated Training.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
Requirements
- Requirements
- Microsoft Excel
Knowledge
- 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
Microsoft Excel for Business Professionals
- 4.1
-
![]()
![]()
![]()
![]()
![]()
Tips, Tricks, and Best Practices Straight from Corporate America In today's day and age, Microsoft Excel is fully integrated in all businesses....
Data Analyst's Toolbox: Excel to MySQL
- 4.1
-
![]()
![]()
![]()
![]()
![]()
Gain hands-on experience with Excel, Statistics, MySQL and Power BI to drive powerful analysis and communicate insights Gain a competitive advantage in the job market....
Ultimate Microsoft Office; Excel, Word, PowerPoint & Access
- 4.5
-
![]()
![]()
![]()
![]()
![]()
Learn basic to advanced Microsoft Office skills in this 8-course bundle for Office 365 or Office 2019 **This course includes practice exercises and LIFETIME access**...
Excel : 2019 Microsoft Excel Beginner to Expert level course
- 0.0
-
![]()
![]()
![]()
![]()
![]()
Excel Complete A to Z Microsoft Excel 2019 Course. Excel 2007, 2010, 2013, 2016, and Office 365. Become 0 to hero !!...
