Intuition Computer Training courses

...this hands-on course has been specially designed to look at the further potential of powerpoint and enhance the skill of experienced powerpoint 2003 users...

...installing the analysis toolpak using functions from the analysis toolpak...

...complex tasks using macros summarise data using pivot tables analyse and extrapolate data using scenarios and solver create complex formulae using combinations...

...of functions like vlookup and match use array formulae to speed up spreadsheet development topic hyperlinks -save as html, make data interactive...

...data using scenarios and solver. create complex formulae using combinations of functions like vlookup and match. use array formulae to speed up spreadsheet development...

...multiple conditions, nested functions data analysis -working with arrays, data tables, goal seek, scenario manager, goto special, custom views...

...trace formulas, comments worksheet management -column widths, insert/delete rows/columns, insert delete move worksheets, name worksheets data validation...

...user what to do next or what data should be used create forms to simplify a procedure like data entry transfer the data from a macro/routine to a spreadsheet...

...complex tasks using macros summarise data using pivot tables analyse and extrapolate data using scenarios and solver create complex formulae using combinations...

...copy to other worksheets, copy to other workbooks, link sheets/ workbooks sorting lists charts -chart types, modify elements, add labels titles...

...create formulae with excel functions, including conditional and nested functions. produce a variety of reports and models including what if analysis and pivot tables...

...undo/redo, move/copy cells file management -save, open, close workbooks formula construction -mathematical operators, order of calculation, autocalculate...

...create a shared workbook, view changes, manage conflicts, view change history workbook templates -custom template, worksheet protection, new default templates...

...navigation tools, help data entry -data types, autocorrect, autocomplete, pick from list, autofill, custom lists, find & replace, import text...

...automation -macros, record, run, relative & absolute macros, customise toolbars...

...This five-day, instructor-led course provides students with the knowledge and skills that are needed to update and support a reliable, secure infrastructure...

...monitor and tune exchange 2000 performance. backup exchange 2000 data and restore exchange 2000 after a disaster. microsoft certified professional exams...

...course description this course provides students with the technical skills required to program a database solution by using microsoft sql server...

...publish and maintain printers and shared folders. delegate administrative control of an organizational unit. install and configure the domain name system (dns)...

...this course participants are expected to be confident powerpoint 2003 users and be familiar with the topics covered in the powerpoint 2003 foundation course...