Longmont Computer Physicians – User Accounts in Microsoft Windows

Longmont Computer Physicians learning teaching series. Computer Physicians of Longmont, Colorado will post an explanation of User Accounts in Microsoft Windows 10.

One thing you will definitely need to have to use a Windows computer is a user account. User accounts are required to make sure people are allowed to access the computer only if the owner wants them to. In order to use a Windows computer, you will need a user account that has been configured for you by an administrator or when you first set up your new computer. There are many reasons why Windows has user accounts, including the following: Having a way to protect their personal files from being accessed from others (unless they want them to be accessed);  Providing a way to assign permissions to shared files and folders on the local computer or network;  Determining what type of functions that person is allowed to perform on the computer itself;  Tracking things such as login times, failed login attempts, and file access using event logging;  Setting allowed times for users to be able to log onto a computer or network;  Saving the personal settings of your computer, such as your desktop background and installed printers etc.;  Assigning levels of access for software usage.  Keep in mind as a home user you won’t have to worry about most of these because your user account will mainly be used to save personalization settings that you customized for your user account and to keep your documents from being accessed by other users. As usual, Microsoft has given us a couple of ways to work with user accounts, and each way works a little differently, but we will get to that later on in this chapter. User Account Types There is more than one type of account for a Windows user, and this makes sense because different people need different levels of access and permissions. The two main types of user accounts that you will be dealing with are the standard user and the administrator.

Standard user accounts are for people who need to do everyday tasks on the computer such as run programs, go online, print, and so on. Standard users can also install and uninstall certain software as well. It’s usually a good idea to make everyone on your computer a standard user, and then if they need something done that requires higher privileges, they can have an administrator do it. And by administrator, I mean you! Administrator user accounts have full control over the computer and can do things such as install or uninstall any software, add or remove user accounts, add or remove hardware, and make changes that affect Windows itself. If you are logged in as a standard user and need to do something that requires administrator access, many times you will get prompted to enter the username and password of an administrator so you don’t need to actually log out and then back in as an administrator to get the job done.

Creating User Accounts With social media being all the rage and everyone and everything being connected to each other, Microsoft decided that it wanted to use what they call a Microsoft account to log into your computer with. This way whenever you log into another device with the same account, it will use many of the same settings for a universal experience each time. A Microsoft account uses an email address to login rather than a standard username. But if you are the type that likes to keep things old school (and simple), then you can still use a standard user type to log in with. Even if your computer was initially configured with a Microsoft account, you can convert it to a standard account pretty easily. I find that local accounts are much easier to troubleshoot when it comes to login problems. To view the user accounts on your computer, go to the Windows 10 Settings and click on Accounts and then on Family & other users. From this screen you will see your account and any other accounts configured on the computer.

Longmont Computer Physicians learning teaching series. Computer Physicians of Longmont, Colorado will post an explanation of User Accounts in Microsoft Windows 10.

How to use the IF function with relational operators with Excel in Microsoft and Office 365

As part of our series of helping customers with their small business needs Longmont Computer Physicians, LLC is offering these free classes on how to use different software programs. Here is our instructional video on using Microsoft Excel spreadsheets.

Microsoft 365 Beginner class – Excel
Microsoft 365 Intermediate class – Excel
Microsoft 365 Advanced class – Excel


 

