Category Archives: Microsoft Office

Microsoft Excel Custom Formats – Celcius

Microsoft Excel LogoMicrosoft Excel is an amazing tool and provides a multitude of different formatting options.  However, there isn’t one for Celcius (or Fahrenheit for that matter).  Have you ever being in a situation where you need to compare temperatures?  Well I have.  A recent course I delivered required this exact thing.

Continue reading Microsoft Excel Custom Formats – Celcius

Microsoft is retiring Infopath

Numberminds Microsoft Infopath 2013 Logo

Some people have seen this application on their desktops and wondered what it is.  Maybe you clicked on it and went “Oh god whats this”.  Some of you maybe even playing around with it.  However, how useful is Infopath?

Well Microsoft has responded to forums and feedback regarding the product and have decided rather than offering and maintaining a seperate product for forms.  They are going to retire it.

Continue reading Microsoft is retiring Infopath

Numberminds given Small Business Specialist status from Microsoft

Microsoft_Logo_smallAs a Microsoft partner, Numberminds are always looking at their new software.  We have recently being awarded their “Small Business Specialist” service.  This is a great honour that we’ve worked hard to achieve and are pleased to have it on our website.

We are already offering training in Microsoft Office from versions 2003 to 2013 as well as other tools such as Microsoft Sharepoint, Microsoft Visio, Microsoft Project, Office 365 and more.

Continue reading Numberminds given Small Business Specialist status from Microsoft

What are XPS files and should I use them?

http://www.numberminds.com/blog/wp-content/uploads/2014/02/Microsoft_XPS_Viewer_Logo.pngMy mother recently asked me a question about XPS files.  She has a massive collection of recipes which she normally cut and pastes into word files.  However, the latest recipe was, by accident saved as an XPS format and she didn’t know what it was.

In short XPS (XML Paper Specification) is Microsoft’s version of PDF.

Continue reading What are XPS files and should I use them?

Microsoft Excel – Using VBA to check values in different columns and apply formatting

Microsoft Excel LogoExcel it a complicated beast.  When I first started with spreadsheets I was always putting things in columns and rows and not doing much with it.  Since learning VBA about 15 years ago I have taken my knowledge to the Nth degree.  Recently, I ran a VBA workshop and one of the delegates asked me a question which perplexed me for a while.

“I want to be able to check two values and if they are equal then I want the “check” column to turn green and a plus sign be the value.  Oppositely if the cell values don’t match then I want the “checked” cell value to be a minus sign and the cell colour to be red.”

Seems simple doesn’t it.  Now try and do it without conditional formatting because that was my first thought too.

Continue reading Microsoft Excel – Using VBA to check values in different columns and apply formatting

Google Plus – Our Office365 Community

Office-365-LogoOffice365 is leading the way in subscription based software packages.  Microsoft Office is used all across the world and Numberminds uses it extensively (dashboards, data modelling, presentations, template building, training and more).  Anyway, by subscribing to Office365 you aren’t limiting yourself to any package – in short its scaleable. Continue reading Google Plus – Our Office365 Community

Microsoft Office 2013 – the smart move

Office-365-LogoThere are very few businesses that don’t run Microsoft Office products.  This isn’t because of some subversive approach by Microsoft to pre-load Office onto everyone’s systems.  It is simply because, in my humbled opinion, the best suite of products on the market.

What’s more they are evolving!

Office2013 brings as many dramatic changes as 2003 to 2007 did.  Remember when the toolbar was removed in favour of the ribbon.  Come on how long did it really take you to get used to it?

Office2013 is built for businesses.  Why spend thousands of pounds on expensive shared storage and backup systems when Microsoft provide it for you free?  Office2013 ensures that all your documents are stored in the cloud by default and are accessible anywhere.

Continue reading Microsoft Office 2013 – the smart move

Microsoft Excel – Weekday Function and VLookups

Microsoft Excel 2010 - LogoMicrosoft Excel is the world’s most used spreadsheet tool.  But what do people use it for really?  I would admit that I began using it at school for creating lists and slight calculations.  However, now with what I have learnt in terms of automation, KPI creation, VBA and analysis. Continue reading Microsoft Excel – Weekday Function and VLookups

Microsoft Excel – Number of Working Days in a month

Microsoft Excel 2010 - LogoI came across a question on LinkedIn from someone who wanted to know how to count the number of working days in a month.  Now I know that there is a WORKDAY function within Excel which is supposed to take into account holidays but, this doesn’t take into account different national holidays in different time-zones (to the best of my knowledge).

Continue reading Microsoft Excel – Number of Working Days in a month

Getting Day Names and Month Names in Microsoft Excel using VBA

 

Microsoft Excel 2010 - LogoMy last post I blogged about how to get the Day Names and Month Names using VLOOKUPs.  However, today let’s look at doing exactly the same but, using VBA (Visual Basic for Applications).  Now for the non-coders reading this it may seem kinda scary but, give it a go and you may be surprised about how easy coding in Excel can be.

I would recommend though that you learn in a practice document that isn’t going to affect real data or an existing document.

 

Continue reading Getting Day Names and Month Names in Microsoft Excel using VBA