![]() |
||||||||
| home > training > microsoft office > microsoft excel level 1 | ||||||||
|
||||||||
microsoft excel level 1 trainingUpon completion of our Microsoft Excel 2003 level 1 training you will be able to create spreadsheets for real-world applications such as budgeting, analysing sales, producing reports, creating charts and graphs, and managing lists. This course assumes no prior knowledge of Microsoft Excel. However, it would be beneficial to have a general understanding of personal computers and the Windows operating system as you will be required to start applications, work with and copy files, and locate file folders. The course duration is 1 day. |
||||||||
|
Spreadsheets How spreadsheets work Spreadsheets characteristics Spreadsheet functionality The appropriateness of spreadsheets Excel 2003 orientation Starting microsoft Excel 2003 The Excel 2003 screen Understanding the workbook Moving the cell pointer Moving about the workbook Using go to Menus and toolbars Using menus and toolbars Using context sensitive menus Exiting Excel A simple workbook Creating a new workbook Entering data in a workbook Saving a new workbook Opening a saved workbook Creating an input range Saving your work Essential formatting Column best fit Closing a workbook Selecting ranges Selecting contiguous ranges Selecting non-contiguous ranges Using special selection techniques Selecting larger ranges Range calculations Formulas Understanding formulas Formulas that add The sum function Formulas that subtract Formulas that multiply and divide Referential formulas What if formulas More complex formulas Formula error checking Common error messages |
Copying and filling Understanding copying in Excel Using fill for quick copying Copying from one cell to another Copying from one cell to multiple cells Copying from many cells to many cells Copying relative formulas Copying to a non-contiguous range Working with functions
Functions |
|||||||
| For further
information call us on +61 3 8611 9800 or
request information here. To request a booking on a course,
click here. | ||||||||
© 2006-2007 QEXIQ Enterprises Pty Ltd