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

Indira Technical Institute Logo

Microsoft Office

Microsoft Office course is offered by Indira Technical Institute. The skill level and educational attainment of the work force determines the productivity, income levels as well as the adaptability of the working class in changing environment.

by Indira Technical Institute [Claim Listing ]
Vedanta Computer Training Institute Logo

MS PowerPoint

MS PowerPoint course is offered by Vedanta Computer Training Institute. We have a team of highly experienced trainers for computer classes in Patna that are expert in the field of providing quality education in various courses of the computer.

by Vedanta Computer Training Institute [Claim Listing ]
Speakeng India Logo

Basic Computer

Basic Computer Course is Offered by Speakeng India.

by Speakeng India [Claim Listing ]
AWT Education (Abstract Web Technologies) Logo

MS Office

MS Office course is offered by AWT Education (Abstract Web Technologies). AWT Computer Institute, is the best computer education institute in Bhubaneswar, ICI is committed to providing students with the latest technologies and expertise to prepare them for a successful career.

by AWT Education (Abstract Web Technologies) [Claim Listing ]
Webnet Computer Institute Logo

Advance Excel

Advance Excel course is offered by Webnet Computer Institute.Webnet Computer Institute training in Nagpur offers training courses in IT software, Computer Hardware & Networking and Management with strong base of placement support, real-time trainers with working experience in MNC companies.

by Webnet Computer Institute [Claim Listing ]

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