Excel Training UK

From first time Excel users to advanced VBA experts, we offer Excel training courses to suit all abilities. Our popular Excel beginners courses are ideal for learning the basics of Microsoft's flagship spreadsheet application but we also offer advanced & tailored courses as well as a VBA for Excel course.

Conditional Formatting Tutorial – Excel 2007 & 2010

Conditional Formatting is the practice of formatting cells in Excel spreadsheets to change cell appearance depending on certain conditions.

It can be extremely useful for immediately highlighting certain parts of a spreadsheet so that your attention is drawn to them – for example when a value goes over a certain threshold, or a date passes its deadline.

In this tutorial we’ll show you how to use conditional formatting to change the colour of cells depending on a percentage.

Why not check out our Top 10 Excel Time Saving Formulas for more helpful tips. 

Conditional Formatting Tutorial – Colour Coded Data

Here’s our example data. We’ve used the 2011 market share figures for smart phone operating systems worldwide.

Excel 2007 Conditional Formatting Tutorial 1

 

Read the rest of “Conditional Formatting Tutorial – Excel 2007 & 2010″

Excel Web App in Office 365 – Working in the Cloud

microsoft-excel-office-365You might have recently heard about Microsoft Office 365 – and if you work in IT you’ve almost certainly come across Cloud Computing.

Office 365 is Microsoft’s new “cloud” version of Microsoft office. Essentially that means online versions of Excel, Word, Outlook etc… that allow users to:

  • Access their office documents from any PC
  • Create, edit and share Microsoft Office documents (including Excel Workbooks) from PCs which don’t have the native version of MS Office installed on them

These online versions of the MS Office packages are known as Web Apps. Here we take a preview of the Excel Web App in Office 365 and how it will work.

Need help with Excel? Check out these 10 time saving Excel formulas

What is the Microsoft Excel Web App?

The Excel Web App in Office 365 is essentially a web-based version of Excel that runs in a web browser. This means that you can run it on any PC with web access (you don’t actually have to have Excel installed on your PC).

The look and feel of the Excel Web App is exactly the same as the latest versions of the Excel desktop application, so if you’re used to working in Excel 2007 or 2010 you should have no problem using the web app.

But if you’re using Excel online – where do your Excel Web App workbooks get saved?

Depending on how you are implementing Office 365, the actual workbooks are stored in one of two places:

  • Windows Live SkyDrive - which is a free online storage & sharing service (if you use the Mac “MobileMe” service – soon to be replaced by iCloud – this is the Windows equivalent – If you have a Windows Live ID (e.g via having Hotmail account) you’ll be able to log in using this.
  • SharePoint Site - If your organisation uses SharePoint server, all of your documents can be stored here

How to Create an Excel Web App Workbook

If you already have a Hotmail account or Windows Live ID – try logging in to your account (if you don’t have one you can set one up here)

Read the rest of “Excel Web App in Office 365 – Working in the Cloud”

Page 10 of 13« First...89101112...Last »