IT DEVICES

How to Subtract Dates in Excel

If you have an Excel sheet with a
 lot of dates, chances are you will eventually need to calculate the 
differences between some of those dates. Maybe you want to see how many 
months it took you to pay off your debt or how many days it took you to 
lose a certain amount of weight?<div class="entry-content" itemprop="articleBody">
<div class="KonaBody">
Calculating the difference between dates in Excel is easy, but can 
become complicated depending on how you want to calculate certain 
values. For example, if you wanted to know the number of months between 
2/5/2016 and 1/15/2016, should the answer be 0 or 1? Some people might 
say 0 since it’s not a full month between the dates and others might say
 1 because it’s a different month.

In this article, I’ll show you how to calculate the differences 
between two dates to find the number of days, months and years with 
different formulas, depending on your preferences.

<h2>
Days Between Two Dates</h2>
The simplest calculation we can do is to get the number of days 
between two dates. The good thing about calculating days is that there 
really is only one way to calculate the value, so you don’t have to 
worry about different formulas giving you different answers.

In my example above, I have two dates stored in cells A2 and A3. At 
the right, you can see the difference between those two dates is 802 
days. In Excel, there are always multiple ways to calculate the same 
value and that’s what I did here. Let’s take a look at the formulas:

The first formula is just a simple subtraction of the two dates, A3 –
 A2. Excel knows it’s a date and simply calculates the number of days 
between those two dates. Easy and very straight-forward. In addition, 
you can also use the DAYS function.

<pre>=DAYS(A3, A2)</pre>
This function takes two arguments: the end date and the start date. 
If you switch the dates in the formula, you’ll just get a negative 
number. Lastly, you can use a function called DATEDIF, which is included in Excel from Lotus 1-2-3 days, but isn’t an officially supported formula in Excel.

<pre>=DATEDIF(A2, A3, "D")</pre>
When you type the formula, you’ll see that Excel does not give you 
any suggestions for the fields, etc. Luckily, you can see the syntax and
 all supported arguments for the <a href="https://support.office.com/en-us/article/DATEDIF-function-bd549d1c-f829-4691-a77d-4a1e3d42bc1a" target="_blank">DATEDIF function</a> here.

As an added bonus, what if you wanted to calculate the number of 
weekdays between two dates? That’s easy enough also because we have a 
built-in formula:

<pre>=NETWORKDAYS(startDate,endDate)</pre>
Calculating the number of days and weekdays is simple enough, so let’s talk about months now.

<h2>
Months Between Two Dates</h2>
The trickiest calculation is the number of months because of how you 
can either round up or round down depending on whether it’s a complete 
month or a partial month. Now there is a MONTHS function in Excel, but 
it’s very limited because it will only look at the month when 
calculating the difference and not the year. This means it’s only useful
 for calculating the difference between two months in the same year.

Since that is kind of pointless, let’s look at some formulas that will get us the correct answer. Microsoft has provided these <a href="https://support.microsoft.com/en-us/kb/214134" target="_blank">here</a>, but if you are too lazy to visit the link, I have provided them below also.

<pre>Round Up - =(YEAR(LDate)-YEAR(EDate))*12+MONTH(LDate)-MONTH(EDate)</pre>
<pre>Round Down - =IF(DAY(LDate)>=DAY(EDate),0,-1)+(YEAR(LDate)-YEAR(EDate))
*12+MONTH(LDate)-MONTH(EDate)</pre>
Now these are two fairly long and complicated formulas and you really
 don’t need to understand what’s going on. Here are the formulas in 
Excel:

Note the you should edit the round down formula in the actual cell 
itself because for some odd reason the entire formula does not show up 
in the formula bar. In order to see the formula in the cell itself, 
click on the Formulas tab and then click Show Formulas.

So what’s the final result of the two formulas on our current example? Let’s see below:

Round up gives me 27 months and round down gives me 26 months, which 
is accurate, depending on how you want to look at it. Lastly, you can 
also use the DATEDIF function, but it only calculates full months, so in
 our case the answer it returns is 26.

<pre>=DATEDIF(A2, A3, "M")</pre>
<h2>
Years Between Two Dates</h2>
As with months, years can also be calculated depending on whether you
 want to count 1 year as a full 365 days or if a change in the year 
counts. So let’s take our example where I have used two different 
formulas for calculating the number of years:

