GCOM Solutions courses

...Using Rectangles, Lines And Borders Database Tools And Maintenance Using Compact And Repair, Changing Database Properties, Documenting A Database... Learn about: Macro Actions, Microsoft Access, Delete Query...

...This course is designed for beginners and covers: publisher basics; working with pages; working with text frames; editing & formatting... Learn about: Font & Font Size, Microsoft Publisher, Rearranging Text...

...Printing Adjusting Margins, Setting Page Orientation, Setting Paper Size, Defining A Print Area, Printing Worksheet Titles, Forcing A Worksheet To... Learn about: Average Functions, Cell styles, Cell borders...

...financial & logical functions; financial and logical functions; date and time functions; and managing workbooks. Working With Tables Creating A Table... Learn about: MS Excel, Chart Text, Totaling Data...

...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: Optimizing Lookup, Data tables, MS Excel...

...Deleting a Pivot Table Summarizing Data Using the Summary Functions, Showing or Hiding Grand Totals, Creating Subtotals, Grouping Numbers and Dates Formatting... Learn about: Report Layout, Grand Totals, MS Excel...

...Functions are at the core of Microsoft Excel and provide much of its power. However, many users find working with functions and formulas confusing and frustrating... Learn about: Database training, MS Excel, IT Auditing...

...the MATCH function for complex lookups Reference Functions Getting data from remote cells with OFFSET; Returning references with INDIRECT; Using INDIRECT... Learn about: Text Functions, Excel date, Blank cells...

...Best practices are introduced from the outset and delegates are encouraged to learn VBA by understanding its key principles, rather than simply memorising syntax... Learn about: Value of cells, Targetting cells, Visual Basic training...

...Setting control properties Workbooks and worksheets The Workbooks collection, The Sheets collections, The Window objects, Workbook events Ranges and names Column and Row properties... Learn about: MS Excel, Dialogue boxes, Alerts property...

...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: Data Visualizations, Formatting Cells, Microsoft Office...

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

...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: Microsoft Visio, Smartshape wizard, Adding a hyperlink...

...Inserting Symbols Formatting Text Using Formatting Tools, Using The Font Dialog Box, Using Format Painter, Using Character Effects, Using Text Effects... Learn about: Correcting Mistakes, Setting Printer Options, Page Breaks...

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

...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: Embedding Data, Updating Fields, Ms Word...

...Our Word VBA Programming course shows experienced users how to automate Word workflows with the creation of macros using Microsoft Visual Basic for Applications (VBA)... Learn about: Macro Recorder, VBA Macro, Visual Basic...

...the stacking order of shapes, Grouping and ungrouping shapes, Changing double-click behaviour... Learn about: Microsoft Visio, Connector tool, Page setup...

...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: Microsoft sharepoint, Create mobile, SharePoint courses...

...Subscribing to a blog’s RSS Feed, Using desktop blogging tools to publish blog posts, Publish a blog post by using Microsoft Word... Learn about: Team sites, SharePoint products, Ms Office...