GCOM Solutions courses

...G Com Solutions Limited deliver onsite Microsoft Access Advanced all over the UK. We customize our Microsoft Access Advanced to match our client’s specific requirements... Learn about: Exporting Data, Data Macro, Microsoft Access...

...Aligning Objects, Using Building Blocks Working With Tables Creating A Table, Formatting A Table, Entering Text Into A Table, Inserting Rows And Columns... Learn about: Font & Font Size, Rearranging Text, New Publication...

...Opening An Existing Workbook, Navigating A Worksheet, Creating A New Workbook, Saving A New Workbook, Moving Between Workbooks, Setting Excel Options... Learn about: Cell styles, MS Excel, Average Functions...

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

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

...Applying a Manual Filter, Including New Items in a Manual Filter, Filtering by Selection, Showing Top and Bottom Items Using Slicers and Timelines Understanding slicers... Learn about: Insurance Policy, PivotTable Style, Report Filter...

...to generate date and time values Database functions How database functions work, Defining the Excel database, Defining the criteria area, Using AND and OR with your criteria... Learn about: MS Excel, Microsoft Excel, Database training...

...Excel date/time capabilities in formulas; Using TODAY and NOW functions for dynamic date/time entry; Identifying the day of the week with WEEKDAY... Learn about: Tabulating blank, Text Functions, MS Excel...

...This introductory Excel VBA Training Course shows delegates how to create and customise macros and gives them a basic familiarity with the Visual Basic for Applications environment... Learn about: MS Excel, Adding comments, Visual Basic training...

...Adding a TextBox control, The CheckBox control, The OptionBox control, ComboBox and ListBox, SpinButton controls, Adding CommandButtons, Setting control... Learn about: Alerts property, Dialogue boxes, Cut Copy...

...Types of end-user, Analysing end-user needs, Planning an application, Planning the user interface Working with events Overview of event types... Learn about: Formatting Cells, Data Visualizations, MS Excel...

...Microsoft Visio Training in Peterborough, Cambridgeshire. Our Microsoft Visio training shows users how to create a variety of different diagrams and drawings... Learn about: Network drawing, Web site maps, Office plans...

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

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

...templates and styles; columns and tables; working with graphics; using mail merge; working with document sections; and workgroup collaboration. Templates... Learn about: Totaling Rows, Quick styles, Sorting Data...

...Documents Understanding Master Documents, Creating a Master Document, Viewing and Collapsing Subdocuments, Editing Subdocuments, Modifying the Master Document’s Structure... Learn about: Microsoft Word, Embedding Data, Data Sharing...

...Defining and Calling Functions, Passing Arguments, Using Optional Arguments, Variable Scope, Using VBA Functions Conditionals, Loops and Arrays If Statements... Learn about: Visual Basic training, Ms Word, VBA Macro...

...Manipulating connectors, Using the connector tool, Using control handles, Adding connection points working with text Adding text to shapes, Creating text-only shapes... Learn about: Connector tool, Adding master, Page setup...

...Microsoft SharePoint is a highly sophisticated, web development platform which allows collaboration, document management, version control and much... Learn about: Empower teamwork, Microsoft sharepoint, SharePoint courses...

...Organizing items by using folders Working with Documents Create a document library, Opening and saving Office documents, Uploading and creating documents in the library... Learn about: Team Training, Office IT, Ms Office...