One formula uses DATEDIF and the other uses the YEAR function. Since 
the difference in the number of days is only 802, DATEDIF shows 2 years 
whereas the YEAR function shows 3 years.

Again, this is a matter of preference and depends on what exactly you
 are trying to calculate. It’s a good idea to know both methods so that 
you can attack different problems with different formulas.

As long as you are careful with which formulas you use, it’s fairly 
easy to calculate exactly what you are looking for. There are also a lot
 more date functions outside of the ones I mentioned, so feel free to 
check those out also on the <a href="https://support.office.com/en-us/article/Date-and-time-functions-reference-fd1b5961-c1ae-4677-be58-074152f97b81" target="_blank">Office Support</a> site. If you have any questions, feel free to comment. Enjoy!

</div>
</div>

Softwares TIPS How to Subtract Dates in Excel

If you have an Excel sheet with a lot of dates, chances are you will eventually need to calculate the differences between some of those da...

How to Stop an LCD Monitor from Flickering

9:09 AM Unknown 0

Compared to older displays, LCD 
monitors are an excellent low-cost, low-power solution to our need for a
 computer display. Unfortunately, some monitor settings can make an LCD 
screen appear to flicker.<div class="entry-content" itemprop="articleBody">
<div class="KonaBody">
A flickering LCD monitor is more than just an annoyance. It can cause
 eye strain, headaches, and a host of other ailments, especially if you 
spend a great deal of time in front of your computer. Luckily, there are
 some steps you can take to stop the flickering and avoid these 
problems. In this article, I’ll show you how to stop your LCD monitor 
from flickering.

<h2>
What Causes an LCD Monitor to Flicker</h2>
Although your computer monitor may appear to be a still image when no
 one is using it, it is actually being updated constantly. Much like a 
film strip is just a bunch of static images displayed quickly, your 
monitor updates at a fast rate to make it look like things are moving 
smoothly on the screen.

The rate at which your monitor updates is measured in Hertz. One 
Hertz is equal to one cycle per second. If your monitor is set to update
 at a rate of 100 Hertz, then it is refreshing 100 times per second. The
 Hertz used to measure monitor refresh rates is similar to the Gigahertz
 used to measure the speed of your CPU, except that Gigahertz is a 
measure expressed in billions of cycles per second.

If the refresh rate on your LCD monitor is set too low, it can appear
 to be flickering since there aren’t enough updates per second. While 
some people are comfortable with around 30 Hertz, others can see the 
flickering and require a higher refresh rate. The most common refresh 
rate is 60 Hertz.

There are other factors that can cause screen flickering and I have mentioned those at the bottom of this post.

<h2>
Setting the Refresh Rate for an LCD Monitor</h2>
The refresh rates that you can set for your LCD monitor are largely 
determined by the capabilities of your monitor. While some LCD monitors 
can take advantage of several different refresh rates, others are 
confined to just one or two.

To choose a new refresh rate for your LCD monitor in Windows, begin by clicking on Start > Control Panel > Appearance and Personalization > Display.
 If you are on Windows 8 or 10, just right-click on the Start button and
 choose Control Panel. If you’re in icon view, you can click directly on
 Display.

On the left hand side of the window, click on Change Display Settings.

Finally, click on Advanced Settings at the bottom right of the window.

Click on the Monitor tab and you will notice a few things. First, notice the setting labeled Screen Refresh Rate.
 This is the current refresh rate for your LCD monitor. Click the drop 
down menu and Windows will display all of the refresh rates possible for
 your monitor.

It is likely that your monitor can only use one or two refresh rates,
 so this list may not be long. Some manufacturers build monitors that 
can display anywhere from 30 Hertz to 200 Hertz. Normally, monitors with
 higher refresh rates will be more expensive. A common refresh rate for 
gaming monitors is 144 Hertz. If the price of a monitor seems too cheap 
to you, it’s probably because it has a low refresh rate. For example, 
some new 4K monitors are cheap, but are only 30 Hertz, which can make 
everything look choppy on the screen.

Also, a lot of monitors will show 59Hz and 60Hz and you can pick 
between the two. So what’s the difference? It’s basically something to 
do with rounding and it really doesn’t matter. You can read the exact 
details on <a href="https://support.microsoft.com/en-us/kb/2006076" target="_blank">59Hz vs 60Hz</a> here.

From here, you can try a higher refresh rate and see if the 
flickering stops. Usually this does the trick. If it doesn’t work or 
there is only one refresh rate listed, there are two things you can try.

