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

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

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

Dashboards in Excel

26/7/2015

0 Comments

 
One of the most useful features in Excel is a "dashboard"
By changing data in a file, you can have many elements such as charts updated at the one time.
This is particularly handy for analysis, trends etc. and with the use of "slicers", it is a simple matter to filter information so you can see just what you need to see.

The dashboard would normally be the first sheet in the Excel file.
A full explanation and demonstration can be found on our YouTube channel. Click the graphic below to be taken to the lesson:

0 Comments

    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