MrExcel Publishing
1,129 FOLLOWERS
MrExcel is your one-stop for Excel tips and solutions. It is an entire community of Excel gurus who are dedicated to helping you unleash the power of Excel. whether it's solving an Excel emergency or simplifying a task, MrExcel.com is here for you.
MrExcel Publishing
5d ago
Microsoft 365 subscribers now have access to 925 People in Excel. In a study conducted by YouTube, 90% of the most-watched videos have an emotive human face prominently on the title card ..read more
MrExcel Publishing
5d ago
The IMAGE function debuted in August 2022. It is only for online images that are available through a URL ..read more
MrExcel Publishing
5d ago
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 ..read more
MrExcel Publishing
5d ago
Make sure to follow these rules when you set up your data for sorting, subtotals, filtering and pivot tables ..read more
MrExcel Publishing
5d ago
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 ..read more
MrExcel Publishing
2w ago
A bell curve is defined by an average and a standard deviation. In statistics, 68% of the population will fall within one standard deviation of the mean. 95% falls within two standard deviations of the mean. 99.73% will fall within three standard deviations of the mean ..read more
MrExcel Publishing
2w ago
Rather than creating a generic bell curve, how about plotting a list of employees or customers on a bell curve ..read more
MrExcel Publishing
2w ago
Three easy visualization tools were added to the Conditional Formatting dropdown in Excel 2007: Color Scales, Data Bars, and Icon Sets ..read more
MrExcel Publishing
3w ago
It is easy to create interactive charts without using VBA. By default, if you hide rows in Excel, those rows will be hidden in the chart. The technique is to build a chart with every possible customer and then use a slicer or a filter to hide all except one of the customers ..read more
MrExcel Publishing
3w ago
It is nearly impossible to read a chart where one series is dramatically larger than other series. In the following chart, the series for Year to Date Sales is 10 times larger than most of the monthly sales. The blue columns are shortened, and it will be difficult to see subtle changes in monthly sales ..read more