Online Excel Tips – Blog – Trump Excel
How to Format Phone Numbers in Excel?
If you work with phone numbers data in Excel, it would be useful to know how to properly format the…
Read more
Online Excel Tips – Blog – Trump Excel
How to Show Ruler in Excel?
Do you know there’s a functionality to show a ruler in Excel that can help you align objects perfec…
Read more
Online Excel Tips – Blog – Trump Excel
Connect a Single Slicer to Multiple Pivot Tables in Excel
If you work with Pivot Tables and also use slicers, you may sometimes wonder whether a slicer can b…
Read more
Online Excel Tips – Blog – Trump Excel
Change Pivot Table to Tabular Form
When working with Pivot Tables in Excel, I always ensure that my Pivot Tables are displayed in the …
Read more
Online Excel Tips – Blog – Trump Excel
Add or Subtract Percentage From a Number in Excel (Formula)
Working with percentages is a daily task for many Excel users. Now you cannot simply add a percenta…
Read more
Online Excel Tips – Blog – Trump Excel
Round to the Nearest 1000 in Excel
When working with very large numbers in Excel, you often need to round them to the nearest thousand…
Read more
Online Excel Tips – Blog – Trump Excel
How to Convert Fraction to Decimal in Excel
Sometimes when you download data from external sources or import information from other systems, yo…
Read more
Online Excel Tips – Blog – Trump Excel
Create Barcodes in Excel (Free Barcode Generator)
Creating barcodes in Excel can be useful for inventory management, product labeling, or any scenari…
Read more
Online Excel Tips – Blog – Trump Excel
Add Comments Within Excel Formulas
Excel formulas can get complicated, especially when you’re working with advanced functions or creat…
Read more
Online Excel Tips – Blog – Trump Excel
Repeat Rows N Times in Excel
If you want to repeat rows in your dataset N number of times (say 5 or 7 times), or based on a valu…
Read more
Online Excel Tips – Blog – Trump Excel
Create All Possible Combinations from Lists in Excel
I was recently working on a project where I had multiple lists in Excel and I had to create all the…
Read more
Online Excel Tips – Blog – Trump Excel
Create Data Validation List from Excel Table as Source
A common complaint of many Excel users is that they can’t directly use Excel table’s structured ref…
Read more
Online Excel Tips – Blog – Trump Excel
Enable Dark Mode in Microsoft Excel
Getting Dark Mode has been one of the most requested features for Microsoft Excel and finally the d…
Read more
Social Plugin