# Category Archives: Excel

## My 6 Recent Blog Posts I published on my other website

Hi Friend, Thank you for your support and following of my Steve Chase Docs blog. I am really blown away by my readers – (that’s you!). Your attention and eagerness to read my posts have amazed me. Since I started … Continue reading

## Join me for 3 free Excel webinars

I’d like to invite you to join me in an upcoming Excel 3 part webinar series. These sessions are for anyone wanting to get better at Excel. Session #1 Excel Tables on 2/22 (Sort, Filter, Calculations within Tables) Session #2 … Continue reading

Posted in Excel, Uncategorized | 3 Comments

## I am excited to announce my new business: Sequentia Solutions

I am excited to announce that I am starting Sequentia Solutions company to help small business owners. My business will help entrepreneurs grow their business and help them achieve their goals with efficient systems and processes.  It is bittersweet to … Continue reading

Posted in Excel | 4 Comments

## Highlight Rows of Data in Excel with Conditional Formatting Formulas

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

Posted in Excel | Tagged | 1 Comment

## Create a Status Report with Green Checks and Red Flags in Excel

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

## Building PivotTable Reports Using Excel’s Data Model in Power Pivot with DAX formulas

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

## How to Use the IF Function and the VLOOKUP Function Together In Excel

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

Posted in Excel, Videos | Tagged | 2 Comments

## How to Use the People Graph in Excel

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.

Posted in Excel, Videos | Tagged | 2 Comments

## Link an Excel Chart to a PowerPoint Presentation

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

Posted in Excel, PowerPoint | Tagged | 2 Comments

## Format Red Cells if the Date is Older than One Year in Excel [Video]

In this video, I will demo how to format rows with red formatting if the date has been more than a year old. I will use the DATEDIF function to work within the conditional formatting rules.