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_tiyi8vtkTp2VTWGalM7lNhFhNpRusCMSIv1gxuodwmk7htHwGz-hn-RHm4InlWO2QDRlj_aKR8OLfnDXiUSDlBA9lKhEUGxm4O5exPDNIWNwhwGw=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
How to connect to a SINGLE file on SharePoint from Power Query (Fix Unable to Connect Error)
I have been working with SharePoint a lot these days. A LOT!!! One thing that frustrates me all th…
Read more
Blog - Excel University
Skipping Excel 1
Excel is used for many different tasks, such as budgeting, reporting, comparing bank statements, an…
Read more
EngineerExcel
Polar Moment of Inertia Explained
An object’s polar moment of inertia is its ability to resist deflection due to an applied torque. I…
Read more
Filter one table if the value is in another table (Formula Trick)
Time for a quick but very handy Excel FORMULA trick. You have two tables. ORDERS & PRODUCTS. Y…
Read more
Online Excel Tips – Blog – Trump Excel
How to Compare Text in Excel (Easy Formulas)
Excel users often need to compare cells or columns to check if the same text is available in the ce…
Read more
Online Excel Tips – Blog – Trump Excel
Delete Blank Columns in Excel (3 Easy Ways + VBA)
When I was working as a data analyst years ago, part of my job was to download data from financial …
Read more
Online Excel Tips – Blog – Trump Excel
How to Sort by Length in Excel? Easy Formulas!
Excel allows you to sort your data set based on numeric values, text values, dates, as well as colo…
Read more
Blog - Excel University
What’s #REF in Excel and How to Fix It
When a formula contains an invalid cell or range reference, the #REF! error is displayed. #REF! in …
Read more
Join P3 Adaptive at PASS Data Community Summit 2022
Spend a week with us at the PASS Data Community Summit 2022 in Seattle November 15 to 18, and we’ll…
Read more
Which Excel Formulas should you learn first?
Let’s face it. You already know the SUMs & COUNTs of Excel. But what should you lea…
Read more
Social Plugin