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...
Would you skip learning how to drive a car had I told you it can get you to your destination hundreds and thousand times faster than your bicycle?! I don’t think so.
Operating a vehicle may sound difficult, if not frightening, if all you’re used to is riding your bike. Still –...
Last week I published a Blog post I thought would be all you may need in order to choose the right Inner Circle plan for you.
However, I am still getting some questions from some Excel enthusiasts about the program.
Today’s post is dedicated to those still having questions.
Q: I already learned Excel VBA and get along pretty well. Why should I...
No doubt one of Excel’s magic is the “live grid” in which formulas connect cells, charts and formatting for real-time calculations and rendering. It Is so appealing, that we tend to forget that maintaining the web of connected cells requires resources. Compute and memory resources.
...In one of my customer’s project that manages trainings and certifications, employees receive email and SMS notifications on various events: upcoming training reminders, training result (with a certificate attached), change of instructor, training assessment reminders etc.
The technique for doing that is using a queue. All notifications...
The first situation in which I encountered the need to verify the printer is ready, was in an application I developed for small business management, in Excel.
In my home country, Israel, tax regulations dictate that the tax invoice confirming the receipt of a payment is printed exactly ONCE. This would be the ORIGINAL...
Simply speaking, a database is any structure in which data is to be arranged along with tools to store, manipulate and retrieve the data.
Several such pre-configured “data arrangements” are available as products, each developed in its time to solve data-related challenges. Let’s mention a couple.
Relational Database: In a relational database data is arranged in tables with relations...
YES!
SQL is the most popular Databases language. It is robust, proven and works with extremely large tables stored in any common relational Database software. If you want to learn more about Databases and SQL – read my last week’s Blog post...
As you probably know, a function (or subroutine) can accept arguments (or parameters) from the calling function (or sub). These arguments are part of the definition (or “stub”) of the function. For example:
Function AddTwoNumbers(_
ByVal FirstNumber as Single, _
ByVal SecondNumber as Single) as Single
The above function...
50% Complete
Once you submit your details, you'll receive an email with a confirmation link. That's it! you're subscribed!