Intuition Computer Training courses

...charts design custom templates apply advanced slide show effects customise toolbar buttons and menus create and edit hyperlinks convert presentations...

...functions category to perform a range of tasks linked to loans, payments and interest rates an introduction to the statistical functions available in excel...

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

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

...pivots, formulas automation -macros, record, run, relative & absolute, assign to buttons, customise toolbars, edit vba code workbook templates...

...report manager, pivot tables list management -sort data, autofilter, custom filter, advanced filter, subtotals, pivot table, data validation shared workbooks...

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

...the modular design includes practical examples and case studies. participants will acquire a robust vocabulary to devise real solutions and promote effective...

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

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

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

...print and select print options. manage large worksheets, multiple sheets and workbooks. generate and print charts using the chart wizard. sort long lists quickly...

...changes to spreadsheets automate repetitive tasks use keyboard shortcuts where appropriate topic review excel essentials -relative & absolute references...

...multiple sheets and workbooks generate and print charts using the chart wizard sort long lists quickly topic getting started -screen layout...

...automate repetitive tasks. use keyboard shortcuts where appropr course description after completing this course, participants will be able...

...Hypertext Transfer Protocol (HTTP), and Network News Transfer Protocols (NNTP). Knowledge of Exchange 2000 Server is beneficial. In addition...

...Using Microsoft SQL Server 7.0 - General 1561 - Designing a Microsoft Windows 2000 Directory Services Infrastructure - General 1561 - Designing a Microsoft...

...create, use, and maintain data views; implement user-defined functions; design, create, and use stored procedures; create and implement triggers...

...the technical support specialist is a secondary audience for this course, because the course deals with troubleshooting tasks, hardware and software installations...

...target audience: experienced users of powerpoint 2003 objectives: after completing this course, participants will be able to: import data from office applications...