Excel for Professionals (Part-2) | BYLCx
Excel for Professionals (Part-2)

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
  • 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