Author Archives: Steve Chase

About Steve Chase

I want to help you work in your business, so you can work on your business. I want to help you achieve your goals and help you have a successful small business journey. I understand that keeping up with the latest technology and cloud based computer trends can be difficult, when you’re running your day to day business. But, it is crucial that you keep up with the technology and best understand your options, in order to thrive in this new era of online business. I can help you discover the right software and tools for your business, train your team on how to use them, and mentor you to best serve and delight your customers. My certifications include: QuickBooks ProAdvisor, Microsoft Office Specialist Master, and OntraPort Certified Consultant. Please contact me on my new website at www.sequentiasolutions.com

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 | 2 Comments

Capture a Screen Recording as MP4 Video Format Using PowerPoint 2013 or 2016

Have you ever needed to create a video with narrations of your computer screen? In this post I will explain how to do that using the desktop Windows versions of PowerPoint 2013 or 2016. This new feature in PowerPoint is a great … Continue reading

Posted in PowerPoint | Tagged | Leave a comment

Create an Access Report with Subtotals and Percentage Formulas

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

Posted in Access | Leave a comment

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

Straighten and Crop an image in Photoshop

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

Posted in Photoshop | Leave a 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

Posted in Excel | Leave a comment

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

Posted in Excel | Leave a comment

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

Automatically Update the Date and Time Stamp for Access Modified Records

Posted in Access, Videos | Tagged | Leave a comment