Intuition Computer Training courses

...2003 users and be familiar with the topics covered in the powerpoint 2003 foundation course. topics: brief revision: text, charts, tables, organisation...

...tab in tool options using information functions to evaluate the contents of cells including error values using date functions to display date/time information...

...course description after completing this course, participants will be able to: create custom templates to be more productive automate repetitive and/or...

...new default templates get external data array formulas data analysis -pivot tables, data tables, solver advanced functions -statistical, dates...

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

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

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

...that is not possible in standard excel e.g. new calculating functions for commissions or discounts, importing or exporting data at the click of a button...

...text, financial, lookup, counta, edate, upper, pmt, match, countblank, eomonth, lower, fv, index, countif, proper, lookup, sum using names, vlookup & match...

...input messages, data restrictions, drop-down list boxes functions -statistical;, date and time, logical group and outline -automatic, manual...

...manipulate and analyse data using list management techniques. create and manage shared workbooks. create and use custom templates. prevent unauthorised changes to spreadsheets...

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

...pivot tables manipulate and analyse data using list management techniques create and manage shared workbooks create and use custom templates prevent unauthorised...

...course description after completing this course, participants will be able to: plan and create worksheets incorporating different data types construct...

...pivot tables manipulate and analyse data using list management techniques create and manage shared workbooks create and use custom templates prevent unauthorised...

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

...and internet messaging connectivity. course description the goal of this course is to teach students the knowledge and skills necessary to install...

...for students who do not meet this prerequisite, the following course provides students with the necessary knowledge and skills: course...

...for microsoft certified professional exam 70-218: managing a microsoft windows 2000 network environment. audience this course is intended for system administrators...

...course description 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...