Power Query in Excel

Posted on 2014-08-14

7,894 Points

0 Comments

1,394 Views

5 Endorsements

Last Modified: 2014-08-26

Published

Experience Level: Beginner

5:18

Zack Barresse

Love Excel, shiny new things, my family, gaming, and general cool stuff. Oh, and being awesome. #hashtagsmatter

Viewers will learn a basic data manipulation technique of unpivoting data in Power Query for Excel 2013 and the importance of using good data.

Video Steps

1. Start with data in a poor structure

2. Create a table on your data

3. Unpivot columns

4. Rename columns

5. Apply query and close editor

6. Summarize data in newly created table

Author:Zack Barresse

0 Comments

Suggested Videos

Title	Views	Activity
Two Ways of Removing Middle Names From A List	3	2024-01-17
Comparing Values of Two Lists in Excel	6	2024-03-16
Why You Should Use Excel’s Sumproduct Function	1	2023-11-03
How to use the new SCAN function in Excel	9	2024-04-02

Storing passwords in VBA using the Microsoft NG Cryptography (CNG) API

Article by: Gustav

This article series will show you how to utilise the Next Generation Cryptography (CNG) API from Microsoft for modern hashing and encrypting/decrypting in VBA. In this part: Handling passwords.