December 4, 2023 - by Bill Jelen
Problem: I don’t want to use just static text in a shape; I want to display the results of a calculation in the shape.
Strategy: This is possible, although typing the formula in the shape is not the way to do it. Here’s how you do it:
Add Text to Any Closed Shape »
November 28, 2023 - by Bill Jelen
How can I add fixed text to a shape?
25 Years of MrExcel on November 21, 2023 »
November 21, 2023 - by Suat M. Ozgur
Can you believe it's been a quarter century since the MrExcel Message Board kicked off? Time really does fly when you're having Excel fun! As we take a stroll down memory lane, let's celebrate this incredible journey we've all been on together.
November 20, 2023 - by Bill Jelen
The oval tool in the Drawing toolbar is hard to use. If I start drawing the rectangle in the upper-left corner of the cell, the shape will start in that corner. But if I start drawing a circle in the same spot, the oval I draw will not completely include the text in the cells. Also, why aren’t there circle and square shapes? I have a hard time drawing perfectly round circles and perfectly square squares.
Guerrilla Data Analysis Using Microsoft Excel - 3rd Edition
May 2022
Two of the leading Excel channels on YouTube join forces to combat bad data. This book includes step-by-step examples and case studies that teach users the many power tricks for analyzing data in Excel. These are tips honed by Bill Jelen, "MrExcel," and Oz do Soleil during their careers run as financial analysts.
Microsoft Excel Inside Out (Office 2021 and Microsoft 365)
December 2021
Dive Into Microsoft Excel for Office 2021 and Microsoft 365 and really put your spreadsheet expertise to work. This supremely well-organized reference packs hundreds of timesaving solutions, tips, and workaroundsall you need to make the most of Excels most powerful tools for analyzing data and making better decisions.
Supercharge Power BI - 3rd Edition
February 2021
Released in 2021, this book will teach you the DAX language from the ground up, using Power BI as your canvas.
Your Excel Survival Kit - Second Edition
March 2021
This book helps you realize that Excel is on your side. It can be your friend, not your enemy. If and when you upgrade your Excel skills you will experience many positives: you will learn to love Excel, you will learn how to use Excel to become an invaluable asset in your workplace.