-
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: MS Excel, Microsoft excel training, Excel 2013...
- 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: Microsoft excel training, MS Excel, Microsoft Excel...
- 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: Excel 2016, MS Excel, Microsoft 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: Analyse Data, Data Operations, Pivot tables...
- 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: Excel 2016, Microsoft excel training, 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: Excel 2013 Advanced, Data validation, Excel 2013...
- 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: MS Excel, Average Functions, Cell borders...
- 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: MS Excel, Date Functions, 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: Data analysis, Custom Filters, Advanced Filters...
- 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: Chart Text, Deleting Rows, MS Excel...
- 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: Microsoft Excel, Ms Office, 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, DAX formula...
- 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: MS Excel, Visual Basic training, 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: Database training, IT Auditing, MS 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: MS Excel, Cut Copy, Alerts property...
- 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: MS Excel, Excel date, Blank cells...