The ‘Microsoft Office’ Archives
Posted March 13, 2015 by

Word 2015 for Mac: Protect Documents with Passwords

mac office

If your document contains confidential information that you want only certain people to see or edit, you can set passwords for the file so that it is completely safe from unauthorized access. In Word 2015, you can create up to two passwords: one for opening the file and the other for editing it. Continue reading […]

Posted March 13, 2015 by

Analytics with the Excel Analysis Toolpack

analytics with excel

Many people talk about “Big Data” and analytics, yet few understand what it means. The term analytics basically refers to the application of math and statistics to data sets, and it is certainly not a new idea. However, certain aspects of it have changed over the past five years because of databases like Hadoop that make […]

Category Microsoft Excel

Posted March 1, 2015 by

How to Edit PDF Files with Microsoft Word 2013

Untitled

What do you do when someone sends you a PDF file?  In the past, you typically read it or printed it. You could only edit PDF files if you bought an expensive copy of Adobe Pro.  If you wanted to edit it without Adobe Pro, you had to ask the sender to resend it as […]

Category Microsoft Word

Posted February 22, 2015 by

How to Add Fonts to Word 2013

add fonts to microsoft word

Calligraphy is a lost art for those who use computers and the Latin alphabet (e.g., English, French, and Spanish speakers). Nevertheless, creating electronic fonts for computers is still artwork. Here is how to add additional fonts to Microsoft Word so that you can use them with Word. Back when printing was done with printing presses […]

Category Microsoft Word

Posted February 14, 2015 by

How to Set Up iCloud Drive and Photos

how to set up icloud

Apple has cloud storage just like Microsoft (Microsoft One) and Google (Google Drive).  It is called iCloud. Setting it up can be quite an ordeal, and Apple only gives you 5 GB of free storage, which is enough for 1,000 5 MB photos. (Photos can be sized much smaller.) That is to be expected of […]

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 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 […]