Online Excel Tips – Blog – Trump Excel
Paste into Filtered Column (Skipping Hidden Cells) in Excel
Excel is an amazing spreadsheet tool, but there are some things that drive me crazy. One such thing…
Read more
Online Excel Tips – Blog – Trump Excel
Copy Visible Cells Only in Excel
When you’re working with the data set that has hidden rows, and you select and copy the cells in th…
Read more
Online Excel Tips – Blog – Trump Excel
SUM Based on Partial Text Match in Excel (SUMIF)
Excel has the SUMIF and SUMIFS functions that allow you to add a range of cells based on one or mor…
Read more
Online Excel Tips – Blog – Trump Excel
How to Remove (Disable) Add-Ins in Excel?
Excel add-ins are helpful when you want to enhance the functionalities in Excel and do things not a…
Read more
Online Excel Tips – Blog – Trump Excel
Name Box in Excel
Among the many awesome features in Excel, Name Box doesn’t get talked about enough. While it looks …
Read more
Online Excel Tips – Blog – Trump Excel
Prevent Duplicate Entries in Excel
When doing data entry work in Excel, you may want to prevent entering duplicate entries in a column…
Read more
Online Excel Tips – Blog – Trump Excel
Conditional Formatting Not Working in Excel
Conditional Formatting allows you to add a visual layer to your dataset and make it easier to under…
Read more
Social Plugin