Banner

Advanced Excel & Power BI Course Training in Patna, Bihar

Learn Advanced Excel, VBA, Power Query, Power BI and DAX in Patna, Bihar through practical training designed for MIS reporting, data analysis and data visualization career opportunities. Skills On Click is an Excel & Power BI Training Institute in Patna, Bihar, offering quality training at reasonable fees. Please note that placement support is not included with this skill-upgrade course.

About Our Advanced Excel & Power BI Course - Learn Advanced Excel Formulas, Pivot Tables, Power Query, VBA Macros, Power BI and DAX for MIS reporting, data analysis and business intelligence-related tasks. This is a skill-upgrade course and does not include placement support. Placement support is not provided for this course. To become eligible for placement support, learners must enroll in a course with a minimum duration of 2 months, subject to the applicable placement support terms, eligibility requirements and conditions.

Jobs Roles Targeted - MIS Executive, Data Analyst, Reporting Analyst, Excel Expert, BI Developer and other Excel, reporting and data analytics-related roles.

Pre-requisites - Basic Excel knowledge

Duration - 2 months

Workshop & Corporate Training - Available

Syllabus

  • Excel Interface & Shortcuts
  • Cell References - Relative, Absolute, Mixed
  • Named Ranges
  • Data Formatting & Custom Formats
  • Sort, Filter & Advanced Filter
  • Conditional Formatting with Formulas
  • Data Validation & Drop-Down Lists
  • Protecting Sheets & Workbooks

  • IF, Nested IF, IFS
  • AND, OR, NOT
  • SUMIF, SUMIFS, COUNTIFS, AVERAGEIFS
  • VLOOKUP, HLOOKUP, XLOOKUP
  • INDEX & MATCH
  • OFFSET, INDIRECT, CHOOSE
  • Text Functions - LEFT, RIGHT, MID, TRIM, CONCAT, TEXTJOIN
  • Date & Time Functions
  • Error Handling - IFERROR
  • Array Formulas & Dynamic Arrays
  • FILTER, SORT, UNIQUE

  • Pivot Table Creation & Grouping
  • Calculated Fields & Items
  • Slicers & Timelines
  • Pivot Charts
  • Power Query - Import & Transform
  • Merge & Append Queries
  • Unpivot & Data Cleaning
  • Power Pivot & Data Model Basics
  • Interactive Excel Dashboard Project

  • Macro Recording
  • VBA Editor Introduction
  • Variables & Data Types
  • If-Else Statements & Loops
  • Range & Cells Objects
  • MsgBox & InputBox
  • User-Defined Functions
  • Automating Reports
  • Simple UserForm
  • Error Handling in VBA

  • Power BI Desktop Overview
  • Data Import & Power Query in Power BI
  • Data Modeling & Relationships
  • DAX Basics - Calculated Columns & Measures
  • CALCULATE, FILTER, ALL
  • Time Intelligence - YTD, MTD, YoY
  • Visuals, Slicers & Bookmarks
  • Drill Down & Drill Through
  • Publishing & Sharing Reports
  • Final Dashboard Project

  • Weekdays (Monday, Tuesday, Thursday & Friday)
    • Option 1 – 2 months - 1.5 to 2 hrs/day
    • Option 2 – 1.5 months – 2 to 2.5 hrs/day
  • Weekends (Saturday & Sunday)
    • Option 1 – 2.5 months - 2 to 2.5 hrs/day
    • Option 2 – 2 months - 2.5 to 3 hrs/day

Yes, a free demo session is available before enrollment.

Online Live Training

  • ✅ Online Live Interactive Lectures conducted on Microsoft Teams, Googlemeet etc. & not pre-recorded lectures.
  • ✅ 1-2-1 Online Doubt Solving via screen share.
  • ✅ Free Lecture / Free Demo / Lecture Recordings available.
  • ✅ Fees Applicable to new enrollments only

Today's Offer

Fees can rise anytime, latest fee apply

Fees

Advanced Excel, VBA, Power Query, Power BI ₹28,000 ₹8,999


Pay ₹8,999

✅ Emi available.

✅ Fees in INR, International students, kindly convert fees in your currency.

Weekday/Weekend Batches available

Classroom Training

  • ✅ Interactive Classroom Sessions, Hybrid Learning Mode available.
  • ✅ Please submit inquiry form or visit institute for fees and batches.

Notify Offers & Batches

Get notified about current and future Online and Offline Offers & Batches on Mail / Whatsapp

Contact Us

Opening

Mon to Fri - 10am to 6pm, Sat & Sun Closed.

Call Us

+91 9990300349

Email

[email protected]

Address

House No. 1, First Floor, Road No. 16, Rajiv Nagar, Patna, Bihar 800024

Overall 1000+ Companies for Placements
(few mentioned below)

Google

Microsoft

Amazon

Flipkart

Infosys

TCS

Wipro

Accenture

Capgemini

Google

Microsoft

Amazon

Flipkart

Infosys

TCS

Wipro

Accenture

Capgemini

FAQs

Best Institute for IT Training & Placements, Students & Corporate Trainings, Excellent Feedback on Google, since 2014.
Training Modes - Live Online and Classroom
Trained Globally - With reach in 650+ locations on Google globally, we have trained students both in India and globally from countries like US, UK, Germany, Dubai etc.
Live projects - ProposalFinder.com, BiodataKing.com, theVibrantBirdie.com etc.
Corporate trainings delivered - To organizations like GeBBS Healthcare, PDG Softwares, NVest solutions etc.
Training Programs:
⇒ 100% job placement - limited training programs, applicable only where mentioned.
⇒ 100% job oriented or 100% job placement assistance or 100% placement support - all courses and training programs of min 2 months duration - end to end placement support until you get job until 15 months (more than sufficient).
Note - Either training programs - placement process and training facilities remains same because for us all students are same.
Best Placement Service:
⇒ 1000+ companies
⇒ Dedicated HR for placements
⇒ For quick results, placement support starts in ongoing training (criteria-based) or by default on completion.
⇒ As a result, lots of students got placed in ongoing training or within just 30 Days of completion of training!! Check photos with company names on placement page.
Other Benefits:
⇒ 1-on-1 Attention & Doubt Solving
⇒ Live Projects / Case Studies
⇒ Comprehensive Syllabus
⇒ Interview Preparation
⇒ Resume Building
⇒ Reasonable Fees
⇒ Installments available
⇒ FREE Demo

You can be the Next Placed Student



Each batch has limited students for better learning.

Recorded sessions will be available to all students.

We support interviews, resume building, and company referrals.

Yes, a free demo session is available before enrollment.

What Our Students Say

Your Journey to Success Begins Here
Enroll > Learn > Succeed