Online Excel Tips – Blog – Trump Excel
How to Compare Dates in Excel (Greater/Less Than, Mismatches)
One area that often troubles Microsoft Excel users is working with dates. This is mostly because da…
Read more
Working with Lists in Power Query – Let’s Count Words
Lists in Power Query are something many people know nothing about. Power Query uses them all the ti…
Read more
Online Excel Tips – Blog – Trump Excel
How to Display Numbers as Fractions (Write Fractions in Excel)
Getting numbers to show up as fractions in Excel could be a challenge. In case you try and enter an…
Read more
Blog - Excel University
Create a Dynamic PivotTable Style Report with One Formula
Historically, we’ve had two basic ways to create reports in Excel. We could enter the report labels…
Read more
EngineerExcel
Parallel Heat Exchangers Explained
The purpose of a heat exchanger is to transfer heat energy from one fluid to another, with the two …
Read more
EngineerExcel
Single Degree of Freedom Systems
When it comes to engineering, it is often ideal to simplify a system in a way that makes it easier …
Read more
March Data-Ness II – The Method Behind the Madness
You asked for it and here it is! We’ve received a ton of buzz since introducing our March Data-Ness…
Read more
Online Excel Tips – Blog – Trump Excel
How to Insert/Draw a Line in Excel (Straight Line, Arrows, Connectors)
Excel is not only a wonderful tool for data entry and data analysis, but also great at making chart…
Read more
Online Excel Tips – Blog – Trump Excel
Copy and Paste Multiple Cells in Excel (Adjacent & Non-Adjacent)
Copying and Pasting a cell or a range of cells is one of the most common tasks users do in Excel. A…
Read more
Online Excel Tips – Blog – Trump Excel
How to Multiply a Column by a Number in Excel (2 Easy Ways)
Although Excel is a powerful data analysis tool, many users use it for basic arithmetic operations.…
Read more
Online Excel Tips – Blog – Trump Excel
How to Fix #VALUE Error in Excel?
When you’re working formulas in Excel, many times you will encounter the #VALUE error. While the er…
Read more
Online Excel Tips – Blog – Trump Excel
How to Get Rid of #DIV/0! Error in Excel? Easy Formulas!
If you have been working with formulas in Excel, I am sure you have encountered the #DIV/0! error (…
Read more
Blog - Excel University
Easily Create and Update Excel Reports from QuickBooks
In this article, we’ll show how to easily create and update Excel reports from QuickBooks. But, let…
Read more
Blog - Excel University
These Are the Top 9 Most Useful Advanced Excel Functions
Looking to make work easier? Instead of trying to do it all, focus on learning these nine useful ad…
Read more
Online Excel Tips – Blog – Trump Excel
How to Do Factorial (!) in Excel (FACT function)
I was kind of a math nerd in school and the sections about probability and permutation/combination …
Read more
Online Excel Tips – Blog – Trump Excel
How to Make an Interactive Calendar in Excel? (FREE Template)
If you like to plan ahead and make a weekly or monthly schedule, having a calendar in Excel could b…
Read more
Online Excel Tips – Blog – Trump Excel
Extract Last Name in Excel (5 Easy Ways)
When working with the names dataset in Excel, often there is a need to slice and dice the dataset a…
Read more
EngineerExcel
Moody vs. Darcy Friction Factor
In fluids engineering, evaluating the pressure loss due to friction is an important aspect of desig…
Read more
EngineerExcel
Darcy vs. Fanning Friction Factor
Friction plays a key role in the flow of a fluid through a pipe or duct. Calculating that friction …
Read more
Blog - Excel University
What Excel Skills are Employers Looking For in 2022?
Need Excel skills for work? Save time job searching by finding out exactly what Excel skills employ…
Read more
Social Plugin