MS Excel courses Cambridge

...perform calculations, modify a worksheet, format a worksheet, print a workbook and manage workbooks. This is a beginners course and is suitable for someone... Learn about: Excel Sheet, Microsoft excel training, Excel 365...

...Headers and Footers Printing Titles Sheet Options Scaling Page Break Preview Setting Print Areas Sheet Background Worksheet and File Linking Creating simple... Learn about: Formula referencing, Create spreadsheets, Excel 2016...

...At the end of the course the participant should be able to create a good selection of spreadsheets. This course will assist users to prepare for the Excel... Learn about: MS Excel, Excel Sheet, Office IT...

...Functions Importance of user defined functions VBA functions basics... Learn about: Microsoft Office, MS Excel, Microsoft Excel...

...Consolidate information Forecasting Goal Seek Scenario Manager Solver Advanced Functions String functions Logical functions Random numbers and rounding... Learn about: Excel 2013, Create multi function calculations, Formula referencing...

...The aim of this course is to assist users who need to become proficient in manipulating data within Excel. By the end of the course you will be able to Summarise, Filter, Sort, Import, and Export data at different levels. You will also have gained an understanding of how to create and edit Macros... Learn about: Excel 2010, Excel 2013, Microsoft Excel...

...tricks to use other Excel features, for example double pie,and extracting numeric values ​​from text... Learn about: MS Excel...

...Aggregating Data in Excel Statistical Functions Outlines Subtotals Pivot Tables Data Relation Analysis Normal Distribution Descriptive Statistics Linear... Learn about: Data analysis, MS Excel, Confidence Training...

...and statistical functions Financial functions Search and data Search and matching Functions MATCH (MATCH) and INDEX (INDEX) Advanced management of lists... Learn about: MS Excel, Financial Training, Database training...

...Triggering Event Handlers Service frequently occurring events VBA Forms Create your own forms Calling a form from code Use the forms in the sheet... Learn about: Visual Basic training, Visual Basic, MS Excel...