Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

excel+courses - mircosoft excel

Forum home » Delegate support and help forum » Microsoft Excel Training and help » excel+courses - Mircosoft Excel

excel+courses - Mircosoft Excel

ResolvedVersion Standard

Angie has attended:
No courses

Mircosoft Excel

can I be trained online?

RE: Mircosoft Excel

Angie,

We are looking to launch our own e-learning later in the year, however if you would prefer you can contact our enquiries team and they will be able to pass your details onto one of our partners who currently provide e-learning.

Hope this helps
David

 

Training courses

Training information:

See also:

Welcome. Please choose your application (eg. Excel) and then post your question.

Our Microsoft Qualified trainers will then respond within 24 hours (working days).

Frequently Asked Questions
What does 'Resolved' mean?

Any suggestions, questions or comments? Please post in the Improve the forum thread.

Excel tip:

Use RANDBETWEEN to generate random numbers

There may be occassions where you need to generate random numbers in your spreadsheet. Use the RANDBETWEEN function to generate random numbers between two values that you specify.

The function looks like this:

=randbetween(LOW,HIGH)

where LOW is the lowest number you want generated; and HIGH is the highest number you want generated.

This formula will work with both positive and negative LOWs and HIGHs. Also it will only generate integer numbers unless forced to do otherwise by the following:

=randbetween(LOW*10^PRECISION,
HIGH*10^PRECISION)/(10^PRECISION).

where PRECISION represents the levels of decimal precision needed (i.e. if you need numbers with one decimal place, PRECISION would be 1; 2 for two decimal places and so on).

One final note, if the RANDBETWEEN formula does not work in your spreadsheet or returns a "#NAME" error, you need to install the Analysis Toolpak Add-In. You will need to press F2 then Enter following the installation.

View all Excel hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.1 secs.