MrExcel Publishing
1,128 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
1w 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
1w 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
1w 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
2w 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
2w 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
MrExcel Publishing
2w ago
For 12 years, I worked at a company doing data analysis. One of my regular tasks was to analyze the profit on sales proposals before they went out the door. I did this with a waterfall chart. For me, the waterfall chart never would have to dip below the zero axis ..read more
MrExcel Publishing
2w ago
In 2016, Microsoft 365 introduced Funnel charts. Early in 2017, Map Charts appeared on the Insert tab in Office 365. A Map chart shades closed regions on a map such as countries, states, counties, even zip code boundaries ..read more
MrExcel Publishing
1M ago
After Google's spreadsheet product began offering the ability for multiple people to edit the same worksheet, the Excel team spent over two years developing a feature that they call co-authoring. The feature was released to Office 365 customers in the summer of 2017 ..read more
MrExcel Publishing
1M ago
Do you share a workbook with co-workers? Does you co-worker want to Filter or Sort the workbook differently than you do? Eight years ago, I was ready to strangle my co-worker Scott when he kept filtering our project list to show only his projects ..read more
MrExcel Publishing
1M ago
Threaded comments debuted in 2018. When you insert a comment, Excel stores the comment, the author, the date, and time. When a co-worker sees your comment, they can click Reply and add a new comment to the same cell. Each set of comments lists the author, date, and time ..read more