the magazine that fast-forwards your career.
Here's how to read the magazine:
by clicking the arrows at the side of the page, or by using the toolbar.
by clicking anywhere on the page.
by dragging the page around when zoomed in.
by clicking anywhere on the page when zoomed in.
websites or send emails by clicking on hyperlinks.
Email this page to a friend
Search this issue
Index - jump to page or section
Archive - view past issues
Real Business : Issue 1 2010
Real Business ISSUE 1, 2010 10 INFRONT FROM SMALL THINGS HOW TO... TWO MINDS WHAT I'M WORKING ON DASHBOARD EXCEL AT WORK If you have a list of values in a column and you need to transfer it to a row of the same values in the same order, you can use the Transpose option in Paste Special. CONVERTING ROWS TO COLUMNS Neale Blackwood offers advice on how to use Microsoft Excel s Transpose tool. Neale Blackwood is a senior business analyst with Access Analytic Solutions, which provides financial modelling, management reporting services as well as advanced Excel training. You can email Neale at email@example.com You can also right click a cell to select Paste Special in both versions. Note: this technique will not paste formulas, if there are formulas in the copied range only the values will be pasted. STEP 3 In Excel 2003, click the Edit menu and then click Paste Special. In Excel 2007, click the Paste button drop down on Home Ribbon and select Paste Special. STEP 4 Tick the Transpose checkbox at the bottom of the dialog box. STEP 5 Click OK STEP 2 Select a cell that isn't in the copied range. STEP 1 Copy the list. MAKING THE MOST OF A CAREER DAY Career days, or career fairs, are an incredible opportunity for all students and graduates to learn more about workplaces and roles you are qualified for. ey are an exciting resource that, when used well, can open doors and give you a chance to meet your potential employer there and then. ON THE DAY: Presentation is the key to a good first impression so make sure you re well groomed and dressed in smart casual attire. Remember, you could be meeting your future employer. Get to career day early so you can make the most of the opportunity and have enough time to talk to everyone there. Be ready to wait to speak to some employers; if you rush them or force them to talk to you, you may give the wrong impression. When you do get a chance to speak with an employer, always speak in a professional tone with a professional manner. Have a list of questions ready before you speak with the employers and don t be scared to add some in that you think of while you are talking with them. An aware, pro-active person is what they are looking for. Carry a pen and paper with you so you can take notes. Questions you might want to ask include: 1 What are you looking for in a graduate? 2 What qualifications do I need? 3 When does your graduate program open? 4 What is your hiring process? 5 What is it like working for the company? 6 What can I expect to be doing in the first year? 7 ese are the areas I am interested in, what types of positions are available? Ask each person you speak to if you can have their contact details -- a business card would be ideal -- so you can contact them for future roles. AFTER THE CAREER DAY: Email or telephone the representative you met within a few days thanking them for their time and advice. Be sure to stay in touch but not to the point you may annoy them or overdo it. BEFORE THE CAREER DAY: Research, research, research. You should have an idea before the day who is coming and the companies you are interested in. Make a list of the companies you want to speak to and research them through their website, any contacts you have or other public information like their annual report. Make sure your resume is up-to-date with all your qualifications and work experience listed. ings like internships and any voluntary work you have done can also be included. You will need an updated resume to hand to potential employees on the day.
Issue 2 2009
Issue 1 2012