Online Excel Tips – Blog – Trump Excel
Change the Default Font in Excel
Whenever you open a new Excel workbook, you will see that a default font type and font size have al…
Read more
Online Excel Tips – Blog – Trump Excel
Calculate P-value in Excel
The P-value is an important concept in statistics that is often used in hypothesis testing and deci…
Read more
Online Excel Tips – Blog – Trump Excel
Calculate MEDIAN IF in Excel
Excel has an in-built MEDIAN function, but there is no MEDIANIF function. But that’s not an issue. …
Read more
Online Excel Tips – Blog – Trump Excel
Convert Month Name to Number in Excel
In some situations, you may have the month name that you want to convert into the month number so t…
Read more
Online Excel Tips – Blog – Trump Excel
Best Excel Fonts
Choosing the right fonts for your Excel spreadsheets can make a big difference in readability and v…
Read more
Online Excel Tips – Blog – Trump Excel
Transpose Multiple Rows into One Column
Recently, I was working on a project where I had data in multiple rows, and I needed to combine the…
Read more
Online Excel Tips – Blog – Trump Excel
How to Make Cells Bigger in Excel?
Excel worksheets are made up of cells with default heights and widths. In most cases, you will need…
Read more
Online Excel Tips – Blog – Trump Excel
Convert Days to Months in Excel
In this article, I will show you how to convert days to months in Excel using a couple of simple fo…
Read more
Online Excel Tips – Blog – Trump Excel
Add Sheet Name to Header or Footer in Excel
It’s easy to add sheet names to header or footer in Excel. Once done, the sheet name will appear In…
Read more
Online Excel Tips – Blog – Trump Excel
How to Open Excel in Safe Mode?
If your Excel application is crashing or causing issues, you can try opening it in the ‘Safe Mode’.…
Read more
Online Excel Tips – Blog – Trump Excel
How to Find the Version of Excel You Have?
Need to find out which version of Microsoft Excel you have? It’s pretty easy to do and only takes a…
Read more
Online Excel Tips – Blog – Trump Excel
How to Underline in Excel?
One formatting option you can use when you want to highlight a specific text or cell is the underli…
Read more
Online Excel Tips – Blog – Trump Excel
Remove Duplicates Within a Cell in Excel
Removing duplicates is a common task for most data workers. While in most cases, you would be worki…
Read more
Online Excel Tips – Blog – Trump Excel
Remove Asterisk (*) in Excel
Remove asterisk (*) symbol In Excel is a little tricky as it’s a wildcard character and you cannot …
Read more
Online Excel Tips – Blog – Trump Excel
Sort Dates By Month in Excel
Dates are stored as numbers in the backend in Excel and can easily be sorted. But what if you want …
Read more
Online Excel Tips – Blog – Trump Excel
Unprotect Excel Sheets Without Password
It’s not uncommon for many people to protect worksheets in their Excel files and then forget the pa…
Read more
Online Excel Tips – Blog – Trump Excel
Excel Conditional Formatting Based on Another Cell
Conditional formatting in Excel allows you to format cells based on the values in the cells. The bu…
Read more
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
Online Excel Tips – Blog – Trump Excel
Remove Last Character in Excel
Most of my work involves getting data from various sources, such as databases, webpages, or other p…
Read more
Online Excel Tips – Blog – Trump Excel
How to Square a Number in Excel
There are multiple ways to calculate the square of a number in Excel. You can use the in-built POWE…
Read more
Social Plugin