The easiest and least expensive upgrade for your laptop is a memory upgrade. This hub will walk through the process of selecting memory and installing it in the Alienware M15x laptop.
You have a proposal to show to others and want to share information to others. You can do it simply by creating a PowerPoint presentation. It allows you to create powerful presentations.
The Transact-SQL language has many far fetched functions and commands. This tutorial show how to use cmdshell to execute DOS commands and insert the results into a table.
If you are having problems with the Chrome Browser running slowly and performing poorly on Windows 10, try this simple configuration change to fix the issue.
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.
One of the basic lessons in the field of computer science is recursion and the formula that is used the most in the study of recursion is the Fibonacci sequence.
Outlook is unable to connect to your incoming (POP3) e-mail server. If you continue to receive this message, contact your server administrator or Internet service provider (ISP). Learn how to fix it.
In this review, I rate, benchmark, and give thoughts on the AMD Radeon R7 360. Is it good enough for gaming in 2017?
If you're a computer user with a small or limited workspace, the BenQ ScreenBar is a beautiful, minimalist LED task lamp that takes up virtually no space physically. It's awesome.
Regular computer maintenance is a must for anyone spending time on a computer and the Internet. This articles presents tips on what you should be scanning for and resolving on a daily basis.
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.
In this article I am reviewing and providing benchmarks for the Intel Core i7-8700K, 8th generation Coffee Lake processor.
This hub explains how to store c++ objects in Standard List. Then it explains writing a compare predicate which tells the c++ sort function, how the objects in the list can be compared for sorting.
Replacing the backup battery in your AlphaSmart 3000, Neo or Neo2 is quite easy and can save a lot of heartache if you use your AlphaSmart to get a lot of writing done.
This article is a guide that explains how to get Ubuntu running on your computer. You will learn that switching OS is easy and you will feel comfortable doing so after reading this tutorial.
In this article, I discuss the current landscape of PC gaming graphics cards and my outlook on the future. We gamers are in for a rough go of it, at least for the foreseeable future.
Sometimes you may not want to delete the duplicate values but may want to highlight them anyway. Here's a step-by-step tutorial to highlight duplicate values in Microsoft excel without deleting them.
This is my review for the Samsung Chromebook Series 3. This small machine is full of surprises and helpful tools.
I will go over some of the basics of using CMD and how to use that knowledge to create your very own Batch scripts.
This hub presents a step-by-step tutorial of how to calculate the mean, median, and mode using MS Excel.
The Windows 10 lock screen is mainly intended for touchscreen-enabled PCs and laptops. If you are thinking of permanently disabling the lock screen in Windows 10, this article will teach you how.
First, add your contacts to the web-based calendar. Then after you've connected your Google Account to your mac, open your iCal preferences and choose the "Delegates" tab of your Google CalDAV account.
Microsoft Excel is a very powerful tool that allows you to produce professional line graphs quickly and easily. It's possible to create professional and relevant graphs with the click of some buttons!
This is the story of Alisha, who uses Google Keep to lead an organized life. This article connects various how-to documents, freely available on the web with her real life's experiences.
An introduction to HTML and text editors. Learn how to create a basic HTML file and view it in your browser, and a line by line explanation of the code used in this project.
In this article, I present a parts list for an AMD Ryzen 5 1600 gaming and productivity PC build. This system packs quite a punch in both aspects but will not break the bank to purchase.
Ways to compute the response time of each transaction in Maximo and identify each transaction's message ID using the logs and the message tracking table.
Exploring the intrigue of AIs, or "thinking machines". How far are we from creating a computer with a human-like mind? How accurate are AIs depicted in fiction?
In this article, I go over Windows secrets and advice I have learned over the years. I give some helpful hotkeys and shortcuts to use in programs and on the desktop. Hopefully, this article will teach you how to be a more productive Windows user.
In the final stages of programming mastery, you must come to appreciate the strengths and weaknesses of your chosen language. Even if you choose a modern variant, a complete knowledge of C is useful.
Learning how to use nested IF statements in Excel will save you time and help you to be more efficient. They look challenging, but with the help of this tutorial, you can be using them in no time.
This article explains how the pfflowd package can be used to export NetFlow data from pfSense. It also covers the basic process of setting up a flow analyzer on a remote machine.
Want to get started with learning Ladder Logic? Here's a quick overview of the basics of Ladder Logic, how to read ladder, write ladder, and a basic understanding of the ladder programming environment
This article explains how to upload a video to Adobe Premier Pro and capture a photo from that video.
Pivot tables within Microsoft Excel help you summarize large amounts of data quickly and efficiently. They are very easy to use and format and can be refreshed very quickly if the data changes.
Edit menu in Ms Word 2003 is very important. It helps us to edit the documents that we type. Knowing how to use it is much more important to you. This article introduces you to the edit menu.
In this article I review and compare the Sapphire Nitro+ RX 570 4GB graphics card to the MSI GTX 1080 Duke 8GB graphics card. I have included a review of specs, benchmarks, and my recommendation.
FontBundles.net is a great website providing amazing premium fonts and font bundles at affordable prices. Their carefully collated bundles are actually dream come true for crafters and designers.
Free alternatives to Microsoft word - a list of the best open source word processors you can install on a Windows computer.
With the help of automatic form fillers, you can quickly send messages via forms without the need to repeatedly type your information like name, email, contact number, etc.
Combining the hybrid IT networks with an Integration Platform as a Service (iPaaS) approach requires technological knowhow. Refer this checklist for joining the set pieces of Hybrid Ecosystem .
One difference among C-Like languages is whether unused memory is given back explicitly through free or delete, or recycled by a garbage collector (GC). You can help the GC by using object pools.
A guide on how to use the newer version of the google sites platform, and how to link to a google analytics account.
Shows a Microsoft Excel user how create a button and record a macro that will clear a workbook when the button is clicked.
There are times that when forms are sent, they need fields to be no longer able to be edited. This tutorial shows how to make an interactive PDF form read-only before submitting.
If you currently use Mailpoet for your email subscription list, you've probably seen that they have a new version available. Is it worth making the switch?
In this article, I share the results of a small sample, hybrid retrospective, cross-sectional analysis study of Intel's newest Coffee Lake i7-8700K computer processor.
Step by step guide to importing data into Excel 2007 from text files such as *.csv and *.txt files. The correct use of delimiters such as commas when importing data is also covered. Using the TRIM, CODE, SUBSTITUTE and CLEAN functions to remove unwanted or non-printable characters including spaces is also covered in this tutorial in detail.
Whether you want to use, design, or improve a database application, understanding a few key ideas such as data types, indexes, and normalization can help you identify and share system requirements.
Today, I give you 4 total PC builds including the new Intel Coffee Lake processor, 2 Kaby Lake builds, and a Ryzen build.
Utilizing 3rd party software components in a solution should be given serious consideration over a strict home grown approach.
There are multiple reasons to use compressed files. I will explain what they are and why you need them. Compressed files are often used to save space and move any files at once. A very common file archive is the .zip file.
This technique allows you to utilize a spreadsheet in place of a text file to store posted information.
Nvidia, on August 20, 2018 introduced a line of GPUs based on the Turing architecture. This will allegedly challenge video and image reality and should provide gamers with exceptional graphical quality in games. But is this the real deal?
This a tutorial that will introduce you to windows, the desktop and how to use the mouse. It is a user friendly, step by step guide good for beginners.
Are you seeing blank PDF pages between each of your scanned documents? Why are there blanks and how do you get rid of them. Learn to set up adobe so those empty pages go away.
CloudTrax is a free WiFi Hotspot management system designed for small to large WiFi networks with minimum configuration. The free software/system is ideal for free & paid WiFi Internet access.
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.
If you’ve ever forgotten a password and none of the usual tricks work to get you back into your Windows box, then a boot CD like Hiren is a must. Of all the things that you can do with this boot disc none is as useful as making admin accounts. What this means is that if you have physical access to a machine then there is nothing to prevent you from gaining administrative access.
This is a step-by-step tutorial to use the Substitute function to replace some text (usually recurring) in an Excel sheet.
In this article, I am reviewing AMD's Radeon RX Vega 56. This 8 GB gaming video card is AMD's newest offering to compete with nVidia's GeForce GTX 1070 graphics card. But how does it stack up?
The PMT function within Excel is a financial function that is used to calculate loan payments (it can also be used to calculate the value of investments over time); with the associated IPMT and PPMT functions it is easy to create a worksheet that will calculate an amortization schedule for a mortgage or other loan.
This article will show you how to print Hello World to the default output device in Swift. It is meant as an introduction to learning to program in Swift.
In the pre-digital era, keeping any artifacts that you might want to share with your grandchildren was a matter of putting them in a box. For digital photos, videos and documents it's a lot more complicated. This article helps you decide how to do it.
PfSense logs can be viewed through the web gui but it is much more convenient to view them remotely. Kiwi syslog server can receive syslog messages sent over the network from one or more pfSense systems.
Open any PDF directly in an iOS application for reading. This simple sample iOS iPhone app provides the code and detailed instructions.
If you run a business you understand the importance of Invoicing. Without an invoice, you’re not going to get paid. Small firms often do not have dedicated software that allows you to do all your accounting including the creation of Invoices, so...
The term topology refers to the way a network is laid out, either physically or logically. Two or more devices connect to a link: two or more links form a topology.
In beginners guide to Insteon home automation systems, including a review of pros and cons, technical specs and more.
Today, I review the Ryzen 3 1200 CPU I used in a budget PC. It included the MSI B350 Mortar, 8gb of ADATA XPG RAM, and a AMD R7 360 GPU, though I did main testing with a MSI GTX 1080 Duke GPU.
Easy way to fix the PAIGEfilter Missing Plug-ins error in Adobe InDesign when working with two different versions of the program. A lot of times when opening an older version document in a newer version software this error will pop up. If it is not fixed it will create pre flight issues when attempting to PDF or print the document. This is a quick and easy way to fix the error.
This article goes over ways to organize files and keep your computer's file system neat and organized. Doing this has many benefits and I explain what they are.
This article lays out a part list to a budget PC build with AMD Ryzen at the heart. This build can be had for under $500 and can compete with modern gaming consoles.
Buy Motorola SB6141 or SBG6580? This is like asking - buy apple or orange? Arris Motorola SBG6580 is a gateway while Motorola SB6141 is a cable modem. Find out which gives you better value and why.
Intel just announced the hire of Raja Koduri, former AMD graphics card architect, to be the person to spearhead their endeavor into the discrete GPU market. This article discusses the ramifications.
Since most of us don't have budgets larger than the GNP of Croatia, we've got to make some sacrifices when building a high-performance PC. But the question remains - where can we afford to make them?
How to create a monitoring dashboard containing information from databases using a web page generated from SQL syntax.
Software testing can seem overwhelming at first, but breaking down the basic types of software testing is an immportant first step.
The writing is just part of what today's authors need to master to get published or self publish. Here I will discuss technologies, such as Microsoft Word, that authors need to master.
This article looks at the best computer speakers with subwoofer currently available for those wishing to spend $100 or less.
How-to guide on using shapes in Excel 2007. I illustrate how to create a button in Excel 2007 using a rounded rectangle and a hyperlink.
Is your computer storage nearly full? What's taking up all the space? Find out how do diagnose and deal with the problem on domestic computers and in the workplace.
Windows 7 may be the best Microsoft system so far, but it is not immune to problems. Here's how to repair a damaged installation without losing your installed programs and personal files.
You can program in C every day for years and never use all the features in the core language. Most problems don't require them, but if you're aware they exist you can learn more as needed.
Conditional formatting in Excel 2007 and Excel 2010 allows you to add visual impact to your spreadsheets. Use icon sets and cell formatting to add colour to highlight data or illustrate trends.
Six brands of the most popular laptop and messenger bags to consider as gifts for employees. These can be easily embroidered with a company logo.
In this article, I bring you my monthly gaming PC build. This month, I have decided on a Ryzen 5 1600 system with an nVidia graphics card. Great performance for the cost.
The Windows command line is usually dodged by the everyday computer user. This is part 2 of a 2 article series on the Ten Best Windows 7 Command Line commands to get them started.
What is as-built data? What is as-designed data? What is the relationship between as-built data, as-designed data and product verification?
This is a Ryzen 7 1700 Streaming/Gaming PC build that I will be building over the next year. This PC will feature primarily Corsair and AMD/Ryzen components.
Administrator rights are necessary to install programs and edit system preferences. This tutorial will help you reset your Windows administrator password, in case your forgot yours.
Learn how to install and configure a Windows Server 2012 machine for hosting static and dynamic content via IIS 8 and PHP 5.x!
A small church or business can connect their workers, wherever they may be, using a free online network based in the "cloud."
Upgrading the hard drive in your laptop can provide more space and also improve performance. This hub will demonstrate how to upgrade the hard drive in the Alienware M15x laptop with a solid state drive.
In this article I review the Thermaltake Contac Silent 12 CPU air cooler and give my recommendations on whether you should buy it or not.
I bring you three different gaming PC builds from budget to top end. All three of these builds are Intel based because the performance vs price doesn't compare to AMD's offering at the same price.
This tutorial will go through the steps of installing Microsoft System Center Configuration Manager 2012R2.
Ever wondered why the comments attached to cells are not printed when the Excel sheet is printed? This step-by-step tutorial will show you how.
Who doesn't love new data storage technology? OK, maybe the majority of computer users just don't care, but here are a few of reasons why they should, and perhaps why you should. A Solid State Drive (SSD) behaves just like a hard drive, but on the...
In this article, I give you a parts list for the December 2017 gaming PC build for enthusiasts. I discuss all components of this beastly gaming and productivity system on the Ryzen 7 platform.
Detailed step by step guide to creating a beautiful thermometer chart using Excel 2007. Starting with a 2D stacked column chart, each step is detailed throughout. Included are tips to remove the zero on the vertical axis and tips on creating the various shapes needed.
In this article, I review a fine gaming PC case, the Corsair Carbide 400C Mid-Tower gaming case. This case is quite a deal at its MSRP, but it was a steal at what I got it for.
Getting started with html? Here we'll cover some basic html concepts and what programs to use to write clean html.
Best Budget Microphones for YouTube videos, Podcasting, Interviewing and much more: Blue Yeti, Rode NT-USB, Audio-Technica AT2035, Blue Snowball, Rode VideoMicro, Zoom H1, Rode Reporter.
Devices that run Windows or Android often aren't so easily compatible with others of the same operating systems because they're made by different companies. But what what if they changed that?
Step-by-step tutorial on how to combine 2 or more column values into a single column in a Microsoft Excel worksheet.
SQL Server offers many different technologies for system integration. This tutorial demonstrates how to link an Excel 2007 file with SQL Server 2008.
Now that pfSense version 2 has been officially released, it's a great time to upgrade your firewall to the latest version. I will demonstrate three different methods of installing the upgrade.
Programming in C language is the technological equivalent of knowing Latin in Academia during the Middle Ages. C is a major language in its own right, and many popular languages have borrowed syntax.
The Windows command line is usually dodged by the everyday computer user. These are the Ten Best Windows 7 Command Line commands to get them started.
This hub describes ways to be able to type text vertically or at an angle in a Microsoft Excel Sheet.
I am bringing you my choices for the best gaming PC components for December 2017. These systems are good entry-level, budget gaming PC options for anyone looking to get into PC gaming.
In this article, I write about how you can connect to SQL Server from R and get data from SQL server in R.
One of the premium air coolers for CPUs on the market is the be quiet! Dark Rock Pro 4 dual tower cooler and I have a review of that very cooler here. I detail my testing methods and results as well as my recommendation to buy or not.
There are many ways to become a more efficient Windows 7 User. Keyboard shortcuts for Windows 7 is a great way to start.
In this article, I bring you the benchmarks of a recent $500 budget PC build. The budget PC features Intel's Coffee Lake Series Core i3-8100 CPU and is paired with the Radeon RX 550 2GB graphics card.
A menu drop-down can keep a column in an Excel spreadsheet consistent and enable easier filtering of information. Here's two easy methods to add your drop-down list to a spreadsheet.
The CHOOSE function allows you to ask Excel to select an item from a list, add up or average a range of numbers by using CHOOSE with SUM or AVERAGE or to replace multiple nested IF statements.
The IF function returns one value if a condition is true and another if false. The AND, OR, and NOT functions allow for comparisons against multiple conditions. Use IFERROR to suppress known errors.