First, make sure you are using the latest driver for your LCD 
monitor. If the driver is outdated or Windows is using a generic driver,
 the number of refresh rates available may be limited. Visit the 
manufacturer website and download the latest driver for your version of 
Windows.

If that doesn’t work, you can force Windows to use a refresh rate 
that is not technically supported by the monitor. Be careful, though, 
because it is possible to damage your monitor hardware if you do this.

On the Monitor tab shown above, there is an option that is checked by default called Hide Modes That This Monitor Cannot Display. By unchecking this option, you can force Windows to use any refresh rate for your monitor that you want.

Notice that right underneath this option, Windows warns you about an 
unusable or damaged display. Uncheck this option and set your monitor to
 an unsupported refresh rate at your own risk. Depending on your version
 of Windows, this option may be grayed out, meaning you can only pick 
from the refresh rates listed in the box.

For Mac users running OS X, you can go to System Preferences and click on Display. Here you can change the refresh rate for an external display connected to your Mac.

<h2>
Other Screen Flickering Causes</h2>
If changing the refresh rate doesn’t fix the flicker on the screen, 
it could be related to other factors. Here is a list of other items you 
should check:

Cable – If you can, change the cable connecting your
 monitor to your computer. In some cases, a defective cable can cause 
the signal to break while being transmitted across the wire.

Input Port – Another solution is to use a 
different port on the monitor, if possible. For example, if you are 
connecting using HDMI, try DVI or DisplayPort or VGA instead and see if 
that fixes the problem.

Surroundings – In addition to hardware issues, 
electromagnetic fields can also cause screen flickering problems. If you
 have something else plugged into the same power strip like a heater, 
fan, etc., try removing it.

Video card – If there is an issue with your video 
card, it will obviously effect the output on the screen. Update the 
drivers and open your computer to ensure that the video card is properly
 seated in the slot.

Monitor – Lastly, the monitor itself could be 
damaged or defective. Try connecting the monitor to another computer to 
see if the problem goes away or remains.

Hopefully, this will help you figure out what’s causing the 
flickering issues with your monitor. If you have any questions, feel 
free to comment. Enjoy!

</div>
</div>

Compared to older displays, LCD monitors are an excellent low-cost, low-power solution to our need for a computer display. Unfortunately, ...

Prevent a Mouse or USB Device from Waking Windows from Sleep Mode

9:09 AM Unknown 0

One of the best power management 
features in Windows is sleep mode, a convenient way to save power and 
reduce the wear and tear on your PC hardware while it isn’t being used. 
Normally, your mouse and keyboard are set by default to wake up Windows 
from sleep mode.
This isn’t a problem for most people, but can be troublesome for 
certain people with a very sensitive mouse. Even slight vibrations can 
cause Windows to wake up from sleep. Luckily, you can easily disable the
 mouse or any other USB device from waking Windows up.

In this article, I’ll show you how to change the power settings for 
your mouse or USB device so that it won’t interfere with Windows 
sleeping. For me, I just use my keyboard to wake up the computer, so I 
don’t have to worry about pressing the power button.

<h2>
Stop Mouse from Waking PC</h2>
To start, go to Control Panel and click on Mouse. If you are in category view, click on Hardware and Sound and then click on Mouse under Devices and Printers. 
<a href="http://11986-presscdn-0-77.pagely.netdna-cdn.com/wp-content/uploads/2010/04/mouse-settings-1.png" rel="attachment wp-att-59063"><img alt="mouse settings" class="lazy size-full wp-image-59063 aligncenter" data-original="http://11986-presscdn-0-77.pagely.netdna-cdn.com/wp-content/uploads/2010/04/mouse-settings-1.png" height="243" itemprop="image" src="http://11986-presscdn-0-77.pagely.netdna-cdn.com/wp-content/uploads/2010/04/mouse-settings-1.png" style="display: block;" width="629" /></a>

In the Mouse Properties window, click on the Hardware
 tab and select your mouse from the list of devices. Normally, there 
will only be one mouse listed here, but that will depend on the hardware
 you have connected to your computer. When you have selected your mouse 
from the list, click the Properties button.

In the second Properties window for your mouse, click on the Change Settings button on the General tab.

Finally, click the Power Management tab and uncheck the Allow This Device to Wake the Computer box. Click the OK
 button and click OK on all the other open windows too. From now on, you
 cannot wake up Windows from sleep mode by clicking a mouse button or 
