ADVANCED EXCEL

• Marksheet
• Salarysheet
• Attendance Sheet
• EMI Chart
• Conditional Formattin
• Charts
• Flash Fill
• Subtotal
• Filtering Data
• Name Manager
• Advance Filter
• Data Validation
• Vlookup
• Hlookup
• Xlookup
• Pivot Table
• Pivot Charts
• Field List
• Slicer
• Timeline
• Report Connection
• Freeze Panes
• Macro
• If Function
• SumIf Function
• CountIf Function
• CountIfs Function
• Invoice
• VBA Code
• ChatGPT In Excel

POWER BI

• Interface Overview
• Connect to Data
• Data Transformation
• Power Query Editor
• Data Modeling
• Create Relationships
• Measure Creation
• DAX Functions
• Build Dashboards
• Create Reports
• Visualize Data
• Use Slicers
• Drillthrough Setup
• Interactive Charts
• Publish to Web
• Export to PDF
• Data Refresh Setup
• Custom Visuals
• Filter Pane Use
• Report Sharing
• Calculated Columns
• Row Level Security
• Data Types Setting
• Manage Relationships
• Conditional Formatting
• Use Bookmarks
• Sync Slicers
• KPI Indicators
• Matrix and Table
• Map Visualizations
• Q&A Visual Use
• Tooltip Customization
• Performance Analyzer
• Mobile View Design
• Workspace Management
• Dataset Management
• Paginated Reports
• Power BI Service
• Embed Reports
• Scheduled Refresh

PYTHON BASIC & ADV.

• Intro
• Environment Setup
• Syntax
• Comments
• Variables
• Data Types
• Operators
• Lists/Tuples
• Control Statements
• Functions
• Arrays
• OOP
• Classes / Objects
• Try...Except
• String Formatting
• User Input

FILE HANDLING

• Read Files
• Write/Create Files
• Delete Files

MY SQL

• What Is Database
• DBMS vs RDBMS
• What Is SQL
• Syntax
• Select
• Select Distinct
• Where
• Order By
• And
• Or
• Not
• Insert Into
• Null Values
• Update
• Delete
• Min & Max
• Count
• Sum
• Avg
• Like
• In
• Between
• Joins
• Group By
• Having
• Exists
• Any
• All
• Select Into
• Insert Into Select
• Primary Key
• Foreign Key
• Unique Key

• Null Functions
• Comments

TABLEAU

• Introduction to Tableau
• Installation & Interface Overview
• Connecting to Data Sources
• Types of Data in Tableau
• Dimensions and Measures
• Data Types and Field Properties
• Working with Extracts and Live Connections
• Data Blending and Joins
• Basic Charts – Bar, Line, Pie, etc.
• Advanced Charts – TreeMap, Histogram, Bullet, etc.
• Cross Tabs and Highlight Tables
• Dual-Axis and Combined Axis Charts
• Calculated Fields and Table Calculations
• Parameters and Filters
• Groups, Sets, and Hierarchies
• Sorting and Aggregation
• Mapping and Geographic Visualization
• Custom Geocoding
• Dashboards and Storytelling
• Dashboard Actions and Filters
• Using Containers and Layouts
• Publishing Dashboards to Tableau Public/Server
• Interacting with Tableau Server
• Data Security and Permissions
• Performance Optimization Techniques
• Best Practices in Dashboard Design
• Real-time Project & Case Studies
• Tableau Certification Guidance