Learn Microsoft Excel free video lesson #19

 Apply conditional formatting


1&1 Web Hosting

Learn Microsoft Excel free video lesson #17

Resize cell to accommodate text

Learn Microsoft excel: Free Videos Lesson #16

Formatting workbook.

2016 Cyber-Security Lessons.

The year 2016 established to be a bane with heart to cyber-security, with many personal and exoteric entities falling person to discipline cyber incidents. The US Presidential elections were not spared, thus upbringing the question-Who is safe in an increasingly virtual class? As engineering evolves and becomes solon engaged, it will be easier for hackers to tap into the vulnerabilities. Alas, we learnt it the solid way. Here are whatever rattling factual lessons in certificate direction from the cyber incidents of 2016.

* Security emerges as an in-demand market: Every cloud has a medal coating, and this was moreso evident in the mushrooming of warrantee bleach providers during in the past. As realistic hacks accumulated, so did the effectuation of tackling them. Differentiated skills were shapely by condition consultants and customers leveraged these to egest themselves cyber-ready. In fact, department defrayment has emerged as a top precedency post-2016. Predictions for the industry are best, with Cybersecurity Ventures predicting that planetary spends on assets products and services present hit $1 cardinal between 2017 and 2021.

* Ransomware present formula: On the flipside, hackers are exploits are much innovational and money-savvy. Ransomware and distributed-denial-of-service (DDoS) attacks dominated 2016. For information, the commencement on an American hospital, followed by one on the San Francisco Municipal Transportation Bureau. FBS assemblage states that in Q1, 2016, $209 million was squared in ransom to cyber jade groups. This has spiralled to a worrisome size of $1 billion for 2016.

* Quislingism faculty cut the solicit: Companies can judge to get rid of cyber-hack chases by collaborating shaft. A numerate of technology mate programs bang been launched-LightCyber, Disconsolate Hair Systems and Skyhigh Networks. Ready-deliverable security integrations tidy it workable to follow rapidly and as per mercantilism needs. It is not around dead alone-join keeping and fend off the mercurial minded.

* A sound political colorize emerged: US elections, Russian-sponsored cut, tiff between Apple and the FBI regarding consumer privacy-the enumerate of government meddling with the warranty listing is interminable. One can expect the unvarying political-led debates and happenings in 2017-be it the cyber-security insurance or expectations on private privateness versus mortal warrantee.

* Assemblage guarantee is the new sort: A motion is seen from perimeter-based meshwork precaution measures to terminus and information department. Start-ups much as Cylance, Cybereason, CounterTack and Crowdstrike in the termination instrument space, eff emerged and are likely to beautify statesman hot in 2017. Biggies in the interval, let Palo Alto Networks and Cisco-they started exploring the end marketplace in 2016. One can judge this movement to hold in the forthcoming gathering.

* Money matters entity: Companies tally visaged huge hits to their revenues, owing to department hassles. Character ended up payment statesman than $1 billion on the two data breaches it was subjected to. Its expected $4.8-billion raft with Verizon, is also on the limit of have. Never before person the business repercussions of section breaches been so stark, sending a dread warning to remain cyber safe in 2017.

* IoT Section is a discriminative poverty: With a super adjunctive Internet of Things (IoT) earth, comes a super danger to disrupting lifetime and transmute. The recent onset on DNS provider Dyn, strip to educatee Internet outages, is evidence enough. Companies moldiness bump themselves o.k. to reality and understand that securing IoT networks finished and through, is not a pick but a necessity.

* Consolidation is the way ascending: A disparate and broken industry cannot make admittedly valuate for the customer, be it toll consider or solvent effectualness. The year 2016 saw whatever statesman consolidations, much as Symantec-Bluecoat, Confer-Carbon Wicked and so on. The way leave talk, with mutual measure existence realised in the hunting to get cyber pitfall-proof.

Learn Microsoft Excel. Free Videos Lesson #15

Learn Microsoft Excel free Lesson #13

Solutions- Workbook and worksheet

