UNITED COMPUTER CONSULTANTS
  • Home
  • Downloads
    • Excel
    • Word
    • PowerPoint
  • Blog
  • Contact Us

Create a watermark in Excel

5/7/2019

0 Comments

 
Unlike Word, Excel does not have an inbuilt command to place a watermark on a worksheet.
The problem can be easily overcome by inserting a text graphic such as WordArt, and then tweaking the transparency.
Visit the following YouTube video on our channel to see how....

https://www.youtube.com/watch?v=WokwwinvYW8
0 Comments

How long to mow the training track....

1/8/2018

1 Comment

 
The key is to find the area of the training track.
This can be done by deducting the area of the green circle from the area of the outer circle.
The areas are found by using "pi r squared" where r is the radius.
Therefore if the diameter is 250 meters then the radius is 125 meters.
The outer circle is 2.5 meters wider i.e. 127.5 meters
Thus the formula is  =pi()127.5^2 - pi()125^2 (the ^ raises the power of a number)
Now we know the area, we simply divide by 4 to find the number of 4 square meters. This gives the number of seconds.
Then divide that answer by 60 to give the minutes

The formula can be seen in the downloaded file at cell A36

If you haven't already downloaded the file to work on it, go to Downloads>Excel in the menu above and look for the file "mowing problem"
1 Comment

Create your CV/Resume if this is your first job

22/12/2017

2 Comments

 
You see a job advertised, and your prospective employer is asking for you resume.
This would normally include details about yourself, your aims and ambitions, etc. and of course your past work experience.
So how can you resolve the problem if this is your first job, and you have no previous experience.
Well, help is at hand.....
The following YouTube video will greatly assist...click on it to play.


2 Comments

Your personal finances

21/10/2017

0 Comments

 
At some stage in our lives, as we move on with engagement, marriage, or maybe just burning ambition, we will consider borrowing money.

Maybe you want to buy property for your future or invest in stocks... Well, you need to ensure that your loan repayments fall within your ability to pay.

This is dictated by two things in the main:
  1. Your income
  2. The terms under which you borrow (interest rate and the term of the loan
Always remember....there are few things in our lives which are more important than a good credit rating. This can ONLY be achieved by the careful management of borrowed money.

To help in this regard, we have uploaded a YouTube video which explains how you can sensibly borrow on a loan which fits WITHIN your budget.

Click the link below to watch...

https://youtu.be/4P2GK8jiZCI
0 Comments

Something for advanced Excel users...Predicting future values

8/4/2017

1 Comment

 
Picture
Most companies, large and small, will need to project out for on-coming weeks months or years so they can prepare for budgeting and other purposes. Another example would be to be aware of staff requirements for projects etc.
This can be achieved by using a combination of two functions...SLOPE and INTERCEPT.
An easy-to-follow video is now available on our Youtube channel to learn how to use this important procedure.
This link will take you there...

https://youtu.be/lgEu0xkWHoc

1 Comment

Get the job with this basic Excel test

31/3/2017

1 Comment

 
Many employment agencies and employers now require a general and basic understanding of Microsoft Excel.
We have now had over 2 million visits to the video on our Youtube channel and assisted many thousands of visitors to prepare for their interview.
You can also download the actual file exercises that are used in the video so you can repeat the exercises as often as you wish.....and its all FREE.
Simply click on the graphic below to be taken to the video....
Picture
1 Comment

Vale Internet Explorer 7, 8, 9 and 10

15/1/2016

1 Comment

 
Beginning January 12, 2016, only the most current version of Internet Explorer available for a supported operating system will receive technical supports and security updates,' Microsoft said.'Internet Explorer 11 is the last version of Internet Explorer, and will continue to receive security updates, compatibility fixes, and technical support on Windows 7, Windows 8.1, and Windows 10.
The software has experienced many problems over the years, with poor security necessitating regular fixes and downloaded updates.
Of interest is that Windows 8 will no longer be supported. This particular operating system proved unwieldy, unpopular, and could hardly match its predecessor, Windows 7. In fact it was not long after its release that Windows 8.1 upgrade took place.
A new browser known as "Edge" is now available with a number of new features which users should find handy. This however is only available for Windows 10, Microsoft's latest Windows operating system.

1 Comment

Cross-references in MS Word

22/8/2015

1 Comment

 
Longer documents can easily be made more user-friendly by the use of "cross references"
For example, you may have information on a page deeper into the document which you would like the reader to be able to skip to at the click of a mouse.
The following link will take you to the YouTube training video which will show you the steps required to insert this cross-referencing. Remember that subscribers to the channel can leave comments, likes and questions if they wish.
1 Comment

Have you ever sent a Gmail message and immediately realized you shouldn't have?

5/8/2015

0 Comments

 
As you know, Gmail has millions of users. Maybe you are one !
At some stage , we all send an email message which we suddenly think "Gosh, I shouldn't have sent that" !!
It might be a missing attachment, a message which needs more data...there are many reasons why we should not have clicked the Send button !!
Well, help is at hand. There is an option available in Gmail that allows us to "recall" a sent message. All we need to do is to set an option to "Unsend"
Here is the video to show you how.....problem solved !!
0 Comments

Excel tips and tricks

26/7/2015

1 Comment

 
Hands up all those who don't like tips and tricks !!

Hmmmm...I don't see any !

Here are 20 of the best....,
1 Comment
<<Previous

    Navigate the blog easily with the Category menu below


    Picture

    Choose a Category

    All
    Browsers
    Excel
    Nouns And Adjectives
    Tenses
    Verbs
    Welcome
    Word


    Archives

    July 2019
    August 2018
    December 2017
    October 2017
    April 2017
    March 2017
    January 2016
    August 2015
    July 2015
    June 2015
    May 2015
    April 2015
    March 2015



Note that ads may appear on various pages, which may generate income for United Computer Consultants.
Visitors to this site are free to use the ads at their discretion but in no way does United Computer Consultants request such usage.
Without exception, we abide by the rules governing the display of advertising on the site.


© United Computer Consultants 2022. All rights reserved
  • Home
  • Downloads
    • Excel
    • Word
    • PowerPoint
  • Blog
  • Contact Us