Excel training London and UK

Microsoft Excel 2013 UK Training Courses

MS Excel 2013 Introduction - Create spreadsheets and input data. Create simple calculations. Learn to edit, delete, move, copy and manipulate data. Chart wizard, formatting a spreadsheet and printing.

MS Excel 2013 Intermediate - Creating formulas over multiple worksheets and workbooks. Sorting and filtering data. Learn advanced formatting techniques. Protecting data, creating advanced charts, using standard templates and creating your own templates.

MS Excel 2013 Advanced Part 1 - Creating advanced formulas to make decisions. Importing and exporting data. Create and use look-ups and queries. Learn to work with Pivot Tables and other analytical tools. Record and use macros to automate your work.

MS Excel 2013 Advanced Part 2 - Formulas & Functions - Building complex formulas, Advanced functions in formulas, Data & Text Functions, Use Lookup and Reference functions to systematically search worksheets, Auditing formulas, Introduction to Array formulas

MS Excel 2013 Advanced Part 3 - For Power Users - Incl. workshop session

MS Excel 2013 Pivot Tables - Understand functionality & potential of Pivot Tables, construct & manipulate complex summaries, use Pivot Table tools, control visual & data formatting, statistical data analysis, automate, troubleshoot & utilise Pivoted data in different contexts.

MS Excel 2013 PowerPivot - Microsoft PowerPivot is an add on for Excel 2010 that provides Business Intelligence functionality & reporting within the familiar environment of Excel. It provides the real power to crunch & analyse data on a scale previously unimagniable with pivot tables.

MS Excel 2013 Charting - Excel Charting Concepts, Creating Basic Charts Quickly, Fine-Tuning Charts with Design Tab Choices, Layout Tab Options, Format Options, Adjusting Specific Chart Types, Changing a Chart's Data, Printing and Sharing Charts

Microsoft Excel 2010 UK Training Courses

MS Excel 2010 Introduction - Create spreadsheets and input data. Create simple calculations. Learn to edit, delete, move, copy and manipulate data. Chart wizard, formatting a spreadsheet and printing.

MS Excel 2010 Intermediate - Creating formulas over multiple worksheets and workbooks. Sorting and filtering data. Learn advanced formatting techniques. Protecting data, creating advanced charts, using standard templates and creating your own templates.

MS Excel 2010 Advanced Part 1 - Creating advanced formulas to make decisions. Importing and exporting data. Create and use look-ups and queries. Learn to work with Pivot Tables and other analytical tools. Record and use macros to automate your work.

MS Excel 2010 Advanced Part 2 - Formulas & Functions - Building complex formulas, Advanced functions in formulas, Data & Text Functions, Use Lookup and Reference functions to systematically search worksheets, Auditing formulas, Introduction to Array formulas

MS Excel 2010 Advanced Part 3 - For Power Users - Incl. workshop session

MS Excel 2010 Pivot Tables - Understand functionality & potential of Pivot Tables, construct & manipulate complex summaries, use Pivot Table tools, control visual & data formatting, statistical data analysis, automate, troubleshoot & utilise Pivoted data in different contexts.

MS Excel 2010 PowerPivot - Microsoft PowerPivot is an add on for Excel 2010 that provides Business Intelligence functionality & reporting within the familiar environment of Excel. It provides the real power to crunch & analyse data on a scale previously unimagniable with pivot tables.

MS Excel 2010 Charting - Excel Charting Concepts, Creating Basic Charts Quickly, Fine-Tuning Charts with Design Tab Choices, Layout Tab Options, Format Options, Adjusting Specific Chart Types, Changing a Chart's Data, Printing and Sharing Charts

MS Excel 2010 VBA Intro Intermediate - On our 2 day Excel VBA course, you'll learn Developing with Procedures and Functions, Introducing Objects, Utilising Intrinsic Functions, Variables and Expressions, Managing Program Execution, Harnessing Forms and Controls, Using the PivotTable Object, Debugging The Code, Handling Errors.

MS Excel 2010 VBA Advanced - Click for more info

Microsoft Excel 2007 UK Training Courses

MS Excel 2007 Introduction - Create spreadsheets and input data. Create simple calculations. Learn to edit, delete, move, copy and manipulate data. Chart wizard, formatting a spreadsheet and printing.

MS Excel 2007 Intermediate - Creating formulas over multiple worksheets and workbooks. Sorting and filtering data. Learn advanced formatting techniques. Protecting data, creating advanced charts, using standard templates and creating your own templates.

MS Excel 2007 Advanced Part 1 - Creating advanced formulas to make decisions. Importing and exporting data. Create and use look-ups and queries. Learn to work with Pivot Tables and other analytical tools. Record and use macros to automate your work.

