GCOM Solutions courses

...Exporting Data To A Pdf File, Exporting Data To Another Access Database, Exporting Data To Excel, Exporting Data To Microsoft Word Creating A Menu System Creating A Switchboard... Learn about: Database training, Delete Query, Exporting Data...

...working with paragraphs 1; working with images & objects; and working with tables. Publisher Basics Understanding Publisher, Starting Publisher... Learn about: New Publication, Page Zoom, Font & Font Size...

...Spell Checking Your Worksheet, Inserting Symbols Editing A Worksheet Working With Ranges, Copying And Pasting Data, Using The Office Clipboard... Learn about: Page Breaks, Average Functions, Cell styles...

...Web Page Preview, Converting Worksheets Into Web Pages, Inserting Hyperlinks, Viewing And Editing Comments Financial & Logical Functions Using The If Function... Learn about: Deleting Rows, MS Excel, Financial Training...

...This course is suitable only for those with considerable prior experience and covers: advanced lookup, maths and array formulas and functions... Learn about: MS Excel, Data tables, Custom Filters...

...What Is a Pivot Table, Understanding the Benefits of Using Pivot Tables, Preparing to Create a Pivot Table, Exploring the Excel Table Features This... Learn about: Insurance Policy, Table Layout, Pivot table...

...Using VLOOKUP() and HLOOKUP(), Using range lookups, Finding exact matches, Using the CHOOSE() function Date and time functions How Excel handles dates and times... Learn about: MS Excel, IT Auditing, Microsoft Excel...

...Using COUNT, COUNTA, and the status bar Mathematical Functions Working with ROUND, ROUNDUP, and ROUNDDOWN; Working with MROUND, CEILING, and FLOOR for specialized rounding... Learn about: Text Functions, MS Excel, Excel date...

...Using constants, Using the VBA debugger Making decisions If statements, Select Case, Looping structures, Different types of loops, Manipulating arrays... Learn about: Value of cells, Targetting cells, MS Excel...

...Making a chart active/inactive, Editing data series, Controlling chart labels, Drawing shapes, Setting shape attributes... Learn about: Cut Copy, Alerts property, Dialogue boxes...

...Using Two Colors of Data Bars in a Range, Using Other Conditional Formatting Methods, Formatting Cells That Are Above or Below Average, Formatting Cells... Learn about: Data Visualizations, Color Scales, Microsoft Office...

...suitable for beginners and experienced users, respectively; and we can also organise in-house training anywhere in the... Learn about: Microsoft Visio, Organizational charts, Visio training...

...Using the master drawing window, Protecting shapes and documents, Changing shape behaviour, Using automatic layout Merging shapes Using the union command... Learn about: Layer properties, Foreground pages, Report wizard...

...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: Microsoft Word, Font Dialog Box, Ms Word...

...Templates And Styles Using Existing Templates, Creating A Template, Modifying A Template, Applying Quick Styles, Changing The Style Set, Creating A Style... Learn about: Sorting Data, Quick styles, Column Width...

...Collaborating with Others Understanding and Configuring Collaboration Tools, Working with Comments, Using Revision Tracking, Comparing Documents... Learn about: Microsoft Word, Ms Word, Embedding Data...

...Referencing Versus Selection and Activation, Testing for the Existence of an Object, Removing Objects from a Collection Events, Dialogs and UserForms Overview of Event Programming... Learn about: Visual Basic training, Macro Recorder, Macro Security...

...users will be confident in using Visio to create basic diagrams and drawings. First steps Starting Visio, Using stencils, Using toolbars, Using the shape explorer... Learn about: Microsoft Visio, Master shapes, Adding master...

...and seamlessly collaborate across the organization... Learn about: Microsoft sharepoint, Empower teamwork, Create mobile...

...description, and logo Site Design Branding your site, Changing the look and feel of a site, Changing the navigation tree view settings, Editing the Quick... Learn about: Office IT, SharePoint products, Team Training...