moving the mouse around.

Some high-end mice, like gaming mice, have high polling rates and 
high DPI, which means even the tiniest of movements will be detected and
 cause your computer to wake up. Fixing this setting will prevent that 
from happening. Note that you can also get to this setting by clicking 
on Start and then typing in Device Manager.

Expand Mice and other pointing device and then right-click on the mouse and choose Properties.

This will get you to the same dialog with the Power Management tab as
 shown above. To prevent other USB devices from waking your computer, 
just right-click on them, choose Properties and go to the power tab. For
 example, you can also prevent the keyboard from waking your computer or
 the network card too.

If you have a wireless keyboard/mouse and there is a USB transmitter 
attached to your computer, you will also need to disable this option for
 that device too. It should show up under Keyboards. If nothing else other than HID Keyboard Device shows up, then just disable it for that also.

<h2>
Missing Power Management Tab</h2>
In some cases, you might not see a Power Management tab for some or all of your USB devices. In addition, sometimes the Allow this device to wake the computer box is grayed out and you can’t check or uncheck it.

If you are missing the Power Management tab or the box is grayed out,
 you need to go into your computer BIOS and make sure it supports wake 
over USB. You can usually tell this if there is an option to enable USB Wake Support or enable a sleep state higher than S1 (normally S3). The option in the BIOS may be called ACPI Suspend Type.

You might also see some options under Wake Up Event Setup related to resuming from S3/S4/S5 by mouse/keyboard/USB device. Make sure these are all enabled.

If you’re having other sleep issues, make sure to check out my post on <a href="http://www.online-tech-tips.com/windows-10/windows-10-will-not-sleep/" target="_blank">troubleshooting Windows not going to sleep</a>. If you have any questions, feel free to post a comment. Enjoy

Computer Peripherals TIPS Prevent a Mouse or USB Device from Waking Windows from Sleep Mode

One of the best power management features in Windows is sleep mode, a convenient way to save power and reduce the wear and tear on your PC...

4 Free/Cheaper Rosetta Stone Alternatives

9:08 AM Unknown 0

If you’re trying to learn a new 
language, you have most likely heard about the popular language learning
 software Rosetta Stone. Rosetta Stone comes in a wide variety of 
different languages, allowing you to learn another language via 
specialized training software on your computer or mobile device.<div class="entry-content" itemprop="articleBody">
<div class="KonaBody">
However, the software is a bit on the expensive side. For 
example, most languages on the site are currently selling for $209, 
which gets you either online access, a download or a CD-ROM.

Although expensive, $209 is probably worth it if Rosetta Stone can 
actually help you master a foreign language. The thing is, the way 
Rosetta Stone teaches languages may not be that effective for some 
people. Rosetta Stone focuses mostly on being able to speak quickly and 
not as much on grammar, sentence structure, etc. For many, classroom 
learning is a better method, as it involves more interaction with an 
actual person who speaks the foreign language, the teacher.

If you want to get started learning a foreign language without buying
 Rosetta Stone or paying for classes, there are some decent free 
alternatives out there that you can try out.

<h2>
Babbel</h2>
<a href="https://www.babbel.com/" target="_blank">Babbel</a>
 is an online tool for learning how to speak, read and write in a new 
language. The site mostly has lessons for European languages like 
French, Spanish, German, Italian, Portuguese, Swedish, Dutch, etc. In 
addition, it has Russian and Turkish.

The lessons are interactive and allow you to practice speaking also. 
The software has voice recognition so you can make sure that you are 
pronouncing the words correctly.

If you create an account, it will sync all your lessons to the cloud 
so you can move from your computer to your phone and continue from where
 you left off. In terms of pricing, they have some free lessons, but if 
you really want to learn a language, you’ll have to sign up for their <a href="https://www.babbel.com/prices" target="_blank">subscription plans</a>.

Overall, it’s a cheaper solution to Rosetta and they have a community
 that lets you connect with native speakers of the language you are 
trying to learn.

<h2>
Busuu</h2>
<a href="https://www.busuu.com/" target="_blank">Busuu</a>
 is a language learning tutorial website that offers many helpful tools 
for learning English, Spanish, Portuguese, Italian, German, French, and 
more. Busuu has a <a href="https://www.busuu.com/enc/video" target="_blank">short video</a> that quickly reviews the features of the website.

