How is giving me lots of fuel for my new business experience

Hey Friends,

As you know, I love reading, both for business and personal. Since I’ve started my business in May I have read many influential books some which includes:

  • Larry Burkett’s Business by the Book
  • Essentialism by Greg McKeown
  • Strengths Finder 2.0 by Tom Rath
  • Profit First by Mike Michalowitz

Currently I’m hooked on reading Business Model Generation by Alexander Osterwalder and Yves Pigneur and novel The Fountainhead by Ayn Rand.

It’s no secret that great business leaders are great leaders! So one of the most intriguing persons I’ve met recently has been Steve Cunningham. He is the founder and nararrator of, a membership service which finds the best business and personal development books and summarizes them in 12 minute audio and videos formats.

Books are being added at a pace of one a day. Topics includes Human Capital, Innovation/Trends, Entrepreneurship, Personal Development, Marketing, Sales, and Leadership.

“In my whole life, I have known no wise people (over a broad subject matter area) who didn’t read all the time — none, zero.” Those are the words of Charlie Munger – Warren Buffet’s right hand man, and one of the most successful business people in the world.

But you might be thinking how do I find time to read in my busy schedule? Well I think most people have a stack of business and personal development books somewhere collecting dust, waiting to be read with good intentions…someday.

That’s why I’m excited to bring you an exclusive offer from

For only $250, you get a Lifetime Membership to their service (regularly $1,499), and 10 -year memberships to gift For to the VIPs in your life (regularly $299 each).

There’s a reason some of the world’s most successful business people (including people on the Forbes billionaires list) and thought leaders use – you get the golden nuggets from the world’s best business and personal development books in less time than it takes to drink your morning coffee.

Even better, you’ll get access to every audio and video summary in the library — present, past and future — and they release a new book summary every single day!

This deal ends on Monday, November 8 at 11:59 pm EST, so grab it fast. They offer a 30 day money back guarantee.

Thank you for being a reader of this blog and I hope you have an amazing day! Learning from talented authors help us serve our customers!

Posted in Training Files | Leave a comment

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 be leaving New Horizons which I am very proud of the many wonderful relationships I formed with my students and fellow staff. I am grateful for all that New Horizons gave me to learn and develop both personally and professionally, including providing me with a training path for me to achieve 18 certifications in Microsoft Office. I feel wind in my sails from the New Horizons community to help me take off into deeper waters in life. My dad had owned several New Horizons in the Ohio Valley before he passed away in 2006. He taught me many leadership lessons in business and family life in which I can help pass along to my clients.


Question: What is sequentia?

Answer: It is Latin for sequence.

Question: What will your new services be?

Answer: I will provide QuickBooks Online bookkeeping services and help set up and manage systems and business marketing automation using OntraPort software. Sequentia Solutions will give me a new chance to do some very new and exciting things along the way!

After leaving New Horizons I have been busy pursuing two new fields of certification.

I took a QuickBooks Online certification course and I happy to have learned many new skill sets which has made me a certified QuickBooks ProAdvisor.

QuickBooks ProAdvisor

I also traveled to Santa Barbara to take a week long certification course to become an OntraPort Certified Consultant. OntraPort provides business owners with an all in one software solution to manage CRM and business marketing and automation.

OntraPort Certified Consultant

Question: How do you plan on doing all of this?

Answer: I plan on always learning and growing to help out my clients in the best way possible.

Question: What is one thing you are glad you did after starting on your own?

Answer: I am really glad that I purchased the Clifton Strengths Finder 2.0 book and assessment test. I discovered that my top 5 strengths are: Learner, Discipline, Harmony, Responsibility, and Belief. I will lean on my strengths in my new journey.

Question: Where can I find more information on your services?

Answer: Head over to my website, and like my new Facebook page

P.S. I still plan on blogging but will be doing it at Sequentia Solutions site.

Posted in Excel | 4 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 tool to get the job done in no time. When completed you will have an MP4 video format that can be shared via email or published online to your audience.

screen recordingBefore you begin open up the desktop version of PowerPoint 2013 or 2016 and check the Insert tab and verify you have the updated Media group with Video, Audio, and Screen Recording. Also do a test audio configuration of your microphone.

screen recording

Click Screen Recording and then choose Select Area.

select area

Drag the mouse pointer around the area you want to screen record. It will display a red dashed box around the area that will be recorded. Tip: Make the box as large as the monitor if you want to capture your whole screen or make the box smaller within the focus program to only select a portion of your screen. Once the recording starts any program that overlays inside the red box will get recorded. Anything outside the red box will not be recorded.

red box

Make sure you close any instant messaging program or email notification alerts that may distract your screen recording.

Click Record  when ready and you will see a 3-2-1 countdown. To  finish either use the shortcut key (Window key +Shift + Q) or click stop. The display bar may be hidden based on the pinned status so move your mouse to the top of the window to reveal the stop button.

