Excel courses

...2. Course description For anyone who is already confident using Excel and wants to learn all the necessary skills to utilise Excel pivot tables and pivot charts for data analysis... Learn about: MS Excel, Data analysis...

...from Excel We are one of only five colleges in the UK to be granted Foundation Degree Awarding Powers by the Privy Council – meaning our higher education... Learn about: MS Excel...

...insert tables, record macros and much more. On successful completion, you will have a solid knowledge of how to utilise the world’s leading spreadsheet... Learn about: Microsoft Excel, Office IT, Office Excel...

...To be able to conduct statistical analysis of data using Microsoft Excel. Suitable for: Researchers, Graduates, Engineers 2 days practical data analysis using microsoft excel... Learn about: MS Excel, Pivot tables, Statistical analysis...

...summarise, analyse and manipulate your data with Excel Lists Single & Multi-level sorting Auto Filter & advanced filter Get external data Extract... Learn about: Microsoft Excel, MS Excel, Manipulating data...

...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 Office, Microsoft Access, Data analysis...

...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...

...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...

...Pre-requisites Basic keyboard and PC skills and a knowledge of the windows environment is assumed Objectives The aim of this course is to have the participant... Learn about: Excel Sheet, Excel 2013, Create Spreadsheet...

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

...& 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...

...Options Customise Quick Access Toolbar Customise the Ribbon Excel Options Advanced Autofill Fill Weekdays Fill Values Only Growth Trend Format Worksheets Apply accounting... Learn about: Excel 2010, Create multi function calculations, Excel 2016...

...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...

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

...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...

...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, MS Excel, Office IT...

...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: Spreadsheet Basics, Manipulating data, Charts and Graphs...

...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...