Microsoft Office Compatible Productivity Tools on Your Mobile Phone or Tablet
jan 23,
2019
Use Polaris Office to access Microsoft Word, Excel, PowerPoint files on your mobile phone just like you do at your office! Let’s face it a majority of businesses use Microsoft Office productivity tools every day. But one day you find yourself on the road traveling on business without your laptop and you need to access […]
Ten Steps to Creating Reliable Spreadsheets
jul 31,
2018
Stop worrying about how sophisticated your spreadsheets are. What you (and your company) should worry about is how reliable your spreadsheet is. Here are ten things you can do to ensure your data is right and that you (and your company) aren’t depending on a unreliable spreadsheet. Embarrassingly enough, I run both my personal finances […]
Optimize SQL Server Queries with Index Statistics
aug 15,
2017
Television’s Mythbusters seem to have a lot of fun; it’s interesting that so many myths seem to involve blowing stuff up on camera. SQL myth-busting may not be as visually dramatic, but for people who are interested in query performance, it is much more important. There are a lot of people who think that it […]
Top 10 Excel Tricks for Increased Efficiency
mar 29,
2017
Considering the time today’s IT professionals spend staring at Microsoft Excel spreadsheets, one might think we’d all be Excel wizards by now. The truth is that while Excel has a low barrier to entry, to become a true super user takes a lot of time, energy, and dedication. While you may think you’re an above-average […]
Creating Rollover Interaction in Excel Dashboards
jun 30,
2016
Excel Dashboards can be great for conveying critical summary data regarding the state of investments, an important project, or even an entire business enterprise. Dashboards also pose many challenging problems for developers; one of the more important ones being, how to convey information using a limited amount of monitor real estate. One solution is to […]