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

Epitome Logo

MS Access

MS Access course is offered by Epitome. Epitome with its various IT & Vocational Training courses ensures to produce of skilled individuals, with skills that can fetch them gainful employment.

by Epitome [Claim Listing ]
ATEES Industrial Training (AIT) Logo

Advanced Excel Course

Explore while working on Advanced Excel and speed up your productivity, to perform complex calculations, perform data analysis, and much more. Candidates could avail of Advanced Excel Course in Thrissur, from ATEES Industrial Training.

by ATEES Industrial Training (AIT) [Claim Listing ]
Inspire Training Academy Logo

MS Access

A database management system (DBMS) for data organization, storage, and retrieval that provides a convenient way to enter, navigate and report your data of any kind.

by Inspire Training Academy [Claim Listing ]
Cyberoism Logo

Advanced Excel

Advanced Excel course is offered by Cyberoism. We provide wide range of Training Programs to improve the skills and competency of Employees, Individuals, Organizations etc.

by Cyberoism [Claim Listing ]
Dream Class Education Logo

Office Automation (Microsoft Office)

Office Automation (Microsoft Office) course is offered by Dream Class Education. We offer comprehensive classroom and online preparation courses for study exams. We have two centers Surat cities in India.

by Dream Class Education [Claim Listing ]

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