Excel Formula Formatting Quick Tip
Excel Formula Formatting Quick Tip
Learn the best Excel Formula Formatting technique so that you can quickly edit them in the future! You will use...
How-to Display Military Time in an Excel Spreadsheet
A few days ago, I had a user ask me a question on the blog about how she can display military time in Excel.
It...
How-to Setup Your Excel Data for a Stacked Column Chart with a Secondary Axis
Many users have mixed reactions about this secondary axis overlap fix. You can see the post here:
Stop Excel From Overlapping the Columns When Moving...
How-to Create and Copy a Table in Google Mail (Gmail) from Excel
On a recent project of mine, I tasked a team member with creating a communication to send out to users. This communication involved making...
USA Today Charts Part 2 – Excel Area Chart with Line and Area Highlights
Well, I have been working hard on my project and it has successfully launched. But that took time away from my other passion, EXCEL!!!
So...
Create a Vertical Line Between Columns in Excel Using Error Bars
Create a Vertical Line Between Columns in Excel Using Error Bars
Thanks to Leonid (a super fan) for advising me on another and possibly better...
Friday Challenge – Mimic Newspaper Chart Line Style in Excel
Hi All,
Here is a fun challenge that I thought you might like. I saw this chart in the Denver Post and I wondered how...
How-to AverageIF Excluding Zeros Across Excel Worksheet Tabs
I didn't receive any sample formulas from Friday's post that included a Friday Challenge, so maybe I stumped everyone when asking you to create...
How-to Make an Excel Bullet Chart
Executives and managers love to see gauge charts in their Excel Dashboards. However, gauge charts may confuse or mislead the dashboard readers. For instance,...
How-to Make a Basic Gantt Chart in an Excel Chart in 7 Easy Steps
Project Managers and Executives love Gantt Charts. They also love Microsoft Excel, Charts and Graphs. So it is a natural to consider how you...