Busuu is a fairly good language learning software and it provides 
several different ways to learn a foreign language: everything from 
vocabulary and writing to punctuation and grammar. Busuu also features 
quizzes, which give you a classroom like learning style.

They have lots of lessons and just about all of them are free. If you become a <a href="https://www.busuu.com/n/en/subscribe" target="_blank">premium membe</a>r,
 you get access to grammar, voice recording and review exercises, faster
 correction from a native speaker, travel and business course and level 
tests.

The pricing is pretty close to Babbel and it follows the same monthly
 subscription model. Overall, it’s very well done and has a lot of 
resources for each language beyond just being able to speak it. They 
also have mobile apps for easy learning on the go.

<h2>
Duolingo</h2>
<a href="https://www.duolingo.com/" target="_blank">Duolingo</a>
 is the first tool mentioned here that is completely free. They don’t 
have a huge number of languages, but they have all the popular ones that
 we have already mentioned above.

When you start a new language, you start at the top of a path and 
work your way down. If you already know some of the language, you can 
take placement tests to skip the lessons.

The lessons include different kinds of interactive questions which will help you read and write the new language.

You can also hear how words and sentences are pronounced so that you 
can speak it yourself. In addition, you can add friends from Facebook in
 case you want to learn with someone else. They also have discussion 
forums and even real world articles that you can translate once you 
become proficient in the language.

<h2>
LiveMocha</h2>
<a href="http://livemocha.com/" target="_blank">LiveMocha</a>
 is a website that is owned by Rosetta Stone and is basically their 
lower-level cheaper option. It’s still not free, but basically lets you 
purchase lessons in small bits and pieces. They also give you some free 
credits to start with that will basically get you about 5 free lessons. 
After that you have to spend about $1 per lesson.

Some languages have more lessons and courses than others, obviously, 
and they do have quite a few languages available. If you are looking for
 something bite-sized, this is a good option.

The lessons are pretty basic in that they include a short intro video
 and then some vocabulary flash cards. They also include audio 
recordings for each word. Overall, it’s a different take on learning 
than the way it is done in Rosetta Stone.

So these are a couple of good options you have when trying to learn a
 new language. They are especially good for popular languages like 
Spanish, French, German, Italian, etc. If you have any other tools you 
use, feel free to mention them in the comments. Enjoy!

</div>
</div>

Computer Peripherals Softwares TIPS 4 Free/Cheaper Rosetta Stone Alternatives

If you’re trying to learn a new language, you have most likely heard about the popular language learning software Rosetta Stone. Rosetta S...

Install and Delete Fonts in Windows the Easy Way

9:07 AM Unknown 0

Starting with Windows 7 and 
continuing to Windows 10, the process for managing fonts in Windows has 
become much more streamlined and easier to use. Whether you are a 
professional who needs to install lots of fonts for your work or someone
 who wants to speed up their computer by getting rid of useless fonts, 
Windows makes it easy to perform either task.<div class="entry-content" itemprop="articleBody">
<div class="KonaBody">
If you do run into any trouble along the way, such as when trying to 
delete a font, I’ve also posted alternate methods to help troubleshoot 
the problem. Note that the procedures below can be accomplished in 
Windows 7, Windows 8.1 or Windows 10. If there is anything operating 
specific, I will mention that separately.

<h2>
How to Install a Font</h2>
Once you have downloaded your font file, go ahead and open the folder
 where your font is saved. Now double-click on the font file.

A window will appear where you will get to see a preview of all the 
numbers and letters for that font. It will also show you a sample 
sentence in different font sizes. To install the font on your system, 
click the Install button at the top.

That’s it! Your font is now installed! If you open a program like 
Word, you’ll see it should now be there in the list of fonts. You can 
select it and start typing with the new font.

<h2>
How to Delete a Font</h2>
Deleting a font is almost just as easy.  First, open Control Panel and click on the Fonts folder. If you’re in Category view, go ahead and switch to Icon view.

Select the font you want to delete and then click the Delete button towards the top of the window.

If all goes well, your font should be removed from your system. Now 
there are a few situations where you might run into problems. Firstly, 
you might get a message stating that the font cannot be deleted because 
it is in use.

If you run into this problem, you should first close all programs and
 try again. If that doesn’t work, try restarting your computer and then 
deleting the font. As a last resort, you can <a href="http://www.online-tech-tips.com/computer-tips/restart-safe-mode/" target="_blank">restart in Safe Mode</a> and then try to delete it.

