How can I have a shared Excel spreadsheet with an user-defined function while making sure nobody adds any other VBA code?

You can have a shared excel spreadsheet with an user-defined function while making sure nobody adds any VBA code. How? This way, KulfiSoftware is providing not one, two, three but, four ways to make the excel spreadsheet protected and with this no one can change the VBA code.

There are four ways are:

I know of to make sure somebody hasn’t added any other VBA code to your workbook.

The minimalist approach would be adding your digital signature to the ...

Continue Reading →

How do I add a checkbox to an Excel spreadsheet?

Introduction – Add checkbox to Excel

In this article, you will learn how to add a checkbox to Excel spreadsheet. Adding checkbox make our Excel spreadsheet professional. Let’s learn how to add a checkbox to an excel spreadsheets step by step guide by KulfiSoftware.

Steps:

1. Let’s suppose the columns are ‘A’ ‘B’ and ‘C’. First, we will delete the data of column ‘C’.

clear-column-c

2. After deleting, Click ...

Continue Reading →
Spreadsheets VS Excel

Which is better for a company to use Google Sheets or MS Excel for spreadsheets?

Question: Which is better for a company to use Google Sheets or MS Excel for spreadsheets?

In this article, we will discuss Google Sheets VS MS Excel Spreadsheets. Sheets VS Excel? Which is better? let’s discuss. KulfiSoftware will explain you this.

Sheets VS Excel

sheets VS Excel

What is Google Spreadsheet:

Google Spreadsheets is a Web-based form that enables users to build, renew and transform spreadsheets and give the ...

Continue Reading →
Success in merging excel spreadsheets

Merge Two Spreadsheets In Excel Effectively

Merge spreadsheets in excel effectively

Merging two spreadsheets in excel is not that difficult you think, And if you think it’s difficult then just read this post by KulfiSoftware. I guaranty yo after reading this article your question will be simplified.

” How To Merge Two SpreadSheets In Excel Effectively”
As you may know, there are many articles on the internet on How to merge spreadsheets in excel and also everyone has the same content but another way to represent you. So ...

Continue Reading →

Does Google Spreadsheet support Monte Carlo simulation?

Monte Carlo Simulation

Know if Google Spreadsheet support Monte Carlo simulation. by kulfisoftware. A spreadsheet is an interactive computer application for an organization, analysis, and storage of data in tabular form. The program operates on data entered in cells of a table.

Google Spreadsheet support Monte Carlo

YES

Monte Carlo Simulation is about modeling uncertain inputs with a range of values rather than just a “point estimate”.
More formally. A spreadsheet is an interactive computer application for ...
Continue Reading →

How can I periodically run a Google Script on a Spreadsheet?

Using Time-Driven Triggers

Periodically run a Google Script on a Spreadsheet. You might want to run a script daily, hourly, or on the same day of the week each week. Here are instructions for setting a trigger to run the script.
To run a script at a time or times you designate:

Periodically run a Google Script on a Spreadsheet

From the Script Editor, choose Resources > Current project’s triggers. You see a panel with the message No ...

Continue Reading →

Does Google Spreadsheet support Monte Carlo simulation?

In their raw form, no, not really. Like excel, they have random functions that allow for single, randomized trials based off of certain criteria, but also like excel, Google Sheets require additional programming through addons and extensions (or VBA or additional addons for excel) in order to actually perform any quantity of randomized trials where n > 1.

With that said, you might be able to find extensions (or create your own) that will allow you to run monte ...

Continue Reading →

What are the best productivity hacks, tips, tools or resources for using Google Spreadsheets?

What are the best productivity hacks, tips, tools or resources for using Google Spreadsheets?

Here’s my list of resources for using Google Spreadsheets that will help you to be more productive:

1 – Keyboard shortcuts

You may know a few shortcuts like copy and paste (Ctrl + C, Ctrl + V) but there are more powerful commands at your fingertips. Shortcuts that let you move to the next sheet and change data formats, for example.

Locate the ‘Help’ menu to ...

Continue Reading →

Does the Dropbox/Microsoft Office 365 announcement mean that Dropbox is no longer working on its own productivity application suite (word processor, spreadsheet, etc.)?

Does the Dropbox/Microsoft Office 365 announcement mean that Dropbox is no longer working on its own productivity application suite (word processor, spreadsheet, etc.)?

Dropbox/Microsoft Office 365 announcement mean that Dropbox is no longer working on its own productivity application suite. Let me make one thing clear: the world does not need another productivity suite. I can’t comment for Dropbox (for the obvious reason that I don’t work there) but if Dropbox ever built one, it would be a terrible waste of ...

Continue Reading →

What is the best excel spreadsheet template for comparing product features?

What is the best excel spreadsheet template for comparing product features? by KulfiSoftware

Best excel spreadsheet template. Take a look at a product like MS Office and you will see many variations of Excel for example. You will see columns like Excel 2013 … Office 365 Home … Office 365 Pro Plus. Each row contains a feature … and each column has a tick or a cross in each row to show whether the feature is available in ...

Continue Reading →