1. USA
  2. Professional
  3. IT Training
  4. Microsoft 365 (Office)
  5. MS Excel

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

Sami Infotech is a renowned Computer Institute, well known for providing education in the field of computers since 2007 in advanced fields like programming, graphic designing, animation, coding, development, accounting, and digital marketing.

Currently, these are the vast growing learning sector and as job-providing sector.

We believe in shaping the lives of students or candidates by not only offering them professional courses but also giving placement assistance in the same field.

Sami Infotech ventures into professional course training, an online exam center, and a placement center for candidates. Having partnered and worked with some of the leading names across Education, IT, IT&ES, Banking, Insurance, Aviation, Retail, Healthcare, and Hospitality sectors. SÁMI INFOTECH has explored business opportunities in software solutions with the Government, Corporate, and Institutes.

Over years of experience, we create and deliver high-impact solutions, enabling our clients to achieve their business goals and enhance their competitiveness. We are imparting training for various computer courses for students and academic courses.

View Detailed Profile

  • Navi Mumbai Branch

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

About Coursetakers.com

Coursetakers.com is more than a decade old course aggregator and Online course platform that helps students find courses and compare course prices from Training providers in the USA, by just submitting their inquiry through the website. Coursetakers also helps Institutes, Universities and Online Instructors market their courses, gain leads and get more students to enroll into their courses.

  • Instagram
  • Facebook
  • Twitter

Courses

Quick Links

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

Ask Us?