Another way to delete the font is via the Windows registry. Before you edit anything, make sure to <a href="http://www.online-tech-tips.com/computer-tips/how-backup-registry/" target="_blank">backup the registry</a>. Now click on Start and type in regedit. Navigate to the following registry key:

<pre>HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows NT\CurrentVersion\Fonts</pre>
<a href="http://11986-presscdn-0-77.pagely.netdna-cdn.com/wp-content/uploads/2010/01/delete-font-registry.png" rel="attachment wp-att-58918"><img alt="delete font registry" class="lazy size-full wp-image-58918 aligncenter" data-original="http://11986-presscdn-0-77.pagely.netdna-cdn.com/wp-content/uploads/2010/01/delete-font-registry.png" height="291" itemprop="image" src="http://11986-presscdn-0-77.pagely.netdna-cdn.com/wp-content/uploads/2010/01/delete-font-registry.png" style="display: block;" width="641" /></a>

Find the font in the list on the right, then right-click and choose Delete.
 You will be able to delete the font file even if you were getting the 
in-use message earlier. Note that if you have 64-bit Windows installed, 
you also need to go to this registry key and delete the font from here 
too:

<pre>HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\Microsoft\Windows NT\CurrentVersion\Fonts</pre>
After you have deleted the key from both locations, go ahead and 
restart the computer for the changes to take effect. The font should now
 be gone from all programs.

This method can also be used to delete fonts that are protected 
system fonts. For example, let’s say you wanted to delete Times New 
Roman. If you tried via the Control Panel, you’ll get an error message.

You can, however, go into the registry and get rid of the font there.
 Make sure to restart your computer after deleting the entries from the 
registry. There really isn’t any good reason to delete protected system 
fonts, so I wouldn’t recommend it.

If you already have installed a bunch of fonts on your computer and 
now don’t want to have some many extra fonts installed, you can check 
out my previous post on how to <a href="http://www.online-tech-tips.com/windows-7/windows-7-fonts/" target="_blank">restore the default Windows fonts</a>.

Finally, you can also <a href="http://www.online-tech-tips.com/computer-tips/how-to-create-your-own-fonts-and-edit-truetype-fonts/" target="_blank">create your own font</a> and then install it using this guide! If you have any questions, feel free to comment. Enjoy!

</div>
</div>

TIPS Install and Delete Fonts in Windows the Easy Way

Starting with Windows 7 and continuing to Windows 10, the process for managing fonts in Windows has become much more streamlined and easie...

How to Enable the God Mode Control Panel in Windows

9:06 AM Unknown 0

Windows has a vast amount of 
settings that can be configured to adjust how Windows operates. However,
 adjusting these settings is not the easiest thing to do. The majority 
of them must be adjusted using the Control Panel, found by going to Start > Control Panel.<div class="entry-content" itemprop="articleBody">
<div class="KonaBody">
Although the Control Panel is a good tool, it can sometimes be 
difficult to use. For the most part, when using Control Panel, you must 
toggle back in forth between numerous different windows to setup 
everything. Sometimes it’s also hard to find a specific setting that you
 are looking for. For example, I’ve written an entire post just on how 
to <a href="http://www.online-tech-tips.com/windows-7/network-and-sharing-center-overview/" target="_blank">configure the Network and Sharing Center</a>.

In addition, Windows 8.1 and Windows 10 have two places for adjusting settings: via the Control Panel and via the Settings app.

However, there is one other way that you can adjust settings on your 
Windows computer, which gives you all adjustment options in one place: 
God Mode or the Master Control Panel. No one is really sure why it’s 
called God Mode because it’s basically just a list of all the possible 
settings in one place and you don’t have to name it God Mode!

To get to this Master Control Panel, you need to first create a new 
folder on your desktop. To do so, right click on your desktop to bring 
up the secondary menu. From the secondary menu, choose New > Folder. This will add a default folder to your desktop which will be named something like New folder, or New folder 2, etc.

Next, you need to change the name of the New folder that you just created. First copy the text below that starts with GodMode.(E…}. Now right click on the folder and choose Rename.

<pre>GodMode.{ED7BA470-8E54-465E-825C-99712043E01C}</pre>
Paste this text as the name of the folder and then press Enter. Now, 
the folder should have changed from the default blank folder icon to a 
Control Panel looking icon with the name GodMode. Note that you can 
change that beginning text to anything you like, it doesn’t have to be 
GodMode.

