Course Content
Certificate Course on Advanced Excel Training
About Lesson
  • What is Power Query?
  • Understanding the Power Query Interface
  • Importing Data from Multiple Sources
    • Excel: Importing structured data from another Excel workbook.
    • CSV and Text Files: Loading data from flat files.
    • Web Data: Pulling in data from web tables (e.g., stock data, sports stats).
    • Databases: Importing data from SQL Server or other databases.
    • Folder Data: Importing & combining data from a folder