Blog Main Categories
- Project Management 72
- Business Skills 125
- Creative Design 68
- Business Processes 74
- IT and Web Development 66
- Digital Marketing 101
You are viewing posts from the Microsoft category. Click to view all posts
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.
Rumour has it Microsoft looks set to release a version of Office for iOS and Android devices early next year, and it's safe to say the preemptive reception is mixed. Whilst there has been no official announcement from Microsoft, The Verge broke the news after receiving various leaks from high-profile sources as well as posting an apparent screenshot of the app in use on an iPad (see pic below).
With the recent release of the Surface Tablet and Windows 8 as a multi-platform operating system, many are questioning the decision to release a flagship product on competitor devices. However, it would appear that the basic free version of Office set to be available on mobile devices will be nothing more than a document reader - editing functions will only come with an Office 365 subscription.
As no official details have been released as yet we can't go into depth on the functionality of the app, so instead in this article we'll be taking a general look at the potential impacts and usefulness of Office on iOS and Android.
Microsoft Office 2013 has already been released to coincide with Windows 8. We will be updating our Microsoft Office courses, which includes our Excel Training and our Advanced Excel Training, to use the latest software.
The question is: would you use Excel and other Office programs on your current mobile device? And if so, how much would you pay to use them?
New course just launched! Learn how to create iPhone apps with no prior coding experience on our iOS App Training for Non Developers course!
If Windows 8 proves to be as popular and widely adopted as Windows 7, it could be huge for apps and responsive web design, taking the formats from mobile to a mainstream desktop market.
The booming mobile industry (dominated by iOS and Android) has seen apps go mainstream in the last few years. It has also prompted a radical change in web design with a desire for responsive design that adapts to browser size.
However, the number of websites with responsive design is still miniscule, and apps are still mostly for personal use on mobile devices. True synchronicity between desktop and mobile, (and between work and home) is still a long way off.
Windows 8 could be the catalyst to take app development and responsive design from mobile to desktop.
Stay ahead of the curve with our range of mobile development courses. We run iOS App training and Android App courses for native app developers as well as our highly popular mobile web week workshop which includes a day on responsive web design.
Windows 8 Apps
Sorry developers, it looks like you're going to have to learn to make apps for Windows 8 on top of Android and iOS.
Taking Apple's latest OSX update a step further, Microsoft have unveiled an operating system to work on all devices, desktop and mobile, by focusing on apps. They're a bit late to the party, with Apple have had an App store on desktop for a long time. But despite Apple's break into the market, Windows is still by far the global operating system of choice, particularly in workplaces.
Like Apple's App Store and Google Play, Microsoft is launching its own closed app marketplace and this is expected to become the norm for downloading software as it's often seen as 'safer' than downloading straight off the web, and easier than going into a shop and buying a disk.
Every SEO Person Needs This in their Link-Building Toolkit.
Link building is the process of trying to manipulate the inbound links that are directly aiming towards a site. It is an essential part of an SEO campaign but a lot of SEO people do not use or have the essential tools to do the job properly and thoroughly. Even so, the people with the right tools still don’t use them to their full potential and are making life difficult for themselves.
If you want to learn more about building your own spreadsheet then take our Excel Training course ( we also offer advanced excel training), also if you want to learn more about Search Engine Optimisation, then try our SEO Training course in Brighton, Sussex.
I have created an Excel document and a Word document to help you with your link building campaign. The Excel document includes different worksheets with different lists in to enter your data as you go along. For data entry, Excel will always be a useful tool to use as it allows you to switch from cell to cell while entering data with ease.
Normally, link building is an on-going practice and from time to time it can get boring and repetitive, but if you keep it all organised then you will find it a lot easier. Also, if you need to get someone else to do the link building for you, with these resources, you can easily pass on what you have done and they can just pick up where you left off.
You can download the resources at the bottom of this page, but here’s a breakdown of what is in them and what you should be considering when starting your link building campaign -
Excel's Auto Sum feature is a handy time-saving feature that prevents you having to type out lists of commonly used values like sequences of numbers, days of the week or months. Auto Sum is covered in our Excel Beginners Training Course.
Watch the video, or read the instructions below:
Let's demonstrate this with months. Type "January" in to a cell in your spreadsheet. Highlight the cell and you'll see that there's a little black arrow in the bottom right hand corner. Carefully click on this arrow with the mouse (a bit fiddly!) and hold the button. Now drag the box downwards a few cells and release, and Excel will fill in the subsequent months for you. Clever eh! Even better, it will also recognise abbreviations, such as Jan, Feb, Mar etc...
When you have finished dragging you will also see an Auto Fill options box appear.
If you click on this a drop down menu will appear showing you a list of further options. Whatever you press in this drop down menu will affect the series of numbers that you have created. If you would rather not have Excel type out all of the months and want all of the cells to say January, use the “copy cells” option