Excel Power Query in excel for beginners

Breadcrumb Abstract Shape
Breadcrumb Abstract Shape
Breadcrumb Abstract Shape
Breadcrumb Abstract Shape

Master importing data from diverse sources like databases, text files, and web pages using Excel Power Query
Transform and clean raw data efficiently to prepare datasets for analysis in Excel
Create and customize Power Query queries to automate data refresh and updates in Excel workbooks
Apply data filtering, sorting, and grouping techniques to organize large datasets effectively
Merge, append, and shape data from multiple sources to build comprehensive datasets in Excel
Utilize Power Query functions for data cleansing, deduplication, and error handling in Excel
Design dynamic dashboards by integrating Power Query with Excel data models for real-time insights
Enhance data analysis skills by automating repetitive data transformation tasks in Excel

كورسات من نفس التصنيف

Show More

Course Content

المحتوى

  • Excel Tutorial Beginner to Advanced 12 Hour Excel Course
    11:55:34
  • Microsoft Excel 365 Tutorial 4 Hour Beginner Excel Training Course
    04:22:11
  • 30 Essential Excel Tips and Tricks for 2024 Excel Productivity Tutorial
    02:07:11
  • 20 Excel Formulas and Functions to Master in 2024 Excel Formulas and Functions Training Tutorial
    02:31:06
  • Microsoft Excel Tutorial 2021 365 4 5 Hours of Getting Started in Microsoft Excel 2021
    04:42:13
  • Microsoft Excel Intermediate Training 2021 365 5 Hour Excel Tutorial Class
    05:09:42
  • Microsoft Excel 2021 365 Tutorial 3 5 Hours of Advanced Excel Training Course
    03:43:41
  • Microsoft Excel Tutorial 3 Hour MS Excel 2019 Course for Beginners
    03:03:16
  • 30 Awesome Excel Tips and Tricks for 2023
    02:01:41
  • Advanced Excel Tutorial Advanced Functions Course VLOOKUP IF Forecasting Statistical
    04:32:56
  • Advanced Pivot Tables Tutorial in Excel 2 5 Hour Pivot Table Excel Course
    02:43:53
  • Top Ten Excel Formulas and Functions IF VLOOKUP PMT INDEX MATCH Excel Tutorial
    52:21
  • Microsoft Excel Mac Tutorial MS Excel Mac Training Course 2 Hours
    02:10:40
  • The Ultimate MS Excel Crash Course 6 Hour Microsoft Excel 2016 Tutorial for Beginners
    06:01:56
  • Excel Power Query Course Power Query Tutorial for Beginners
    01:49:28
  • Data Cleaning in Excel Text Functions and Power Query in Excel
    01:07:32
  • VBA Excel Edit a Macro using VBA in Excel Tutorial
    46:36
  • How to Create a Stunning Interactive Dashboard in Excel Sales Excel Dashboard Crash Course
    01:54:00
  • Excel Formulas for Beginners 1 Hour Class
    01:07:31
  • The Ultimate Excel Tutorial Beginner to Advanced 5 Hours
    05:43:05
  • Dynamic Array Functions in Excel XLOOKUP FILTER UNIQUE XMATCH
    53:27
  • Advanced Excel Formulas IF IFS INDEX MATCH SUMPRODUCT XLOOKUP OFFSET CHOOSE
    59:45
  • Basic Forecasting in Excel Tutorial SLOPE INTERCEPT FORECAST LINEAR TREND Forecast Sheets
    44:57
  • Excel Tips Tricks Designing Better Spreadsheets 1 hour Excel Tutorial
    01:04:56
  • Logical Functions In Excel Tutorial IF IFS AND OR COUNTIF SUMIF Excel Formulas and Functions
    56:30
  • Creating an Interactive Dashboard in Excel Using Pivot Tables Pivot Charts and Slicers
    01:01:04
  • What If Analysis Goal Seek Scenario Manager Data Tables 1 hour Excel Tutorial
    55:16
  • Ten Excel Tips that are Easy to Learn Part 2
    41:01
  • Ten Microsoft Excel Tips and Tricks to Learn Part 3
    37:34
  • Excel 2021 365 Beginners Intermediate Training 10 Hour Excel Tutorial Class
    09:51:35
  • Using the Data Model to Create Pivot Tables 1 Hour Tutorial
    42:47
  • PivotTables for Excel A Quick 1 Hour Crash Course
    53:31
  • Cleaning Data in Excel Microsoft Excel Crash Course
    01:01:13
  • Interactive Dashboards in Excel Microsoft Excel Crash Course
    01:07:03
  • 20 Excel Tips to Improve Your Productivity
    59:59
  • How to Use the AVERAGE Function in Excel
    04:45
  • Microsoft Excel Tutorial Basic to Advanced Formulas in 2 5 hours
    02:23:28
  • Microsoft Excel Chart Formatting Tips and Tricks
    01:02:15
  • Advanced Excel Tutorial 3 Hours of Tips and Tricks
    03:21:31
  • Chat GPT Tutorial How to use ChatGPT to Convert Excel into PDF
    03:10
  • Chat GPT Tutorial How to use ChatGPT to Create VBA Scripts
    12:09
  • How to Create a Dropdown Menu in Microsoft Excel
    04:55
  • How to Create a Number Series in Microsoft Excel
    01:29
  • How to Add Emojis to Data in Excel
    04:00
  • How to Convert Numbers into Percentages in Excel
    03:15
  • How to Autofit Column Widths in Excel
    01:28
  • How to Highlight Cells or Rows with a Checkbox in Excel
    03:01
  • How to Transpose Rows into Columns in Excel
    02:00
  • How to Keep the Formula in a Cell Unchanged Using Absolute Referencing in Excel
    02:26
  • How to Combine Excel Cells Using the Sign
    01:34
  • The Top 19 Excel Hacks of 2023 Master Spreadsheets Like a Pro
    01:33:37
  • 2024 Kickstart with Microsoft Excel 11 Functions to Supercharge Your Skills
    01:42:38
  • How to Change Letter Cases in Excel Convert Text Tutorial
    02:08
  • How to Insert a Search Bar in Excel Add Search to Spreadsheet
    08:06
  • How to Add Spin Buttons in Excel Add buttons to a spreadsheet
    02:54
  • Excel Time Saving Tips
    10:07
  • Excel Mastery Calculate Days Between Dates Easily
    01:48
  • How to Filter Data with Excel Slicers
    04:59
  • How to Flash Fill in Microsoft Excel
    01:47
  • How to Use Autosum in Excel to Quickly Sum Data
    01:20
  • How to Insert Multiple Rows in Excel
    01:23
  • Ultimate Guide to Lookup in Excel VLOOKUP XLOOKUP and more
    48:09
  • Ultimate PivotTables Tutorial in Excel 365
    48:30
  • 13 Excel Top Tips and Tricks to Save You Time
    53:11
  • Top 10 Excel Formulas for Beginners
    01:31:33
  • Final Exam – Excel Power Query in excel for beginners

