Doing common Excel tasks in Google Sheets

Posted on
3,008 Points
Last Modified:
Experience Level: Intermediate
Bob Flisser
Bob Flisser has authored many courses and books about Microsoft, Adobe and Apple products, and has been a computer trainer since the 1980s.
Between the Sheets podcast, episode 2

If you’re familiar with Excel and want to use Google Sheets, you’ll find that it looks very familiar. But it’s not always obvious where the tools and menu items you want are, and some of the features work a little differently than in Excel. In this episode, we look at the features you’re most likely to use.
Author:Bob Flisser
Windows Explorer lets you open archive (tar and tgz) files like any other folder. In VBA you can easily handle normal files and folders, but opening and indeed creating archive files takes a little more - and that you'll find here.
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.

Keep in touch with Experts Exchange

Tech news and trends delivered to your inbox every month