- Регистрация
- 27 Авг 2018
- Сообщения
- 35,757
- Реакции
- 465,802
- Тема Автор Вы автор данного материала? |
- #1
![Microsoft-Excel-Beginner-and-Intermediate-with-Certificate.jpg](https://coursedrive.org/wp-content/uploads/2019/12/Microsoft-Excel-Beginner-and-Intermediate-with-Certificate.jpg)
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
- Microsoft Excel
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
- 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
- Intermediate
- Advanced
- Anyone interested in harnessing the power of Microsoft Excel
- Mac users
- Beginner
DOWNLOAD: