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....
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....
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....,
Dashboards in Excel
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:
Navigate the blog easily with the Category menu below
Choose a Category