Category: Software

Well finally we migrated to Outlook 2007 - very mickey mouse with all the colours and resembles being back at school using colour blocks.  The ribbons take up far too much room whereas it was more practical to have drop down menus and add other toolbars as and when required.  Why do all the backgrounds have to be so blue and highlighted?  It's blinding.

I requested the full Office 2007 suite be installed on my pc since I am progressing with certification in 2007.  Again too much space taken up with ribbons when I could use the extra space to view and work with documents on screen.

Whilst the functionality may have improved the colour schemes and layout leave a lot to be desired.  In my opinion less professional, less user friendly and more childlike.

Q. We have heard of Table of Contents and Table of Figures, but how do you create a Table of Tables?

A. Well it's simple.....for each table you want to include, follow these steps -

- Click in the table

- From the Insert menu select Reference>Caption (or Insert>Caption if applicable)

- Add a Caption but don't change the Label

- Next click where you want the Table of Tables to go

- From the Insert menu select Reference>Index and Tables (or Insert>Index and Tables if applicable)

- Select the Table of Figures tab

- The Caption Label should have Table selected, if it doesn't, select it

 

Remember, right-click the T of T and select Update Field to update it.

 

Category: Miscellaneous

Sign up here if you are fed up with spammers ruining this site...

Gee4

Category: Career

Two crucial questions you will be asked at an interview: How much did you earn in your last job? What level of salary are you looking for now? Getting this part of the interview right can add literally thousands to your next salary package - so you need to make sure you get it right!

"What did you earn in your last job?"

You have to be very careful when answering this question because once an interviewer knows your current salary they will try and fix your next remuneration package based on this figure. This may be satisfactory if you only wanted a modest rise in salary and your current salary is in line with their salary range, but, what if your current salary is substantially lower than the rate for the job, or if you want a substantial salary rise?

In these cases you would be best advised to say that you do not really want to prejudice yourself by being too high or too low. Ask if you can discuss this later after the responsibilities for the job have been discussed; you may also want to ask them what the range for the job is (if you do not already know). If the new job you are discussing is substantially different from your current job you might want to point this out. This is especially true if the new job carries far more responsibilities than your existing job.

If you feel that you must state your actual salary then add up all your benefits, including salary, bonuses, car allowance, pension, healthcare, etc. Giving just one figure will make your total remuneration package seem larger than just giving them your actual basic salary.

"What level of salary are you looking for now?"

Be very careful when you answer this question - you do not want to appear to be too greedy or just be seen as a money grabber. You need to make sure that you convey that you are looking for a new career opportunity and you should emphasise your potential with their organisation.

If you are applying for a specific vacancy you could ask them what the salary range is. Once they have answered you could say "I think my experience would place me at the top end of your range, don't you?" This one question could add thousands to your next salary - so don't be afraid to ask it. You should only ask this question if you feel confident that they would say, "Yes".  If they ask you this question fairly early on in the interview you could delay answering by saying "It is hard to discuss salary without first knowing a little bit more about the job and the responsibilities."

If this is a new position or there is no defined salary then the salary negotiation is wide open. It would probably be best if this was the initial meeting with the employer to say that you would need to see the full job description before you could answer this question. If there isn't a job description then you could offer to help write it - this would give you scope to find out more before you negotiate your salary.

Afterthoughts
You should approach the actual salary negotiation just as you would any other negotiation. Don't be shy about stating why you are worth X, when they think you are only worth Y. If you cannot get the initial basic salary you want you may be able to persuade them to increase your salary level after a period of time. You might be able to supplement your basic salary with extra benefits in kind or a good bonus payment if you perform satisfactorily.

Cell styles in a workbook - 4,000

Colours in a workbook - 56

Column width - 255 characters

Fields in a data form - 32

Linked sheets - limited by available memory

Named views in a workbook - limited by available memory

Open workbooks - limited by available memory

Page breaks - 1000 horizontal and vertical

Length of cell contents (text) - 32,767 characters. Only 1,024 display in a cell; all 32,767 display in the formula bar

Panes in a window - 4

Row height - 409 points

Sheets in a workbook - limited by available memory (default is 3 sheets)

Sort references - 3 in a single sort; unlimited when using sequential sorts

Undo levels - 16

Windows in a workbook - limited by system resources

Worksheet size - 65,536 rows by 256 columns

Zoom range - 10 percent to 400 percent

Want to save some typing when working on a Microsoft Excel spreadsheet? Microsoft Excel can automatically continue a series of numbers, number/text combinations, dates or time periods based on a pattern you establish. You can begin a sequence in one cell (such as "Monday") and use the auto-fill feature to continue the sequence in other cells (such as "Tuesday," "Wednesday," etc).

  • Enter data in a cell
  • Next, drag the bottom right corner...to automatically fill other cells with the rest of the sequence

By dragging the fill handle of a cell, you can continue the data series of a cell to other cells in the same row or column eg.  Mon, Tue, Wed or Day 1, Day 2, Day 3...and so on.

