Author Archives: Steve Chase
In this post I will explain how to create an Access report that has subtotals and percentage formulas. The first step is to ask the question for which the report will answer. Lets look at the screenshot below and ask … Continue reading
In this post I will explain how to format certain rows in Excel with formatting that matches a condition set you a formula. First lets study the sample dataset in the screenshot below. Observe that the first row of data is … Continue reading
This post will teach you about a feature that is connected to the crop tool in Photoshop. Open the photo and then click the crop tool or hit the shortcut key “c”. Once you activate the crop tool you will … Continue reading
Let’s say that we have a spreadsheet that records a purchase date for when a customer places an order and a ship date for when the product ships out. We would like to have a red flag in column A for orders that … Continue reading
Data Modeling Steps in Excel Power Pivot 1.Import data into Power Pivot Data Model 2.Create relationships between the Dimension Tables and Fact Tables 3.Create DAX formulas (Data Analysis Expressions) DAX Measures are used in the Values area of a PivotTable Calculated … Continue reading
The Vlookup function is an awesome function. It looks up information in a table where you have defined the lookup value in the left-most column of the table. In this video I share how to use it with an IF … Continue reading
The People Graph is an Excel 2013/2016 Add-In which makes graphic style charts. Find this command in the Add-Ins group of the Insert tab. Below is a video demonstration.
In this post I will share with you how to link an Excel chart to a PowerPoint presentation. This is helpful when you expect changes to be made to the Excel chart and you want to have your audience view … Continue reading
In this post, I am going to explain how to connect Visio shapes. You can connect to the shape or to its connection point.