The recording will appear on the PowerPoint slide as a video object as soon as you click stop recording. To export the video, right click and choose “Save Media as”.

save media as

The video will save as the mp4 format.


Tip: Before you save your mp4 video, you can first trim out the beginning or end of the video clip from the Video

trim video

I hope you found this post helpful. Here is a link to some of my favorite PowerPoint keyboard shortcuts.





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 “Which country has the highest units sold?” and “What is the percentage of the total units sold per country?” We will group the report by country which has United States, Canada, Brazil and the Dominican Republic.

sales table

First click the Insert tab and chose report wizard.

report wizard

Select the table(s) or query you want to work with.


Select the fields you want to be included in the report.


Group by country.

summary options

Select summary options.

calculate options

Click sum and check the box to calculate percent of total for sums.


name the report

Name the report and click finish.

You could touch up the report by clicking on the design view.



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 row 2 because we have a header row. So that means I will need to start off selecting the dataset with row 2. Then I will choose the conditional formatting button from the home tab and click new rule. When the new rule dialog box displays, I will click “Use a formula to determine which cells to format”.

Lets say that I want to highlight an orange row for all records that sales were sold in a “store”. Column C has either “store” or “online”. It will be important to write the formula using the first row of data that references the cell of that row. The formula will be =$C2=”store”. The reason for the dollar sign in front of column C is that is will absolutely reference column C. I do not want a dollar sign in front of row 2 because I want that formula to go down relative to all the other rows till the end of my dataset. Not certain you understand the difference between $A$1 and A1 then check out my video post explaining when you use absolute vs relative.

rules manager

Pick a format fill and then click ok.

rules managere

Here is what I get. All the rows containing “store” will show up in orange.:)

excel conditional formatting rows with orange

Let me do another example

Ok in this next lesson I will format all the rows that are Fridays. I can format the dates to long date format just to peek at the days of the week to help the screenshots.


First I will select the dataset and then click the conditional formatting command to add a new rule. I will use the WEEKDAY() function which results in a value 1 to 7.


Monday = 2

Tuesday =3

Wednesday =4




My formula will be =WEEKDAY($A2)=6.

Friday = 6

And my result is that all rows will turn green when the date is a Friday.

friday rows green


For more cool things you can do with dates use the DATEDIF formula. Details here.

Download my Excel keyboard shortcuts or Income and Expenses budget.




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 have the “Straighten” command in the tools panel above.

Click “Straighten” and then draw a line with the mouse across the horizon you want to be the corrected. The photo will rotate and crop out the corners. Then click the check mark or hit enter to commit changes








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 currently have not been shipped. And if the product has shipped we would like a green check mark. See the below the example and then keep reading and I’ll show you how to create this spreadsheet using either Excel 2007, 2010, 2013 or 2016. Note that row 6 and row 10 displays a red flag because those orders have not been shipped.

status report in excel

Step 1: Click in cell A2 and write a formula =IF(G2=””,-1,G2-F2). This IF function checks if the Ship Date is blank. Excel an verify if there is a blank cell by using the formula =”” so if G2=”” is true then make the value equal to -1. Otherwise, if the ship date is not blank, then use the formula to equal ship date minus purchase date [G2-F2]. The answer will be zero if the order has the same ship date as the purchase date. Note that on row 4 and row 7 that the formula equals zero because the ship date is equal to the purchase date which results in 0.

Step 2: Copy the formula down using the auto fill handle.

if formula

Step 3: With the status cells selected in column A, choose the Conditional Formatting command from the Home tab. Select the icon sets menu and then click the 3 symbols (Uncircled).

icon sets 3 symbols uncircled

Step 4: Click Conditional Formatting –> manage rules –> Edit formatting rule.

Step 5: Click show icon only (Screen shot below is from Excel 2013. Will look a little different in Excel 2007)

Step 6: Green check mark icon when value is >=0 Number. (Replace percent with number from the type drown down). Type a zero in the value area.

Step 7: Click no cell icon for when < 0 and >=0 Number. ( the middle range yellow exclamation mark will be replaced with no cell icon.

Step 8: Change the red X with a red flag for when <0 and click OK.

manage rules

Click here to download this practice file.

Download my Excel Keyboard Shortcuts here.






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 Columns are used in the criteria for Rows, Columns, and Slicers

4.Hide Tables and Fields not to be used in the PivotTables reports

5.Create PivotTables & PivotCharts

6.Refresh when source data changes

7.Update the Data Model if necessary






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 function after determining whether an individual has made their sales goal to determine their commission check.

Practice with my training file here. Also you might be interested in using the Match and Index functions as an alternative to the Vlookup if you have a large list of table columns.

Download my Excel Keyboard Shortcuts guide here.

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.

people graph excel


Posted in Excel, Videos | Tagged | 2 Comments