Online Excel Tips – Blog – Trump Excel
Get Day Name from Date in Excel (Easy Formulas)
When working with dates in Excel, sometimes you may want to know what day the date is (whether it’s…
Read more
How to write complex Excel formulas (hint: it’s a lot like LEGO)
Do you want to know the secret to building complex, advanced Excel formulas? Here it is…
Read more
Online Excel Tips – Blog – Trump Excel
How to Get Descriptive Statistics in Excel? (Quick and Easy)
If you’re working with large datasets in excel, getting Descriptive Statistics for this data set co…
Read more
Online Excel Tips – Blog – Trump Excel
How to Enable Macros in Excel? Everything You Must Know!
Macros in Excel are a game-changer if you have to deal with repetitive tasks. Macros allow you to a…
Read more
EngineerExcel
Section Modulus: Complete Guide and Calculators
Section modulus is a geometric property of a cross section used in the design of beams or other fle…
Read more
Online Excel Tips – Blog – Trump Excel
Calculate Area Under Curve in Excel (2 Easy Ways)
Area Under Curve (AUC) is a widely used concept in data sciences in multiple fields. While the conc…
Read more
EngineerExcel
Colored Vector Plot in Excel
In the last blog post, I showed how to use VBA to create a vector plot in Excel. That plot was just…
Read more
Online Excel Tips – Blog – Trump Excel
How to Delete Named Range in Excel? 2 Easy Ways!
Named Ranges can be extremely useful when you’re working with a lot of data and formulas. Named ran…
Read more
Blog – Excel University
Excel Month List
In this post, we’ll create a list of months with a single Excel formula. To make it more interestin…
Read more
EngineerExcel
Create a Vector Plot in Excel
For some time now, I’ve been interested in figuring out how to create a vector plot in Excel. I did…
Read more
Online Excel Tips – Blog – Trump Excel
How to Copy and Paste Column in Excel? 3 Easy Ways!
When working with Excel spreadsheets, copying and pasting data is a frequent task. And many times, …
Read more
EngineerExcel
Colebrook-White Equation
The Colebrook-White Equation (or simply Colebrook Equation) is an engineering equation used to appr…
Read more
Online Excel Tips – Blog – Trump Excel
How to Get the Sheet Name in Excel? Easy Formula
When working with Excel spreadsheets, sometimes you may have a need to get the name of the workshee…
Read more
Blog – Excel University
PivotTable with Multiple Text Values Alternative
If you have tried to insert a text field into the values layout area of a PivotTable, you may have …
Read more
EngineerExcel
Numerical Integration in Excel
There are two primary ways to perform numerical integration in Excel: Integration in Excel via the …
Read more
Blog – Excel University
PivotTable Text Values Alternative
This post show how to use Power Query instead of a PivotTable to display text values in a report. …
Read more
Online Excel Tips – Blog – Trump Excel
How to Select Entire Column (or Row) in Excel – Shortcut
Working with Excel means working with cells and ranges in the rows and columns in it. And if you wo…
Read more
EngineerExcel
Linear Interpolation in Excel
To perform linear interpolation in Excel, use the FORECAST function to interpolate between two pai…
Read more
Blog – Excel University
Retrieve QuickBooks Data with Genius Sheets
This is the next post in the add-in series, where we are exploring various add-ins that expand the …
Read more
Online Excel Tips – Blog – Trump Excel
How to Insert New Worksheet in Excel (Easy Shortcuts)
Working with MS Excel means working in the worksheets in Excel. A worksheet is an area that has all…
Read more
Online Excel Tips – Blog – Trump Excel
How to Convert Numbers to Text in Excel – 4 Super Easy Ways
Excel is a great tool which can be used for data entry, as a database, and to analyze data and crea…
Read more
Blog – Excel University
Mapping Table without a Helper Column
A mapping table is a handy way to automatically translate labels between systems and reports. As wi…
Read more
Blog – Excel University
2021 Scholarship Winners
I am excited to announce this year’s Excel University scholarship winners! These scholarships are s…
Read more
Online Excel Tips – Blog – Trump Excel
How to Calculate PERCENTILE in Excel (Easy Formula + Examples)
Percentile is a statistics metric is that is often used when working with data. It gives you an ide…
Read more
Online Excel Tips – Blog – Trump Excel
Calculate Percentage Change in Excel (% Increase/Decrease Formula)
When working with data in Excel, calculating the percentage change is a common task. Whether you wo…
Read more
Blog – Excel University
Excel to Word Document Automation
This is the next post in the add-ins series, where we are exploring various add-ins that enhance an…
Read more
EngineerExcel
Engineering Notation in Excel
In this post, you’ll learn how to display numbers in Excel using engineering notation, how engineer…
Read more![Sorting values in Olympic Medal Table style [Quick Tip]](https://lh3.googleusercontent.com/blogger_img_proxy/AEn0k_v81xmfaHXbIP1lah1rkeFrHoOZ4Ybpq8R_JjYVR9UVMA4Dv0RCcq6Sp-jP_SJeu0lx6zxQW4DwC6Va2f8De9ZWSr8X_46EwR4x6Es0mTJsiZWEIIKfNDlZXQQ3F4ckD5Vo5v0i-QIBgA=w680)
Sorting values in Olympic Medal Table style [Quick Tip]
It is Olympic season. Everyone I know is tracking the games and checking their country’s performanc…
Read more
How to use Date & Time values in Excel – 10 + 3 tips
Knowing how to use Excel date values can help you save a ton of time in your day to day spreads…
Read more
Blog – Excel University
Text Toolkit by Ablebits
This is the next post in the Add-Ins series, where we are exploring various add-ins that enhance an…
Read more
Online Excel Tips – Blog – Trump Excel
How to Find Slope in Excel? Using Formula and Chart
The slope of the regression line is a measure of the steepness of the line. It’s a numeric value th…
Read more
Online Excel Tips – Blog – Trump Excel
NAME Error in Excel (#NAME?)- What Causes it and How to Fix it!
If you have worked with Excel formulas for a while, I am sure you must have encountered the #NAME e…
Read more
Online Excel Tips – Blog – Trump Excel
How to Copy Excel Table to MS Word (4 Easy Ways)
When working with data in Excel, you would often have a need to copy some tables from Excel into an…
Read more
Online Excel Tips – Blog – Trump Excel
How to Make a Scatter Plot in Excel (XY Chart)
Excel has some useful chart types that can be used to plot data and show analysis. A common scenari…
Read more
Blog – Excel University
CalCPA LET Article
Often, our Excel formulas are simple and short. As such, they are easy to read, understand and main…
Read more
Online Excel Tips – Blog – Trump Excel
How To Subtract In Excel (Subtract Cells, Column, Dates/Time)
While Excel is an amazing tool for data analysis, many people use it for basic arithmetic calculati…
Read more
Online Excel Tips – Blog – Trump Excel
How to Combine First and Last Name in Excel (4 Easy Ways)
Excel is an amazing tool to store and analyze data. And many of the times, you will have to deal wi…
Read more
Blog – Excel University
Visio Diagram from Excel Data
This is the third post in the Add-Ins series, where we are exploring various add-ins that enhance a…
Read more
Getting Started with Power BI – Sales Dashboard in one hour
LIVE on Friday, 25 June – 2021 Make a Sales Dashboard in Power BI Getting sta…
Read more
Online Excel Tips – Blog – Trump Excel
Fill Down Blank Cells Until the Next Value in Excel (3 Easy Ways)
Watch Video – Fill Down in Excel A lot of times, you may encounter a data set where only one cell i…
Read more
6 Essential TEXT functions in Excel with 6 Everyday Examples
Excel text functions are useful for cleaning up text / alphanumeric values, extracting …
Read more
Online Excel Tips – Blog – Trump Excel
How to Calculate IRR in Excel (Easy Formula)
When working with capital budgeting, IRR (Internal Rate of Return) is used to understand the overal…
Read more
Blog – Excel University
Online Excel Tips – Blog – Trump Excel
Arrow Keys not Working in Excel | Moving Pages Instead of Cells
When everything is working as expected, when you hit the up arrow key or the down arrow key in Exce…
Read more
Online Excel Tips – Blog – Trump Excel
How to Add Months to Date in Excel (Easy Formula)
Sometimes, when working with dates, you may want to know the date after a specific number of months…
Read more
Online Excel Tips – Blog – Trump Excel
Combine Date and Time in Excel (Easy Formula)
Sometimes you may have dates in one column and time values in another column and you want to combin…
Read more
Blog – Excel University
People Graph
This is the first post in a series where we’ll be exploring various add-ins that enhance and extend…
Read more
Blog – Excel University
CalCPA LAMBDA Article
Excel has a lot of useful functions: FILTER, SUMIFS, VLOOKUP, XLOOKUP, SUM, SUBTOTAL and more. All …
Read more
Social Plugin