Spreadsheet Courses

... professionals who need to automate Excel spreadsheet tasks using Visual Basic for Applications (VBA). Note: delegates should have a solid knowledge of Microsoft Excel 2007, including how to create, edit, format, and print worksheets that contain charts, and how to sort and filter data... Learn about: Microsoft Excel, Microsoft excel training, Visual Basic...

...Semester one: taught units Compulsory units You will take these units: Databases and business intelligence Spreadsheet modelling Business statistics... Learn about: Business English...

... Ribbon · The Data Ribbon · The Page Layout Ribbon Basic Spreadsheet Tasks · Using Templates · Using Formulas in Excel · Customizing your Workbook... Learn about: Microsoft excel training, Microsoft Excel, MS Excel...

...Selection Object Range Collection Cells Collection Using Status Bar Screen Updating and Optimizing Timer and Time Measuring Events Handling in VBA... Learn about: Visual Basic training, Visual Basic, Microsoft Excel...

...During the training, will present the issues of financial analysis using the advanced features of Excel. This course is intended for financial analysts, accountants and all those who want to expand their skills spreadsheet with issues of financial analysis... Learn about: Financial Training, Database training, MS Excel...

...This course is designed to give users an understanding of advanced features and functions within Microsoft Excel 2000. The course is entirely 'hands on', so those attending will get practice in using Microsoft Excel to analyse and share spreadsheet data and create spreadsheet databases. Suitable... Learn about: MS Excel, IT Auditing, Microsoft excel training...

...This intensive one-day training course is designed to let users get to grips with the main features of Microsoft Excel 2007, including a thorough treatment of the new 'Ribbon' interface. It is entirely 'hands on', so those attending will get practice in creating and modifying actual spreadsheets... Learn about: MS Excel, Microsoft Excel, PC training...

...Working with Names and Ranges:· What Are Range Names? · Defining And Using Range Names · Selecting Nonadjacent Ranges · What Is Auto Calculate?... Learn about: Ms Word, MS Excel, Database training...

...Microsoft Excel 2003 is the popular spreadsheet from Microsoft and part of the Microsoft Office XP suite.This training course is designed to let users get to grips with the main features of Microsoft Excel.It is entirely 'hands on', so those attending will get practice in creating and modifying... Learn about: Ms Office, Microsoft Excel, MS Excel...

...To apply the Visual Basic for Applications (VBA) programming language to simplify and automate many of the repetitive tasks that are part of spreadsheet development. Suitable for: Existing experienced users of Microsoft Excel who are confident in their use of commands, functions and simple Macros... Learn about: Visual Basic training, Microsoft Visual Basic, Microsoft excel training...

...functions PivotTables and PivotCharts Creating Pivot Tables Calculated Item and Calculated Field Working with External Data Exporting and importing Exporting... Learn about: Financial Training, MS Excel, Microsoft Excel...

... Information Introduction to Computer Systems Customising Applications Software Website Development Database Software Spreadsheet Software Doing Business on-line... Learn about: Database training, Full Time, Operating Systems...

...Mean Difference Between Mean of Two Populations ANOVA: Analysis of Variances Goodness-of-Fit Test for Discrete Random Variables Test of Independence... Learn about: Excel Sheet, Microsoft Excel, Confidence Training...

...This course has been created for VBA developers who want to learn advanced topics and use VBA macros in the most efficient way. The course deals with object oriented programming... Learn about: Microsoft Excel, Object oriented Programming, Object oriented training...

... Improving Productivity Using IT (Mandatory) IT Software Fundamentals Desk Top Publishing Design Software Spreadsheet Software Website Software... Learn about: System Operation, Ms Word, Full Time...

...Execution For Next • Understand Control-of-Flow Structures• Use the If...End If Decision Structures• Use the Select Case ...End Select Structure• Use the Do... Learn about: Microsoft Word, Office systems, IT Security...