Word Count in Microsoft Word Have you ever needed to get the word, page, paragraph or line count in an MS Word Document? Below are some examples of how to count the words in any amount of selected text including a sentence, paragraph or entire document. In this example I have a sample document with […]
Blog
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 […]
Fall 2019 Classes
If you are interested in learning more about Microsoft Excel, Microsoft Word, WordPress or are looking to learn more about your pc please have a look at some of our upcoming classes for the Fall of 2019. Classes are held in Marlboro MA, or Franklin MA. See the individual classes below for locations and times. […]
Can ping but not browse internet behind PFSense firewall
Had a frustrating problem of being able to ping the internet by name and by ip address but could not browse any website. My virtual pc was on a network protected by a PFSense firewall. Both the pc and the PFSense server were running as virtual machines on Xenserver. The firewall was connected to two […]
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 […]