MS Excel Advanced Part 2 - Formulas & Functions - Building complex formulas, Advanced functions in formulas, Data & Text Functions, Use Lookup and Reference functions to systematically search worksheets, Auditing formulas, Introduction to Array formulas

MS Excel Advanced Part 3 - For Power Users - Incl. workshop session

MS Excel 2007 Pivot Tables - Understand functionality & potential of Pivot Tables, construct & manipulate complex summaries, use Pivot Table tools, control visual & data formatting, statistical data analysis, automate, troubleshoot & utilise Pivoted data in different contexts.

MS Excel PowerPivot - Microsoft PowerPivot is an add on for Excel 2010 that provides Business Intelligence functionality & reporting within the familiar environment of Excel. It provides the real power to crunch & analyse data on a scale previously unimagniable with pivot tables.

MS Excel Charting - Excel Charting Concepts, Creating Basic Charts Quickly, Fine-Tuning Charts with Design Tab Choices, Layout Tab Options, Format Options, Adjusting Specific Chart Types, Changing a Chart's Data, Printing and Sharing Charts

MS Excel 2007 VBA Intro Intermediate - On our 2 day Excel VBA course, you'll learn Developing with Procedures and Functions, Introducing Objects, Utilising Intrinsic Functions, Variables and Expressions, Managing Program Execution, Harnessing Forms and Controls, Using the PivotTable Object, Debugging The Code, Handling Errors.

MS Excel 2007 VBA Advanced - Click for more info

Microsoft Excel 2003 UK Training Courses

MS Excel 2003 Introduction - Create a spreadsheet, input data and carry out simple calculations. Edit, delete, move and copy data. Using the chart wizard. Format a spreadsheet and print it.

MS Excel 2003 Intermediate - Create formulas across multiple worksheets and workbooks, sort and filter data, use advanced formatting techniques, create advanced charts, protect data, use standard templates and create your own.

MS Excel 2003 Advanced - Create advanced formulas to make decisions, import and export data, create and use lookups and queries. Work with Pivot Tables and other analytical tools, record and use a macro to automate your work.

MS Excel 2003 Pivot Tables - Understand functionality & potential of Pivot Tables, construct & manipulate complex summaries, use Pivot Table tools, control visual & data formatting, statistical data analysis, automate, troubleshoot & utilise Pivoted data in different contexts.

MS Excel 2003 VBA Intro Intermediate - On our 2 day Excel VBA course you'll learn how to customise and manipulate Excel within the Microsoft Visual Basic environment. You'll be using macros, custom functions and user forms. The skills gained from this Excel training UK course can be applied to all versions of Excel.

MS Excel 2003 VBA Advanced - Click for more info

Microsoft Excel 2002 XP UK Training Courses

MS Excel 2002 XP Introduction - Create a spreadsheet, input data and carry out simple calculations, edit, delete, move and copy data, charting, formatting and printing a spreadsheet.

MS Excel 2002 XP Intermediate - Using large worksheets. Customising Excel. Use advanced formatting and charting. Learn to use standard templates and create your own, sort and filter data. Share and protect your data.

MS Excel 2002 XP Advanced - Create advanced formulas, import and export data and publish content onto the Web. Understand database functions. Work with Pivot Tables and other analytical tools, create and run simple macros.

MS Excel 2002 XP VBA Intro Intermediate - 2 day Excel VBA training UK course. Learn how to customise and manipulate Excel within the Microsoft Visual Basic environment, using macros, custom functions and user forms. The skills gained from this course can be applied to all versions of MS Excel.

Microsoft Excel 2000 UK Training Courses

MS Excel 2000 Introduction - Create spreadsheets, input data and carry out simple calculations. Edit, delete, move and copy data. Creating charts. Format a spreadsheet and printing it.

MS Excel 2000 Intermediate - Use a workbook and create formulas. Use standard templates and create your own. Sort and filter data, create charts and collaborate on a worksheet.

MS Excel 2000 Advanced - Use a workbook, create advanced formulas. Analyse data using pivot tables and scenarios. Sort and filter data; advanced functions and macros.

MS Excel 2000 VBA Intro Intermediate - Two day Excel VBA training course. Learn how to customise and manipulate Excel within the Microsoft Visual Basic environment, using macros, custom functions and user forms. The skills gained from this course can be applied to all versions of MS Excel.

Microsoft Excel 97 UK Training Courses

MS Excel 97 Introduction - Create an electronic spreadsheet, input data and carry out simple calculations. Edit, delete, move and copy data. Using the chart wizard. Format a spreadsheet and prepare it for printing, use a workbook.

MS Excel 97 Intermediate - Use a workbook and create formulas. Analyse data using pivot tables and scenarios, use standard templates and create your own. Sort and filter data and create advanced charts.

MS Excel 97 Advanced - Create advanced formulas, run queries on data, import and export data. Share and protect data, understand simple macros.