Excel & Power Queries Training

INR 19,999 Now @ INR 5,499/- only

Excel & Power Queries Course teaches you how to automate tasks, streamline workflows, and handle complex data efficiently using Excel's & Power Queries. This course is crucial for enhancing productivity and accuracy by enabling the creation of custom formulas, queries and functions. Mastering Excel and Power Queries helps professionals save time, reduce errors, and gain advanced data analysis skills. It is particularly beneficial for roles involving data management, reporting, and automating and transforming repetitive tasks.

Enroll Here

Excel Training Content

Excel (Introduction)

  • Excel & History

  • Basic Terminology of Excel

  • Spreadsheet Environment

  • Object Model of Excel

  • Different Versions of Excel

  • Different File Formats and when to use

  • Excel User Interface

  • Customization of Quick Access Toolbar

Excel (Basics)

  • Clipboard Group

  • Font Group

  • Alignment Group

  • Data Types in Excel

  • Number Group

  • Number Formatting & Advanced Techniques

  • Change default number settings

  • Conditional Formatting Cell Styles & Cells

  • Format as table

  • Fill Options & Clear Options

  • Find & Select

Excel (Advanced)

  • Formulas (Data & Time, Text functions, Logical Functions, Mathematical Functions, Statistical Functions, Information Formulas, Lookup & Ref, Cell Reference Styles)

  • Report Designs

  • Dynamic & Conditional formatting using formulas

  • Illustrations

  • Sparklines

  • Filter Options & Insert Options

  • Print Report Techniques (Themes, Page Setup, Scale to Fit, Sheet options, Arrange objects)

  • Techniques to Execute Formulas

  • Auditing Formulas

  • Calculation Options

  • Data Management (connecting external applications, Sort & filter, Data tools, Data validation, Forecast, Outline)

  • Data Protection (Spell check, Protection options, Comments, Notes)

  • Data View (Workbook view, Show/hide)

  • Zoom, create new window, arrange workbooks, split worksheet screen, switching, side by side

  • Data Analysis & Visualization (Pivot Tables, Charts, Dashboards)

Introduction to Power Query

  • What is Power Query

  • Benefits of Power Query in Data Transformation

  • Understand ETL Process

  • Power Query Vs Excel Formulas Vs VBA

  • Navigating the Power Query Editor Interface

Getting Started with Power Query

  • Importing data from various sources (Excel, CSV, Text files, Databases, Web and APIs, SharePoint)

  • Understanding Query Dependencies & Applied Steps

  • Working with Query Settings and Pane

Data Transformation Basics

  • Renaming, Removing & Reordering Columns

  • Changing Data Types

  • Filtering and Sorting Data

  • Removing Duplicates & Handling Missing Data

  • Splitting & Merging Columns

  • Using "Group By" for Summarization

Advanced Data Transformation Techniques

  • Pivot & Unpivot data

  • Creating custom columns with formulas

  • Conditional columns and Logic operations

  • Working with Parameters & Input variables

  • Using Merge Queries (Joins) for Combining Data

  • Using Append Queries to Stack Data

Power Query M Language Basics

  • Introduction to M Language

  • Writing basic M code

  • Understanding Power Query Formula Bar

  • Modifying existing queries with M

  • Commonly used M functions

  • Creating Custom functions in M

Performance Optimization in Power Query

  • Best Practices for Efficient queries

  • Reducing load time and memory usage

  • Avoiding common performance pitfalls

  • Using buffering to optimize queries

Automating workflows with Power Query

  • Refreshing queries automatically

  • Creating dynamic reports with Power Query

  • Parameterizing queries for user input

  • Connecting Power Query with PowerBI & Excel Dashboards

Real-world Case Studies & Hands-on Projects

  • Cleaning and preparing financial data

  • Sales and marketing data analysis

  • Automating monthly reports with Power Query

  • Creating a data model for Business Intelligence

  • Troubleshooting & Debugging Power Query issues

Power Queries Training Content

  • Gain Deep Expertise: Master Excel and Power Queries to automate complex tasks and enhance productivity.

  • Stand Out: Enhance career prospects and distinguish yourself with advanced Excel & Power Query Automation skills.

  • Drive Cost Savings: Learn to optimize data handling processes and reduce operational costs.

  • Lead Projects: Develop leadership skills to manage and mentor teams on Excel & Power Queries automation.

  • Competitive Salary: Earn an average salary ranging from ₹6 lakhs to ₹20 lakhs per year with potential for more.

  • Best Price for College Students: 75% discount on Course Fee (INR 4,999/- only) with comprehensive learning benefits.

  • Best Price for Working Professionals: 73% discount on Course Fee (INR 5,499/- only) with comprehensive learning benefits.

What's In It For YOU?

  • Weekday Batch: 8:00am IST to 10:00am IST (Monday to Friday - 2 Hours Daily X 20 Days)

  • Total Course Duration in Hours: 40 Hours

  • Training Material: Included

  • Training Method: Virtual (Live) Instructor Led by Certified Trainer & an Experienced Industry Professional

  • Training Platform: Microsoft Teams

  • Live Project / Project Support: Optional with an extra fee of INR 1,999 per hour

Enroll Here

Training Information

For Project Support
For Corporate Training
Why Limited Participants