-
All
-
Online
-
Filters
-
London
-
Online
-
Type of studies
-
+ Filters (1)
Excel Courses London
- Training
- London
- Advanced
- Different dates available
- 1 Day
... , The TRANSPOSE function Auditing Worksheet Functions Understanding Excel error values, #DIV/0!, #NAME?, #REF, #NULL!, #N/A, Using conditionals to anticipate error... Learn about: Custom Filters, Advanced Filters, Optimizing Lookup...
- Course
- London
...their operational partners (Business Architects, Solution Architects, Project Managers and Sales Teams), and Executive Stakeholders. Modules Hide all Day... Learn about: Microsoft excel training, Microsoft Excel, MS Excel...
- Training
- London
- Intermediate
- Different dates available
- 1 Day
...Using Sparklines, Customizing Sparklines Working With Graphics Adding Clip Art, Adding Pictures, Adding Shapes, Formatting Drawing Objects, Inserting Wordart... Learn about: Deleting Rows, Chart Text, Financial Training...
- Training
- London
- Intermediate
- Different dates available
- 1 Day
...Connecting to Data from outside Excel Getting native Excel data; Getting data From relational databases; Getting data From .CSV And .TXT files... Learn about: DAX formula, Data Types, DAX Language...
- Training
- London
- Intermediate
- Different dates available
...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: Range property, Visual Basic, Value of cells...
- Short course
- Southwark
- 1 Day
...This course spends time on some of the built-in functions and formulae within Excel, as well as exposing you to Excel as a database, adding clipart, WordArt and AutoShapes to enhance your spreadsheet, protecting your sheet from unwanted changes, and exchanging data between Excel and other Office...
- Training
- London
- Intermediate
- Different dates available
- 1 Day
... function categories. Delegates will also be shown the various types of formulas and the different methods of creating them, the different ways of inserting functions and using nested functions to build complex formulas. This Excel course also covers the auditing of formulas and and the handling of errors... Learn about: Database training, IT Auditing, MS Excel...
- Training
- London
- Intermediate
- Different dates available
- 2 Days
...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: Dialogue boxes, Cut Copy, Alerts property...
- Short course
- Southwark
- 1 Day
...This course looks at preparing a spreadsheet for ease of use. Automatic hiding and displaying of columns, getting statitical information from Pivot Tables, using Excel as a 'What If' analysis tool, using Excel on the Web, sharing a workbook with others, using VLookup, and linking to data...
- Training
- London
- Advanced
- Different dates available
- 1 Day
...The ability to understand and create complex formulas is critical to the building of effective Excel solutions. This one day course shows experienced Excel users how to rank and tabulate data using statistical functions, format data with text and math functions, and work with financial data using... Learn about: Excel date, Blank cells, Text Functions...
- Training
- London
- Intermediate
- Different dates available
- 1 Day
...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: PivotTable Style, Report Filter, Table Layout...
- Training
- London
- Intermediate
- Different dates available
- 2 Days
...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: Adding Data Bars, Formatting Cells, Color Scales...
- Short course
- Southwark
- 1 Day
...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...
- Short course
- Southwark
- 1 Day
...This course is designed for the Power Excel user who wants to use his Excel spreadsheets as applications in their own right. It introduces VBA programming and custom forms...
- Course
- London
...their operational partners (Business Architects, Solution Architects, Project Managers and Sales Teams), and Executive Stakeholders. Modules Hide all Day... Learn about: MS Excel...
- Course
- Twickenham
- Different dates available
...This is a skills training course in how to use Pivot tables in Excel 2013. When you have a lot of data, it can sometimes be difficult to analyse all of the information in your worksheet. PivotTables can help make your worksheets more manageable by summarizing data and allowing you to manipulate... Learn about: IT Development, MS Excel, Excel Formula...
- Vocational qualification
- Richmond Upon Thames
- Different dates available
...Course Overview: This is a skills training course in how to use Pivot tables in Excel 2013. When you have a lot of data, it can sometimes be difficult to analyse all of the information in your worksheet. PivotTables can help make your worksheets more manageable by summarizing data and allowing... Learn about: Excel Formula, MS Excel, Excel Sheet...
- Course
- Twickenham
- Different dates available
...This intensive 1 day course is a follow on from the intermediate course and covers the more complicated function and features of excel... Learn about: Excel Formula, Excel for Accounting, Excel Sheet...
- Course
- City Of London
... data from various data sources using Open Database Connectivity (ODBC) and Online Analytic Processing (OLAP) Use Tables and PivotTables to create financial reports and analyses Automate the processes involved in reporting Build validation structures into spreadsheet reports Master Excel shortcuts... Learn about: MS Excel, Financial Reporting, Financial Training...
- Vocational qualification
- Richmond Upon Thames
- Different dates available
...the benefits and uses of spreadsheets and basic terminology Entering and editing data- creating workbooks, entering and editing formula, labels and values... Learn about: Excel Sheet, Excel for Accounting, Mathematics Series...