Raising the Bar Blog

The Benefits to Learn Excel – Raising the Bar

Learn Excel with Raising the Bar — The benefits to learn Excel

Across every industry, every job and every workspace, the benefits of continuing training and development in your professional space is key to building a rewarding career. Whether you work in accounting, marketing, sales, human resources, or even a school, if your job requires a computer, then you will most likely need to learn Excel and benefit from a professional Excel training course provider. Although that green icon looming in your desktop space can be daunting for people who aren’t familiar with the software, Excel had many key benefits which can make your job a lot easier.
Continue reading “The Benefits to Learn Excel – Raising the Bar”

Project Management Workshops

Case Study:

Raising the Bar is currently partnering with a state government organisation to design, develop and deliver a range of Microsoft Project and project management workshops.

Some of the courses and workshops that Raising the Bar has been working on are: Continue reading “Project Management Workshops”

Styles in Microsoft Word

Do you find yourself spending way too long fiddling with the formatting of text and headings in Microsoft Word? Do you work with longer documents and find it difficult keeping your formatting consistent across the document? Do you find it time-consuming and repetitive when you need to update your formatting? If you answered yes to any or all of these questions, then you would probably benefit from using styles in Microsoft Word. Continue reading “Styles in Microsoft Word”

Dealing with Leading Zeros in Excel

I’m a big fan of custom number formats in Excel. People generally think that formatting is all about making your data “pretty” for want of a better term. It’s not. It’s all about making your data easier to read. In this blog I’m going to start by showing you how to deal with leading zeros, aka insignificant zeros, in your Excel spreadsheets. Continue reading “Dealing with Leading Zeros in Excel”

Ligatures in Microsoft Word 2010

Being someone who is keen on design, desktop publishing and typography in general, I was really pleased to learn that Microsoft Word 2010 supports ligatures. That got me wondering, just how many people actually know about this? It is not so easy to find, you have to dig quite a bit and even then you may not immediately see much in the way of results. If you need to make anything that requires something a bit fancy, such as menus, invitations or certificates; or you just happen to like typography or calligraphy, it’s a really cool feature once you get it going, so here goes… Continue reading “Ligatures in Microsoft Word 2010”

Sharing Outlook Folders Including Inbox

There are two ways to share your Inbox in Outlook. I need to point out from the start that you need to be using an exchange server for this to work. You can’t use these methods to share your inbox from home. OK, now that’s out of the way let’s get down to it. The first method of sharing your inbox is delegation. It’ great if you just want to share your inbox, however if you want to share your sent items too, then you need to use another method – see method 2. Continue reading “Sharing Outlook Folders Including Inbox”

10 Basic Tips For PhotoShop

A long time ago, my first business was editing photographs for professional photographers. During this time I picked up many useful time saving tips in Photoshop that I would like to share with you. Most of them are basic however they can really save you some time in Photoshop and I use these tips and tricks all the time. If your not a keyboard shortcut fan then you really should learn. Some features require you to use keyboard short cuts to get the job done. Read on – 10 basic tips for Photoshop.

Continue reading “10 Basic Tips For PhotoShop”

Raster and Vector Graphics Explained in Illustrator

Illustrator, Adobe’s drawing and design program, can be used to design and create anything from a simple logo to complex illustrations including text, but underpinning all of that is the notion of the vector-based image. This is in complete contrast to the raster-based world of Photoshop (where everything is made of pixels), because in illustrator our images are object-based. Continue reading “Raster and Vector Graphics Explained in Illustrator”

Excel VBA Selection and Navigation Techniques – part 2

See previous article: Excel VBA Selection and Navigation Techniques

In the last article I showed you how to make some basic navigation and selection techniques using the macro recorder. In this article I’ll show you how you can navigate and select when the data is more complex. Blank cells can be difficult to deal with if you don’t know how. I’ll take you through some of the methods I use when coding in Excel VBA. Continue reading “Excel VBA Selection and Navigation Techniques – part 2”

Excel VBA Selection and Navigation

Microsoft Excel VBA Navigation People often ask me about selection and navigation techniques using keyboard shortcuts when I’m teaching Macros in an Advanced Excel course. However, when I’m teaching students how to program for the first time in an Excel VBA course:

Question: How do I select or navigate using Excel VBA?

In this article I’m going to show you some basic techniques on how to go about it. Continue reading “Excel VBA Selection and Navigation”