Our PowerApps canvas app currently reads customers from a SharePoint list and also provides a way to contact customers with a “Send E-Mail” screeen. In this post, we expand the app once again so that it now includes a ticket… Read More ›
Office
Microsoft Power Apps – E-Mail App for SharePoint Contacts
Microsoft Power Apps with SharePoint and E-Mail The Microsoft Power Apps customer directory started in the previous post will now be enhanced. This post demonstrates how to add integration with SharePoint and providing a lightweight interface to contact customers via… Read More ›
Microsoft PowerApps – Filter Collection using List Box Control and Distinct
Let’s continue building on the customers list from the previous post by demonstrating how we can filter the collection that drives our customers data table. Our simple filter UI will be built using a List Box control and will also… Read More ›
Power BI – Sales and Expense Reports – Prepare Excel Tables from Office 365 SharePoint
Power BI can connect to Microsoft Excel files in your Office 365 SharePoint sites to produce powerful reports. You can then publish those reports and create dashboards using the Power BI Service in Office 365. In this first of two… Read More ›
Excel Stock Trading Spreadsheet using NETWORKDAYS
This is a post on how to use NETWORKDAYS in an Excel Stock Trading Spreadsheet. Use this workbook to help you track your average profits over your total number of trading days. In practice, Microsoft Excel is a great tool… 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 ›
Excel – VLOOKUP and OFFSET with Profit and Expense
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 Expense Reports – Global Currency Support in Office 365
In this post, Power BI Expense Reports will be created Office 365 using SharePoint. You’ll see how to create an expense report solution that easily accounts for your team’s global presence and globally accrued expenses. Below I demonstrate how to… Read More ›