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 […]
Blog
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 […]
What is a Excel 3D Reference and How Do You Use One?
What is a Excel 3D Reference and How Do You Use One? Excel 3D References can come in handy when you need to perform a calculation on data located in the same cell across multiple worksheets. These type of calculations are sometimes forgotten. There is also some confusion on how to set it up. Below […]
Helpful WordPress Resources
Helpful WordPress Resources I have compiled a set of useful WordPress Resources to help build a website using WordPress. These include links to SEO guides, free images, free WordPress themes, Logo builders, online image editing tools and much more. These were initially for my class students however any new web designer may benefit from at […]
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 […]
How to create a dual axis chart in Excel
Creating a dual axis chart In my opinion, charting in Excel is an art that needs to be practiced extensively to be an expert. As I demonstrate many examples in class I like to give additional info here for reference, for past, or future students. In this example I will show you how to create […]
How to insert a degree symbol in Microsoft Word
How to Insert Degree Symbol in Microsoft Word I recently created a post on How to insert the degree symbol in Google Docs. The post received quite a few views so I figured I would create a similar post on How to Insert a degree symbol in Microsoft Word as well. Below is a simple […]