Microsoft Admits Overly Aggressive Windows 10 Upgrade Campaign Was ‘Pretty Painful’ And Obnoxious

Microsoft does not always do things the right way, few people would argue otherwise. However, Microsoft has traditionally been good at admitting when it drops the ball or otherwise could have done a better job. Such is the case with Windows 10 and the super aggressive approach Microsoft took to getting users to upgrade. It was annoying and at times even obnoxious, and while Microsoft can't go back in time and change that, it can at least give users the satisfaction of recognizing it. That's what Microsoft's chief marketing officer Chris Capossela did during a recent video podcast.

One "pretty painful" incident Capossela pointed out was when Microsoft rolled out an update that disabled the red "X" that would normally close the Windows 10 upgrade dialog box. After the update, clicking the red X had no effect. As a result, users who had thought they cancelled the update process to Windows 10 that Microsoft was pushing would wake up to a machine that had upgraded overnight.

"We know we want people to be running Windows 10 from a security perspective, but finding the right balance where you’re not stepping over the line of being too aggressive is something we tried and for a lot of the year I think we got it right, but there was one particular moment in particular where, you know, the red X in the dialog box which typically means you cancel didn’t mean cancel," Capossela admitted.

"And within a couple of hours of that hitting the world, with the listening systems we have we knew that we had gone too far and then, of course, it takes some time to roll out the update that changes that behavior. And those two weeks were pretty painful and clearly a low light for us. We learned a lot from it obviously," Capossela continued.

Microsoft's mea culpa through its CMO doesn't change the fact that some users were severely inconvenienced and pretty ticked off. However, when bad decisions are made, the next best thing you can hope for is that a company acknowledges it, learns from it, and does not repeat it. You can check one of those off in this case, though whether Microsoft learned from its mistake and refrains from repeating it remains to be seen.

For some folk, taking Microsoft at its word will not be easy. The red X situation was not the only time Microsoft was too aggressive in pushing Windows 10. Prior to that, Microsoft silently pushed out Windows 10 downloads to machines in anticipation of users wanting to upgrade. The problem there is that it was taking up valuable disk space, especially for users who were running a fairly low capacity SSD as their primary drive.

While the barrage of nag screens and dubious behavior could have blown up in Microsoft's face, it hasn't. At present, Windows 10 holds a nearly 24 percent share of the desktop operating system market, according to Net Applications. It still has a long way to go before it catches Windows 7, which has a 47.17 percent share, but it has more than doubled the share that belongs to Windows 8/8.1 (around 10 percent).
Read more at http://hothardware.com/news/microsoft-admits-aggressive-windows-10-upgrade-campaign-pretty-painful#MhVmfHh4BM68B5v4.99

Despite IT Boom, over 90% of Africa Has No Internet Access

Internet access: Vital to providing wider access to education and health awareness in rural communities in Mozambique

