by Svetlana Cheusheva This tutorial will guide you on how to make a checkbox in Excel and use the check box results in formulas to create an interactive checklist, to-do list, report or graph. I believe everybody knows what a checkbox is, you must have seen plenty of them on various forms online. Still, for the Read More
Category: Microsoft Office
How to Use COUNTIF in Excel
Use the COUNTIF function to make Excel count words or numbers in any range of cells. Instead of manually counting how often a certain value or number appears, let Excel do the work for you. With the COUNTIF function, Excel can count the number of times a word or number appears in any range of Read More
How to Use VLOOKUP in Excel
Have you ever had two sets of data on two different spreadsheets that you want to combine into a single spreadsheet? For example, you might have a list of people’s names next to their email addresses in one spreadsheet, and a list of those same people’s email addresses next to their company names in the Read More
How to Split a Text into Multi-columns on Excel
What if you want to split out information that’s in one cell into two different cells? For example, maybe you want to pull out someone’s company name through their email address. Or perhaps you want to separate someone’s full name into a first and last name for your email marketing templates. Thanks to Excel, both Read More
How to Remove Duplicate Data in Excel.
Larger data sets tend to have duplicate content. You may have a list of multiple contacts in a company and only want to see the number of companies you have. In situations like this, removing the duplicates comes in quite handy. To remove your duplicates, highlight the row or column that you want to remove Read More
How to Unhide Multiple Sheets in Excel at Once
The tutorial explains how to unhide worksheets in Excel 2016, 2013, 2010 and lower. You will learn how to quickly unhide worksheet by right-clicking and how to unhide all sheets at a time with VBA code. Imagine this: you open a worksheet and notice that some formulas refer to another worksheet. You look at the Read More