Microsoft Excel is a widely used computer application that allows you to create and edit spreadsheets. The spreadsheets are used to store information in rows and columns that can be organised or processed. Spreadsheets are designed to work well with numbers but can also include text, graphcis and charts.
Excel Training London is an excellent way to improve your IT skills. We provide a range of MS Excel training courses (different levels, usually one level per day). Training can be held in one of our London training venues or you can be trained at your premises across the UK through an on-site event. Perhaps you have a group of people requiring training, but don't have the facilities to host a training event: simply arrange some Closed Company training at one of our venues.
By gaining
Microsoft Excel skills, you can drastically reduce time spent doing complex
calculations. It's easy to use Excel functions once you've
learnt the basics.
Charts: Select the data and press the function key F11 and the chart will be created on a separate worksheet.
Outlining - ungrouping rows or columns: Highlight want you want to ungroup and press ALT + SHIFT + right cursor arrow
DATEDIF function: The DATEDIF function is a worksheet function that computes the difference between two dates. This function is documented only in the help files for Excel 2000. It isn't documented in Excel 2002. the formula function is: =DATEDIF(Your age,Today(),"Y") where Y stands for year.
Quickly Adding New Worksheets: Want to place a new Excel worksheet before current worksheet. Use keystroke SHIFT+F11
No Zeros: Want all the zeros in your worksheet to appear blank? Choose Tools/Options, Click on the View Tab, Deselect the Zero Values Option, Click OK. Easy wasn't it? But be aware that these cells are not actually blank, they still contain the value zero. This is important because certain functions (ie AVERAGE) make a distinction between blank cells and those with a zero value.
Deleting cells, Rows & columns: place your cursor on a cell, row number or column letter and use CTRL + -
Reset Excel toolbars to default settings: If you find any of your toolbars in Excel have changed (i.e. they are missing or have extra buttons) then you can reset them to their defaults. Go to Tools -> Customise. Select the Toolbars tab. Highlight the name of the toolbar you wish to reset, then click the Reset button on the right. Close the dialogue box.
Create and delete borders: To put a border around the outside of a selected range, press Ctrl+Shift+&. Use Ctrl+Shift+_ (underscore) to remove any borders from a range.
Removing border lines on the keyboard: Highlight your cell(s) that have boreders on them and press CTRL + SHIFT + _, this will then remove the border lines.
How do I create a workbook?
Whenever you open Excel from the start menu or a shortcut on your desktop you will be taken into a new workbook but this will be unsaved you can then do this by going to the file menu and choosing save.
Now if you need to create a new workbook from within excel what you will need to do is as follows, go to the file menu and then click on new, you will then see a window with options of new thing to create you need to click new workbook then click OK
Can I draw on an existing graph?
You can draw any graphics on you graph just draw them over your chart or move them into position.
How do I make a macro non-workbook specific, so that it works in any Excel file?
When you are creating your macro, in the first dialog box after choosing menu command Tools>Macro>Record New Macro, in the Store macro in text box, use the drop down arrow choices and select Personal Macro Workbook. Record your macro in the normal way. Your macro will now be available to you whenever you open that PC's version of Excel.
To delete this macro you cannot use the normal method of deleting it from the Macro dialog box; The macro has been saved in a special hidden workbook, so you must first Hide the current workbook, Window>Hide, then immediatly go to Window>Unhide, you will see the Personal Macro Workbook displayed in the choices, open it and delete the Macro/s as per normal, Save the Personal Macro Workbook, and then Hide it as above, then Unhide your original Workbook, the macro will not be shown or operate.
If I set up two cells with dd/mm/yyyy:hh/mm and subtract one from another, how can I get the answer to display in the same format or number of days:hours:minutes and not just as xx.xx days?
This is a formatting problem, you must change the answer cell format to that which you require ie dd/mm/yyyy hh:mm. Right click on the cell, choose Format and Choose the Number tab, Select Date and make your choice from the options available, or go to Custom and type your required custom format.
A quick fix would also be to click on one of your previously set up cells, then to click the Format Painter button (little yellow paintbrush) on the Standard toolbar and then click on the cell with the number in it, thereby changing its cell format.
When would you use VLookup?
The VLOOKUP function is used to extract information from data that is stored in a series of columns (a list).
Excel uses a lookup value which you type into a cell in the spreadsheet - it will look for the value you type in, in the leftmost column of the lookup area you select (called the 'table array' in Excel speak). It will then extract and display the information related to the lookup value you have entered, from the column in the table array you specify.
An example of when this might be used is if you have information about invoices stored in columns (invoice number, date, company the invoice was issued to, their purchase order number); and you want to be able to type in the invoice number (your lookup value) and get Excel to display the information related to this invoice number (date etc) for you. This saves you having to hunt through the list yourself to find the particular invoice details.