MS-OFFICE-
• MS-WINDOWS
• TYPING SKILLS
• MS-WORD
• MS-EXCEL
• MS-POWERPOINT
• INTERNET & EMAIL
• SCANNING & PRINTING
• SHORTCUT KEYS
• MS-OUTLOOK
Our highlights:
• Provides demo and free trial before joining the course.
• Free software & study materials
• Individual training.
• Flexible timing.
• Job interview-oriented sessions,
• Wide range of practice worksheets.
• Improves typing skills
• Reasonable fees.
• Daily Classes
Advanced Excel - course Outline
• Dynamic Excel Dashboard
• Advanced 50+ Formulas and Functions (VLOOKUP, HLOOKUP, XLOOKUP, etc)
• Macros
• Data Validation and Conditional Formatting
• Data Sorting and Filtering
• Pivot Tables and Pivot Charts
• Advanced Charting Techniques
• Advanced Data Analysis
• Excel Templates
• Advanced Tips and Tricks.
• Short Cut keys
POWERBI Course Outline
1.Introduction to Power BI
Power BI Installation
Power BI Desktop interface overview
2.Connecting to Data Sources
Connecting to Excel, CSV, and text files
Connecting to databases (SQL Server, Azure)
3.Introduction to Power Query Editor
Data cleaning and transformation basics
Merging and appending queries
Working with unpivot and pivot operations
4. Data Modeling and Relationships
Importance of data modeling
Star schema vs. snowflake schema
Creating Relationships
5.Advanced DAX and Data Analysis
Using Time Intelligence Functions
6.Data Visualization
7. Dashbord, charts ,Slicers and Filters
8.Power BI Service and Collaboration
For free trial and more details contact us @ 97343699 /66765847 / Whatsapp.
http://www.theimperialinstitute.com/
https://www.facebook.com/imperialtraininginstitute/