Recent Active Posts
John O'Rourke
(VP of Product Marketing at OneStream Software)
Well, it’s the middle of 4th quarter, and many organizations are knee-deep in budgeting for 2018. How’s the budgeting process going in your organization? Is it running... Nancy Tso
(Head of Client Service at SkyStem)
Here is a story of what people used to do with Excel, back in the day… (here’s the full article)
Forgive me if I now divert into telling you a quick story about my... Charley Kyd
(Founder at ExcelUser) 
When Microsoft introduced Excel 2007, one of its best improvements was the Excel Table feature. This allows you to transform worksheets with columnar data into a simple database that... Charley Kyd
(Founder at ExcelUser)
Last month I blogged about my Complete Excel Shortcuts Workbook. So with shortcuts in mind, here are four useful ones that work from Excel in Windows 7…
The... Charley Kyd
(Founder at ExcelUser)
“Export to Excel is the 3rd most common button in BI apps…after OK and Cancel.”—Rob Collie, former member of Microsoft’s Excel team, and now CTO... Charley Kyd
(Founder at ExcelUser)
You can use a Pivot Table as a database in the same way that you can use Simple Tables or Excel Tables.
However, I’ve never seen a description of how to do it. ... Charley Kyd
(Founder at ExcelUser)
Excel offers three general ways to arrange data in your spreadsheet so you can use it as a database with your worksheet formulas:
Simple Tables, which I’ve used since... Charley Kyd
(Founder at ExcelUser)
Several years ago, I created my Complete Excel Shortcuts Workbook. It contains more that 250 keyboard shortcuts we can use when the workbook is active.
I created the workbook... Charley Kyd
(Founder at ExcelUser)
The purpose of management reports should be to help readers find and track patterns of performance…quickly and easily.
That’s the attraction of charts, of course.... 