Explore Excel on Experts Exchange

Expert Solutions for Your Tech Problems

ExcelMicrosoft Excel

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user int...

Read more
  • 142K Content
  • 12K Contributors

Expert Spotlight
Author

Bob Flisser has authored many courses and books about Microsoft, Adobe and Apple products, and has been a computer trainer since the 1980s.

Advice Solution

Excel Table for NZ Lotto with Main and Expenses Tab

bysimon
111

Lotto draw results excel file below updated till 30/3/22 .

30MarDraw Results.xlsx


I have created a

Article

How to quickly and accurately populate Word documents with Excel data, charts, and images (including Automated Bookmark generation)

32
How to quickly and accurately populate Word documents with Excel data, charts and images
Video
Post

The Course of the Month for May: Comp TIA A+!  Prepare for …

The Course of the Month for May: Comp TIA A+!
Prepare for the 220-901 & 220-902 exams in the month…
Video
Article

Getting your EE Ranking statistics in Excel

byQlemo
90
The code described here does no longer work. Please see replacement Article:
Troubleshooting Solution

Add One or Two draws,   Copy N Paste,  Font Resize and Keyboard Shortcut

bysimon
94

Adding One or  Two draws option

Apart from entering 4 draws per day manually,  if you could kindly

Video
Video
Video
Video
Article

Six Reasons Why Your VLOOKUP or HLOOKUP Formula Does Not Work

21
by Patrick G. Matthews


Introduction

VLOOKUP is a tremendously useful function …
Troubleshooting Solution

Manual Addition of Draws

bysimon
73

Keno draws file are uploaded by the Lotto Server only twice a week on Thursday and 

Sunday.   However

Article

Utilise Microsoft's Next Generation Cryptography (CNG) API in VBA

2
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: Compatible with other environments.
Article

Hashing in VBA using the Microsoft NG Cryptography (CNG) API

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: Hashing.
Article

Encryption in VBA using the Microsoft NG Cryptography (CNG) API

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: Encryption.
Article

Storing encrypted data in Microsoft Access

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.
Article

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

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.
Article
Oh no

A Guide to Writing Understandable and Maintainable VBA Code

14
This article describes some techniques which will make your VBA or Visual Basic Classic code easier to understand and maintain, whether by you, your replacement, or another Experts-Exchange expert.
Video

Do more with Experts Exchange.


Get Answers

Join a Group Discussion

Collaborate

Monitor your Site

Explore solutions and more