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

Career Edge Logo

Office Automation & Internet Course

Office Automation & Internet course is offered by Career Edge. With our expert Curriculum and Product Development team, Career Edge courseware is structured to offer courses for basic/beginner through to advanced levels which is of highest clarity & standard.

by Career Edge [Claim Listing ]
Shekhawati Classes And Computer Logo

MS Office

This course provides an overview of Microsoft applications including Windows, the Office Suite: Word, PowerPoint, Excel, Access, and Outlook. ... Students will need to follow oral and written directions and demonstrate good work habits to be successful in the course.

by Shekhawati Classes And Computer [Claim Listing ]
Matha Education Logo

MS Office

MS Office course is offered by Matha Education. Matha Education Statebank is a place where people of different ages gain education. Which is established in the year 2001. Past from many years we have been bagging with highest result with Distinction in Dakshin Kannada in private SSLC & II PUC.

by Matha Education [Claim Listing ]
IT Pathshaala Logo

Advance Excel

Advance Excel course is offered by IT Pathshaala. IT Pathshaala implements a blend of academic learning and practical sessions to give the student optimum exposure that aids in the transformation of naive students into thorough professionals that are easily recruited within the industry.

by IT Pathshaala [Claim Listing ]
DASVM Logo

Microsoft Visio

Visio is a drawing and diagramming program that includes a variety of pre-drawn shapes and picture elements that can be dragged and dropped onto the illustration. Users can define their own elements and place them onto the Visio palette.

by DASVM [Claim Listing ]

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