A course by

A

Student Ratings & Reviews

No Review Yet
No Review Yet

Course Includes:

  • Price:Free
  • Instructor:admin
  • Lessons:65
  • Students:0
  • Certifications:No

Courses You May Like

68ed73c46582d
Teclas de Atalho e Produtividade no excel
(0.0/ 0 Rating)
Free
  • 6 Lessons
  • 0 Students
Teclas de Atalho e Produtividade no excel
(0.0/ 0 Rating)
Free

Master keyboard shortcuts for efficient navigation and cell selection in Excel for increased productivity Apply formatting shortcuts to quickly enhance spreadsheet appearance and readability in...

  • 6 Lessons
  • 0 Students
Enroll Now
68ed798871dd4
Microsoft powerPoint básicos
(0.0/ 0 Rating)
Free
  • 16 Lessons
  • 0 Students
Microsoft powerPoint básicos
(0.0/ 0 Rating)
Free

Create professional PowerPoint presentations with effective slide layouts and design principles Insert and format texts, images, tables, and charts to enhance visual communication Apply themes,...

  • 16 Lessons
  • 0 Students
Enroll Now
68ed7aa3eed99
Movimento e fluxo de caixa no excel
(0.0/ 0 Rating)
Free
  • 5 Lessons
  • 0 Students
Movimento e fluxo de caixa no excel
(0.0/ 0 Rating)
Free

Create Excel spreadsheets to record cash inflows and outflows for accurate financial tracking Apply formulas to calculate daily, weekly, and monthly cash balances in Excel...

  • 5 Lessons
  • 0 Students
