Shakti Education Institute | Graphic Design & IT Courses

Bestseller

0 rating

Certificate Course In Advance Excel and Power BI(S-CAEAPB-1797)

Last updated Oct, 2026
Certified Course

Buy Now

Enquire Now

Course Includes

Duration3 Months
Enrolled1
Lectures120
Videos0
Notes0
CertificateYes

What you'll learn

An Advanced Excel and Power BI coursehelps you transition from basic spreadsheet tracking to automated business intelligence and interactive dashboards

Course Syllabus

Advanced Excel:
Complex formulas and logical functions (IF, AND, OR, XLOOKUP, INDEX/MATCH)
Data cleaning, text manipulation, and conditional formatting
Dynamic PivotTables, PivotCharts, Slicers, and Timelines
Power Query inside Excel for automated data transformation and consolidation [1, 2, 3]
Power BI & Business Intelligence:
Connecting Excel workbooks, SQL databases, and web sources into Power BI Desktop
Data modeling, star schemas, relationships, and cardinality
Writing DAX (Data Analysis Expressions) for calculated columns and measures
Building and publishing interactive reports and dashboards via Power BI Service