-
All
-
Online
-
Filters
-
Location
-
Online
-
Type of studies
-
+ Filters (1)
Excel training
- Training
- Aberdeen
- 1 Day
...Terminology and techniques are introduced to ensure knowledge and confidence is instilled allowing the participant to administer their duties and Excel tasks proficiently... Learn about: Excel 2013, MS Excel, Microsoft excel training...
- Training
- Aberdeen
- Different dates available
- 1 Day
...features of Microsoft Excel. The course is designed to augment the trainee’s existing spreadsheet skills, thereby utilising Excel 2010 to its full potential... Learn about: MS Excel, Microsoft Excel, Microsoft excel training...
- Training
- Aberdeen
- July
- 1 Day
...your premises or using our portable training school. EXCEL 2016 ADVANCED The skills and knowledge acquired in Microsoft Excel 2016 Advanced are sufficient... Learn about: Track Changes, Microsoft excel training, Excel 2016...
- Training
- Norwich
- Intermediate
- 1 Day
...Day Course Assumed Knowledge: A working knowledge of Excel gained from prior attendance on a Jarrold Training Microsoft Excel Introduction course or from a user environment...
- Training
- Nottingham
- Advanced
- Different dates available
...delegates should be able to: Group cells and use outlines to manipulate the worksheet Create summaries in your spreadsheets using subtotals Combine... Learn about: MS Excel, Pivot tables, Create Recorded Macros...
- Training
- Norwich
- 1 Day
...One Day Course Assumed Knowledge: A basic understanding of PCs, use of a keyboard and mouse plus knowledge of Microsoft Windows is required...
- Training
- Aberdeen
- Different dates available
- 1 Day
...Use Vlookup to compare or merge data Use Flash Fill to extract data Freeze Row and Column headings Use Conditional Formatting to highlight cells based... Learn about: Microsoft excel training, Microsoft Excel, MS Excel...
- Training
- Aberdeen
- Different dates available
- 1 Day
...functions to identify errors and calculation steps Create, edit and format Pivot Tables to summarise, analyse and report on data Record Macros and... Learn about: Visual Basic Editor, Formula Auditing, MS Excel...
- Training
- London
- Intermediate
- Different dates available
...Switching Between Views, Using Help, Closing A Workbook And Exiting ExceOn Your Own Working With Data Entering Text And Numbers, Entering Simple Formulas... Learn about: Cell styles, Average Functions, Page Breaks...
- Training
- Aberdeen
- 1 Day
...data Sort and filter to find and organise data Format your data to present or track your data Protect your workbooks Create charts to present your... Learn about: Date Functions, Excel 2013, Flash fill...
- Training
- London
- Advanced
- Different dates available
...Advanced Number-Crunching Functions Controlling rounding sensitivity, Using SUMIF and INDIRECT , Using wildcards with SUMIFS, AVERAGEIFS, MINIFS and MAXIFS... Learn about: Pivottable Data, Optimizing Lookup, Data tables...
- Training
- London
- Intermediate
- Different dates available
...Filtering Data Using Autofilter, Creating Custom FiltersOn Your Own Working With Charts Creating A Chart, Moving A Chart, Resizing A Chart, Changing The Layout And Style... Learn about: Totaling Data, MS Excel, Deleting Rows...
- Training
- Online
- Different dates available
...at information in new ways using Excel’s 3-D data visualization tool, Power Map. A power map lets you discover insights you might not see in traditional 2-D tables and charts... Learn about: Data Access, Microsoft Excel, Sales Training...
- Training
- London
- Intermediate
- Different dates available
...Getting native Excel data; Getting data From relational databases; Getting data From .CSV And .TXT files; Getting tabular data from a web page Transforming... Learn about: Data Types, DAX Language, MS Excel...
- Training
- London
- Intermediate
- Different dates available
...Stepping through macros, Getting help on macros Objects, properties and methods About Excel objects, Using the Object Browser , Range object... Learn about: Range property, Visual Basic, Adding comments...
- Training
- Norwich
- 1 Day
...who wish to continue advancing their knowledge of Excel Microsoft Excel Advanced - Level 2 One Day Course Course Aims: This course is designed to provide...
- Training
- Norwich
- Beginner
- 1 Day
...practical understanding Microsoft Excel Advanced - Level 1 One Day Course Course Aims: This course is designed to provide delegates with the knowledge...
- Training
- London
- Intermediate
- Different dates available
...nested functions to build complex formulas. This Excel course also covers the auditing of formulas and and the handling of errors. Building formulas Entering and editing formulas... Learn about: IT Auditing, MS Excel, Microsoft Excel...
- Training
- London
- Intermediate
- Different dates available
...The Immediate Window Function procedures Sub versus function, User-defined functions, Declaring a function, Calling a function, Private and public scope... Learn about: Cut Copy, Alerts property, MS Excel...
- Training
- London
- Advanced
- Different dates available
...removing hidden characters with CLEAN; Using ampersands and CONCATENATE to combine data from different cells; Adjusting the case within cells with PROPER... Learn about: Tabulating blank, MS Excel, Excel date...