The ‘Windows’ Archives
Posted February 9, 2015 by

How to Write a Custom Function in Microsoft Excel

how to create custom excel function

Microsoft products have always included Visual Basic. You can use it in Microsoft Word, Access, and Excel. One reason this is true is that Bill Gates and some of his friends wrote Visual Basic while Gates was still at Harvard.  Thus, he felt proud of his accomplishment and wanted to keep it. Gates wrote the floating […]

Category Microsoft Excel

Posted February 2, 2015 by

Create Citations, Endnotes, and Footnotes in Microsoft Word 2013

how to create a footnote in word

Citations, footnotes, and endnotes are important for academic writing.  Microsoft Word 2013 generates these items for the writer automatically. It can also make a table of figures and an index.  It would take much effort to do this manually, which is what publishers did for many years. Here is how to make a citation, footnote, and […]

Category Microsoft Word

Posted January 20, 2015 by

Microsoft Windows: How to Create a God Mode Folder in Windows

Windows_GodMode

The Windows operating system is full of hidden features and tricks. Using these hidden features can save you a lot of time and increase your productivity. One of the most useful features which is not widely known in Windows 7 and Windows 8 is God Mode.

Posted January 17, 2015 by

How Do I Cut My Own Micro and Nano SIM Cards

feature micro SIM card

Are you using a Mini SIM (2FF)? More commonly termed as the regular SIM card, Mini SIM is still the most widely used SIM card in the world. You may notice, though, that once you switch to flagship devices, they are using smaller types of SIM cards. These are the Micro SIM card (3FF) and […]

Posted January 16, 2015 by

How to Check the Memory of an External Graphics Card in Windows 7

graphics

You have two types of graphics memory in your computer systems: internal graphics memory and external graphics memory. The internal graphics memory is part of the system’s motherboard. The external graphics memory belongs to the hardware of a dedicated graphics card which is installed separately on the motherboard. Graphics memory is needed to run high […]

Posted January 11, 2015 by

Hide Files and Folders in Windows Using Command Prompt

tech_recipes_windows_command_line

Today, privacy is a hot topic. The technique of hiding files and folders comes in handy when you are using a computer which is used by more than one person. This article will show you a techie way to hide files and folders in Windows 7 using command line.

Posted December 18, 2014 by

Excel 2013: Convert European Numbers to American

sshot-4

If you work in more than one language with Excel, then you know that there are often issues converting numbers from French, Spanish, or other Romance languages to American or British English.  The reason for this is that the number $1,000.25 USD is written as $1.000,25 in Romance languages with the decimal and comma switched. […]

Category Microsoft Excel

Posted December 16, 2014 by

Microsoft Excel: Convert Dates from European to US Format

sshot-4

If you work in more than one language with Excel, then you probably have noticed that you have problems converting dates from the European format (dd/mm/yyyy) to the American English format (mm/dd/yyyy). In fact, in most countries outside the US, the date is written as dd/mm/yyyy. (i.e., The day is first, the month is next, […]

Category Microsoft Excel

Posted December 10, 2014 by

How to Recover a Different File Version on Microsoft OneDrive

sshot-2

For many reasons, you might find you need to recover an older version of a Word document, spreadsheet, or document created online. If you find that a hacker has locked your file using a virus or if you have accidently deleted important sections of your document, knowing how to locate a previous version of a […]

Posted December 6, 2014 by

How to Write Gmail Filters

filter gmail

You depend on your email for your social life and work, so it is quite annoying when someone sends you junk mail. Your phone beeps that you have mail, but the message is nothing important that you need to read. Fortunately, you can deal with junk email messages when you use Gmail with filters. Here […]