This can be a sticky wicket if you’ve ever inherited a workbook that has charts linking data from several locations. Until you know how its put together, you either don’t change anything, or change one thing and watch all of it fall apart. To address this rather unpleasant choice, let’s first understand how it gets [...]
Q. Can I get college credit for my Microsoft Office Specialist certifications?
If you have a treasure trove of photos from the office or work site with which you’d like to create slideshow for your holiday gathering, it’s easy to do in PowerPoint.
Did you just do the most amazing thing on your computer, but sure you’ll never remember it again? Try the Problem Step Recorder (PSR) in Windows 7.
Q. I want to use Pivot Tables in my Excel dashboard, but I don’t want the viewer to easily change anything except the Report Filter selection. How do I do that?
Q. How can I avoid changing the data source each time my source data grows?
If you have a workbook that everyone views a little bit differently, you can automate it, so that everyone just has to click their own button. Even if you are the only one who uses it, but you use it differently for different purposes, this solution would work, too.
Q. I have workbooks with a lot of worksheets. I don’t need the horizontal scroll bar. I’d rather see more worksheets. Can I get rid of it?
If you’ve recently implemented or are thinking about implementing SharePoint in your new Office 365 environment here are a few things that I think are definite improvements.
How is the new Excel Sumlfs different from SumIf, and how do you dissect a formula to troubleshoot?