This tutorial is a detailed guide to creating a fully automated cashbook in Excel. If you are an Accountant or any kind of financial accounts handler whose job is to prepare daybooks or cashbooks, then this tutorial is for you! This guide collectively teaches you to create a fully automated cashbook in Excel that allows …
Excel by default tends to make it easier to enter dates. It is preprogrammed to handle numbers as Dates and convert them accordingly. Number in formats, separated by a backslash (/) or by a hyphen (-), are automatically converted to dates by Excel. For example, 13/6 or 13-6 gets converted to 13-Jun automatically by Excel. …
Stop Excel from changing Numbers to Dates automatically Read More »
Welcome to Part 2 of creating a sleek and interactive business dashboard in Microsoft Excel! Before we begin, we recommend you to read Part 1 if you’re learning for the first time. This article is Part 2 of creating a sleek and interactive business dashboard using the data charts we created in Part 1. Read …
Create a Sleek and Interactive Business Dashboard in Excel [PART 2] Read More »
Are you looking to create a well-designed, sleek, and interactive business dashboard in Excel? Well, your search stops here! This article is a comprehensive how-to guide to create beautiful and responsive dashboards for your organization. Also read: Creating Fully Automated User Forms in Excel [No VBA] PART 1 What are business dashboards? Dashboards are organizational …
Create a Sleek and Interactive Business Dashboard in Excel [PART 1] Read More »
Want to create an impressive user data entry form in Excel? You’re at the right place! This article is a comprehensive and advanced step-by-step guide to create fully automated user forms in Microsoft Excel. You can collect, store, and process the data provided by your customers via the user form created by you. We will …
Creating Fully Automated User Forms in Excel [No VBA] PART 1 Read More »
In this article, I’ll be walking you through the steps to insert a PDF in Excel. We’ll also work on exporting/saving an excel as a PDF. Let’s get right into it! Steps to insert a PDF in Excel There are two ways to insert PDFs in Excel. You can insert a PDF file as an …
PDF in Excel: How to Insert PDFs or Save an Excel File as a PDF Read More »
In this tutorial, we’ll learn how to pull geographical data in Excel. Getting geographical data of any country, region, or city using the traditional method of manual ‘Google’ or ‘Bing’ searching or ‘Wikipedia’ is time-consuming as well. Also, directing the way to possible errors while copy-pasting of these data points. Multiply these efforts when pulling …
How to Pull Geographical Data (County/City) in Excel? Read More »
This tutorial is a detailed guide to recovering unsaved and corrupted Excel files. We will look at the different tips and tricks to recover unsaved files or corrupted files step-by-step. Steps to recover unsaved Excel files An Excel file can be unsaved due to unexpected system shutdowns, restarts, lags, or ending tasks via task manager …
Genuine Ways to Recover Unsaved and Corrupted Excel Files Read More »
There are various websites and apps which provide us Market Data for all the securities, and commodities traded in the stock market. But it would be very handy if we could get all this data directly into our Excel Workbook. This would help us for better calculation, analysis, and visualization of the data, in form …
Why is my Excel file so large? Here’s the answer! This article is a complete guide to reduce the file size in Microsoft Excel. Steps to compress large Excel files Let’s get started with the multiple ways to compress large Excel files. 1. Save as Excel Binary Workbook Microsoft Excel has an in-built file type …