IT, Computing, Telecommunications Training London

...Excel / Intermediate Objective: To give users an extended knowledge of the features and functions within Excel and realise the advantages of using a powerful electronic spreadsheet...

...Labeling Chart Elements, Formatting Chart Text, Formatting Chart Elements, Changing The Chart Type, Showing Or Hiding Gridlines, Customizing... Learn about: Totaling Data, MS Excel, Deleting Rows...

...Delegates will gain practical knowledge on how to analyse and share spreadsheet data and create spreadsheet databases. Delegates: Maximum 8 This course...

...Using the SUBTOTAL function , The RANK function variations , The LARGE and SMALL functions Array Formulas Array formula basics , Using conditionals in array formulas... Learn about: Data tables, MS Excel, Data analysis...

...Delegates: Maximum 8 This course is suitable for existing users of Excel who want to gain further in-depth knowledge in a short space of...

...Changing a Pivot Table, Adding a Report Filter, Updating the Pivot Table, Changing the Summary Function, Applying a PivotTable Style, Deleting a Pivot... Learn about: Table Layout, PivotTable Style, Insurance Policy...

...This is suitable for anyone who wants a basic knowledge of how to use Excel and get the most out of it. It is primarily for people who have not used Excel...

...UPPER, and LOWER; Adjusting character content with REPLACE and SUBSTITUTE; Using other utility text functions: LEN, REPT, VALUE, TEXT Statistical Functions... Learn about: Text Functions, Blank cells, Tabulating blank...

...Delegates: Maximum 8 This course is suitable for users of Excel who want to gain a good knowledge of VBA. An advanced knowledge of Excel is required...

...The Selection property The Range property Targetting cells, Counting the cells in a selection, Using the Offset statement, Retrieving the value of a... Learn about: Visual Basic training, Range property, MS Excel...

...Defining arguments, Optional arguments The Application object When to use, ScreenUpdating property, DisplayAlerts property, Setting CutCopyMode to false... Learn about: Alerts property, Cut Copy, Dialogue boxes...

...Add-in events, Potential problems with add-ins Customising the Ribbon The customui Folder and File, Creating a Tab and a Group, Adding a Control to a Ribbon... Learn about: Microsoft Office, Formatting Cells, Data Visualizations...

...– from organizational charts and flowcharts, web site maps and network drawing to office plans, calendars and timelines. We offer two one-day Microsoft Visio training courses... Learn about: Office plans, Microsoft Visio, Microsoft Visio Training...

...Using the subtract command, Using the fragment command, Using the combine command, Using the intersect command Using background pages Creating a background... Learn about: Smartshape wizard, Report wizard, Adding a hyperlink...

...Using HelpOn Your Own Editing Text Selecting Text, Copying And Pasting Text, Cutting And Pasting Text, Using Drag-And-Drop, Using The Office Clipboard... Learn about: Setting Printer Options, Correcting Mistakes, Ms Word...

...Creating A New Style, Modifying A Style, Managing StylesOn Your Own Columns And Tables Creating Columns, Adding A Column Break, Modifying Column Layout... Learn about: Quick styles, Totaling Rows, Column Width...

...Inserting Content with {IncludeText} and {IncludePicture} Working with Fields Understanding Fields, Inserting Fields, Updating Fields, Finding and Moving Between Fields... Learn about: Data Sharing, Updating Fields, Embedding Data...

...What is involved in learning Word VBA?, Getting Set Up, The Developer Tab and Macro Security, Recording a Macro, Attaching Macros to the Quick Access Toolbar... Learn about: Ms Word, Macro Programming, Visual Basic...

...Closing a Visio file, Using print preview, Using page setup, Printing a drawing Creating a drawing Starting a drawing, Adding master shapes to a drawing... Learn about: Adding master, Master shapes, Connector tool...

...and seamlessly collaborate across the organization... Learn about: Microsoft sharepoint, Create mobile, SharePoint courses...