Shows a Microsoft Excel user how to apply the IFERROR Function to remove errors in cells.
Covers how to use the VLOOKUP function in Microsoft Excel with examples on the correct syntax to use.
Shows a Microsoft Excel user how to use the count function in a spreadsheet.
Shows how to use the AVERAGE function in Excel with application examples.
Covers how to use the ABS function in Microsoft Excel with examples on the correct syntax to use.
Shows how to create a transcript in Microsoft Word from a Youtube Video. A macro is created in Word to make adjustments to the text formatting.
Shows to how insert the Bing Maps add-in and what you can do with it.
This tutorial walks you through the few steps that it takes to create a histogram in Microsoft Excel with the Data Analysis ToolPak.
Show you how to delete pages from a PDF document from the Tool menu and using a short cut key while working with Adobe Acrobat Pro DC.
Shows how to find websites for academic research that is conducted in the United States to narrow searches on Google.
Shows a Microsoft Excel user how to create a button that opens up the Windows pre-installed calculator application from an Excel spreadsheet.
Shows a Microsoft Excel user how to use a hyperlink with a button to easily access a website without having to go directly to a browser.
Discover how PowerPoint can replace screen recording software to allow you to create presentations and tutorials for YouTube.
Have you every wondered if this was another way to look at your HubPages data. Here I explain how to read HubPages earning data graphically within Microsoft Excel. A short tutorial is used to describe the steps used to create a PivotTable that can be customize to your specific reporting needs.
This tutorial explains how to password protect an Excel Workbook in four easy steps.
This article discusses the adoption of lean manufacturing by the United States and how these lean principles help to reduce costs and reduce wastes to enhance business performance. Three of the biggest lean applications adopted from the Toyota Production system are discussed briefly.
Displaying the developer tab in Microsoft Word requires a few easy steps. In this tutorial I show step by step how to display the developer tab in Microsoft Word 2016. In addition, I go over some the options available after the tab is displayed.
This article shows you how to create a scatter plot in Excel. Also, you will learn how to display different chart elements.
Shows the steps to take to find out your version of Microsoft Excel.
The article describes how to create a macro button on an Excel spreadsheet that will save and close a workbook to avoid having to select both operations. This button can save you time and can be accomplished in only a few steps. A medium level of Excel skills is required to complete this tutorial.
In this tutorial I explain how to use an Excel Add-in to display stock price & percent change in a Microsoft Excel spreadsheet.
Shows how to edit the transparency of photos in Office 365 programs. The steps taken in this tutorial to explain this topic are completed in Microsoft PowerPoint but the steps are similar in Excel and Word.
The best Christmas songs are classics. Take a look at the songs that I cherish and spend your holiday listening to the Christmas songs that remind you of the Christmas past where the love of your family and music was all that it took to bring up your spirit.
This writing describes how to use the less advanced features of Google Ads to create an advertising campaign. You'll learn how to use Google Ads to create an ad campaign with a goal to increase website and phone traffic while targeting a geographical area of Google searches of related AdWords.
Shows how to utilize the FREQUENCY function to construct a frequency distribution in Microsoft Excel. An example data set is used to show how to apply the function to separate frequencies by class intervals.
YouTube was down for a period and I didn't enjoy all the negativity that it caused around the world. This is a guide to help keep you busy just in case a blackout occurs in the distant future. Let's call it a "things you can do list."
In this tutorial you will find out how to use Microsoft Excel’s NORM.DIST function to find the area of the a normal distribution. Three examples are offered to show how to find areas in the lower tail, upper tail, and middle area of a normal distribution.
This article describes elements of a PivotTable as well as how to create one. A step by step approach to creating a PivotTable is illustrated that does not require an intermediate understanding of Microsoft Excel. An Excel workbook is made available so the reader can follow along.
The tutorial shows a Microsoft Excel user how to use Excel Data Analysis ToolPak add-in to complete a descriptive statistical analysis. An example is used to show results for a data set.
This short tutorial shows a Microsoft Excel user how to add spin buttons to a spreadsheet to increase or decrease values incrementally.
This tutorial shows you how to record tasks and assign these tasks to shortcut keys. The record macro function is utilized to record the tasks. You can follow along with examples if you download the example spreadsheet that is made available in the article.
This poem is about my Grandfather's inspiring traits that have inspired me throughout my life. I only knew him as a newborn, but till this day I think about him.
Describes how to use the CONVERT function within Microsoft Excel to convert various types of measurement units to other types of units. Types of conversions include: weight and mass, distance, time, pressure, force, energy , power, magnetism, temperature, volume, area, information, speed and more.
Shows a Microsoft Excel user how create a button and record a macro that will clear a workbook when the button is clicked.
Shows multiple methods to find the future value of investments.
This article describes why takt time is useful and shows an example of a takt time calculation.
This article describes why to choose an X-Bar R chart and how to construct the graphs in Minitab with an example.
The application of break-even analysis is important in business. An example of an analysis in included in this article where production processes are compared to show breakeven point and a Microsoft Excel graph is created to illustrate breakeven points.
This is a tutorial on how to plan and create flowcharts. Flowchart symbols are available to download and are introduced with descriptions of their applications.
Shows how to create a classic Google Sites webpage to share content. In the example I use links articles that I created to make a niche website.
This article shows you how to compute process capability using Minitab 18. You can read along or follow tasks with a provided Minitab file data. A short analysis of the data is conducted.
This tutorial on how to create a regression in Minitab includes sample data to follow along with. Explore this straight forward explanation and short analysis of the results.
Prepare to be blown away with nostalgia vibes through alternative rock music. This list was put together with consideration of top alternative rock charts and my personal tastes. What is alternative rock some may ask? Listen and find out.
This tutorial on how to create a P-chart in Minitab includes sample data to follow along with. Explore this short explanation and an analysis of the results.
This is a tutorial on how to create a Pareto chart in Minitab 18. It includes sample data to follow along with while a chart is constructed and explained.
In this piece I Reflect on my first job working in an aluminum wheel manufacturing facility in the mid-west was a treat. Take peak into plant that works closely with the aluminum giant Alcoa.
This article explains how to upload a video to Adobe Premier Pro and capture a photo from that video.
You may need to bring data from different cells together in Microsoft Excel. One way to do this is to use a formula. A concatenate formula can display data together with spacing that is editable.
Developing a quality plan can be easier if you refer to your employees, customer’s responses, and other businesses for feedback. Let's start the conversation about quality improvement.
Here I reflect on my short stint in the aerospace industry in the United States of America. I discuss what components of quality (e.g., quality assurance, failure/external failure, and prevention) factor into the high costs of operations.
While completing my first month of earnings on HubPages I've been making some mental notes about strategy, writing improvement, and generally how I feel about Hubpages.
Shows how six sigma level of a process (process sigma), can be calculated with use of the upper tolerance limit (UTL), lower tolerance limit (LTL), mean, and Standard deviation of a process.
This article shows how to calculate the net present value and net future value of an investment that pays uneven annual payments. An example is provided with a detailed explanation.
The essay is a reflection that I had after reading the book "Complications" by Atul Gawande. I related the book to my fear of hospitals and poor judgement that both plagued me for years.
If you have an amortization problem to solve, it's possible to find all the data that you need with a financial calculator instead of creating a table. Find out how with a TI BAII+ calculator in a few steps.
If you have an amortization problem to solve, it's possible to find all the data that you need with a calculator instead of creating a table. Find out how with an HP 10bII+ calculator in a few steps.
The article will show you how to create a set of buttons allowing you to filter a table within a spreadsheet and revert to your original view quickly. A document template for the task will be provided.
This article shows you how to navigate through the MS Excel options menu to enable visibility of the developer tab within the Excel main menu.
Creating a list box (drop-down menu) in Excel can reduce data input and increase your work flow. Use these steps to create a simple list box in minutes that may save you hours of time.