|
|
||||||
 |
ms
excel
This course is intended for users who require an excellent working knowledge of a spreadsheet. |
 |
| Introduction problem solved by a spreadsheet model start excel ms excel window layout move through a worksheet enter data select cells using autofill the help menu option saving a workbook close the workbook open a workbook locate a folder basic view setting options exit excel edit the worksheet, clear data, undo changes insert and delete cells cut,copy and paste data check spelling calculating with excel: introduction to formulas and functions enter a formula or a function enter a function with the function wizard autosum errors in formulas or functions if function what if exercise create an absolute reference copy formulas pivot table date and time function Manipulating columns and rows insert and delete a row or column format the worksheet: change appearance of numbers data alignment bold, italic, underline change fonts change data orientation add border and colour copy formats conditional formatting format a worksheet automatically formatting and customising date and time sorting data numerically and alphabetically preview a worksheet change margins center data on a page print a worksheet insert page break change paper orientation change scaling change print options: showing gridlines print titles add headers and footers |
change the screen display
zoom in or out display or hide toolbars freeze rows and columns split t the screen using multiple worksheets switch between worksheets name a worksheet select all worksheets select multiple worksheets copy or move data between worksheets copy or move a worksheet to another worksheet link data across worksheets enter a formula across worksheet enter a function across worksheet delete a worksheet insert a worksheet move a worksheet using multiple workbooks create a new workbook arrange open workbooks copy or move data between workbooks copy or move a worksheet to another workbook maximise a workbook switch between workbooks close a workbook creating a chart- introduction chart layout create a chart chart areas move and size a chart add a data series to a chart change chart options: add titles format text in a chart change chart type format a 3-d chart format data labels format data series options add colour to a chart add a text box draw shapes and lines size and move an object import a spreadsheet in word create a macro protect and unprotect a worksheet set-up a password to your workbook using and creating templates excel data base basics create and find data in a list filter a list sorting data numerically and alphabetically add subtotals to a list hide or display subtotalled data turn off subtotals mail merge function with excel data source |