GCOM Solutions courses

...It’s an easy-to-use tool for creating applications that help you run your business This course is suitable only for those with considerable prior experience and covers... Learn about: Data Macro, Delete Query, Database training...

...Setting Publisher Options, Using Help, Working With Business Information SetsOn Your Own Working With Pages Navigating Pages, Changing Page... Learn about: Font & Font Size, Page Zoom, Microsoft Publisher...

...Choosing Formula Cell References Manually, Using Autosum, Changing & Deleting Data, Using Undo/Redo, Using Find And Replace, Using The Go To Command... Learn about: MS Excel, Page Breaks, Cell styles...

...Editing A Template, Showing Or Hiding Workbook Elements, Creating A Workspace, Comparing Two Workbooks Side By Side, Saving A Workbook In A Different File Format... Learn about: Chart Text, MS Excel, Totaling Data...

...Advanced Number-Crunching Functions Controlling rounding sensitivity, Using SUMIF and INDIRECT , Using wildcards with SUMIFS, AVERAGEIFS, MINIFS and MAXIFS... Learn about: Advanced Filters, MS Excel, Data tables...

...Removing a Pivot Table Style, Creating a Pivot Table Style, Applying a Custom Pivot Table Style, Modifying a Custom PivotTable Style, Duplicating a Pivot Table Style... Learn about: Table Layout, Report Layout, MS Excel...

...Copying a formula without adjusting relative references , Displaying Worksheet Formulas , Working with range names in formulas , Pasting a name into a formula... Learn about: IT Auditing, Database training, Microsoft Excel...

...Text Functions Locating and extracting data with FIND, SEARCH, and MID; Extracting specific data with LEFT and RIGHT; Removing extra spaces with TRIM... Learn about: Blank cells, Excel date, MS Excel...

...Drawing shapes, Setting shape attributes Using Visual Basic Language structure, Using variables, Declaring variables, Scoping variables, Data types... Learn about: MS Excel, Visual Basic, Targetting cells...

...Working with embedded charts, Working with independent charts, Controlling chart formatting, Assigning a range to a chart, Positioning a chart... Learn about: Alerts property, MS Excel, Dialogue boxes...

...Click events Creating Add-ins Add-ins defined, Creating an add-in, Installing and add-in, Controlling add-ins with VBA, Add-ins collection, Add-in properties... Learn about: Color Scales, Formatting Cells, Adding Data Bars...

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

...Using the smartshape wizard Using special features Viewing custom properties of a shape, Adding a custom property to a shape, Using the property report wizard... Learn about: Adding a hyperlink, Smartshape wizard, Foreground pages...

...Creating A Bulleted List, Creating A Numbered List, Creating A Hanging Indent Working With Pages Creating A Header And Footer, Modifying A Header And Footer... Learn about: Microsoft Word, Page Breaks, Correcting Mistakes...

...templates and styles; columns and tables; working with graphics; using mail merge; working with document sections; and workgroup collaboration. Templates... Learn about: Column Layout, Microsoft Word, Column Width...

...Saving the Form as a Template, Word 2007 or Legacy Fields?, Displaying the Developer Tab, Creating a Form with Content Controls, Creating a Form with Legacy Form Fields... Learn about: Ms Word, Embedding Data, Data Sharing...

...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: Macro Security, VBA Macro, Quick Access...

...Our Introduction to Visio course assumes no prior knowledge of the program and gives users a good basic familiarity with the program interface... Learn about: Page setup, Microsoft Visio, Master shapes...

...G Com Solutions Limited deliver onsite Microsoft SharePoint Training all over the UK. We customize our Microsoft SharePoint Training to match our client’s specific requirements... Learn about: Create mobile, Microsoft sharepoint, SharePoint courses...

...Following a person, Stop following a person, Searching for people to follow, Search for a person by name, Search for a person by keyword, Updating your status... Learn about: Office IT, Team sites, Ms Office...