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
Online Excel Tips – Blog – Trump Excel
How to Convert Text to Date in Excel (8 Easy Ways)
Working with dates is a common task for many Excel users. And sometimes, you can come across dates …
Read more
Blog - Excel University
How to Clean Data in Excel – 8 Easy Ways
Man sitting at a desk with an open computer learning How to Clean Data in Excel The post How to Cl…
Read more
Blog - Excel University
CalCPA Article Instant Reconciliations
When you have two different lists that you need to compare, how do you do it? For example, you want…
Read more
Social Plugin