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

Arth Training Institute Logo

Excel VBA Training

In Visual Basic for Applications (VBA), courses and tutorials cover a range of topics, from basic programming concepts to advanced techniques. Participants learn how to create, manipulate, and analyze data using VBA macros and objects.

by Arth Training Institute [Claim Listing ]
ICS India Group of Institutions Logo

Advanced Excel

Advanced Excel course is offered by ICS India Group Of Institutions. The goal of ICS Group of Institutions is to mould the student in the right way as they can analyze themselves and explore the hidden talents and helps the existing talents improved.

by ICS India Group of Institutions [Claim Listing ]
Gurukull Infosystems Logo

Microsoft Office Training

We do offer Fast-Track MS Office Training and One-to-One MS Office Training. Every topic will be covered in a mostly practical way with examples. Gurukull Infosystems is located in Bathinda. We are the best Training Institute that offers certification-oriented MS Office Training.

by Gurukull Infosystems [Claim Listing ]
NICE (National Institute of Computer Education Pvt. Ltd) Logo

MS Access

MS Access course is offered by NICE (National Institute of Computer Education Pvt. Ltd). NICE-National Institute of Computer Education Pvt. Ltd., is one of the Pioneer Computer Training Institute of the Country setting quality standards for ‘IT Education’.

by NICE (National Institute of Computer Education Pvt. Ltd) [Claim Listing ]
Seldom India Technologies Logo

MS PowerPoint & Presentation Skills

MS PowerPoint & Presentation Skills course is offered by Seldom India Technologies for all skill level. We have a pool of Enthusiastic and Charismatic Trainers with us, who imbibe the finer aspects of the skills in the candidates subconsciously.

by Seldom India Technologies [Claim Listing ]

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