Excel courses

...A series of short Excel-based lesson files that teach essential tips and tricks for financial modeling. Suitable for: Anyone who will use Microsoft Excel...

...be able to access a number of exclusive bonus resources to help you along your Excel Data Analysis journey. Excel Data Analysis is suitable for anyone... Learn about: Microsoft Access, Data analysis, Microsoft Office...

...introduction to the VLOOKUP function – when and how to use it An introduction to the IF function, including SUMIF and COUNTIF Format and modify charts... Learn about: MS Excel...

...2. Course description Learn skills to utilise macros within Excel. Techniques for creating, storing and reusing macros, and looking at editing... Learn about: Visual Basic, MS Excel, Visual Basic training...

...& Named Ranges • Paste Special • Transposing rows and columns • Importing text and text delimiters • Named ranges in cells • Using names ranges in formulae...

...isolates the important changes that will affect bankers and is designed to make the transition to the 2007 version as smooth as possible. Excel 2003...

...For a full introduction, it is suggested that this course is taken in conjunction with the Intermediate course. Pre-requisites: None other than a working...

...enterprising and innovative skills and behaviours, which will help you to become successful in an ever-competitive world. We offer all of the above in a supportive... Learn about: Quality Training, MS Excel...

...• Using Styles • Conditional Formatting • Using The Format Painter • Using Guidelines • Hiding And Displaying Cells More Formulae and Functions • Using...

...who wishes to develop more complex spreadsheets, use more advanced formulae and develop skills in data analysis techniques. The reasonably experienced...

...in Microsoft Office Excel 2010 by evaluating the ability to use the advanced features in the product to solve real-world business problems. In today’s... Learn about: Ms Office, Office IT, MS Excel...

...To use advanced tools like Macros, Import HTML and Scripts to replicate Excel’s functions. How to write compelling formulas quickly and easily with the point-and-click method... Learn about: Manipulating data, MS Excel, Spreadsheet Basics...

...expected economic growth). The model would return an estimated value of a company under each scenario. 1) - Customising the settings in Excel to accommodate the Model... Learn about: Financial Training, MS Excel, Financial Modelling...

...College Group will help you develop an entrepreneurial mindset by instilling enterprising and innovative skills and behaviours, which will help you... Learn about: Quality Training, MS Excel...

...in formulae Basic charting in Excel Printing Course Benefits Be able to identify and describe the component features that collectively make up the working... Learn about: MS Excel...

...set up subroutines, and create functions. How to use input boxes and message boxes to interact with end users. Practical methods for using macro errors... Learn about: MS Excel, Microsoft VBA, Microsoft Access...

...understand the use of basic macros/VBA for automation. Target Audience Designed for users who need to interpret and communicate large quantities of information... Learn about: MS Excel, Microsoft Office, Microsoft Excel...

...mindset by instilling enterprising and innovative skills and behaviours, which will help you to become successful in an ever-competitive world... Learn about: Quality Training, MS Excel...

...Course Content Its main focus is to introduce users to more specialist areas of Excel's functionality. We would suggest that you have a demand for the skills described below... Learn about: MS Excel...

...Establishing Excel and Office 2007 SharePoint Server Fundamentals - Initiating the Project - Determining Project Requirements - Planning and Acquiring Resources...