The Internet is one of the most important enablers of social development and education. While Internet services have been quite phenomenal in the rest of the world, access to the Internet remains very low in Africa, especially in the rural communities. According to the Internet World Stats for Africa 2016 (http://APO.af/AvhzA), only 9.3% of people across the African continent are Internet users.

“A few years ago anyone who could not read and write was considered illiterate, but today this concept goes further, encompassing people who do not know how to use information and communication technologies. Health organizations and schools in Africa often face a unique set of obstacles, including a lack of access to much-needed health education and counselling platforms. The Community Tablet was created to help solve these problems”, says Dayn Amade.

In today’s digital world, bringing Internet access to rural communities is a tremendous step in the right direction of social development and education. Mozambican technology start-up company Kamaleon (http://Kamaleon.co.mz) has developed an innovative and engaging way of promoting digital literacy through a shared platform called the “Community Tablet” (“Tablet Comunitário”). The Community Tablet is a solar powered mobile computer with touch screen displays and virtual keyboards built in on a trailer to provide Internet access to remote areas. In order to facilitate interaction with the virtual world, Kamaleon also offers training on how to use the Internet and its features to members of the community and the local workforce.

Launched in November 2016 in Mozambique, the Community Tablet ultimately aims to promote digital inclusion and a knowledge based society in Africa. Beginning in Mozambique with an astounding 24 million people with no Internet connection, the Community Tablet will be used to support campaigns on various Health and Education initiatives in partnership with governmental and private organisations. Spreading up-to-date messages and interactive lessons that showcase symptoms, prevention and treatment options – replacing the need for leaflet distributions to convey life saving information. Kamaleon is on a mission to close the digital divide and empower more people in Africa to engage in the digital economy and its educational benefits.

“I believe technology and digital literacy can contribute to greater effectiveness of civic education campaigns in various communities”, says Dayn Amade.

How to Set up Microsoft Outlook 2013 Pictures

Open Outlook 2013, Select The "Manually setup and click next, if you have no existing Account

Open outlook 2013 if you have an existing account 

From the File menu add account

Select the setup account option.

Select POP or IMAP and click Next

Enter Your Name and E-mail Address.

Select IMAP as your account type.

For Incoming mail server (IMAP), enter imap.one.com.

For Outgoing mail server (SMTP), enter send.one.com.

In Logon Information enter the e-mail address and password that you created in the control panel.

Click More Settings.

Fill in information Details

Select Outgoing Server and check My outgoing server (SMTP) requires authentication.

Select Advanced.
For Incoming server (IMAP) enter 993 and select SSL.
For Outgoing server (SMTP) enter 465 and select SSL.
For Root folder path enter INBOX with uppercase letters.
Click OK and then Next.

Click Close.

You have now set up your account in Microsoft Outlook 2013. Click Finish.

Learn Microsoft Excel for free Lesson #11

Add Values to Workbook properties

Please Feel free to leave your comments

Learn Microsoft Excel for Free Lesson #9

Insert columns and rows: hide and unhide data.

Learn Microsoft Excel for free Lesson #7

Free Excel videos, feel free to leave comments
Formatting using the page layout ribbon.

Learn Microsoft Excel for free: Lesson #6

Formatting and using styles or themes

WHAT TO DO WHEN PC BECOMES UNRESPONSIVE

WHAT TO DO WHEN PC BECOMES UNRESPONSIVE

Summary
At times you may find that your PC has become unresponsive. This article provides recommendations to help identify the potential causes for this behavior, and to help resolve this problem. 

Resolution

The first step is to identify the category of issue you are facing. For the purposes of this article, we will define four categories of behavior for PCs that become unresponsive, as follows:

• Hang -- Your PC becomes unresponsive whenever you do a specific set of steps, and you must restart to recover the PC.
• Random Hang -- Your PC becomes unresponsive seemingly at random, and you must restart to recover the PC.
• Generic Freeze -- Your PC becomes unresponsive for a period of time, and then becomes usable again without taking any action. You don't need to restart your PC for it to be usable again. This behavior seems to affect all apps.
• Single-app Freeze -- Your PC exhibits the same behavior as a Generic Freeze, except that it only occurs when running a specific app, such as when playing a game or browsing websites.

Please review the appropriate steps below, according to the category that most closely describes the behavior your PC is experiencing.

Troubleshooting a Hang

Please review the sub-category below that most closely matches when your PC experiences a hang. If the guidance below does not address the issue, please use the guidance under Radom Hang for further recommendations.

At Startup

The most common causes for a hang at Startup are:

Connected Devices

If you have external devices connected to the PC, try starting the PC with those devices disconnected. Device connection and driver issues can contribute to hangs. If the PC starts successfully without external devices connected, try repeating with more devices connected to identify the specific device or combination of devices that are contributing to the hang. 

Fast Startup in Windows 8.1

Older PCs may hang during startup when Windows 8.1 Fast Startup is enabled. The best first action is to update the PC firmware and drivers available from the PC manufacturer. These updates may resolve the issue.

If you are still having a problem after updating all drivers and firmware, you can disable Fast Startup to see if that may be contributing to the issue:

1. Tap or click Search.
2. In the Search box, type Power button. Then, in the search results, tap or click Change what the power buttons do.
3. Tap or click Change settings that are currently unavailable.
4. If the check box in front of Turn on Fast Start up (recommended) is selected, tap or click on the box to remove the check mark.
5. Click Save changes.

Recent hardware or software changes

You may have recently made a change on the PC that may have caused the hang. If so, you can resolve the problem by returning the PC to a previous configuration using System Restore. To learn how to run System Restore, click on the link for your operating system

At Shutdown

Hangs during shutdown can result from faulty hardware, faulty drivers, or damaged Windows components. To resolve these issues:

1. Check for updated firmware and drivers from your PC manufacturer. Install available updates.
2. Install all recommended updates for Windows using Windows Update.
3. Disconnect non-essential hardware, such as USB devices, to see if there is a change that could indicate a device issue.
4. See if the issue also happens in Safe Mode. If not, the problem may be related to installed software. Uninstall software that you are no longer using.
5. Scan for malware.

Troubleshooting a Random Hang

Random hangs are often due to damage to the Windows configuration, faulty hardware, or malware. However, because this behavior is random, it can be especially difficult to identify the proper cause. Please review the steps below to help identify the cause and determine the next course of action:

Due to problems with the Windows configuration

If the system is hanging randomly, it could be caused by damaged system files, software compatibility, or damaged registry files. Try each of the following steps to check if the hang is caused by one of these possibilities.

Damaged system files

Corrupt system files can cause Windows Explorer to stop responding. You can repair corrupted system files by running the System Update Readiness tool, the Deployment Image Servicing and Management (DISM) tool, or the System File Checker (SFC).

Windows Update freezes when you install updates in Windows 8, Windows 7, or Windows Vista

Symptoms

When you try to download or install updates from Windows Update in Windows 8, Windows 7, or Windows Vista, the computer may freeze. If the computer freezes during installation, you receive a message that resembles the following:

Installing Updates X of Y. Please do not shut off your computer.

Note In this message, the placeholders X and Y represent any number. For example, if you're installing 16 updates, you may receive the following message: 

Installing Updates 4 of 16.

Or, the computer may freeze when Windows Update is scanning for updates, and no error messages occur. 

Or, the computer may freeze after you receive the following message:

Preparing to configure Windows.

Don't turn off your computer.

Resolution

To resolve this issue, use one of the following methods, depending on your operating system.

Windows 8

Method 1: Run the scan again

If the scan freezes and doesn't complete when Windows Update is scanning for updates, try to run the scan again. If you still can't scan for updates successfully, go to method 2.

Method 2: Run the Windows Update Troubleshooter

If Windows Update freezes during download, use the following method. If this method doesn't resolve your issue, go to method 3.
Fix it for me
To fix this problem automatically, click Fix it, click Run In the File Download dialog box, and then follow the steps in the Fix it wizard.

The Automatically diagnose and fix common problems with Windows Update troubleshooter may automatically fix the problem described in this article.  This troubleshooter fixes many problems.

Notes

• This wizard may be in English only. However, the automatic fix also works for other language versions of Windows.
• If you are not on the computer that has the problem, save the Fix it solution to a flash drive or a CD, and then run the solution on the computer that has the problem.

If you're still having problems when you scan for updates, you can ask questions and get answers from other users at the Microsoft Community. To ask a question, or search for other users' posts, click here. 

Method 3: Perform a System Restore

If you're having problems installing Windows Updates, use the following method. If this method doesn't fix your problem, go to method 4.

Note If your computer is not configured to start from a CD or DVD, or if the computer had Windows preinstalled and you have no installation CDs or DVDs, see the documentation that was included with the computer for information about how to continue. 

When you start your computer by using the Windows installation disc, you can perform system recovery options on startup. To do this, follow these steps:

1. Turn off your computer manually by pressing the power button.
2. Start your computer by pressing the power button.
3. At the logon screen, tap or click the power icon in the lower-right corner.
4. Press the Shift key, and then tap or click Restart.
5. On the Choose an option page, tap or click Troubleshoot, and then tap or click Advanced options.
6. Tap or click System Restore. The computer will restart to System Restore. Select your account to continue.
7. On the System Restore page, tap or click Next.
8. If you are prompted to specify a disk to restore, select the hard disk, and then tap or click Next.
9. When the restoration process is complete, tap or click Restart.

Method 4: Refresh your PC

Note When you use the "Refresh your PC" tool, your computer will restore the current Windows installation to the original installation version. This method requires you to reinstall all updates that are not included on the installation. Applications that you installed from disc or websites will be removed. You will find a list of removed applications on your desktop.

1. Turn off your computer manually by pressing the power button.
2. Start your computer by pressing the power button.
3. At the logon screen, tap or click the power icon in the lower-right corner.
4. Press the Shift key, and then tap or click Restart.
5. On the Choose an option page, tap or click Troubleshoot, and then tap or click Advanced options.
6. Tap or click Refresh your PC.
7. Under Refresh your PC, tap or click Next.
8. Follow the instructions on the screen.

Windows 7 and Windows Vista

Method 1: Run the Windows Update Troubleshooter

If the computer freezes when you download updates from Windows Update, use the following method. If this method doesn't resolve the issue, go to method 2.


Fix it for me
To fix this problem automatically, click Fix it for your version of Windows, click Run in the File Download dialog box, and then follow the steps in the Fix it wizard.

Windows 7 or Windows Vista

The Automatically diagnose and fix common problems with Windows Update troubleshooter may automatically fix the problem described in this article.  This troubleshooter fixes many problems.

Notes

• This wizard may be in English only. However, the automatic fix also works for other language versions of Windows.
• If you are not on the computer that has the problem, save the Fix it solution to a flash drive or a CD, and then run the solution on the computer that has the problem.

Let me fix it myself

Important This section, method, or task contains steps that tell you how to modify the registry. However, serious problems might occur if you modify the registry incorrectly. Therefore, make sure that you follow these steps carefully. For added protection, back up the registry before you modify it. Then, you can restore the registry if a problem occurs. For more information about how to back up and restore the registry, click the following article number to view the article in the Microsoft Knowledge Base:

322756 How to back up and restore the registry in Windows XP
Back up the registry (For Windows Vista)
Back up the registry (For Windows 7)

To reset the Windows Update components, follow these steps:

1. Click Start, click Run, type cmd, and then press Enter.
2. At the Command Prompt window that appears, type net stop bits, and then press Enter.
3. Type net stop wuauserv, and then press Enter.
4. Delete the qmgr*.dat files. To do this, type the following command, and then press Enter:
   Del "%ALLUSERSPROFILE%\Application Data\Microsoft\Network\Downloader\qmgr*.dat"
5. Type cd /d %windir%\system32, and then press Enter.
6. To reregister the BITS and Windows Update files, type the following commands, and make sure that you press Enter after you type each command.
   • regsvr32.exe atl.dll
   • regsvr32.exe urlmon.dll
   • regsvr32.exe mshtml.dll
   • regsvr32.exe shdocvw.dll
   • regsvr32.exe browseui.dll
   • regsvr32.exe jscript.dll
   • regsvr32.exe vbscript.dll
   • regsvr32.exe scrrun.dll
   • regsvr32.exe msxml.dll
   • regsvr32.exe msxml3.dll
   • regsvr32.exe msxml6.dll
   • regsvr32.exe actxprxy.dll
   • regsvr32.exe softpub.dll
   • regsvr32.exe wintrust.dll
   • regsvr32.exe dssenh.dll
   • regsvr32.exe rsaenh.dll
   • regsvr32.exe gpkcsp.dll
   • regsvr32.exe sccbase.dll
   • regsvr32.exe slbcsp.dll
   • regsvr32.exe cryptdlg.dll
   • regsvr32.exe oleaut32.dll
   • regsvr32.exe ole32.dll
   • regsvr32.exe shell32.dll
   • regsvr32.exe initpki.dll
   • regsvr32.exe wuapi.dll
   • regsvr32.exe wuaueng.dll
   • regsvr32.exe wuaueng1.dll
   • regsvr32.exe wucltui.dll
   • regsvr32.exe wups.dll
   • regsvr32.exe wups2.dll
   • regsvr32.exe wuweb.dll
   • regsvr32.exe qmgr.dll
   • regsvr32.exe qmgrprxy.dll
   • regsvr32.exe wucltux.dll
   • regsvr32.exe muweb.dll
   • regsvr32.exe wuwebv.dll
7. Reset Winsock. To do this, type netsh reset winsock, and then press Enter.
8. If you are running Windows XP, set the proxy setting. To do this, type proxycfg.exe -d at the command prompt and then press Enter.
9. To restart the BITS and Windows Update services, type the following commands at the command prompt, and make sure that you press Enter after you type each command:
   • net start bits
   • net start wuauserv
10. If you are running Windows Vista or Windows 7, clear the BITS queue. To do this, type bitsadmin.exe /reset /allusers at the command prompt, and then press Enter.
11. Install the latest Windows Update Agent. For more information, click the following article number to view the article in the Microsoft Knowledge Base:
    949104 How to obtain the latest version of the Windows Update Agent to help manage updates on a computer
12. Restart the computer.

Method 2: Perform a System Restore

If you're having problems installing updates from Windows Update, use the following method. If this method doesn't fix your problem, go to method 3.

Note You must be logged on to Windows by using an administrator account to use this method. If the computer is part of a work network, ask the system administrator for help. For information about how to log on to Windows as an administrator, go to the following Microsoft website:

How do I log on as an administrator?

Note If the computer is not configured to start from a CD or DVD, or if the computer had Windows preinstalled and you have no installation CDs or DVDs, see the documentation that was included with the computer for information about how to continue. 

When you start your computer by using the Windows installation disc, you can perform system recovery options on startup. To do this, follow these steps: 

1. Insert the Windows Vista or Windows 7 installation disc in the drive, and then restart the computer.
2. When you are prompted to start from the disc, press any key.
3. When you are prompted, configure the following options, and then click Next:
   • Language to install
   • Time and currency format
   • Keyboard or input method
4. Click Repair your computer.
5. On the System Recovery Options page, click the version of the Windows operating system that you want to repair, and then click Next.
6. On the System Recovery Options page, click System Restore.
7. On the System Restore page, click Next.
8. Select a restore point at which you know that the operating system was working, and then click Next. 
   
   The restore point should be a date before the first time that you experienced the error. To select a date, select the Choose a different restore point option, and then click Next.
9. If you are prompted to specify a disk to restore, select the hard disk, and then click Next.
10. On the Confirm your restore point page, click Finish.
11. When the restoration process is complete, click Restart.

Method 3: Perform an in-place upgrade

Performing an in-place upgrade will restore the current Windows installation to the version of the installation DVD. After you perform this upgrade, you have to reinstall all updates that are not included on the installation DVD. 

Note If the computer had Windows preinstalled, review the manufacturer's documentation for information about how to do an in-place upgrade. 

Note We strongly recommend that you back up all personal files. For information about how to back up your files, go to the following Microsoft website:

Back up your files

1. Insert the Windows 7 or Windows Vista DVD into the computer's DVD drive.
   • Note If the computer is not configured to start from a CD or DVD, or if the computer had Windows preinstalled and you have no installation CDs or DVDs, see the documentation that was included with the computer for information about how to continue.
2. In the Setup window, click Install Now.
   • Note If Windows does not automatically detect the DVD, follow these steps:
     1. Click Start, and then type Drive:\setup.exe in the Start Search box. 
        
        Note The placeholder Drive represents the drive letter of the computer's DVD drive. This letter is usually D.
     2. In the Programs list, click Setup.exe.
     3. In the Setup window, click Install Now.
3. Click Go online to obtain the latest updates for installation (recommended).
4. Type the CD or DVD key if you are prompted to do this.
5. On the Install Windows page, select the operating system if you want to upgrade.
6. Click Yes to accept the Microsoft Software License Terms.
7. On the Which type of installation do you want? screen, click Upgrade.
8. When the installation is complete, restart your computer.