<

Power Query in Excel

Posted on
7,892 Points
0 Comments
1,392 Views
5 Endorsements
Last Modified:
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

5
Author:Zack Barresse
0 Comments
Storing encrypted data in Microsoft Access
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: Storing hashed or encrypted data.
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.

Keep in touch with Experts Exchange

Tech news and trends delivered to your inbox every month