Historically, Microsoft dominated the personal computing operating system, named Windows since 1985.
Watching successful productivity software take root in the office worker PC, offering word processors, electronic spreadsheets and database-centric applications, Microsoft did what it proves to do best every time: re-invent great innovations, creating highly appealing user experience,...
Lucien, one of the professional Excel VBA experts following my Blog and courses approached me this week with this question.
He noted a shift from Excel to Power BI in his workplace and asked about my point of view on the two.
Lucien mentioned that he is more of an “Excel/VBA person” and that the Power BI reports seem slow and not interactive.
What a great question to call for a Blog post!
...This Blog post continues the current series dealing with building robust business applications with Excel VBA and MySQL Database.
If you have not read the previous posts about preparing MySQL Server and Excel for communications and connecting and sending SQL Select statements, read them first.
In the Databases...
Last week, I guided you through setting up MySQL server and Excel so that they can communicate with one another.
If you don’t have a ready environment for Excel VBA to talk with MySQL server – complete this first and jump back afterwards.
As I want to focus on writing SQL queries from VBA, I will assume...
In case you miss the outstanding promise of that title up here, you are about to discover a new world of capabilities and opportunities you have never imagined with Excel.
Most of the business application running our world’s economy (all organizations out there) – rely on a strong...
One of the first things you learned in Excel was calling built-in functions.
The basic concept of a function can be summarized in three points:
Lets take the LEFT()
function to better understand...
When you save a file, you need to point to a particular folder and give it a name.
Your 2022 P&L Workbook may have the following path and file name: \\Shared-Server\Financials\P&L\2022.xlsm
Instead of you manually browsing to the destination folder and typing a filename when you...
Reports can take many forms, as far as presenting data is concerned.
A report is any artifact created from data for end use, or as required by another system as input.
A report can be a single page summarizing information about something (see the certificate example of last week’s Blog post), it can be an order for an employee to do something (such as in a production order) and it...
PDF has become to be the standard file format for immutable documents.
Immutable, for those not computer programmers yet, means it cannot be changed once it is created.
PDF is highly popular for its quality, compactness, and the ability to sign electronically to render a formal document accepted by private and public institutions.
What I always do, is dedicate a Worksheet for staging the report. This...
50% Complete
Once you submit your details, you'll receive an email with a confirmation link. That's it! you're subscribed!