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           
Close
eBook Download

If you would like to receive our FREE eBook, please enter your email address below and click Send eBook.



Send eBook


Video Tutorials - Excel Formulas Resources
Video Tutorials - Excel Formulas Resources

Video Tutorials - Excel Formulas - Resources

Content produced for your benefit: use, modify and share as you wish

On occasion, data may need to be formatted as a percentage and there are a few rules to consider with this.

When entering figures such as 50 or 75 then clicking the Percent symbol on the Home tab will add the percentage sign but it will also multiply your data by 100. When using this...
When using Excel we can use names to define a cell or range of cells, we explain this in full detail on our Excel Intermediate course, however there is a shortcut when using names that lets you identify and use a list of current names available to paste into your spread...
On occasion data may need to be formatted as a percentage and there are a few rules to consider with this.

When entering figures such as 50 or 75 then clicking the Percent symbol on the Home tab will add the percentage sign but it will also multiply your data by 100. When using this ...
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 values together.

Initially, people can get confused with the difference between SUM and COUN...
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 the calculation steps involved, creating these in Excel can sometimes be tricky. Wouldn't...
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 nothing to do with money. So what's the reason for that?

The short answer for this is that Excel is using the dollar signs...
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 user-friendly ways of displaying and calculating figures. When importing information from other programs o...
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.

Using Upper and Lower Case

UPPER and LOWER convert any text to the corresponding case. PR...
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 you search for it using the Insert Function dialog box. In fact, even when you are typing i...
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 using formulas.

There is a fundamental difference between mark-up vs profit, and figur...
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.

The Most Common Causes

One very common reason when totals are not adding up can be fo...
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.

So Excel supports a 1900 date system. When you type a date into Excel, even though you see the f...
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 our video to find out What is a Circular Reference Warning in Microsoft Excel?

What Is a Cir...

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

Nationwide coverage
Click to view all locations


Back to top
HOME
Resources
    Resources
    Expert Insights
About Us
    Useful Information
    CPD Accredited Training
    ILM Accredited Courses
    Special Offers
    Training Vouchers
    Career Opportunities
    SUBSCRIBE To Our Newsletter
Free Tools
    Personal Development Tests
    Speedy Quote
    Bespoke Course Creator
    Test Your Skills
    Free Online Revision
    Activia Training Scholarships
    NEW: Activia GateWay
Courses
Locations
Contact Us
    Callback Request
    More Information
    Feedback
    Schedule your own class
    Free eDirectory
Assertiveness
Time Management
Communication Skills
Likeability
Prices for Online Courses
Online Training FAQ
TRY BEFORE YOU BUY
VIDEO: How to Use It
Assertiveness
Time Management
Communication Skills
Building Relationships
Free Microsoft Office Course
Microsoft Access
Microsoft Excel
Microsoft Outlook
Microsoft Powerpoint
Microsoft Project
Microsoft Word
Microsoft Access
Microsoft Excel
Microsoft Office (incl. 365)
Microsoft Outlook
Microsoft Powerpoint
Microsoft Project
Microsoft Publisher
Microsoft Visio
Microsoft Word
Crystal Reports
Management Skills
Performance Management
Supervision & Teams
HR and Coaching
Accounts and Finance
Project Management Essentials
PRINCE2® Project Management
HR and Recruitment
Training & Coaching
Sales
Presentation Skills
Sales Management
Negotiation Skills
Business Writing Skills
Minute Taking Made Easy
Professional Telephone Skills
Touch Typing
Customer Service
Receptionist Skills
Assertiveness
Time Management
Communication Skills
Building Relationships
London Victoria (SW1)
Tower Bridge (E1)
Bristol (BS1)
Milton Keynes (MK9) NEW
Reading (RG1)
Slough (SL1)
Birmingham (B4)
Nottingham (NG1)
Manchester (M1)
Leeds (LS1)
Site Cookies
We have placed cookies on your device to help make this website better.

You can change your cookie settings in your browser. Otherwise, we’ll assume you’re OK to continue.

I'm fine with this