Enroll Now
68ed7e0b01dc1
Excel VIP básico de intermediário
(0.0/ 0 Rating)
Free
  • 1 Lessons
  • 0 Students
Excel VIP básico de intermediário
(0.0/ 0 Rating)
Free

Master creating and formatting Excel spreadsheets for professional reports and data management Apply essential formulas and functions to analyze financial, inventory, and project data efficiently...

  • 1 Lessons
  • 0 Students
Enroll Now
68ed87a9c5399
Excel básico
(0.0/ 0 Rating)
Free
  • 20 Lessons
  • 0 Students
Excel básico
(0.0/ 0 Rating)
Free

Create and format spreadsheets using Microsoft Excel for various practical applications Insert and organize data efficiently in Excel worksheets for improved data management Apply basic...

  • 20 Lessons
  • 0 Students
Enroll Now
68ed8acda44c3
Excel avançado
(0.0/ 0 Rating)
Free
  • 23 Lessons
  • 0 Students
Excel avançado
(0.0/ 0 Rating)
Free

Create complex formulas using PROCV, ÍNDICE, CORRESP, SOMASES, and logical functions for data analysis Design dynamic tables and interactive charts to visualize large datasets effectively...

  • 23 Lessons
  • 0 Students
Enroll Now
68ee646cac540
Análise de dados com o excel
(0.0/ 0 Rating)
Free
  • 8 Lessons
  • 0 Students
Análise de dados com o excel
(0.0/ 0 Rating)
Free

Master data organization, filtering, and sorting techniques to enhance Excel data analysis skills and efficiency Create professional reports using pivot tables, charts, and advanced Excel...

  • 8 Lessons
  • 0 Students
Enroll Now
68f63cd887bb6
Fundamentos de Power BI
(0.0/ 0 Rating)
Free
  • 16 Lessons
  • 0 Students
Fundamentos de Power BI
(0.0/ 0 Rating)
Free

Master data import, transformation, and modeling in Power BI for effective business analysis and decision-making Create interactive reports and dynamic dashboards using Power BI visualizations...

  • 16 Lessons
  • 0 Students
Enroll Now
68f6a51788648
Gráfico no excel
(0.0/ 0 Rating)
Free
  • 24 Lessons
  • 0 Students
Gráfico no excel
(0.0/ 0 Rating)
Free

Create various types of charts in Excel, including column, bar, line, and pie charts for data visualization Customize chart elements such as colors, labels, titles,...

  • 24 Lessons
  • 0 Students
Enroll Now
68f6b5cb36c72
Excel avançado e revisão dos conceitos
(0.0/ 0 Rating)
Free
  • 18 Lessons
  • 0 Students
Excel avançado e revisão dos conceitos
(0.0/ 0 Rating)
Free

Master advanced Excel formulas like PROCV, ÍNDICE, CORRESP, SOMASES, and DESLOC for complex data analysis and automation Create dynamic tables and interactive charts to visualize...

  • 18 Lessons
  • 0 Students
Enroll Now
68f6c6f694532
Fundamentos de PowerPoint
(0.0/ 0 Rating)
Free
  • 24 Lessons
  • 0 Students
Fundamentos de PowerPoint
(0.0/ 0 Rating)
Free

Create visually appealing PowerPoint slides with effective layout and design principles Navigate PowerPoint interface efficiently for seamless presentation creation and editing Insert and format texts,...

  • 24 Lessons
  • 0 Students
Enroll Now
68f6ceb047364
Fundamentos de microsoft word
(0.0/ 0 Rating)
Free
  • 29 Lessons
  • 0 Students
Fundamentos de microsoft word
(0.0/ 0 Rating)
Free

Create professional documents using Microsoft Word’s formatting, styles, and layout tools effectively Insert and customize tables, images, charts, and visual elements to enhance document presentation...

  • 29 Lessons
  • 0 Students
Enroll Now
68f6d192ab61e
Microsoft excel avançado
(0.0/ 0 Rating)
Free
  • 20 Lessons
  • 0 Students
Microsoft excel avançado
(0.0/ 0 Rating)
Free

Master advanced Excel formulas like PROCV, ÍNDICE, CORRESP, SOMASES, and DESLOC for complex data analysis Create dynamic reports and dashboards using PivotTables, Power Query, and...

  • 20 Lessons
  • 0 Students
