Aeternus Consulting Blog
Hello, We are Aeternus Consulting
We like to put our tentacles into a lot of things. We teach, consult, design presentations and develop VBA applications & websites.
Blog Articles
Excel infographics for XLOOKUP Part 1
Purpose of this Excel Infographics for XLOOKUP Infographics (information + graphics) use visuals and text to highlight key information and ideas. The overall goal of infographic
Excel Infographics for VLOOKUP
This is an infographic on the Excel function VLOOKUP. VLOOKUP is a super useful function when you need to find things in a table or a range by row.
Great Art Pixelated with Excel VBA
You can create beautiful pixelated artworks with this Excel VBA application! There are creative ways to use it. Create unique avatars for Zoom meetings or WhatsApp!
How to use Windows API in VBA (2021 edit)
The Windows Application Programming Interface (Windows API) is a set of functions from the Microsoft Windows operating system that are available to Windows programmers.
Fastest Search Excel VBA Codes
In this article I set myself a challenge to write the fastest VBA codes to locate a cell in a range of 5 column by 1048576 rows (5.2 millon cells) in a worksheet. They are written to be reusable in your own Excel VBA projects.
Beautiful Excel Charts: All 11 Star Wars Box Office Revenue Ranked
This is a Microsoft Excel chart showing All 11 Star Wars Box Office Revenue Ranked.
Beautiful Excel Charts: chart with emojis
This is a very simple way to create a beautiful chart in Microsoft Excel to visually display numbers with emojis and emoticons!
Connect Microsoft Access to MYSQL backend – A fully illustrated instructions guide
This article is a set of complete instructions on how to link a Microsoft Access database front to an MYSQL database hosted on a webserver. We start you from ground zero and build it up to the top.
Why small businesses should use Access database – 6 Reasons that really matter.
Time and again I have found that the humble Microsoft Access database can serve the needs of resource-strapped SMEs perfectly. Let me explain the 6 reasons why.
Best Excel file format for Excel VBA Programming
Back in the days of Excel 2003, saving a workbook file is simple. You only save in .XLS file format.
Best Milliseconds Timer in VBA Tutorial
I will show the complete VBA codes that you can simply copy and use, I will describe the research process involved to create millisecond timers in VBA using Windows APIs so that you can deepen your understanding of using Windows APIs with VBA coding.
Heat wave in Tokyo, Beautiful Excel Charts.
A deadly heat wave in Tokyo, producing record high temperatures in Tokyo in July 2018.
