MS Excel courses Cambridgeshire

...worksheet and table data using various techniquesCreate and modify chartsAnalyse data using PivotTables, Slicers, and PivotChartsInsert and modify graphic... Learn about: MS Excel, Microsoft Excel, Microsoft excel training...

...This introduction to Excel course will equip you to be able to complete these tasks with ease and professionalism. During this course you will learn how... Learn about: Excel Formula, Microsoft excel training, Excel Sheet...

...Tips for Working with Large Spreadsheets Freezing Screen Titles Splitting Windows Displaying Multiple Sheets/Files on Screen Page Setup Options Margins... Learn about: MS Excel, Excel 2010, Excel 2016...

... with Excel 2016 Create a basic worksheet Modify a workbook Use formulas and functions Format an Excel worksheet Manage worksheets and workbooks Set up printing options... Learn about: Microsoft Excel, MS Excel, Microsoft excel training...

...The aim of this course is to have the participant `up and running' immediately following a one day basic programme based upon their existing skills and future needs... Learn about: Excel 2010, Excel 2013, Microsoft Office...

... how toCreate a basic worksheet by using Microsoft Office Excel 2010.Perform calculations in an Excel worksheet.Modify an Excel worksheet.Format a worksheet.Print the content of an Excel workbook.Manage an Excel workbook... Learn about: Office IT, Microsoft excel training, Microsoft Excel...

...Dropdown lists Check boxes Spin buttons Macros Macro basics: Automating with useful macros Creating navigation tools through protected workbooks User Defined... Learn about: Microsoft Excel, MS Excel, Microsoft Office...

... on this subject is covered in our Microsoft Excel 2016 Advanced course.Target Audience This course is aimed at end users who have taken the following QA course or have equivalent knowledge: Microsoft Excel 2016 Introduction. Learning Objectives Delegates will learn how to: Calculate with advanced formulasAudit... Learn about: MS Excel, Microsoft excel training, IT Auditing...

...currency & scientific formats Create custom number formats Conditional formatting Multiple WorkbooksLink workbooks Use multiple workbooks Save a workspace... Learn about: Formula referencing, Excel 2007, Excel 2016...

... foundation in the basic and intermediate skills for working in Excel. You have already used Excel to perform tasks such as running calculations on data and sorting and filtering numeric data. Learning Objectives Delegates will learn how toEnhance productivity and efficiency by streamlining... Learn about: Office IT, Microsoft Office, Microsoft excel training...

... and be able to create a simple Macro. Suitable for: Designed for existing users of Excel who wish to progress their Excel skills and benefit from it's powerful data analysis tools... Learn about: Exel 2007, MS Excel, Microsoft Excel...

.... Please Note: Microsoft Excel 2013 is used as the primary application during the course for demonstration purposes. Target audience Delegates looking to gain enhanced skills to apply VBA to develop macros to work with Office applications. You will work with the application object models, manipulate... Learn about: Microsoft Office, Ms Office, Office IT...

...in Excel Application Development and its distribution Distribution and securing additions to Excel Creating custom toolbars and menu Excel Hacks Tips... Learn about: MS Excel...

...Suitable for: Participants should be familiar with the basics of Excel and Statistics. Participants should be familiar with the basics of Excel and Statistics... Learn about: Data analysis, MS Excel, Confidence Training...

...accountants and all those who want to expand their skills spreadsheet with issues of financial analysis. Advanced functions The logic functions Mathematical... Learn about: Financial Training, Database training, MS Excel...

...using ScreenUpdating The time measurement by the method Timer Event handling in VBA What is an event? Responding to an event and create an event handler... Learn about: Visual Basic, Visual Basic training, MS Excel...