Enroll Now
68f6d318304d7
Fundamentos de informática
(0.0/ 0 Rating)
Free
  • 15 Lessons
  • 0 Students
Fundamentos de informática
(0.0/ 0 Rating)
Free

Develop skills to operate computers efficiently using hardware, software, and operating systems for daily tasks Apply best practices in digital security, data storage, and safe...

  • 15 Lessons
  • 0 Students
Enroll Now
68f6d68ac4c01
Microsoft excel
(0.0/ 0 Rating)
Free
  • 21 Lessons
  • 0 Students
Microsoft excel
(0.0/ 0 Rating)
Free

Master Excel formulas and functions like SUM, AVERAGE, IF, and VLOOKUP for data analysis and reporting Create and format spreadsheets to organize financial data, control...

  • 21 Lessons
  • 0 Students
Enroll Now
68f8ec2ae2746
Raspberry Pi
(0.0/ 0 Rating)
Free
  • 36 Lessons
  • 0 Students
Raspberry Pi
(0.0/ 0 Rating)
Free

Master Raspberry Pi setup, configuration, and installation of operating systems for diverse projects Utilize Linux commands and terminal skills to manage Raspberry Pi efficiently in...

  • 36 Lessons
  • 0 Students
Enroll Now
68f8ef16b8d38
Fundamentos de linux
(0.0/ 0 Rating)
Free
  • 14 Lessons
  • 0 Students
Fundamentos de linux
(0.0/ 0 Rating)
Free

Configure and install Linux distributions for server and development environments effectively Navigate and manipulate Linux directory structures using essential commands and tools accurately Manage user...

  • 14 Lessons
  • 0 Students
Enroll Now
68f92db75e312
Fundamentos de hardware
(0.0/ 0 Rating)
Free
  • 35 Lessons
  • 0 Students
Fundamentos de hardware
(0.0/ 0 Rating)
Free

Identify computer hardware components such as motherboard, CPU, RAM, ROM, HDD, SSD, and peripherals accurately Perform computer assembly, disassembly, and upgrades with confidence and precision...

  • 35 Lessons
  • 0 Students
Enroll Now
68f9468844f98
Microsoft word essencial
(0.0/ 0 Rating)
Free
  • 22 Lessons
  • 0 Students
Microsoft word essencial
(0.0/ 0 Rating)
Free

Create professional documents using Microsoft Word’s basic formatting tools and features Apply styles, headers, footers, and page numbering to enhance document structure and readability Insert...

  • 22 Lessons
  • 0 Students
Enroll Now
68f956c020909
Como Faz soma no excel
(0.0/ 0 Rating)
Free
  • 7 Lessons
  • 0 Students
Como Faz soma no excel
(0.0/ 0 Rating)
Free

Master basic and advanced Excel sum functions like =SOMA(), SOMASE, and SUBTOTAL for efficient data analysis and financial management Apply Excel autosum (Σ) and work...

  • 7 Lessons
  • 0 Students
Enroll Now
68f957ffcae66
Pacote office
(0.0/ 0 Rating)
Free
  • 9 Lessons
  • 0 Students
Pacote office
(0.0/ 0 Rating)
Free

Create professional documents using Word with advanced formatting, styles, and images for business and academic needs Organize, analyze, and visualize data efficiently in Excel through...

  • 9 Lessons
  • 0 Students
Enroll Now
68f9595707b7a
Microsoft word
(0.0/ 0 Rating)
Free
  • 6 Lessons
  • 0 Students
Microsoft word
(0.0/ 0 Rating)
Free

Create professional documents using advanced formatting and styles in Microsoft Word Insert and customize tables, images, headers, and footers for comprehensive document design Utilize automatic...

  • 6 Lessons
  • 0 Students
Enroll Now
68f95ac07761f
Como mexer no word
(0.0/ 0 Rating)
Free
  • 59 Lessons
  • 0 Students
Como mexer no word
(0.0/ 0 Rating)
Free

Create and format professional documents using Microsoft Word tools and features effectively Navigate the Word interface confidently to access essential functions and commands Insert and...

  • 59 Lessons
  • 0 Students
Enroll Now
68f95c80063cf
Como Criar planilha no excel
(0.0/ 0 Rating)
Free
  • 8 Lessons
  • 0 Students