What is Bullying? Bullying is an exposure to long-term, repeated negative actions on the part of one or more persons and is often acombination of verbal and physical aggression.

 
Individuals accused of bullying or harassing behaviour are often surprised that their behaviour is interpreted in this way and may react defensively.
 
Bullying is an intentional act.
 
Bullying is a learned behaviour, not a character trait. Bullies can learn new ways to curb their aggression and handle conflicts.
 
Bullying is the imbalance of power between the parties involved.
 
Visible bullying traits: controlling, very ambitious, overly confident, strong-willed, judgmental, highly critical, vengeful.
 
Bullying requires only a couple of traits from the bully, but these traits are very specialised. A bully needs intention, as well as the ability to hold some kind of power.
 
Be mindful of bullies. One bullying trait might lead to others if you do not confront the problem.
 
Types of Bullying
·         Pair bullying takes place with two people
·         Direct bullying involves physical aggression such as shoving, poking, slapping, punching and kicking
·         Indirect bullying often takes the form of social isolation and intentional exclusion from activities - includes intimidation, dirty looks, starting rumours, falling out of friendship groups.
 
Dealing With Online Bullying
Having a chat and exchanging opinions in online discussions can be fun, and firm friendships between like-minded people are often forged.
 
Unfortunately there are some people out there who just aren't very nice. Learn to spot the tell-tale signs and find out the best way to deal with online pests.

Cyberbullies are pretty nasty characters who take it upon themselves to stop other people from having fun in message boards and chat rooms. They will single out a particular member of a community and do their best to intimidate them. It can be tricky to spot a cyberbully immediately, since they will often pose as a friend to begin with.

Trolls are a kind of cyberbully who lure unsuspecting victims into their trap by posting messages on controversial topics in an attempt to get people to respond negatively. They do this either to give the impression that their 'opinions' are reflected by other users, and sometimes they do it to drum up sympathy and get genuine users to come to their aid.

All posts made in the presence of a troll are likely to come back to haunt whoever makes them, since trolls have a habit of getting people to say things they later regret, and then quoting them in subsequent arguments.
 
Flaming is a word used to describe posting deliberately provocative messages that are intended to inflame people's anger and encourage them to argue with them and one another. A flamer's goal is to start a conflict between unsuspecting victims and then sit back and watch it escalate.
 
This kind of behaviour can be a particularly difficult and distressing nuisance to deal with, since the sole aim of a cyberbully is to cause misery in others. However, as in real life, these people feed on attention and, starved of this, will usually move on.

Q. Ever wondered how to recover deleted items in Outlook?

A.  Here's how...

1. From within Outlook, go to Deleted Items Folder
2. From the Tools menu click Recover Deleted Items
3. Select the item or folder you want to retrieve from the list
4. Click Recover Selected Items

Selected items should appear in your Deleted Items Folder.

NB. Some items or folders may not be recoverable because of the length of time that deleted items are stored on the server, which is set by your IT Administrator.

Q. Ever wondered how to extend the viewable free/busy section?

A. The default for viewing the free/busy section of the Outlook Calendar is set for two months by Microsoft (current month plus one month). To make the free/busy section viewable to include a longer period -

·         Log into Outlook (you can be on the email inbox to make this change)
·         Click Tools and Options
·         Click Calendar Options
·         Click Free/Busy Options, and make your change (12 months is advised)

NB: This assists greatly when checking availability for meetings, but can only be changed using the computer that the owner of the calendar uses.  If you work for a team, send them the steps above so they can change this on their own computers.

Q.  Ever wondered how to print sections of a document or a range of pages within a section?

A. Here's how...

Print Sections
s3,s5
This prints Section 3 and 5.


Print a Range of Pages Within a Section
p5s3
This prints Page 5 of Section 3.
 

Print a Range of Pages across Sections
p2s2-p3s5
This prints Page 2 of Section 2 to Page 3 of Section 5.

 Q.  Ever wondered how to change the background of a slide without altering the Master?

  • From Slide Sorter View, click the slide you want to change
  • On the Format menu click Background
  • Tick the checkbox 'omit graphics from master'
  • Click Apply
  • Changes will not affect other slides or the master unless you click Apply to All

 This is widely used when illustrating information from either another presentation or organisation.

Q.  Ever wondered how to view a selection of dates at the same time?

  • From Calendar view, select Work Week
  • In the top right corner you will see the current month
  • Click on that month or scroll left/right to choose another month
  • While holding the Ctrl key, click the dates you wish to view (these may or may not change colour depending on which version of Outlook you are using)
  • The Work Week will then display the dates you selected to view

Q.  Ever wondered how to enter numerical data, that starts with zero, in to an Excel spreadsheet?

A. In Excel, cells take on the format 1, 2 etc instead of 001 or 002.  To change this, or similar, use the following steps -

  • Click on the cell or cells
  • Right click and choose Format Cells
  • In the Category tab click Custom
  • Click in the 'Type' box, delete what is there and enter 000 (or as many zeros, as you want depending on how many digits are in your data)

Q. Ever wondered why distribution lists are not sorted in alphabetical order according to surname?

A. Enter surname first so entries are listed A-Z.....eg. Bloggs, Joe

For existing distribution lists, just open and edit each entry.