Description

Power Query

Free tool part of Excel and Power BI What is it for? Automate manual and repetitive tasks Solve data analysis problems that require complex formulas Easy to import and transform data in ways Excel finds hard Designed to pull data from a source Modify it Return the modified version What you can do with Power Query?

Import data from different sources Transform and clean data Load data as a basis for reports Import data from different sources

Another workbook Text file Folder Sharepoint drive Databases … Example

Can make a PivotTable from 50 million records Power Query Editor

Graphical script editor Part of Excel and Power BI Course Curriculum

Advanced topics in Power Query and M. Experience

Excel experience recommended No Power Query or programming experience required Programming experience will help What You’ll Need

A PC computer Power Query isn’t available on Excel for Mac What You’ll Need

A free trial or paid license of Excel https://go.microsoft.com/fwlink/p/?LinkID=403802

• 1. 01b (Prerequisite) Introduction to Solidity
  • How to Build Smart Contracts Online | Introduction To Ethereum Remix Ide-1

    8:12

  • Build Your First Solidity Smart Contract | 01 Build Your First Contract

    8:49

  • Build Your First Solidity Smart Contract | 02 Change A State Variable Value

    5:56

  • Build Solidity Variables | 01 Build A Local Variable

    4:28

  • Build Solidity Variables | 02 Build State Variables Of Different Data Types

    10:55

  • Build Solidity Variables | 03 Build A Custom Data Type With A Struct

    4:48

  • Build Solidity Arrays | 01 Build Arrays

    11:08

  • Build Solidity Arrays | 02 Build Array Functions

    6:17

  • Build Solidity Mappings | 01 Build A Mapping

    6:20

  • Build Solidity Mappings | 02 Build A Database-Like Mapping

    7:43

  • Build Solidity Mappings | 03 Assign Ownership To Individual Ethereum Addresses

    5:00

  • Build Solidity Conditionals and Loops | 01 Build A Conditional

    6:58

  • Build Solidity Conditionals and Loops | 02 Build A Loop

    9:25

  • Send Ether | 01 Send Ether

    8:31

  • Build Smart Contracts | 00 Build A Profit Splitter Contract

    11:48

  • Build Smart Contracts | 01 Build A Contract With Limited Addresses

    11:41

  • Build Smart Contracts | 02 Build A Contract And Library

    15:01

  • Build Smart Contracts | 03 Build A Contract With A Limited Time Transaction

    10:21

  • Build Smart Contracts | 04 Build Contracts With Inheritance

    13:22

  • Build Smart Contracts | 05 Build Contracts With Visibility Modifiers

    10:50

  • Build Smart Contracts | 06 Build A Contract With Mutability Modifiers

    10:21

  • Build Smart Contracts | 07 Build An Abstract Contract

    13:09

  • Build Smart Contracts | 08 Build A Bank Contract

    9:26

  • Build Smart Contracts | 09 Access Struct Value

    4:14

• 2. 02 How to Build Smart Contracts Online
  • 01 Introduction To Ethereum Remix Ide

    8:12

• 3. 03 Build Your First Solidity Smart Contract
  • 01 Build Your First Contract

    8:48

  • 02 Change A State Variable Value

    5:56

• 4. 04 Build Solidity Variables
  • 01 Build A Local Variable

    4:29

  • 02 Build State Variables Of Different Data Types

    10:55

  • 03 Build A Custom Data Type With A Struct

    4:47

• 5. 05 Build Solidity Arrays
  • 01 Build Arrays

    11:08

  • 02 Build Array Functions

    6:18

• 6. 06 Build Solidity Mappings
  • 01 Build A Mapping

    6:20

  • 02 Build A Database-Like Mapping

    7:43

  • 03 Assign Ownership To Individual Ethereum Addresses

    4:59

• 7. 07 Build Solidity Conditionals and Loops
  • 01 Build A Conditional

    6:58

  • 02 Build A Loop

    9:25

• 8. 08 Send Ether
  • 01 Send Ether

    8:32

• 9. 09 Build Smart Contracts
  • 01 Build A Contract With Limited Addresses

    11:41

  • 02 Build A Contract And Library

    15:01

  • 03 Build A Contract With A Limited Time Transaction

    10:21

  • 05 Build Contracts With Visibility Modifiers

    10:50

  • 00 Build A Profit Splitter Contract

    11:49

  • 06 Build A Contract With Mutability Modifiers

    10:21

  • 07 Build An Abstract Contract

    13:10

  • 08 Build A Bank Contract

    9:26

  • 09 Access Struct Value

    4:14