Excel for Professionals (Part-2)
Microsoft Excel is the most powerful tool in the corporate world. Excel can reduce your effort in every industry, including sales, finance, marketing, engineering, supply chain, HR, and administration.
This Part-2 of the FREE “Excel for Professionals” online course is designed for advanced users of Microsoft Excel. You will be introduced to more complex Excel functions, data visualization techniques, and presentation tools in this part.
Last Update | 08/23/2022 |
---|---|
Completion Time | 4 hours 22 minutes |
Members | 3480 |
-
-
Free preview
-
-
Logical Function
-
Free preview
-
Free preview
-
04. AND Function
-
05. OR function
-
06. COUNTIF & COUNTIFS function
-
07. SUMIF & SUMIFS function
-
08. IFERROR function
-
-
Data Finding Function
-
09. VLOOKUP
-
10. HLOOKUP
-
11. Index - Match
-
-
MS Excel Advance
-
12. Pivot Table
-
13. Slicer
-
14. Data Analysis tool pack
-
15. Goal Seek
-
16. Solver
-
17. Power Query
-
18. Error Handle
-
-
Data Visualization
-
19. Pie Chart
-
20. Bar Chart, Column Chart and Histogram
-
21. Combo Chart , Pivot Chart
-
22. Tree map
-
-
Dashboard
-
23. Dashboard Making
-
-
Keyboard Shortcuts
-
24. Keyboard Shortcuts
-
-
Resource Files
-
Excel for Professionals: Resource File
-
Assessment and Certificate
-