Create a watermark in Excel
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....
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"
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.
Your personal finances
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:
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...
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...
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....
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.
Cross-references in MS Word
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.
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 !!
Excel tips and tricks
Hands up all those who don't like tips and tricks !!
Hmmmm...I don't see any !
Here are 20 of the best....,
Navigate the blog easily with the Category menu below
Choose a Category