New Horizons' top 10 blog posts of 2014

 Jan 20, 2015

Where did my Acrobat tab go in Microsoft Word?
By Katherine Davis | March 14th, 2014

I recently upgraded my computer with Microsoft Office 2013 and Acrobat XI. I was all excited about the new improvements in both software packages. When I decided to create a PDF [...]
Read More...
How to import public holidays in Project 2010
By Magdalena Todor | April 9th, 2014

Microsoft Project 2010 comes installed with three global calendars, and these calendars haveonly Saturdays and Sundays marked as non-working days. You will have to add public [...]
Read More...
How to create a PivotTable using Excel VBA
By Nicky Bull | March 21st, 2014

PivotTables are a powerful Microsoft Excel tool for analysing large quantities of data. When the process of creating a PivotTable needs to be automated, it can be done quite easily using Excel VBA.  [...]
Read More...
Easily convert date format in Excel
By Liz French | July 14th, 2014

This is one of the most frequently asked questions that come up when I’m teaching Microsoft Excel courses. Many people export their data from an accounting system or a database [...]
Read More...
VBA Excel: Finding the last row of a worksheet
By Matthew Goodall | May 15th, 2014

When creating macros in Microsoft Excel, you often want to find the last row of data in a worksheet to be able to choose the correct area so the macro can do things with that area. The main challenge  [...]
Read More...
Saving a file with a unique name in Excel VBA
By Matthew Goodall | February 24th, 2014

When creating macros in Excel (or another Office application), you often want to have the macro save the file of results as part of the macro. There are two main issues with saving files: where to save it [...]
Read More...
SQL Server 2014: Now how do I get certified?
By Adam Keats | April 1st, 2014

Dear Uncle Adam, How are you? Well, I hope. So, here’s my problem. Microsoft has released SQL Server 2014 and they’ve signaled that there are going to be some changes  [...]
Read More...
How to create a custom theme in Office 2013
By Liz French | April 7th, 2014

Themes in the Microsoft Office suite are used to format a whole document quickly and uniformly. In this blog post, I’ll go through some ways of creating a custom theme in Microsoft Office 2013. [...]
Read More...
Database indexing issues in Exchange Server 2013
By Gordon Cowser | March 24th, 2014

In this blog, I want to change tack a little bit, and talk about an issue that has cropped up a number of times in the Exchange Server 2013 courses, as well as in production systems [...]
Read More...
Dual boot Windows 8.1 on Windows 7 using VHD
By Barend Koekemoer | April 10th, 2014

Many IT guys and girls may know the way to dual boot Windows 8.1 on Windows 7 by creating a new partition, but that way has some disadvantages and is riskier than the way I will show you in today’s post.  [...]
Read More...

How do your Excel skills stack up?   

Test Now  

About the Author:

New Horizons  

New Horizons is Australia's leading corporate training provider, and has been educating business professionals for over 15 years in the areas of Professional Development, Microsoft Office & Adobe Applications, and IT Technical. Our aim through this blog is to bring you relevant stories, articles, and tips & tricks that can help you to improve your skills and productivity in the workplace. Our expert trainers will also be posting their own articles from time to time, so be sure to keep an eye out.

Read full bio
top
Back to top