Subscribe for access to this FREE e-learning mini-course!


Your First Name:


Your Surname:


Your Email Address:



Subscribe
Close


Small logo
Hamburger menu
Menu
bookings:   0333 6000 111
service:       0333 6000 555
    or           
Free Excel Video Tutorials From Activia Training
Free Excel Video Tutorials From Activia Training
Search
FREE RESOURCES FROM ACTIVIA

Learn and work with new Excel formulas to help create effective, automated spreadsheets

Resources for Excel courses that we hope you find useful


Excel Formulas: Circular reference warning
Excel Formulas: Circular reference warning

See what a Circular Reference warning means and how to locate it in your Excel spreadsheet

If you are creating a formula which refers to the same cell that you are currently working on (or refers to it indirectly via another cell), you will get a circular reference warning.

Watch   ...   read more


Excel Formulas: Calculate difference in dates
Excel Formulas: Calculate difference in dates

Learn how to calculate the difference between two dates in your Excel spreadsheet in a few easy steps

Forget the Big Bang theory: according to Microsoft Excel, the universe began in 1900. January 1st 1900 was day 1 in Excel and it doesn't recognise dates earlier than this as actual dates.

S   ...   read more


Excel Formulas: Why a formula doesn't work
Excel Formulas: Why a formula doesn't work

Find out why your formula might not work in Microsoft Excel and how to fix it

So you have spent a long time working on your spreadsheet, created some formulas, added some numbers to the cells. and nothing happens. There are many reasons for this, so here are a few to check.<   ...   read more


Excel Formulas: How to work out gross profit
Excel Formulas: How to work out gross profit

Find out how to use a formula to work out gross profit in Microsoft Excel

Working out the calculation for marking up a figure or working out gross profit is not the easiest of tasks with a pencil, paper and calculator, let alone translating that into an Excel spreadsheet   ...   read more


Excel Formulas: The DATEDIF function
Excel Formulas: The DATEDIF function

Find out what the DATEDIF function is and how to use it in Microsoft Excel

The undocumented DATEDIF function can be incredibly useful when calculating the difference between dates in Excel. It is a bit of a hidden gem, as it doesn't appear in the list of formulas or if yo   ...   read more


Excel Formulas: How to capitalise first letter
Excel Formulas: How to capitalise first letter

Find out how to use Excel functions to automatically capitalise the first letter of your text

There are various functions for changing the case of text in a cell. UPPER, LOWER and PROPER are all incredibly useful functions, particularly when you have columns of data in various formats.

  ...   read more

Excel Formulas: How to remove spaces
Excel Formulas: How to remove spaces

Learn how to remove unwanted cell spaces or non-printer friendly characters from your Excel spreadsheet

'Trim the fat' is a phrase many of us use and it applies to Excel as well.

There are so many different programs which analyse and report on data and Excel is still number one for u   ...   read more


Excel Formulas: Absolute cell references
Excel Formulas: Absolute cell references

Find out what absolute references are in Excel and how to use them

Although you can use Excel to display a number as a currency value, such as ££££1.00, $1.00 or €1.00, you might have seen dollar signs in formulas when they have   ...   read more


Excel Formulas: Converting measurements
Excel Formulas: Converting measurements

Learn how to convert different measurements in Excel

You may find yourself in situations where you need to convert one measurement to another. This can be a pain, particularly if you are converting metric to imperial, or vice-versa. Even if you know   ...   read more


Excel Formulas: Counting text values
Excel Formulas: Counting text values

Learn more about Excel's COUNT function and how you can use it to count text values

One of the exercises we run through in our courses is the COUNT function. This is very handy when you want to find out how many cells have a number in but you are not interested in adding the value   ...   read more

GET IN TOUCH

Call us on:
0333 6000 111

   You can Email us direct (You'll usually get a response within 2-3 working hours)
   Or fill out the details below and we'll be in touch very soon:
SEND MESSAGE

USING FORMULAS IN MICROSOFT EXCEL

We can enhance your skills with courses for business at any of our twelve training centres UK wide, or we can come to your offices: if you have groups of three or more staff who need training, this is a very convenient, flexible and cost effective option. Moreover, most of our excel courses are 1 day, which keeps "out of office" periods for attendees to a minimum.

We have been delivering Microsoft Excel course all over the UK since 1995 and have continually developed our philosophy of high quality, flexible and results-driven provision of training for business to ensure constantly improving standards of quality.   So you can be confident that we have the expertise, and the experience, to give you a great return on your investment in Free Excel Video Tutorials From Activia Training.

Why not contact us today to see how we can help with providing your more software and IT productivity ?


Stay in touch

Stay In Touch!

Google+
LinkedIn
Twitter
FaceBook
YouTube

Contact Details

Activia Training

Locations Address: Head Office, Regus House,
268 Bath Road
Slough, Berkshire SL1 4DX

Phone Sales:           0333 6000 111

Service:       0333 6000 555

Accounts:   0333 6000 777



Back to top