Apr 24, 2019 | Excel, VBA
Protecting a single worksheet is pretty easy, you simply hover your mouse, right click, and select Protect Sheet. But what happens if you are working on a Excel workbook that has like 50 worksheets and you want to password protect just certain worksheets?In this...
Apr 19, 2019 | Excel, VBA
When you work with Excel files that contain macros, ActiveX Control, userforms, or connect to an external data source, sometimes, you will get those annoying Privacy Warning message “Be careful! Parts of your document may include personal information that...
Apr 19, 2019 | Excel, Excel General
As we all know, Excel is a very useful application that has many features. You can use Excel to do things like a building a database, a data entry sheet, creating pivot table and more. Because there are way too many features in Excel sometimes it can get a little bit...
Apr 19, 2019 | Excel, Excel General
Sometimes when we perform data entry task, or copying data from somewhere, we occasionally encounter the issue where some data are duplicate. Unfortunately, In Excel, dealing work duplicate records aren’t that difficult.In this tutorial, I will show you 3 ways...
Apr 19, 2019 | Excel, Excel General
In Excel, there no built-in formatting that converts date as quarter (plus year). In this quick video, I will show you how you can easily format dates to quarter and year in Excel using simple formula. data-ad-layout="in-article" data-ad-format="fluid"...
Apr 15, 2019 | Excel, VBA
An audit trail is a record or log captures a change. For example, when you change a product price from $10 to $15, the change in the $5 difference is a trail. Audit trail is commonly used in accounting, finance, retail, and other industries. Unfortunately in Excel,...
