Excel courses York

...Programme content: The course illustrates list management in Excel and educates users in building spreadsheets to save as templates. It also covers... Learn about: Microsoft Excel... More

...This course has been created for anyone who works with Excel and wants to automate most of their tasks. The course covers procedural programming in VBA. Students will learn which objects are available in Excel and how to use them. They will also learn how to write their own worksheet functions... Learn about: MS Excel, Visual Basic training, Visual Basic... More

...format worksheets and data. Create calculations, formulae and functions. Use the function wizard and understand absolute cell referencing. Format numbers... Learn about: Microsoft Excel... More

...This course has been created for anyone who works with Excel and wants to automate most of their tasks. The course covers procedural programming in VBA. Students will learn which objects are available in Excel and how to use them. They will also learn how to write their own worksheet functions... Learn about: MS Excel, Visual Basic training, Visual Basic... More

...Create and use multi page worksheets. Link formulae and use group formatting techniques for worksheets. Use range names within a spreadsheet... Learn about: Microsoft Excel... More

...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: MS Excel, Financial Training, Database training... More

...Adjustment of the working environment Hotkeys, facilities Create and modify toolbars Options excel (autosave, input, etc.). Options paste special... Learn about: Database training, Database Management, Data analysis... More

...Adjustment of the working environment Hotkeys, facilities Create and modify toolbars Options excel (autosave, input, etc.). Options paste special... Learn about: Data analysis, Database training, MS Excel... More

...Audience Analysts, researchers, scientists, graduates and students and anyone who is interested in learning how to facilitate statistical analysis in Microsoft Excel. Course Objectives This course will help improve your familiarity with Excel and statistics and as a result increase... Learn about: MS Excel, Data analysis, Microsoft excel training... More

...Training for those working with a Microsoft Excel spreadsheet that would like to improve their work... Learn about: Ms Office, Office IT, Microsoft excel training... More

...Audience Analysts, researchers, scientists, graduates and students and anyone who is interested in learning how to facilitate statistical analysis in Microsoft Excel. Course Objectives This course will help improve your familiarity with Excel and statistics and as a result increase... Learn about: Microsoft Excel, Microsoft excel training, Confidence Training... More

...Training for those working with a Microsoft Excel spreadsheet that would like to improve their work... Learn about: MS Excel, Ms Office... More

...Audience Financial or market analysts, managers, accountants Course Objectives Facilitate and automate all kinds of financial analysis with Microsoft Excel... Learn about: Financial Training, MS Excel, Microsoft excel training... More

...Audience Financial or market analysts, managers, accountants Course Objectives Facilitate and automate all kinds of financial analysis with Microsoft Excel... Learn about: Database training, MS Excel, Financial Training... More

...? Rather than deal with data analysis and preparation of wasting time? Do you have to manually verify the correctness of such data obtained from different systems? Do you have to stay at work after hours or Excel to take books home because not doing during the day? Is Your job is to prepare reports based... Learn about: MS Excel, Construction Training, Data analysis... More

...? Rather than deal with data analysis and preparation of wasting time? Do you have to manually verify the correctness of such data obtained from different systems? Do you have to stay at work after hours or Excel to take books home because not doing during the day? Is Your job is to prepare reports based... Learn about: Construction Training, MS Excel, Data analysis... More

...Excel Object Model The protection sheet from VBA Object Workbook, Workbooks collection Worksheet Object, Collection Worksheets Validation sheets... Learn about: Object oriented training, Object-oriented training, Visual Basic training... More

... Types of errors and ways to avoid Capturing and handling run-time errors Structures: On Error Resume Next, On Error GoTo Excel Object Model... Learn about: Visual Basic training, Visual Basic, MS Excel... More

... Types of errors and ways to avoid Capturing and handling run-time errors Structures: On Error Resume Next, On Error GoTo Excel Object Model... Learn about: Visual Basic training, MS Excel, Visual Basic... More

...and resolve performance issues, properly define indexes for best performance, and how to optimise XQuery applications for concurrency. Application development... Learn about: Database training, Application Development... More