The ‘Microsoft Office’ Archives
Posted April 6, 2015 by

How to Fix Problems with the Word App for iOS or Android

fix office app sync issues

Using your Microsoft Office app to edit a document creates problems when you edit the same document using Office 365 or Word 2013 and a communication delay also occurs when you upload your changes to OneDrive. This can happen when you lose your internet connection or your connection is slow. This tutorial explains why this issue […]

Category Microsoft Office

Posted April 1, 2015 by

How to Fix OneDrive Sync Errors with Office Tools

Untitled

When you save a Word document or Excel Spreadsheet on OneDrive, there is a delay before that data gets uploaded from your PC. However, Micrcosoft hides the details of this from the PC user by making it appear as if the changes you have saved have been uploaded. This tutorial explains how this occurs and […]

Category Microsoft Office

Posted March 29, 2015 by

Office 2015 for Mac: Disable the Start Screen

office-2013-logo

By default, whenever you launch either Word, Excel, or PowerPoint, the program greets you with a list of pre-configured document templates so that you can select and start working on a document right away. This feature can be helpful if you often use these templates. However, if you always start with a blank document, it […]

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