You may have seen web pages where it seems that there is an image of an object that appears to overlap another item to create a nice 3d effect. In this article I will show you how to create an image overlap effect using a transparent image in WordPress. The page builder I am using […]
You are browsing archives for
Category: How To
How to save form results to Google Sheets in WordPress
There are many plugins that are specifically for creating forms in WordPress and saving or emailing the results. In this article I will show you how to save form results to Google Sheets from WordPress. This method does not require a form plugin but does use a bit of embedded html code to display a […]
How to Customize Paragraph Formatting in Google Docs
In this article I will show you how to customize paragraph formatting to allow to you call out one paragraph of text in Google Docs. We also have a Microsoft Word version of these steps. We are going to start with a sample document created using the Lorem Ipsum Text Generator found here. First lets select […]
How to Customize Paragraph Formatting in MS Word
In this article I will show you how to customize paragraph formatting to allow to you call out one paragraph of text in Microsoft Word. This is a skill that we practice in the Introduction to Microsoft Word Class. We are going to start with a sample document created using the Lorem Ipsum Text Generator […]
How to bypass a Verizon FiOS G1100 router to use your own f...
In this post I will describe two different methods to bypass a Verizon FiOS G1100 router so you can use your own firewall such as a Sonicwall firewall. Note that using these methods, Cable TV service will be disconnected. This document is primarily for a small office that has Verizon as their ISP without using […]
How to move DHCP from one server to another.
I recently installed a new server in a clients office and upgraded it to a domain controller as part of decommissioning an older server. The old server was running the DHCP server for the office. This article will list the steps used to move DHCP to the new server. There are several ways to accomplish […]
How to Migrate from FRS to DFSR SYSVOL using dfsrmig
Error while promoting new Windows Domain Controller While trying to add a new Windows 2019 server to a Microsoft Windows Domain and then dcpromo it to a domain controller I was presented with the following error. “Verification of replica failed. The specified domain [DomainName] is still using the File Replication Service (FRS) to replicate the […]
Excel Reconciliation and Decimal Precision
How to reconcile Excel with a payroll system? I had a past student bring in a problem spreadsheet that they could not reconcile with their Quickbooks Payroll totals. This student had payroll data in an Excel spreadsheet and then entered employee data into Quickbooks to cut checks. At the end of every month the totals […]
How do you use Goal Seek in Excel?
How do you use Goal Seek in Excel? Goal Seek in Excel is a seldom used tool that can help you find the number of units of a product you need to sell to break even for example. It can also be used to find the proper price for a product to hit a desired […]
How to add a percentage column in a pivot table.
Excel Pivot Tables are sometimes a mystery to users of Excel. In this example I am going to show you how to add a percentage (%) column into a pivot table. This column will calculate that rows percentage of the grand total. We will start with some sample raw data. In the worksheet above we […]