When looking at sales income versus expense values in Microsoft Power BI, you can easily turn expense / cost values into negative numbers using DAX formulas. I’ll demonstrate a scenario using CONTAINSSTRING to convert numerical values imported from Microsoft Excel… Read More ›
Microsoft Excel
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 ›
Microsoft Excel – Quick Day Trading Averages using NETWORKDAYS
This is a post on how to use NETWORKDAYS in Microsoft Excel to help you track your average profits over your total number of trading days. In practice, Microsoft Excel is a great tool for tracking your day trading gain/loss… Read More ›
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 ›
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 ›
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 ›
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 ›
Microsoft Excel – Understanding Template Options
Most users of Microsoft Excel know that the product supports templates. There are the many out-of-the-box templates you are presented with when you first launch Excel, and there is the “Save as Template” XLTX options through which you can save… Read More ›
Power BI Fitness and Meal Planning with Excel
Power BI Fitness and Meal Planning with Excel This post demonstrates a Power BI Fitness and Meal planning solution based on Excel data. Power BI is an excellent tool for visualizing important data about the food we consume and provides… Read More ›