Double click on the icon to open it up. You will notice that it looks
 similar to the Control Panel window, with all options placed in list 
format. This is a great way to see all the available adjustments for 
Windows in one spot.

Now, you can jump to a certain setting and configure it easily, 
without having to go through a bunch of different Windows. When you 
click on a listing within the “God Mode” window, you will be able to go 
straight to the configuration page.

Note that everything in the Master Control Panel can also be found in
 the regular Control Panel by performing a search. Below, I have shown 
the results from doing a search in GodMode and in the regular Control 
Panel. As you can see, you get the same results.

The main convenience of GodMode is that you can see all the settings 
without having to know what to search for. This has proved helpful on a 
number of occasions because I didn’t know exactly what word to search 
for, but was able to find the setting when browsing through the list.

Again, this little trick works on Windows 7, Windows 8.1 and Windows 10. If you have any questions, feel free to comment. Enjoy!

</div>
</div>

Softwares How to Enable the God Mode Control Panel in Windows

Windows has a vast amount of settings that can be configured to adjust how Windows operates. However, adjusting these settings is not the ...

How to Burn a DVD on a Mac

9:06 AM Unknown 0

I’ve already talked about how you can <a href="http://www.online-tech-tips.com/computer-tips/how-to-burn-cds-dvds-blu-ray-discs-windows/" target="_blank">burn CDs and DVDs in Windows</a>,
 so now it’s time to learn how to burn discs in OS X. It’s worth noting 
that even though you can burn Blu-ray discs in Windows, you can’t in OS X
 because no Mac computers include built-in Blu-ray support.<div class="entry-content" itemprop="articleBody">
<div class="KonaBody">
This really isn’t a big deal because most Windows computers don’t 
have Blu-ray burners either and most people still burn DVDs and CDs. 
Also, judging by how Apple completely removed the optical drive from the
 new MacBook and MacBook Air, burning CDs and DVDs on Macs is probably 
going to be a thing of the past pretty soon whether you like it or not.

Now when it comes to burning discs on a Mac, there are usually a 
couple of scenarios: burn a data disc or ISO image, burn an audio CD or 
burn a video DVD playable in a DVD player. Depending on what type task 
you need to complete, you may have to use different software.

In this article, I’ll talk about how you can burn a disc in OS X for 
multiple purposes. I’ll also mention some alternatives for Mac that you 
can use to burn CDs and DVDs. Unfortunately, with Macs, you just have 
fewer choices. For example, Apple has iMovie for making awesome edited 
movies, but you can’t use iMovie to burn a DVD!

<h2>
Burn a Data Disc or ISO Image</h2>
Let’s start with the easy stuff first: burning a simple data disc or 
an ISO image file. For an ISO image, check out my previous post on <a href="http://www.online-tech-tips.com/mac-os-x/burn-an-iso-file-using-mac-os-x/" target="_blank">burning ISO images using OS X</a>. Burning a data disc is also really easy.

The first thing you need to do is copy all the data you want to burn 
into a folder. It really doesn’t matter where the folder is located or 
what name you give the folder; it should just all be in one place.

Now just right-click on the folder and choose Burn “Folder Name” to Disc. If you don’t already have a disc in the optical drive, you’ll get a message asking you to insert one.

Next, you can give your disc a name and choose the burning speed, which should automatically be set to the max speed.

Click Burn and the CD or DVD will begin to be burned. For data discs, it’s as simple as that.

<h2>
Burn Audio CD</h2>
In Windows, you can <a href="http://www.online-tech-tips.com/computer-tips/how-to-burn-cds-dvds-blu-ray-discs-windows/" target="_blank">burn an audio CD using Windows Media Player</a>.
 On a Mac, you can burn audio CDs using iTunes. Open iTunes and add all 
your music to your library. Once you have added your music, you need to 
create a playlist.

Go ahead and select the songs you want on your audio CD, right-click and choose New Playlist from Selection.
 Note that if you are going to burn an audio CD, you can only have up to
 72 minutes of audio. If you are burning an MP3 CD, you can add up to 
700 MB worth of MP3 files.

Now you should see your new playlist in the left hand side under Playlists. Click on the playlist to select it. Now click on File and choose Burn Playlist to Disc.

The Burn Settings dialog will appear where you can choose how you want to create your audio CD.

The main section is Disc Format, where you can choose from an Audio CD (72 minutes), an MP3 CD (700 MB) or a Data CD/DVD. For an audio CD, you can choose how long the gap between songs should be, use Sound Check
 to make sure the volume is consistent across all songs and include CD 
