A metered connection is an internet connection that has a data limit associated with it. Some apps might work differently on a metered connection to help reduce your data usage. Also, some updates for Windows won’t be installed automatically. A cellular data network connection is set as metered by default. Wi-Fi and Ethernet network connections Read More
Month: January 2021
How to Fix: AS400 Client (Access for Windows) Installation Asking for Restart
When installing the Access for Windows Client, a Reboot pending message may appear resulting in the installation being aborted. Rebooting the PC has no effect on the message. When this occurs, you should check the following registry path: HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Control\Session Manager 1. Look for the following key: PendingFileRenameOperations 2. Right-click -> Rename. 3. Add a prefix ### and press Enter. Read More
How to Use Pivot Tables
Pivot tables are one of Excel’s most powerful features. A pivot table allows you to extract the significance from a large, detailed data set. Our data set consists of 213 records and 6 fields. Order ID, Product, Category, Amount, Date and Country. Insert a Pivot Table To insert a pivot table, execute the following steps. 1. Click any Read More
How to Use Conditional Formatting in Excel
Conditional formatting in Excel enables you to highlight cells with a certain color, depending on the cell’s value. Highlight Cells Rules To highlight cells that are greater than a value, execute the following steps. 1. Select the range A1:A10. 2. On the Home tab, in the Styles group, click Conditional Formatting. 3. Click Highlight Cells Rules, Greater Than. Read More