Krystyna has been an IT Trainer for over 22 years; she has trained Microsoft products since their 1st release, as well as other packages from other companies such as Oracle, Adobe, Lotus and Corel. She has trained a varied audience from University students to Managing Directors, in one to ones, small groups to over 50 in a lecture environment. Her experience of industries covers a wide spectrum from Utilities, MOD, Advertising, Medical, Police, Cosmetics, IT and Financial.
It is quite strange that when I ask my students at the beginning of a training course what they believe formatting is, I usually get a silent long pause. If you go to the Oxford English Dictionary online you will see this entry. Simply put:- formatting is the way the words or values appear.…
Some of you may still remember the time, when we used computers, we had to do everything with just the keyboard. Yes, there were no pretty icons to select to do something for us. Or just click on something in a complex dialog box with a multitude of selections. We had to know special key…
I see loads of adverts for all sorts of loans that look so inviting. But wouldn’t you like to see what will be the amount you have to pay back if the rate of interest changes. One such way is to create a Data table in Excel. Using the PMT function to do the calculations.…
This may sound like a very easy subject for most but I do find that a lot of people still don’t know how easy it can be to create a chart in Excel. My first question to all of you is “Why do you want a chart?” the answer is simple “to make the multitude…
When I do a walk about day on clients sites, I come across many people who work with enormous spreadsheets. They have columns of formulas referring to several columns of data then another column of formulas referring to the next block of data and so on. I watch them laboriously hide columns they don’t want…
You won’t believe it but yes I have seen many people actually use a highlighter pen to write diagonally across a document that it is a draft or a copy rather than trying to create a watermark which looks far more professional. A watermark can be used for a number of things. Your logo for…
Tables in word are quite diverse. You have now read (I hope) my other three tips on tables. Create a simple table, draw a table, insert an Excel spreadsheet and now Insert a Quick table. What is a Quick Table Microsoft have created four sets of ready to use tables for your convenience. They are…
This tip is the third in a series of four tips about different ways of creating a table in Word. I have already shown you how to insert a simple table from the Insert tab, draw a table and now I’m going to explore the excel table. Or rather how to insert an Excel…
I often see people struggling with tables in Word. They create a table by inserting it. There is nothing wrong with that. But what they then need is different sized cells or columns down the table and they spend a long time merging cells and highlighting and dragging boundaries. Nothing wrong with that at…
Going through my many Excel Functions that I use I remembered one that I think you’ll like. It helps to find data that you need to work on and highlights it in a different way to using Conditional Formatting which I showed you some time ago. The function in question is called ISNA. It can be…