Microsoft Office Excel Level 2 ~ QEXEQ ~


home > training > microsoft office > microsoft excel level 2

	training	consulting	facilities
	microsoft office access level 1 access level 2 excel level 1 excel level 2 excel level 3 front page level 1 powerpoint level 1 powerpoint level 2 project level 1 project level 2 outlook level 1 word level 1 word level 2 word level 3 visio level 1 access 2007 level 1 access 2007 level 2 excel 2007 level 1 excel 2007 level 2 excel 2007 level 3 powerpoint 2007 level 1 outlook 2007 level 1 word 2007 level 1 word 2007 level 2 word 2007 level 3 upgrading to word and excel 2007 upgrading to word 2007 upgrading to excel 2007 upgrading to powerpoint 2007 upgrading to outlook 2007 schedule Telstra convergence and telecommunications CIW courseware development contract trainers
		microsoft excel level 2 training Upon completion of our Microsoft Excel 2003 level 2 training you will be able to work more efficiently with workbooks and worksheets, enhance the appearance, perform analysis, and use the sorting and filtering features to manage and analyse data. Completion of Microsoft Excel level 1 or equivalent experience. The course duration is 1 day.
		Working with workbooks The open dialog box Opening a workbook Closing a workbook Opening multiple workbooks Working with multiple workbooks Opening recently used workbooks Compare workbooks side by side Working with worksheets Copying a worksheet Renaming worksheets Moving worksheets Inserting and deleting worksheets Grouping worksheets Colour coded worksheet tabs Adjusting a worksheet Inserting cells Deleting cells Inserting columns Inserting rows Deleting rows and columns Resizing columns Resizing rows Hiding grid lines Viewing worksheets Freezing columns and rows Splitting windows Using zoom Hiding rows and columns Formatting cells Using the font tools Using the alignment tools Using the number tools The format cells dialog box Formatting fonts using the menu Superscript, subscript and strikethrough Changing horizontal alignment Centering across a selection Wrapping text Changing text orientation Changing vertical alignment Formatting dates Formatting numbers Formatting currency Creating custom formats Borders and shading Clearing cell formats Absolute referencing Absolute and relative referencing Problems with relative formulas Tracing precedents Creating absolute references Creating mixed references Circular references	Filling series Filling a series Filling a growth series Filling a series backwards Filling using options Creating a custom series Modifying and deleting custom series Labels and names Labels and names explained Accepting labels in formulas Using text labels Creating labels Creating names using the name box Using names to select cells Using names in formulas Creating names between workbooks Creating names for constants Creating a list of names Changing the range for names Deleting names Logical functions Logical function concepts Displaying information using if Displaying values using if Nesting an if function Using the and function Using the or function Using the not function Lookup functions Requirements of lookup functions The CHOOSE function The ISERROR function The VLOOKUP function Testing lookup functions Using VLOOKUP for exact matches The index function Sorting Performing a simple sort Sorting on more than one column Sorting numbers Sorting by rows Autofilter Applying & using autofilter Creating compound filters Creating custom filters Multiple value criteria Using wildcards in custom criteria pdf version
		For further information call us on +61 3 8611 9800 or request information here. To request a booking on a course, click here.
	privacy \| webmaster \| about us \| partners \| exam centre \| contact us \| sitemap

microsoft excel level 2 training