April 22, 2024 - by Bill Jelen
Every day, your IT department sends you a file with the columns in the wrong sequence. It would take them two minutes to change the query, but they have a six-month backlog, so you are stuck rearranging the columns every day.
You can reorder the columns with a left-to-right sort.
Add a new row above the data. Type numbers to represent the correct sequence for the columns.
Excel 2024: Sort East, Central, and West Using a Custom List »
April 19, 2024 - by Bill Jelen
At my last day job, we had three sales regions: East, Central, and West. The company headquarters was in the East, and so the rule was that all reports were sorted with the East region first, then Central, then West. Well, there is no way to do this with a normal sort.
Excel 2024: Set Up Your Data for Data Analysis »
April 17, 2024 - by Bill Jelen
Make sure to follow these rules when you set up your data for sorting, subtotals, filtering and pivot tables.
Excel 2024: Place Pictures In Cell From Local Computer »
April 15, 2024 - by Bill Jelen
For the last 30 years, you could use Insert, Picture in Excel. The image was added to a special drawing layer that floated above the grid. In June of 2023, that legacy experience became known as Place Over Cells. The new experience is to Place In Cell.
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.
Microsoft Excel Pivot Table Data Crunching (Office 2021 and Microsoft 365)
December 2021
Use Microsoft 365 Excel and Excel 2021 pivot tables and pivot charts to produce powerful, dynamic reports in minutes: take control of your data and your business!
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.
Microsoft Excel VBA and Macros (Office 2021 and Microsoft 365)
April 2022
Use this guide to automate virtually any routine Excel task: save yourself hours, days, maybe even weeks. Make Excel do things you thought were impossible, discover macro techniques you won't find anywhere else, and create automated reports that are amazingly powerful.