The IF function in Excel is one of its logical functions, which evaluate to either a “TRUE” or “FALSE” value. The IF function in Excel lets you perform a logical test on a cell’s value and then return a result based on whether or not the cell’s value passes or fails the test. The IF function is similar to an “If…then…else” coding statement. You must know at least three different arguments to write a logical function. The first argument is the “logical test” to apply to the cell. The second is the cell value or formula to return if the test returns a “TRUE” value or “passes” the logical test. The third is the cell value or formula to return if the test returns a “FALSE” value or “fails” the logical test. The syntax of the IF function is: =IF(logical_test,true_response,false_response) If you want the formula to display a text value for the true response or false response, then you must place the text value inside double quotation marks (“ ”). If you want the function to display a date, it must be enclosed within pound signs (##). The only time you wouldn’t mark the data type of the value to return is if you want the function to display a numerical result or calculate a formula. Often, you may want to know if a cell passes or fails multiple logical tests.

One way to apply multiple logical tests to a cell is to use nested logical functions. A “nested” logical function in Excel is one that places the cell through a second logical test if it “fails” the first. These functions are useful for determining the value of a cell by placing it through several different tests, displaying different results based on which test it passes. You can nest up to 127 additional IF statements behind your original, if needed. The syntax for these are: =IF(logical_test _1,true_response,IF(logical_test_2,true_response,false_response)) You must remember to close all open parentheses for every IF statement you nest within the logical function at the end of the formula. In this case since there are two IF statements, there are two closing parentheses at the end of the formula. Alternatively, if using Excel 2019 or later or using Excel as part of Office 365, you can use the new IFS function to pass a cell though multiple logical tests and return a value for the test it passes. The IFS function replicates the features provided by nested IF functions, but uses a simpler, streamlined syntax. We’ll examine the IFS function in a later lesson.

In addition, you may also want to know if a cell meets multiple criteria at the same time. You can use the AND and OR functions to find this out. The AND function returns a “TRUE” value if the evaluated cell passes all the logical tests listed after the AND function. The OR function returns a true value if the evaluated cell passes any of the logical tests that follow the OR function. Note that you can evaluate up to 255 different logical tests after the AND and OR statements. When you look at how you can combine these tests with the IF function or nested IF functions, you can see how you can start to become a very powerful formula creator. Combining these Excel functions lets you place cells through a battery of tests, and then decide what function to perform or value to display, based on the results from the tests. The general syntax when combining the IF function with the AND and OR functions is as follows: =IF(AND(logical_test_1,logical_test_2,logical_test_3,etc.),true_response,false_response) =IF(OR(logical_test_1,logical_test_2,logical_test_3,etc.),true_response,false_response) The IFS function is only available in Excel 2019 or later or Excel as part of an Office 365 subscription. The IFS function in Excel lets you pass a cell through a series of logical tests and then return a value based on which logical test the cell passes. This provides a very similar functionality to using multiple, nested IF statements. When using Microsoft Office Excel 365.

Longmont Computer Repair in Longmont, Colorado

Longmont’s Computer Physicians loves Longmont! We are glad to be your full time Computer company in Longmont, CO. Opening in 1999 in Longmont. Call us for a appointment in Longmont Colorado. Providing Computer Repair, upgrades, sales, installations, troubleshooting, networking, internet help, Virus removal, data recovery and training.

Computer Networks in Longmont Denver Erie Colorado Computer Physicians

Networking is one of the jobs that Longmont Computer Physicians, LLC does to help it’s clients.  Sometimes it is wireless networks, other times the client wants a wired computer network.

I needed to hard wire an entire house with CAT5e cabling for a client a few months ago for internet and file sharing access.   It was a great success!  8 rooms in the house had access to a network cable for computers.

Here are some pictures of the job of the patch cables and routers running into the house and through the walls.

Computer networking in Denver Boulder Colorado router and CAT 5e cable PC repair

Computer Networking in Boulder Longmont Denver Erie Colorado PC Repair

PC Computer Networking in Longmont, Boulder, Denver, Erie Colorado

Computer Repair Windows update in Longmont, Boulder, CO

Our Longmont Computer Physicians, LLC office computer had an interesting issue recently I thought I would share:

After an automatic installing of windows 10 update for Valentine’s Day Feb 14, 2018 (KB4074588) my USB keyboard on my desktop computer would no longer work. I tried 3 different USB keyboards  – none worked.  So I went into device manager to uninstall, reinstall, and update the keyboard drivers.  That did not work. So then I uninstalled the windows update.  This fixed the problem, but the update would try to install again the next time I reboot.   So I set the windows update to never install hardware drivers during the update in (system properties) I would need to choose what driver update I want manually from now on.

Computer Physicians provides PC computer networking, repair, Data Recovery, training and virus removal  in Longmont, Boulder, Denver, Erie Colorado and the Colorado Front Range

Boulder/Longmont Computer Repair – PC with no hard drive used

Longmont Colorado PC Computer not using it’s hard drive:

Computer Physicians, LLC  just worked on a unusual situation on a Zotac mini PC computer in Longmont, CO that had a boot windows drive that was filled up.  I thought this would be good to share with my readers:

This very small Zotac mini PC computer running Windows 10 home with 4GB of RAM was booting to a 64GB memory chip located on the motherboard and was not using the 300GB internal SATA hard drive.  As a result since the Windows OS was on a small 64GB memory chip it quickly got filled to capacity.  I backed up the customer’s data to an external hard drive.   The internal hard drive was not being used except for the storing of a few small files.   I could not clone the 64GB memory chip but was able to transfer the OS using special disk software.  I then needed to go into the BIOS and set the boot drive to the internal drive.  The computer is running  slower now since it is not using the small 64GB memory chip for windows and the CPU and computer itself is an inexpensive under-powered computer which was designed to run on the 64GB memory chip. The problem with this design is that the 64GB memory chip quickly gets filled to capacity.  (Windows 10 uses a lot of hard drive memory most systems have 1000GB or more)

I do not like this design and would not recommend this Zotac computer to a client.

The computer will run faster if the original drive is replaced with a solid state drive and if the OS can be transferred and if more RAM memory is installed.

These are some of the situations that Computer Physicians, LLC runs into.

-Steve

Longmont’s Computer Physicians Computer Service and Repair in Longmont Colorado

Computer Physicians, LLC is a computer service company in Longmont, CO in business since 1999.

Longmont Computer Repair Data Recovery in Boulder Erie Denver Colorado Networking PC services help virus removal training

We provide computer repair and other services onsite at your location for same day service or in our workshop for the lowest cost in the area.

We also provide: Computer training, tutoring, help, upgrades, computer systems, rentals, sales, troubleshooting, performance improvement, cyber security, virus removal, networking, website development and hosting, internet setup, router and switch install and we can use our 1gbps upload and download internet service connection at our office for any fast internet needs you have.  We are experts at Data Recovery of lost data and PC system crash recovery. We also develop, program and create Song Director and NameBase database software.

Computer Physicians services the entire Colorado front range. Our main technician and president is CompTia A+, MCP, MTA Microsoft certified professional with many college degrees in computers.

Call us today for any of your computer needs.

Longmont’s Newest Computer Viruses – Longmont/Boulder CO – Computer Physicians

Computer Repair Longmont, CO Virus removal. – Computer Physicians, LLC

Here is some news about the latest computer viruses out today that Computer Physicians in Longmont/Boulder, CO can help you with:

Technewsworld:

A new ransomware exploit dubbed “Petya” struck major companies and infrastructure sites this July 2017, following last month’s WannaCry ransomware attack, which wreaked havoc on more than 300,000 computers across the globe. Petya is believed to be linked to the same set of hacking tools as WannaCry.

Petya already has taken thousands of computers hostage, impacting companies and installations ranging from Ukraine to the U.S. to India. It has impacted a Ukrainian international airport, and multinational shipping, legal and advertising firms. It has led to the shutdown of radiation monitoring systems at the Chernobyl nuclear facility.

(more…)

%d bloggers like this: