Blog Main Categories
- Project Management 82
- Business Processes 88
- Business Skills 163
- IT and Web Development 86
- Creative Design 110
- Digital Marketing 184
You are viewing posts from the Microsoft Office category. Click to view all posts
The decision to upgrade to a new version of Office doesn't come lightly. It's not just the monetary cost to consider it's also the time spent training staff on the new software, compatibility issues and potential bugs if you're an early adopter.
We run most of our Office courses on Office 2010 because very few businesses have taken the leap of faith and upgraded to Office 13. A lot of them actually can't; Office 2013 is incompatible with XP, Vista and early versions of Windows - making it unavailable for more than half of Windows users.
However, we know that some businesses are thinking about making the switch so we've put together this list of Office 2013 guides to help you decide whether it's worth upgrading and what you need to know if you decide to.
There's no doubt that Word will around for a long time. It's taught in all schools and is the de facto software for Word Processing and document creation worldwide. However, InDesign has become more and more popular in businesses due to the desire to create more consistent and professional internal and external documents.
If you have ever tried to persuade your employees/co-workers/boss to switch to InDesign then you've probably been met with one or all the following:
I don't want to learn new software!
It's too complicated!
There's nothing wrong with Word!
I'm going to try and dispel these myths with 6 reasons why now is the right time to switch from Word to InDesign:
When people think of Microsoft Excel, they often picture dull figures and charts and just generally lots and lots of data. All very useful stuff but not the most enthralling outside of a work environment.
Some people however, take a different approach. To them Excel can be anything and everything. It's not just for business and numbers. It can be used to create innovative and original concepts, in all sorts of different ways.
Whatever you want to use Excel for, our Excel Training will give you all the knowledge you need to make the most of this powerful tool and it's also worth reading this blog post on some hidden Excel tips and tricks.
So let's take a look at some of the less traditional uses of Excel to give you an idea of what this software can really do.
Art in Excel
Excel can and has been used by artists as a platform to express their ideas and creativity. It may sound like an odd choice of medium but the flexibility and functionality Excel provides is surprisingly suited to artistic endeavour.
Take a look at these magnificent pieces by Japanese artist Tatsuo Horiuchi:
And these Star Wars-themed works by Shukei are out of this world (excuse the pun):
With Microsoft Office 2013 set for release very soon (and after our look at the new mobile excel apps), we thought we'd take a look at some of the new features to be added to its Access software.
The database powerhouse has undergone an overhaul and not just aesthetically. More app-focused, easily shareable and with a revised back-end, Access 2013 is set to build and develop upon the now three year old incumbent, Access 2010.
If you'd like to learn how to use Access from scratch, come on our Beginner's Access Training Course or if you have some experience but would like to brush up on your skills, try our 1 day Advanced Access Workshop.
So what exactly is different about Access 2013 compared to previous versions? And will these differences make the user experience better or worse?
The biggest new feature to be brought in with Access 2013 is the focus on a more app-based system.
What with the introduction of Windows 8 and Sharepoint's development into a realistic competitor to Google Drive and Dropbox, it's unsurprising that Access 2013 has such a focus.
In Access 2013 you'll be able to create an app (which can effectively be anything, but we'll assume an Access file!), upload it to Sharepoint and then allow access to anyone you like.
No extra login details are required; just those of the business'/users' Sharepoint account.
In this post, our Excel trainer Maggie runs through using large files in Excel.
Split Screen and Freezing Panes
In many cases, you might find it helpful to work with different sections of your worksheet at the same time.
For example, you might want to keep the data in row 4 visible while you scroll down to look at information located in row 35. You do this by applying split bars.
If you already know how to use split bars but are struggling with other aspects of Excel, why not try our Advanced Excel Training.
Applying Split Bars
When you apply split bars to a worksheet, Excel creates identical copies of the worksheet side by side. If you apply either a horizontal or vertical split bar, you can scroll within one pane while the other pane remains stationary.
Although the Split command can be accessed from the View Menu, you can also manipulate split bars with the mouse using the split boxes. You can move between the different panes by simply clicking the pane in which you want to work. Because each pane is a view of the same worksheet, a change in one pane means a change to the worksheet.
The VIEW tab contains the option to SPLIT. However, if you do choose to split using this option, Excel will split the Window at the current location, i.e. the cell you are currently in. You will probably end up with a horizontal and vertical split.
To Split a Window horizontally, place the mouse over the Split Symbol and drag it half way down the vertical scroll bar. To Split a Window vertically, place the mouse over the Split Symbol and drag half way across the horizontal scroll bar.