Microsoft Office Excel Level 3 ~ QEXEQ ~


home > training > microsoft office > microsoft excel level 3

	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 3 training Upon completion of our Microsoft Excel 2003 level 3 course you will have extended your knowledge and skills in the more advanced areas of Excel such as goal seeking, linking, macros, web publishing and PivotTables. Completion of Microsoft Excel level 2 or equivalent experience. The course duration is 2 days.
		Nesting functions Scoping a formula Developing a nested function Creating a nested function Editing a formula with nested functions Copying a formula with nested functions Concatenation Advanced filters Advanced filter concepts Using an advanced filter Extracting records with advanced filter Using formulas in criteria Using database functions Validations Validation techniques Data validation by number range Testing data validation Input messages Creating error alerts Creating drop-down lists Using formulas as validation criteria Creating custom validation criteria Number formats with built-in logic Conditional formatting Copying data validation settings Goal seeking Goal seek components Using goal seek Data tables Using a simple what-if model Creating a one-variable table Using one-variable data tables Creating a two-variable data table Scenarios Creating a default scenario Creating scenarios Using names in scenarios Displaying scenarios Creating a scenario summary report Merging scenarios Pivot tables PivotTable theory Creating a simple PivotTable Adding row fields to a PivotTable Using the page field in a PivotTable Filtering row and column values Formatting a PivotTable Counting with PivotTables PivotTable summary and display options Show data as percentages in PivotTables Calculated fields in PivotTables Calculated items in PivotTables Creating a PivotChart Modifying a PivotChart via the PivotTable	Linking workbooks Linking data in excel Linking within a workbook Linking between workbooks Updating links between workbooks Consolidation Consolidating data with identical layouts Consolidating data with different layouts Consolidating data using a PivotTable Consolidation quick reference Excel on the web Previewing workbooks as web pages Publishing a static worksheet Adding to an existing web page Publishing an interactive web page Summarising data Creating subtotals Using a subtotalled worksheet Creating nested subtotals Copying subtotals Using subtotals with autofilter Installing the conditional sum wizard Using the conditional sum wizard Creating relative names for subtotals Using relative names for subtotals Macro virus control Opening workbooks with macros Setting macro security levels Trusting publishers Creating a digital signature Removing a trusted publisher Recorded macros Setting macro security levels Recording a simple macro Running a recorded macro Relative cell references Running a macro with relative references Viewing a macro module Modifying a recorded macro Recorder workshop Preparing data for an application Recording a summation macro Recording consolidations Recording divisional macros Testing macros Creating objects to run macros Assigning a macro to an object 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 3 training