Como Criar planilha no excel
(0.0/ 0 Rating)
Free

Create organized spreadsheets in Excel using data entry and formatting techniques Apply basic formulas like SUM, AVERAGE, and IF for data analysis and calculations Design...

  • 8 Lessons
  • 0 Students
Enroll Now
68f95e202be66
Como mexer e usar o microsoft excel
(0.0/ 0 Rating)
Free
  • 9 Lessons
  • 0 Students
Como mexer e usar o microsoft excel
(0.0/ 0 Rating)
Free

Create and organize spreadsheets using Microsoft Excel for personal and professional tasks Apply basic formulas and functions like SUM, AVERAGE, and IF to analyze data...

  • 9 Lessons
  • 0 Students
Enroll Now
68f960b5bd315
Como aprender a usar o Pacote office
(0.0/ 0 Rating)
Free
  • 60 Lessons
  • 0 Students
Como aprender a usar o Pacote office
(0.0/ 0 Rating)
Free

Create professional documents using Microsoft Word with advanced formatting and editing skills Organize, analyze, and visualize data effectively in Excel using formulas, functions, and data...

  • 60 Lessons
  • 0 Students
Enroll Now
6907b5e641cc3
Cómo instalar windows server 11
(0.0/ 0 Rating)
Free
  • 135 Lessons
  • 0 Students
Cómo instalar windows server 11
(0.0/ 0 Rating)
Free

Master Windows Server 11 installation, configuration, and setup for enterprise and lab environments using best practices and security measures Configure BIOS/UEFI settings and prepare installation...

  • 135 Lessons
  • 0 Students
Enroll Now
6924affe978cb
Microsoft power pages
(0.0/ 0 Rating)
Free
  • 40 Lessons
  • 0 Students
Microsoft power pages
(0.0/ 0 Rating)
Free

Create secure, professional low-code websites using Microsoft Power Pages for business applications and data management Design and customize website layouts, themes, and pages with Power...

  • 40 Lessons
  • 0 Students
Enroll Now
6924b235aeec9
Uploading files to teraBox
(0.0/ 0 Rating)
Free
  • 22 Lessons
  • 0 Students
Uploading files to teraBox
(0.0/ 0 Rating)
Free

Create and manage TeraBox accounts for seamless cloud storage access Navigate TeraBox interface to upload and organize photos, videos, and documents efficiently Utilize automatic backup...

  • 22 Lessons
  • 0 Students
Enroll Now
6924b51ee129e
Handbrake
(0.0/ 0 Rating)
Free
  • 44 Lessons
  • 0 Students
Handbrake
(0.0/ 0 Rating)
Free

Master video transcoding using HandBrake for optimal quality and file size reduction Apply HandBrake presets and customize settings for various devices and platforms effectively Implement...

  • 44 Lessons
  • 0 Students
Enroll Now
6924b694917b7
VLC media payer
(0.0/ 0 Rating)
Free
  • 59 Lessons
  • 0 Students
VLC media payer
(0.0/ 0 Rating)
Free

Master navigating VLC media player interface for efficient media management and playback control Apply VLC’s advanced features such as playlist creation, media conversion, and online...

  • 59 Lessons
  • 0 Students
Enroll Now
6924ba2cb079c
Microsoft planner
(0.0/ 0 Rating)
Free
  • 34 Lessons
  • 0 Students
Microsoft planner
(0.0/ 0 Rating)
Free

Create and organize task plans using Microsoft Planner for effective project management and team collaboration Build and customize task boards with buckets, labels, and due...

  • 34 Lessons
  • 0 Students
Enroll Now
6924bc53f2326
Google Photos Interface
(0.0/ 0 Rating)
Free
  • 59 Lessons
  • 0 Students
Google Photos Interface
(0.0/ 0 Rating)
Free

Master how to navigate Google Photos interface including Photos, Search, Library, and Sharing tabs for efficient media management Utilize AI-powered organization features to automatically categorize...

  • 59 Lessons
  • 0 Students
Enroll Now
6924beab79669
Accessing Kimi AI
(0.0/ 0 Rating)
Free
  • 49 Lessons
  • 0 Students
Accessing Kimi AI
(0.0/ 0 Rating)
Free

