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 ›
Business
Excel Profit and Loss – INDIRECT and VLOOKUP
You can build an Excel profit and loss spreadsheet using the INDIRECT and VLOOKUP functions. Together, these functions enable you to analyze profit and expense data for your projects. I’ll demonstrate how these functions can be combined to help you… 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 ›
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 ›
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 ›
SDL – Security Development Lifecycle – Threat Modeling – DREAD
Many of us today are developing solutions using Microsoft 365, AWS, and other cloud ecosystems as our core platform and computing environment. We also often tie in Azure services, and reach out across the globe to wire-in free (or subscription… 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 ›
Microsoft Project – Insert or Unhide Task Name Column
Not too long ago, I accidentally hid the “Task Name” column in a Microsoft Project plan. It wasn’t as obvious as I thought it would be to restore or reinsert that critical column. Here are some options for you if… Read More ›