Advance Excel

Duration:-  2 Months

IICE માં છોકરીઓ માટે 70%, SC/ST/OBC માટે 60%, અને સામાન્ય વર્ગ માટે 40% સબસીડીની સ્કીમ ઉપલબ્ધ છે.

Check Scholarship Fees
Adv. Excel

Advance Excel Syllabus

Detailed syllabus for Advance Excel.

Advance Excel
  1. Create outlines in Excel
  2. Create your own templates
  3. Work with Sparklines
  4. Create and manage scenarios
  5. Use Goal Seek and Solver
  6. Create, manage, and format pivot tables
  7. Use the Excel mathematical functions
  8. Create and write complex formulas
  9. Perform data Lookups
  10. Create and use IF statements
  11. Use Excel's data functions
  12. Create and use data validation rules
  13. Apply custom and Prebuilt conditional
  14. Formatting
  15. Link and consolidate Worksheets & workbooks
  16. Create and use macros
  17. Troubleshoot and audit formulas
  18. Create pivot tables and pivot charts
  19. Use queries to import external data
  20. Import and clean data
  21. Troubleshoot errors

Admission Guidance

Talk to our career counsellors and build a strong future ahead..

    captcha

    IICE-LOGO

    Visit Our Institute

    2nd Floor 209-210, Sunrise Point Near Hanuman Temple, Opposite Raopura Bus Stop, Vadodara.

    Popular Courses

    Mobile No :

    +919227100665

    Email Id :

    iicebaroda@gmail.com