Tables in Microsoft Excel are used frequently. They help with formatting, filtering, sorting, creating ranges, and are even required to light-up or correctly use other features in the application. In this quick post, let me share two shortcuts that I… Read More ›
Microsoft makes it simple to deploy Azure SQL Databases. Once deployed, Microsoft Excel and Power Pivot make reporting against those databases a pretty much perfect experience. In this post, I’ll demonstrate how you can connect these technologies and produce meaningful… Read More ›
We have a common scenario as the basis of this blog post: use Microsoft Excel to calculate sales order and invoice totals for a specific month. Though, for a recent requirement, I had a data set and a few requirements… Read More ›
Both professionals and hobbyists depend on Microsoft Excel for scheduling and resource planning, and if that’s the case for you too, then the WORKDAY and WORKDAY.INTL formulas are two essential tools to have in your belt of Excel tools. Both… Read More ›
I’m excited to share this solution around Human Resources (HR) Onboarding using Microsoft Excel and SharePoint Designer Workflows in Office 365 and SharePoint. This is a unique way to track Human Resources’ progress as they complete essential steps in the… Read More ›
You saw how Excel, Office 365, and SharePoint empowers your team to deliver reports online in this post. That example used a pivot table to report on the status of Contract Lifecycle Management Tasks as they relate to a Sales… Read More ›
Contract Lifecycle Management and Microsoft Excel There are many ways to generate Contract Lifecycle Management reports in SharePoint and Office 365. To start, view the backround on how to convert the home page into a reporting dashboard: Most fully functional… Read More ›