text so that the song name, artist, etc. are displayed on disc players.

<h2>
Burn Video DVD</h2>
In Windows, you can <a href="http://www.online-tech-tips.com/computer-tips/burn-wmv-to-dvd/" target="_blank">burn a DVD using Windows DVD Maker</a>
 or a third-party program if you don’t have Windows 7, but on Mac there 
is no official software from Apple for burning DVDs. There used to be 
iDVD Author, but that was part of iLife 11, which you can still buy, but
 it’s old and probably not worth the money.

For Macs, you don’t have a lot of options. The only free program I can recommend is <a href="http://burn-osx.sourceforge.net/Pages/English/home.html" target="_blank">Burn</a>,
 which also hasn’t been updated since 2011, but works well enough for 
most people. First, go ahead and download the software and then run the 
application. If you get a message stating the program is blocked because
 of your security settings, then go to System Preferences, click on Security and Privacy and click on Open Anyway.

Once the program is open, you’ll want to click on the DVD tab. Give 
your DVD a title and then click on the drop-down box and change the 
format from VCD to DVD-Video. Next, click on the little plus icon at the bottom left to add video to your project.

Note that if you video is not in the correct format, you will get a 
message saying it is incompatible and asking if you would like to 
convert it to the proper format. You need to have videos in MPG format 
in order to use this program.

Click the Convert button and the file will be 
converted for you automatically. If you can’t convert using this 
program, use a program like HandBrake to convert the files for you.

Once you have added all your files, go ahead and click the Burn button to start the burn process.

That’s about it! It’s not fancy and the navigation controls for the 
DVD are pretty basic, but it gets the job done for free. If you are 
interested in creating custom themes for your DVD, customizing text and 
buttons, etc., then you’ll need to shell out some money for a DVD 
authoring program.

The most popular ones for Mac are <a href="http://www.roxio.com/enu/products/mydvd/default.html" target="_blank">Roxio MyDVD</a> for $49.99 and <a href="http://www.voilabits.com/dvd-creator-mac.html" target="_blank">Voilabits DVDCreator</a> for $39.99. Roxio has been around for ages and their software is excellent.

For $10 less, DVDCreator is also an excellent choice for authoring DVDs. You can purchase <a href="http://www.tkqlhce.com/click-7812933-10373745-1429024178000?url=http%3A%2F%2Fshop.roxio.com%2Fstore%2Fsonic%2Fen_US%2Fbuy%2Fproductid.319639400%2Fthemeid.44200&cjsku=319639400" target="_blank">MyDVD from here</a> and <a href="https://shopper.mycommerce.com/checkout/cart/add/53846-3?affiliate_id=619538" target="_blank">DVDCreator from here</a>. Both programs are also priced fairly considering they are pretty feature-rich.

<h2>
Troubleshooting</h2>
A quick frustration I wanted to mention was if you run into problems 
when burning a disc on your Mac. For whatever reason, the SuperDrive is a
 super piece of crap on most Macs and doesn’t burn discs properly a lot 
of times.

The most common error you’ll get is the following:

<pre>The disc can't be burned because an unexpected error occurred (error: 0x8002006E)</pre>
The only solution according to folks in the Apple forums is to buy an
 external DVD writer and use that instead. It’s pretty sad, but it’s not
 a top priority for Apple and that’s why they are removing the drives 
from their computers anyway.

If you can’t get another drive, try recording at a slower speed 
(maybe 1x or 2x) and try a different type of DVD. The drive is supposed 
to support +R and -R, but I sometimes find one format works better and 
doesn’t fail as often as the other. It’s a lot of trial and error.

Hopefully, this article will help you burn what you need on OS X. If you have any questions, feel free to comment. Enjoy!

</div>
</div>

TIPS How to Burn a DVD on a Mac

I’ve already talked about how you can burn CDs and DVDs in Windows , so now it’s time to learn how to burn discs in OS X. It’s worth noting...

How to Subtract Dates in Excel

How to Stop an LCD Monitor from Flickering

Prevent a Mouse or USB Device from Waking Windows from Sleep Mode

4 Free/Cheaper Rosetta Stone Alternatives

Install and Delete Fonts in Windows the Easy Way

How to Enable the God Mode Control Panel in Windows

How to Burn a DVD on a Mac

Labels

Blog Archive