How to use Google Sheets for Project Management
There are many Project Management Tools available in the market. Many of them have cloud versions that you can access with a …
Spreadsheets
A spreadsheet is a computer application for organization, analysis, and storage of data in tabular form. Under this category, you will learn tips and tricks for using various types of spreadsheet applications. Mainly we will be discussing spreadsheets applications such as Microsoft Excel and Google Sheets.
Multi-Row Dependent Dropdown List in Google Sheets
In a previous post, I explained how to create a simple dependent dropdown list in Google Sheets. However, using that method you …
How to Calculate Loan Repayments with Google Sheets
Are you planning to take a loan? If so, what is your monthly payment would be? Will you be able to afford …
Read moreHow to Calculate Loan Repayments with Google Sheets
How to Create Data Entry Form with Google HTML Service and Submit Data to Google Sheets
Data entry is one of the important steps in the data analysis process. It is important that the data collected is correctly …
Read moreHow to Create Data Entry Form with Google HTML Service and Submit Data to Google Sheets
How to create a Data Entry form in Google Sheets
When it comes to mass data entry works, it is essential to use data entry forms to improve accuracy and speed. This …
How to Create a Dependent Drop-Down List in Google Sheets
The drop-down lists are useful when you are creating data entry forms or creating interactive dashboards to visualize your data. Sometimes, you …
Read moreHow to Create a Dependent Drop-Down List in Google Sheets
20 Excel Tips and Tricks to Save Time
Microsoft Excel is the most widely used spreadsheet application. We can use it in many ways to achieve the same result. However, …
10 Benefits of Converting Data into Excel Tables
The table feature of Microsoft Excel allows you to manage and analyze related data easier. With Excel tables, you can manage rows …
10 Microsoft Excel Tips to Save Time and Work Faster
Microsoft Excel is one of the most used productivity tools out there. The things that you can do with it is endless. …
Read more10 Microsoft Excel Tips to Save Time and Work Faster
Visualizing and Presentation Styles in Excel – Conditional Formatting
in Microsoft Excel conditional formatting is one of basic style for visualizing a set of data using colour ranges without changing the …
Read moreVisualizing and Presentation Styles in Excel – Conditional Formatting