Online Excel Tips – Blog – Trump Excel
Excel Showing Formula Instead of Result
Sometimes, it happens that instead of showing the result of a formula in Excel, you see the formula…
Read more
Online Excel Tips – Blog – Trump Excel
Extract URL from Hyperlinks in Excel
Many of my projects involve working with data from the web, where I get hyperlinks in cells in Exce…
Read more
Online Excel Tips – Blog – Trump Excel
Calculate Fiscal Year from Date in Excel (Formulas)
I was recently working on a project where I had some dates and had to classify each date into its f…
Read more
Online Excel Tips – Blog – Trump Excel
How to Calculate Number of Weeks Between Two Dates in Excel
When working with dates and making project plans in Excel, you may come across a situation where yo…
Read more
Online Excel Tips – Blog – Trump Excel
How to Add Parentheses Around Text in Excel
Sometimes, when working with text data in Excel, you may want to add parentheses around the text in…
Read more
Online Excel Tips – Blog – Trump Excel
Check IF Cell Contains Partial Text in Excel (Formulas)
Sometimes, in my work, I have to check if a cell or a range of cells contains the partial text I’m …
Read more
Online Excel Tips – Blog – Trump Excel
Insert Pi Symbol (Ï€) in Excel
The Pi symbol (Ï€) represents a mathematical constant that is used when calculating the area circumf…
Read more
Online Excel Tips – Blog – Trump Excel
Calculate Interquartile Range (IQR) in Excel
Interquartile Range (IQR) is often used in statistics to identify outliers and understand the sprea…
Read more
Online Excel Tips – Blog – Trump Excel
Find the Second Largest Value in Excel
If you want to get the highest value in a column or a range, you can easily do that using the built…
Read more
Online Excel Tips – Blog – Trump Excel
How to Swap Cells in Excel?
Sometimes, when you’re organizing data, creating charts, or analyzing information, you may need to …
Read more
Online Excel Tips – Blog – Trump Excel
Split Text into Multiple Rows in Excel
Most of the time, the data in Excel is arranged in columns, and it is more common to split the text…
Read more
Online Excel Tips – Blog – Trump Excel
How to Write Scientific Notation in Excel?
Scientific notation is a format that allows us to write very large or very small numbers in a consi…
Read more
Online Excel Tips – Blog – Trump Excel
Convert Columns to Rows in Excel
Most of the time, when working with Excel, you need to restructure your data before you can start a…
Read more
Online Excel Tips – Blog – Trump Excel
Count Cells Less than a Value in Excel (COUNTIF Less Than)
It’s a common data analysis task to count the number of cells with a value that is less than a spec…
Read more
Online Excel Tips – Blog – Trump Excel
Format Numbers to Show in Millions in Excel
Whenever I’m working with financial data, I have to clean and format it so it’s more readable. One …
Read more
Online Excel Tips – Blog – Trump Excel
How to Create QR Codes in Excel (QR Code Generator)
I was recently working on a project where I had to create QR codes (Quick Response codes) in bulk i…
Read more
Online Excel Tips – Blog – Trump Excel
Count Between Two Numbers in Excel (COUNTIF / COUNTIFS)
Excel has multiple count-related functions that allow you to quickly analyze large data sets. A com…
Read more
Online Excel Tips – Blog – Trump Excel
How to Calculate Ratios in Excel?
It’s a common task to calculate ratios when working with financial data or doing other data analysi…
Read more
Online Excel Tips – Blog – Trump Excel
How to Delete Rows in Excel (Single or Multiple)?
Deleting a row or deleting multiple rows is a regular part of most Excel users. Sometimes you need …
Read more
Online Excel Tips – Blog – Trump Excel
How to Count Filtered Rows in Excel?
If you want to count filtered rows in Excel, you can do that using the SUBTOTAL function. The SUBTO…
Read more
Online Excel Tips – Blog – Trump Excel
Remove Parentheses in Excel
Most of my time working in Excel is spent cleaning data that I get from different sources. One comm…
Read more
Online Excel Tips – Blog – Trump Excel
Repeat Last Action in Excel (Shortcuts)
I’m a huge fan of using shortcuts in Excel to speed up my work While there are many shortcuts that …
Read more
Online Excel Tips – Blog – Trump Excel
Highlight Cells With Formulas in Excel
In many situations, you may want to quickly highlight all the cells with formulas in Excel. When I …
Read more
Online Excel Tips – Blog – Trump Excel
How to Get the Number of Days in a Month in Excel?
When working with dates, sometimes you may need to know the total number of days in a given month. …
Read more
Online Excel Tips – Blog – Trump Excel
How to Change Date Format In Excel?
If you work with date values in Excel, it would be useful to know the different formatting options …
Read more
Online Excel Tips – Blog – Trump Excel
How to Change Page Orientation in Excel?
Page orientation can be important when planning to print your work in Excel. While the default page…
Read more
Online Excel Tips – Blog – Trump Excel
How to Add Axis Titles in Charts in Excel?
Excel charts can be confusing for people, and it’s always a good idea to mark everything clearly in…
Read more
Blog - Excel University
Round to the Nearest 5 in Excel Using 3 Different Functions
Whether you’re working with something like test scores, tracking expenses, or any other type of dat…
Read more
Online Excel Tips – Blog – Trump Excel
Filter By Color in Excel
Filtering your data is a common task for many Excel users as a part of their daily work. Excel alre…
Read more
Online Excel Tips – Blog – Trump Excel
Select Every Other Row in Excel
Many times, I have a need to select every other row in Excel so that I can highlight or delete them…
Read more
Online Excel Tips – Blog – Trump Excel
How to Remove Dashes (-) in Excel?
Excel is a great tool when it comes to data manipulation. There are many functionalities and functi…
Read more
Online Excel Tips – Blog – Trump Excel
Delete Blank Rows in Excel (5 Easy Ways)
While working with large datasets in Excel, you may need to clean the data to use it further. One c…
Read more
Blog - Excel University
How to Create a Simple Basis Points Calculator in Excel
Microsoft Excel is fantastic since it simplifies the process of creating and managing a portfolio (…
Read more
Online Excel Tips – Blog – Trump Excel
Status Bar in Excel
Excel has so many unique features that sometimes, some of the features don’t get the credit they de…
Read more
Power BI Usage Metric Reporting: A Guide to Game-Changing Insights
If you build it, they will come. That movie line doesn’t just fit baseball diamonds, it is often u…
Read more
Online Excel Tips – Blog – Trump Excel
Calculate the Coefficient of Variation (CV) in Excel
Coefficient of Variation (CV) is a common statistical metric used to understand the variability in …
Read more
Blog - Excel University
Create an Average Daily Balance Calculator in Excel
Whether you’re tracking your personal or business finances, an average daily balance calculator in …
Read more
Online Excel Tips – Blog – Trump Excel
How to Mark an Excel Workbook as Final?
When I was working as a financial analyst a few years ago, we used to send our work as Excel files …
Read more
Blog - Excel University
How to Find Merged Cells in Excel (& What You Can Do Instead)
You’ve probably come across situations where Excel didn’t allow you to make certain changes to your…
Read more
EngineerExcel
W8x24 Beam Specifications
W8x24 is a rolled structural beam with wide flanges that is used in construction and other applicat…
Read more
Online Excel Tips – Blog – Trump Excel
How to Undo Sort in Excel (Revert to Original)
It’s common for Excel users to sort their data set when they’re analyzing. Sometimes, you may want …
Read more
Blog - Excel University
How to Remove Leading Spaces in Excel
Any work you do in Excel is built around data. The cleaner the data is, the easier worksheets are t…
Read more
Blog - Excel University
How to Square a Number in Excel
Squaring numbers are helpful in all different kinds of calculations, but it can be a tedious task i…
Read more
Online Excel Tips – Blog – Trump Excel
Make VBA Code Pause or Delay (Using Sleep / Wait Commands)
Sometimes, when working with a VBA code, you may want to put a pause on the code execution or delay…
Read more
EngineerExcel
Parallel Axis Theorem for Area Moment of Inertia
The parallel axis theorem can be used to calculate the area moment of inertia about any axis. This …
Read more
EngineerExcel
Pressure Ratings of PVC Pipe
Pressure ratings for PVC (Polyvinyl Chloride) pipe are based on the ability of the material to resi…
Read more
Online Excel Tips – Blog – Trump Excel
How to Group Columns in Excel?
When working on an extensive Excel worksheet, you can avoid getting confused and overwhelmed by org…
Read more
Blog - Excel University
Four Ways to Select Every Other Row in Excel
Selecting every other row in Excel can be helpful. Aside from making it easy to get rid of duplicat…
Read more
Social Plugin