Excel courses

...in Excel and turbocharge your data handling capabilities. Advanced methods for automating tedious Excel jobs. How to write and implement Excel events... Learn about: Office Interop, VBA Language, Language Details...

...Setting manual and automatic outline Hiding and displaying outline Working with visible data only Linking worksheets Consolidating worksheets Hyperlinks...

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

...the use of Excel to develop. financial models. In particular: if you are in finance, accounting, treasury or development. if you are involved in building...

...a demand for the skills described below, as the tools are not necessarily part of most peoples Everyday Spreadsheet work. If you have attended or understand...

...Database Using Data Forms Adding, Editing And Deleting Records Sorting Records Searching For Records Removing Duplicates AutoFilter And Advanced Filter...

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

...already use some Visual Basic programming, but now you are looking for a more professional result using Excel. This programme has been specially designed...

...The Display Freezing and splitting worksheets Hiding and unhiding files, rows and columns Utilities The Watch Window Charting Creating and formatting...

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

...This course is designed to enhance the knowledge of existing Excel users and improve their skills. Course content Naming cells and creating 3D names Relative...

...and edit formulas and functions use a variety of formatting techniques to enhance worksheet presentation print and select print options manage large worksheets...

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

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

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

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

...and edit formulas and functions use a variety of formatting techniques to enhance worksheet presentation print and select print options manage large worksheets...

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

...and edit formulas and functions use a variety of formatting techniques to enhance worksheet presentation print and select print options manage large worksheets...

...and edit formulas and functions use a variety of formatting techniques to enhance worksheet presentation print and select print options manage large worksheets...