Author Archives
I am a software engineer, business and systems analyst, program manager, and technical architect with a passion for delivering business strategy and technology. Over the past 15 years I have partnered with dozens of employers and clients to achieve goals across the corporate landscape.
-
Microsoft Excel – Profit and Loss Reporting with INDIRECT and VLOOKUP Functions
The Microsoft Excel INDIRECT and VLOOKUP functions can be used together to help you analyze profit and expense data for your projects. I’ll demonstrate how these functions can be combined to help you break that analysis up by month and… Read More ›
-
Power BI – Sales Invoice Reports with Filled Map, Slicers, and Report Level Filters
Creating Sales Invoice Reports using Power BI is a straightforward concept, but it comes with some quirks when you actually go to build the report and evaluate the results. I’ll build a visual report in this post using the Filled… Read More ›
-
Office 365 SharePoint – Content Approval – Critical Non Repudiation Security Flaw
This post covers a critical security flaw in Office 365 SharePoint with the Content Approval feature and version history. I’m hoping it’s fixed by the time you read this, but I was told it is “by design” first by the… Read More ›
-
Microsoft Excel – Using VLOOKUP and OFFSET for Profit and Expense Charting
VLOOKUP and OFFSET can be combined in Microsoft Excel to produce quick and easy to read charts for analyzing your net profits, expenses, and total profit/loss. We’ll cover the basics of these formulas to demonstrate monthly p/l total calculations, along… Read More ›
-
Microsoft Excel – Expense Report with SUMPRODUCT and Simple Pie Charts
You can use the SUMPRODUCT function in Microsoft Excel to help you quickly calculate business expenses per department and then visualize that report data using Excel Pie Charts. That’s what will be demonstrated in this post, along with some use… Read More ›
-
Microsoft Project – Gantt Chart Outline and Task Essentials
The Gantt Chart view in Microsoft Project is the default view of new project plans, and understanding the basics of working with the Outline, Project Summary Task, Summary Tasks, and Subtasks will be critical to your success with project plans… Read More ›
-
Power BI – International Expense Reports with Office 365 SharePoint
SharePoint and Power BI come together perfectly in Office 365 to create an expense report solution that easily accounts for your team’s global presence and globally accrued expenses. “Create an expense report” solution in SharePoint is an old scenario, but… Read More ›
-
Office 365 SharePoint Usage Report with Microsoft Excel PivotChart
Recently, I posted how one can use the Microsoft Excel WEEKDAY function to help clean-up and provide a tabular report on monthly Office 365 SharePoint Usage. This post is a follow-up where I’ll demonstrate how you actually create the visual… Read More ›
-
Angular App for Office 365 SharePoint Using REST Web Services
After you register your custom applications with Azure Active Directory, it’s straightforward to build a completely remote application for working with Office 365 SharePoint data which depends only on the SharePoint REST web services. Angular SharePoint App Demo Below is… Read More ›
-
Microsoft Excel – Data Validation Functions and Conditional Formatting
Microsoft Excel has numerous functions and features that are used to validate data and apply conditional formatting to cells. Below we’ll see how to combine these features along with the CODE, ISNUMBER, and LEN functions to make quick work of… Read More ›
