by Ilker | Jul 1, 2021 | Excel Tips & Tricks
In this guide, we’re going to show you how to create a To-Do list in Excel with the help of checkbox controls and conditional formatting. Download Workbook Preparation before creating a To-Do list Start by creating a 3-column range for the to-do list. These columns...
by Ilker | Jun 29, 2021 | Excel Tips & Tricks
Checkbox type of input controls are commonly used for answering Yes/No questions, True/False questions, or just checking items off a list. In this guide, we’re going to show you how to insert a checkbox in Excel. Download Workbook Developer Tab and Checkbox command...
by Ilker | Jun 29, 2021 | Excel Tips & Tricks
Excel is one of the most common platforms for creating charts. In this guide, we’re going to show you how to save Excel charts as an image. Download Workbook We will introduce you to three different methods of saving charts. Let’s start. Save as Picture The...
by Ilker | Jun 28, 2021 | Excel Tips & Tricks
How to add watermark in Excel Image or video watermarks are commonly used for copyright protection or marketing. Although Excel has watermark support, it’s not very easily accessible. In this guide, we’re going to show you how to add watermark in Excel and also...
by Ilker | Jun 23, 2021 | Excel Tips & Tricks
In this guide, we’re going to show you how to get filename from path in Excel. We will cover how to do this with and without VBA. Download Workbook File path and file name A file path is a string identifier that specifies the unique location in a file system. It...
by Ilker | Jun 22, 2021 | Excel Tips & Tricks
Excel VBA allows you to open a workbook directly - all you need is the full path of the file, including the file name. However, locating and supplying the file path each time may can be tedious when working with multiple files. In this guide, we’re going to show you...
by Ilker | Jun 21, 2021 | Excel Tips & Tricks
by Ilker | Jun 16, 2021 | Excel Tips & Tricks
Inserting new columns is the easiest way to add new fields into your worksheet area. Since Excel inserts columns by copying the formatting of the previous column, it is usually more practical than moving bottom cells to open up space for new data. Thanks to VBA, we...
by Ilker | Jun 16, 2021 | Excel Tips & Tricks
Inserting new rows is the easiest way to add new fields into your worksheet area. Since Excel inserts rows by copying the formatting of the previous row, it is usually more practical than moving bottom cells to open up space for new data. Thanks to VBA, we can insert...
