Excel training courses

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

...Gain competency in the more complex features of Microsoft Excel for business or individual use. Increased effectiveness with the ability to explore the benefits of Microsoft Excel and make tasks easier. A choice of training locations and times, and the flexibility and value of self-study training...

... the basics of Excel...

...This course is designed to provide a new Excel user with a good understanding of the basic concepts of spreadsheet design, commands, data manipulation, using calculations and formatting techniques, as well as creating charts...

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

...Gain a clear understanding of the basic principles and key features of this software package, and the ability to use it effectively. Increased effectiveness with the ability to explore the benefits of Microsoft Excel and make tasks easier. A choice of training locations and times...

... of Microsoft Excel... Learn about: Functions in Excel, Flash fill, Advanced pivot tables...

...This two day course is designed to provide delegates with the knowledge to manipulate Excel and gives developers greater opportunities to create rich desktop applications for end users. An improved programming model gives easier access to office functionality allowing for the delivery of powerful...

...select visible cells multiple sheets and workbooks -create, name, delete and view sheets; copy/move data to other sheets; group editing, workspaces...

... and value of self-study training methods that allow for different learning speeds and styles. Suitable for: Business individuals, including secretaries, with a good knowledge of Microsoft Excel who want to increase their skills to include the more advanced features of this market leading software package...

...Microsoft Excel Intermediate This intermediate course will help build the delegates existing knowledge of Excel. The areas this training can cover...

...You already know the basic and some advanced operations in Excel, now you will learn even more. Suitable for: Someone who has completed Excel 2002 intro and inter...

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

...Introduction to Excel VBA Programming Understanding Macros The Visual Basic Editor Excel VBA Fundamentals Variables, Data types, and Constants... Learn about: Analytic Expert...

...Data Lists • Sorting & Filtering Data • Sub Totals • Creating Charts • Manipulating Chart Data • Modifying Chart Layouts • Previewing & Printing Charts...

...Set up a spreadsheet Use formulas to add/subtract/multiply divide. Find averages using formulas Change the layout and appearance of cells Set up headers/footers. Suitable for: People who want a good basic knowledge of Microsoft Excel including using formulas and enhancing the layout...

...select visible cells multiple sheets and workbooks -create, name, delete and view sheets; copy/move data to other sheets; group editing, workspaces...

...To develop skills in advanced features of Microsoft Excel, shortcuts, automated processes and add-ins. To introduce concepts of statistics, practical significance testing and probability. Suitable for: Advanced Excel for Analysts Personnel who possess a basic knowledge of Microsoft Excel...

...Charts Using the Drawing Tools An Introduction to Macros Attaching Macros to Shortcut Keys &Toolbar Buttons Editing Macros Macro Virus Protection...

...select visible cells multiple sheets and workbooks -create, name, delete and view sheets; copy/move data to other sheets; group editing, workspaces...