ERP Explained: What is it? Why use it?

Can you run your business with a pen and a paper? I don’t think so. What software solutions can come to the rescue? The most popular recommendation you here is probably: ERP * In a series of Blog posts I will dissect ERP to the what, why, how, benefits and challenges. We start today with: What is an ERP system and why should you consider getting one?

A typical business has to handle money, employees, suppliers, sales, marketing, some also have inventory to maintain, production, warehouses etc.

One cannot manage all of these areas with a pen and a paper. We use computer software for...

Continue Reading...

Google Spreadsheets vs. Microsoft Excel: What Should You Choose?

You know an electronic spreadsheet is the right tool for your need, but you’re not sure which of the available products to choose. Two prominent options are suggested: Google Spreadsheets and Microsoft Excel. Let’s make it easier for you

First, let’s consider your requirements. The following list will help us frame the discussion:

  • Do you need multiple users to concurrently work on the solution, or can one person at a time exclusively work on it?
  • Do you need pixel-perfect visual design with wide flexibility over fonts, colors, forms design etc.?
  • Does the solution needs to...
Continue Reading...

Business Software Strategy - 3 Options

In choosing a software to support your business processes and requirements, you basically have the following options:

  1. An ERP solution (either implemented on your premise, or used as a service delivered from “the cloud”).
  2. Best of Breed - buying and implementing different solutions for different areas (departments) of your business (e.g. Human Resources, Manufacturing, Sales, Financials, …) and maintaining interfaces between them.
  3. Tailored Development Solutions - Software that is designed and developed for your specific needs (may also be to support only parts of your...
Continue Reading...

Creating dynamic dashboards in Excel

Creating a live dashboard is a skill combining data sourcing and staging (arrangement of the data to serve the dashboard elements), queries (typically SQL, or smart Excel functions), visual design, user experience and layout, and business requirements to be fulfilled. My students learn how to create beautiful, business dashboards.

I recently offered an answer on Quora to the question: How can you create a live dashboard with Excel for your clients? After submitting my answer, I thought my Blog readers may benefit from this as well, so here it is :)

Consider the following dashboard:

This is...

Continue Reading...

What Does it Take to Become a Successful Business Software Consultant?

Becoming a successful figure in any field required a combination of skills, resources, knowledge and experience. Why is one lawyer so successful while others are not? How about marketing consultants? * What is the recipe for a successful business software consultant?

The last two Blog posts clarified some questions about choosing VBA as the programming language for your business software consultant career. I presume by now you have come to appreciate the opportunity, and the alignment of your career goals with VBA. Frankly, you can take the Excel VBA courses I offer and find your way. This...

Continue Reading...

Microsoft is Storming the Cloud. What’s the Future of VBA? Impressions and Thoughts from a Microsoft Meeting

Last Sunday was our monthly meeting at Microsoft's Offices in Raanana, Israel. We are Israel's Excel Masters - developers and trainers mostly. We meet once a month at Microsoft's office to learn new things and engage in discussions with Microsoft's managers * Below are my key takeaways and predictions from this meeting with Microsoft's Collaboration Customer Success Manager, Maor. Do we know what is the future of Excel VBA?

Cloud Cloud Cloud

Maor, who's leading the Collaboration Customer Success with the Large Enterprises in the local market, presented Microsoft's future (cloud, cloud,...

Continue Reading...

VBA As a Programming Language: Pros and Cons

Should you consider investing in learning Microsoft’s Visual Basic for Applications? It is so ubiquitous as it is supported by all MS-Office installations. However, it was not adopted as a general, all purpose programming language by the professional developers’ community. Who would benefit and what are the pros and cons of learning and becoming a professional VBA developer?

In my last blog post I offered a brief analysis of why VBA was not adopted by the professional developers’ community as an all-purpose business applications technology. You will not find too many...

Continue Reading...

Why isn’t VBA Popular Amongst Software Programmers?

A glimpse at any major open positions board will quickly reveal VBA is not among the popular programming languages out there, when it comes to business applications. This is surprising, considering the fact it is the language used in MS-Access, a database-oriented applications development environment that is part of the MS-Office 365 Business Suite, and the underlying language of the other, most popular MS-Office Suite of applications.

Brief VBA History

Ever since it was introduced in 1993 with Excel 5.0, VBA hesitantly played in between two fields: Microsoft’s Office applications...

Continue Reading...

Can Business Information Systems be Developed on Excel? YES!

Ask yourself: what can I do with the Excel I have on my computer? In most cases, the answer will be: maintain tables, compute with formulas, present data as charts, summarize tables by different variables. The advanced users among us will add: record a sequence of tasks and save as a “Macro” for automatic repetition. * Did you know that Excel offers a complete development environment allows for information systems for almost any purpose to be realized at a significant lower time and cost?

Every entrepreneur, business owner or a corporate manager knows that information systems...

Continue Reading...

Welcome, pleased to meet :)

morsagmon Oct 07, 2019

Hi!

Welcome and thank you for taking interest in myself and my offering to you.

Let me tell you a little bit about myself and my background.

Oh Boy, oh Boy, oh Boy

I was born on January 1969, in Israel, my homeland still today. As a young child I had an opinion about everything, and didn’t hesitate to ask questions. I was always seeking for the ultimate truth.

I did my best to improve the way the school operated and to enlighten my teachers with tips of dos and don'ts. I must have been an everyday subject of conversation in the teachers’ lounge... I am sure that the staff were...

Continue Reading...
1 2
Close

50% Complete

Two Step

Once you submit your details, you'll receive an email with a confirmation link. That's it! you're subscribed!