Suppress & Hide Formula Cell Value Error in Excel

When using many formulas in the workbook of Microsoft Excel, the spreadsheet may display error for formulas that do not return proper values or results. For example, the cell displays #N/A for value not available error, #DIV/0! [...]

By | 2017-01-20T00:57:40+00:00 January 20th, 2017|Categories: Office|Tags: |0 Comments

Sum the Total of Same Cell on All Worksheets in Excel

In Microsoft Excel spreadsheet software, there may be a need to sum the total of a cell in all individual worksheets to display in a master sheet. For example, you have 12 worksheets that contain sales figure [...]

By | 2016-12-10T21:41:07+00:00 December 10th, 2016|Categories: Office|Tags: , |0 Comments

Delete a Defined Name & Named Range in Excel

Microsoft Excel is the powerful and advanced spreadsheet application which comes as part of Microsoft Office. EXcel allows users to define name for individual cell, cell range, function, constant or table in order to be used in [...]

By | 2016-12-09T08:38:16+00:00 December 9th, 2016|Categories: Office|Tags: , |0 Comments

Microsoft Outlook Not Update Nor Sync Exchange Mailboxes / Inbox

When using Microsoft Outlook client to access Exchange mailboxes and Inbox, the Outlook does not actually update the all mailboxes and Inbox folder. The content and emails in the mailboxes are not refreshed, i.e. only the old [...]

By | 2016-12-09T08:38:22+00:00 December 9th, 2016|Categories: Office|Tags: |0 Comments

Outlook 2013 / 2016 IMAP Not Delete Emails in Gmail Inbox / All Mails

When deleting email messages in Microsoft Office Outlook 2013 or Outlook 2016 from Gmail (inclusive of both personal Gmail, paid commercial or free Google Apps) account which is configured to sync via IMAP protocol, the deleted emails [...]

Change Sync Folder Location of OneDrive for Business

OneDrive for Business is part of Office 365 or SharePoint Server which provides cloud storage and personal library for storing and organizing the work documents. By default, in Windows, when you sync a document library with OneDrive [...]

By | 2016-12-09T08:38:29+00:00 December 9th, 2016|Categories: Office|Tags: , , , |0 Comments

Open & Save Files in Google Drive from Microsoft Office Easily

If you are using Google Drive (either free personal account or as part of Google Apps), and are using the full-featured Microsoft Office desktop software such as Word, Excel and PowerPoint to create and edit your documents, [...]

By | 2016-12-09T08:38:31+00:00 December 9th, 2016|Categories: Office|Tags: , |0 Comments

Microsoft Office 2016 (Word, Excel, PowerPoint, Outlook, OneNote) Quick Start Guides

Microsoft Office 2016 was officially released by Microsoft on mid 2015. Office 2016 generally retains the similar yet simpler and improved user interface when comparing with its predecessor, yet it comes with various interesting new features, functionality [...]

By | 2016-12-09T08:38:31+00:00 December 9th, 2016|Categories: Office|Tags: |0 Comments

Microsoft Outlook Must Be Closed Because an Error Occurred on Mac

When opening Outlook for Mac 2011 or Outlook for Mac 2016 from Office for Mac productivity suite, the Outlook app displays the following error message within a few minutes of opening, and then the program crashes and [...]

By | 2016-12-09T08:38:33+00:00 December 9th, 2016|Categories: Office|Tags: , |0 Comments

Office 2016 Price (Free for Office 365 Subscribers)

Microsoft has released Microsoft Office 2016 for Windows desktop productivity software suite. With it, Microsoft is also making a big push for consumers to go for Office 365 annual subscriptions. This reflects in the pricing strategy on [...]

By | 2016-12-09T08:38:34+00:00 December 9th, 2016|Categories: Office|Tags: , |1 Comment