Master how to create and manage a Kimi AI account for seamless platform access and security. Navigate Kimi AI’s interface efficiently to utilize chat, research,...

  • 49 Lessons
  • 0 Students
Enroll Now
6924e1003c71d
Accessing structured web
(0.0/ 0 Rating)
Free
  • 26 Lessons
  • 0 Students
Accessing structured web
(0.0/ 0 Rating)
Free

Identify structured data formats like Schema.org, JSON-LD, Microdata, and RDFa for web content analysis Extract structured web data efficiently using parsing tools and techniques for...

  • 26 Lessons
  • 0 Students
Enroll Now
6924ecdb3b2bc
Setting up thunderbird
(0.0/ 0 Rating)
Free
  • 121 Lessons
  • 0 Students
Setting up thunderbird
(0.0/ 0 Rating)
Free

Configure Mozilla Thunderbird installation for optimal performance and security using latest software versions and system settings Set up and manage multiple email accounts with IMAP...

  • 121 Lessons
  • 0 Students
Enroll Now
669e8624d4a92
Microsoft word advanced skills
(0.0/ 0 Rating)
Free
  • 3 Lessons
  • 0 Students
Microsoft word advanced skills
(0.0/ 0 Rating)
Free

Master advanced formatting, styles, and templates to create consistent, professional documents in Microsoft Word Utilize tables of contents, indexes, bibliographies, and layout techniques for efficient...

  • 3 Lessons
  • 0 Students
Enroll Now
6575f6f5a4fe7
Microsoft Word
(0.0/ 0 Rating)
Free
  • 46 Lessons
  • 0 Students
Microsoft Word
(0.0/ 0 Rating)
Free

Create professional documents, reports, and letters using advanced formatting and layout tools in Microsoft Word Apply spell check, grammar check, and editing features to ensure...

  • 46 Lessons
  • 0 Students
Enroll Now
6575f6f5aebd9
Microsoft Excel
(0.0/ 0 Rating)
Free
  • 49 Lessons
  • 0 Students
Microsoft Excel
(0.0/ 0 Rating)
Free

Master data entry and storage techniques using Microsoft Excel for efficient business operations Apply Excel functions and formulas to verify and analyze business data accurately...

  • 49 Lessons
  • 0 Students
Enroll Now
6575f6fa704c8
Advanced Excel
(0.0/ 0 Rating)
Free
  • 13 Lessons
  • 0 Students
Advanced Excel
(0.0/ 0 Rating)
Free

Master advanced Excel functions like macros, pivot tables, and lookup formulas for data analysis and automation skills Utilize complex formulas, including arrays and conditional lists,...

  • 13 Lessons
  • 0 Students
Enroll Now
6575f6f696c69
Power BI
(0.0/ 0 Rating)
Free
  • 31 Lessons
  • 0 Students
Power BI
(0.0/ 0 Rating)
Free

Create interactive dashboards and reports using Power BI’s visualization tools and data modeling features Connect and integrate diverse data sources, including ERP systems, for comprehensive...

  • 31 Lessons
  • 0 Students
Enroll Now
6575f6f64026e
Computers skills
(0.0/ 0 Rating)
Free
  • 25 Lessons
  • 0 Students
Computers skills
(0.0/ 0 Rating)
Free

Master effective typing, mouse skills, and fundamental computer operations for daily tasks and productivity Utilize productivity software like word processors, spreadsheets, and presentation tools efficiently...

  • 25 Lessons
  • 0 Students
Enroll Now
hqdefault-101
MS Excel
(0.0/ 0 Rating)
Free
  • 94 Lessons
  • 0 Students
MS Excel
(0.0/ 0 Rating)
Free

Spreadsheets, files and memos are necessary documents in most businesses. … Microsoft Excel and Microsoft Word are part of the Microsoft Office package of …...

  • 94 Lessons
  • 0 Students
Enroll Now
hqdefault-24
Excel Course Basic to Advanced
(0.0/ 0 Rating)
Free
  • 26 Lessons
  • 1 Students
Excel Course Basic to Advanced
(0.0/ 0 Rating)
Free

What is Excel mean? : to be superior to : surpass in accomplishment or achievement. intransitive verb. : to be distinguishable by superiority : surpass...

  • 26 Lessons
  • 1 Students
Enroll Now

Want to receive push notifications for all major on-site activities?

✕