Ready To Go!

10. June 2016 Intro 0
Ready To Go!
After few more hours of work I think this is officially done. The new blog is ready for visitors! Let me know what you think. – Office Wizkid

Moving again…

05. June 2016 Intro 0
Moving again…
Working on moving my blog from its previous location to this brand new domain. Not an easy task and I’ve already been spending few hours struggling with moving around all the posts, comments and media. Not sure when this will all be done…

Document Inspector on Mac?

Document Inspector on Mac?
I read today a blog entry regarding the hidden information in Office document and what can be done about it (Do You Know What’s Hiding in Your Documents?). From a personal experience, especially in business negotiation and contracts, it is kind of surprising to see what can be extracted out of a seemingly clean Word ...

Basic Pivot Table Example

Basic Pivot Table Example
Microsoft describes PivotTables as “A PivotTable report is useful to summarize, analyze, explore, and present summary data. A PivotChart report can help you visualize PivotTable report summary data so that you can easily see comparisons, patterns, and trends. Both reports enable you to make informed decisions about critical data in your enterprise. The following sections ...

Excel COUNTIF Condition Examples

Excel COUNTIF Condition Examples
Excel COUNTIF is one of these functions that are simple enough to understand the concept but make you scratch your head when you try to do something less trivial with the condition part. Sure, simple cases are simple enough: How to count all the cells in a range A1:A100 that have a specific value called ...

Excel Icon Sets – Simple Example

Excel Icon Sets – Simple Example
They say that picture is worth a thousand words and that is even more accurate when dealing with numbers. Sometimes in Excel you want to show Icons that provide quick meaningful indication for the value of the rows. A simple way to do that is by using Excel’s icon sets conditional formatting. For a simple ...

Excel VLookup – Simple Example

Excel VLookup – Simple Example
VLookup is an Excel search function. See the official definition at the Microsoft Office site. It is part of a family of search functions that includes Lookup, VLookup, HLookup and Match. Each one with a slightly different behavior. The VLookup syntax seems abstract and complex so instead of explaining the syntax let’s focus on a ...