Online Excel Tips – Blog – Trump Excel
How to Freeze Multiple Columns in Excel?
As you scroll horizontally across a worksheet with many columns, the columns at the beginning of th…
Read more
Merry Christmas & Happy New Year 2023
Hi everyone… Let me start by wishing you all a very happy holiday season and stellar start to 2023…
Read more
Online Excel Tips – Blog – Trump Excel
How to Turn OFF Scroll Lock in Excel?
Tell me if this has happened to you – you’re working on an Excel spreadsheet, and as soon as you pr…
Read more
EngineerExcel
Beam Deflection Calculators
Calculating the deflection of a beam applies to several structural engineering scenarios. For examp…
Read more![Range Lookup in Excel – How to lookup the pricing tier? [Formulas]](https://lh3.googleusercontent.com/blogger_img_proxy/AEn0k_vdprklGwY2SAOeldtPzLI9v2z5ukWtM_ZLdn8bLnJlzzpfihJnw4OrR_1QUaprbuw8HHQqIO-M19xHBjYYSTW9XoY87mwtCogwh-2ZleUCyOJoQw=w680)
Range Lookup in Excel – How to lookup the pricing tier? [Formulas]
Here is a really tricky problem. Recently I was given a data set like this (shown below…
Read more
Blog - Excel University
Skipping Excel 3
In this third and final post of the Skipping Excel series, we’ll connect all the dots and use Zapie…
Read more
Online Excel Tips – Blog – Trump Excel
AutoSum in Excel (Shortcut)
What do you do when you have to get the sum of cells in a column? Do you use the SUM function? Whil…
Read more
Online Excel Tips – Blog – Trump Excel
How to Switch First and Last Name in Excel with Comma?
When working with name data sets in Excel, you may want the names to be in a specific format. Usual…
Read more
#### in Excel cell
You open an Excel file and some cells show #### instead of the value. Here is a quick fix. Just m…
Read more
EngineerExcel
Young’s Modulus Calculator
Young’s modulus is an important physical property of any material. It describes how easily a materi…
Read more
EngineerExcel
Frictional Loss in Pipes
Frictional loss in pipes refers to the energy lost as fluid flows through a length of the line. Sev…
Read more
EngineerExcel
Hazen-Williams Equation Explained
The Hazen-Williams Equation is used to calculate the head loss (pressure loss) of water due to its …
Read more
Online Excel Tips – Blog – Trump Excel
10 Excel Pivot Table Keyboard Shortcuts
Pivot tables are used by hundreds of thousands of people every day to analyze and summarize large a…
Read more
EngineerExcel
Manning’s Equation for Pipe Flow
Manning’s equation calculates flow parameters for gravity-driven water flow. The formula input valu…
Read more
Online Excel Tips – Blog – Trump Excel
Row vs Column in Excel – What’s the Difference?
While this may be a basic question for many Excel users, I have been asked multiple times about the…
Read more
Online Excel Tips – Blog – Trump Excel
How to Add Week to Date in Excel?
It’s a common requirement to calculate the date after a specific number of weeks from the current d…
Read more
Social Plugin