Member login
IT's Easy Training
Customising a Toolbar Using Solver IF Statements Advanced VlookUp and SUMIF IF And Match Logical Tests, Error Trapping Using Form Tools Data Validation Advanced Pivot Tables Formulae Recording Basic ...
Customising a Toolbar Using Solver IF Statements Advanced VlookUp and SUMIF IF And Match Logical Tests, Error Trapping Using Form Tools Data Validation Advanced Pivot Tables Formulae Recording Basic Macros Importing External Data Using Named Ranges in a Formula Advanced Database Filters and functions Advanced Scenarios Investment Rate of Return Functions Using Text Functions, Left, Right, Mid, Large, Small Using Forecast and Frequency functions. Suitable for: Anyone →
Progressive Training & Development
This course takes Excel to its limits, introducing automated templates, the use of macros, using WhatIf Logic, and sharing spreadsheets.
This course takes Excel to its limits, introducing automated templates, the use of macros, using WhatIf Logic, and sharing spreadsheets. →
Progressive Training & Development
Anyone wishing to automate common worksheet operations, convert worksheets into forms and understand Excel VBA code.
Anyone wishing to automate common worksheet operations, convert worksheets into forms and understand Excel VBA code. →
Pitman Training - Forres Morayshire
→
Pitman Training - Glasgow
→
Strata Training
This course will show you how to use more advanced formulae in Excel to carry out complex calculations. Suitable for: Excel users with a reasonable knowledge of creating basic functions and formatting ...
This course will show you how to use more advanced formulae in Excel to carry out complex calculations. Suitable for: Excel users with a reasonable knowledge of creating basic functions and formatting spreadsheets. →
Enable Technology
This course assumes no prior knowledge, introduces candidates to Excel 2007 and moves onto advanced topics within the two training days. The syllabus is mapped against the Microsoft Application ...
This course assumes no prior knowledge, introduces candidates to Excel 2007 and moves onto advanced topics within the two training days. The syllabus is mapped against the Microsoft Application Specialist qualification and gives a detailed overview of the Excel 2007 application. Topics include →
Pin-Point Training Limited
→
Marda Associates
This course introduces the skills necessary for creating and using pivot tables (used for summarising large amounts of data) and includes formatting pivot tables and using pivot table calculations. ...
This course introduces the skills necessary for creating and using pivot tables (used for summarising large amounts of data) and includes formatting pivot tables and using pivot table calculations. Finally you will learn the basics of using a macro, creating a macro button and custom menus. Suitable for: Anyone →
LMG Training and Development
This course is directed at users who want to take their spreadsheets to a new level. Get Excel to solve your more complex financial problems. You will learn how to create robust and professional ...
This course is directed at users who want to take their spreadsheets to a new level. Get Excel to solve your more complex financial problems. You will learn how to create robust and professional models utilizing Excel functionality that most Excel users do not know how to use. Suitable for: Anyone interested in Financila Modelling in Excel. Must have Intermediate to Advanced knowledge of Excel. →
Pitman Training - Forres Morayshire
To learn Excel to Microsoft Office Expert Level. The flexibility and value of a self-study course designed to enable you to work at your own pace. A personalised workbook to use as a reference guide ...
To learn Excel to Microsoft Office Expert Level. The flexibility and value of a self-study course designed to enable you to work at your own pace. A personalised workbook to use as a reference guide on completion of the course. The opportunity to gain the widely recognised Pitman Training certificate. Suitable for: Perfect for those who are familiar with using Microsoft Excel and want to broaden their knowledge of the universally used application. You will learn advanced features including finding trends in data, deleting a custom toolbar and menu; use AutoFilter, create pivot tables, use digital signitures and insert embedded objects. Successful completion of this course will enable you to work towards further qualifications. →
Vital Training (UK)
More advanced formulas and functions. How to use 'IF' functions. Linking worksheets within a workbook. Conditional formatting. Creating templates. Creating and customising graphs. Using Pivot tables. ...
More advanced formulas and functions. How to use 'IF' functions. Linking worksheets within a workbook. Conditional formatting. Creating templates. Creating and customising graphs. Using Pivot tables. Suitable for: This course is aimed at people who use Excel regularly including. being already able to write their own formulas. →
First Training
Suitable for: This is a one day course designed for delegates who are established users of Excel and want to expand their knowledge of the application.
Suitable for: This is a one day course designed for delegates who are established users of Excel and want to expand their knowledge of the application. →
Ecom Learning Solutions Ltd
Suitable for: This course is aimed at people with either no or very little experience in using Excel, it is therefore perfect for the first time user especially if you will be using Excel in the ...
Suitable for: This course is aimed at people with either no or very little experience in using Excel, it is therefore perfect for the first time user especially if you will be using Excel in the workplace. Anyone looking for a comprehensive grounding in Excel will benefit from this course. →
Ivory Computer Training
→
Solveway Ltd
Students will learn how to represent data graphically and maintain and manage lists.
Students will learn how to represent data graphically and maintain and manage lists. →
Plato Training
→
Plato Training
→
Marda Associates
Microsoft Excel is a software application that can be used as a spreadsheet, database, or graphing program. The electronic spreadsheet portion of Excel allows you to perform sophisticated calculations ...
Microsoft Excel is a software application that can be used as a spreadsheet, database, or graphing program. The electronic spreadsheet portion of Excel allows you to perform sophisticated calculations and create formulas that automatically calculate answers. Suitable for: Anyone →
The Glenholm Centre
At the end of the course participants will be able to enter data into a spreadsheet, format that data, perform simple calculations using that data and present that data in an attractive printed form. ...
At the end of the course participants will be able to enter data into a spreadsheet, format that data, perform simple calculations using that data and present that data in an attractive printed form. Suitable for: Those who can already use a computer and need to use Microsoft Excel to produce simple spreadsheets, but have little or no experience of this program. →
Just answer 4 simple questions!
Start now
