Advance Excel Course

by Sami Infotech Claim Listing

Advanced Excel Functions: Covers VLOOKUP, INDEX-MATCH, SUMIFS, PivotTables.Data Visualization: Includes sparklines, trendlines, and custom chart formatting.Automation: Explores macros, VBA, Power Query, and Power Pivot.Financial Modeling.

Price : Enquire Now

Contact the Institutes

Fill this form

Advertisement

Sami Infotech Logo

img Duration

6 Weeks

Course Details

Advanced Excel Functions: Covers VLOOKUP, INDEX-MATCH, SUMIFS, PivotTables.Data Visualization: Includes sparklines, trendlines, and custom chart formatting.Automation: Explores macros, VBA, Power Query, and Power Pivot.Financial Modeling: Provides training in modeling, forecasting, and valuation. Advanced Data Analysis: Covers regression, correlation, and statistical functions.

 

What You Learn:

  • Advanced Excel Functions: Covers VLOOKUP, INDEX-MATCH, SUMIFS, PivotTables.
  • Learn the basics of Java programming language, including syntax, data types, variables, operators, and control flow statements.
  • Learn the basics of Java programming language, including syntax, data types, variables, operators, and control flow statements.
  • Learn the basics of Java programming language, including syntax, data types, variables, operators, and control flow statements.

 

Curriculum:

  • Module 1: Mathematical & Statistical Functions
  • Module 2: Advanced Mathematical Functions
  • Module 3: Statistical Functions
  • Module 4: Text Manipulation Functions
  • Module 5: Text Manipulation Functions
  • Module 6: Attendance Register
  • Module 7: Text Functions And & Functions
  • Module 8: Logical Functions And Salary Sheet with Logics
  • Module 9: Financial Functions
  • Module 10: Data Validations And Invoice Creations
  • Module 11: IS Functions And Error Handling
  • Module 12: Conditional Formattings And Advanced Formatting
  • Module 13: VLOOKUP
  • Module 14: HLOOKUP
  • Module 15: LOOKUP
  • Module 16: INDEX + MATCH
  • Module 17: Date Functions And Dynamic Calendar
  • Module 18: Advanced Pivot Chart & Tables
  • Module 19: Excel Tips And Tricks
  • Navi Mumbai Branch

    Office no F21, First floor , HawarCenturion Complex Sector 19a, Near Seawoods, Nerul, Navi Mumbai

Check out more MS Excel courses in India

IDreamKraft Productions and Technologies Logo

Advanced Excel Training Course

Advanced Excel provides a good insight into the latest & advanced features that are available in MS Excel 2013. In a step-by-step manner it explains how to use a particular feature. To look impressive, Advanced Excel users know how to gather, structure & present their data.

by IDreamKraft Productions and Technologies [Claim Listing ]
STEP-GNDEC (Science & Technology Entrepreneurs’ Park) Logo

MS PowerPoint

MS PowerPoint course is offered by STEP-GNDEC (Science & Technology Entrepreneurs’ Park). Science & Technology Entrepreneurs’ Park (STEP-GNDEC), Gill Road, Ludhiana established in 1986 has been conducting successfully Entrepreneurship Awareness Camps.

by STEP-GNDEC (Science & Technology Entrepreneurs’ Park) [Claim Listing ]
Shivanya Computer Education Logo

Microsoft Access

Microsoft Access course is offered by Shivanya Computer Education. We embrace a learning environment that will prepare you for the path ahead. Our classes incorporate traditional learning styles as well as hands-on experiences.

by Shivanya Computer Education [Claim Listing ]
  • Price
  • Start Date
  • Duration
Hare Krushna Computer Education (HKCE) Logo

Microsoft Access

Microsoft Access course is offered by Hare Krushna Computer Education (HKCE). Our Aim is computer literate world, who want to build up career in computer-related fields. We provide knowledge of computers in depth as per student's requirements.

by Hare Krushna Computer Education (HKCE) [Claim Listing ]
PBA Institute Logo

MS Office

Ms. Office course trains students how to use MS Office applications use in office work such as creating professional-quality documents; storing, organizing and analyzing information; arithmetic operations and functions; and create dynamic slide presentations with animation.

by PBA Institute [Claim Listing ]
  • Price
  • Start Date
  • Duration

© 2024 coursetakers.com All Rights Reserved. Terms and Conditions of use | Privacy Policy