Excel intermediate courses

... for: This course is suitable for people who have attended the intermediate course or have good knowledge and understanding of Excel 2007 and would like to explore the more complex functionality it can offer. Prerequisites A working knowledge of Microsoft intermediate topics or attendance to our Intermediate Microsoft Excel course...

...If you have some Excel knowledge, or no Excel knowledge, this course takes you quickly from basic knowledge to a greater understanding of Excel's features. It touches on Beginner, Intermediate and Advanced features...

...To teach Excel 2003 to Microsoft Office Expert level. Suitable for: Those familiar with using Microsoft Excel to an intermediate level who now wish to learn advanced features...

... level Excel training or equivalent...

...Understanding predictive analytics concepts of regression modelling, correlation and implementing them using MS Excel... Learn about: MS Excel, Pharma sectors, Modelling skills...

...If you have some Excel knowledge, or no Excel knowledge, this course takes you quickly from basic knowledge to a greater understanding of Excel's features. It touches on Beginner, Intermediate and Advanced features...

...Connecting to Data from outside Excel Getting native Excel data; Getting data From relational databases; Getting data From .CSV And .TXT files... Learn about: MS Excel, DAX Language, Data Types...

...Get to grips with the basics of using a spreadsheet effectively with the Excel 2010 Introduction Course. Designed to be a complete introduction to the basics of using Microsoft Excel, this quick-start package will teach students everything they need to get started with using spreadsheets... Learn about: MS Excel, Data entry, Microsoft Excel program...

...This course aims to provide delegates with a foundation for Excel knowledge and skills. The intermediate course will give you the tools you need to be able to use Microsoft Excel at an intermediate level... Learn about: Quick Analysis, Excel Formulas, Microsoft excel training...

...In this Excel 2013 – Protecting Your Spreadsheets online course, you’ll learn how to protect your Excel cells, worksheets, and workbooks in Microsoft® Excel® 2013.... Learn about: Simulations & Solver, Tables & Formatting, Data tables...

...Our Excel VBA Level 2 course is designed for experienced Excel users who have already begun to create macros and know their way around Excel’s Visual Basic Editor. This course delves deeper into the Excel object model and provides delegates with practical experience of developing their own VBA... Learn about: MS Excel, Alerts property, Dialogue boxes...

...Get to grips with the basics of using a spreadsheet effectively with the Excel 2010 Introduction Course. Designed to be a complete introduction to the basics of using Microsoft Excel, this quick-start package will teach students everything they need to get started with using spreadsheets... Learn about: MS Excel, Microsoft Excel program, Microsoft Excel...

...Excel’s new frontiers; Understanding Excel’s new power components; New ways of working in Excel; Limitations of VLOOKUP models; Connections and queries versus automation; Activating Excel’s power tools... Learn about: Excel data, Query Basics, MS Excel...

... time learning the basics of navigating the program and understanding how it manages and displays data. Or, if you’ve been using Microsoft Excel for a while, speed through the early lessons to get to tutorials on laying out your worksheets using tables, formatting and calculations. Later sessions cover... Learn about: Microsoft Excel, Excel worksheet, MS Excel...

...Functions are at the core of Microsoft Excel and provide much of its power. However, many users find working with functions and formulas confusing and frustrating. This Excel training course focuses on the creation of formulas using the most useful and essential functions in each of Excel’s main... Learn about: IT Auditing, Database training, MS Excel...

...Our Excel VBA Level 3 course is designed for experienced Excel VBA developers who are familiar with working with the Excel object model... Learn about: Microsoft Office, Adding Data Bars, Color Scales...

...What Is a Pivot Table, Understanding the Benefits of Using Pivot Tables, Preparing to Create a Pivot Table, Exploring the Excel Table Features... Learn about: Report Filter, PivotTable Style, Pivot table...

... workaround which will enable you to use this function to extract data from your local XML documents as well. The final section of this course is given over to an XML capability which is well hidden in Microsoft Excel, namely the ability to transform XML as you import it by using XSL stylesheets... Learn about: MS Excel, Microsoft Office, XML training...

...pivot table KPIs Overview of KPIs; Creating KPIs; Base value; Target value; Status threshold; Creating measures for KPIs; Displaying a KPI on a pivot table... Learn about: 3D Map Reports, 3D Map data, MS Excel...

...This introductory Excel VBA Training Course shows delegates how to create and customise macros and gives them a basic familiarity with the Visual Basic for Applications environment. Best practices are introduced from the outset and delegates are encouraged to learn VBA by understanding its... Learn about: MS Excel, Targetting cells, Visual Basic...