GCOM Solutions courses

...Creating A Macro Group, Using A Macro Group, Using Macro Conditions, The Autoexec Macro, Creating An Autokeys Macro, Creating A Data MacroOn Your Own Action... Learn about: Microsoft Access, Macro Actions, Database training...

...Wrapping Text Around Images, Inserting Clip Art, Adding Shapes, Inserting And Modifying Wordart, Grouping Objects, Layering Objects, Rotating Objects... Learn about: Font & Font Size, Rearranging Text, Microsoft Publisher...

...page setup and printing; working with pages; formulas and functions; and modifying workbooks. Excel Basics Creating An Excel Workbook, Examining The Excel Environment... Learn about: Average Functions, Page Breaks, Cell styles...

...Enter Data Into A Table, Deleting Rows And Columns, Formatting A Table, Totaling Data In A Table, Sorting Data In A Table, Sorting Multiple Columns... Learn about: Financial Training, MS Excel, Deleting Rows...

...Saving A Workbook With Macros, Opening A Workbook With Macros, Adding A Macro To The Quick Access Toolbar Pivot Tables, Slicers and Timelines Setting Pivottable Options... Learn about: Pivottable Data, Data tables, Optimizing Lookup...

...day course is designed for experienced Excel users who will be using pivot tables extensively in their work. Delegates will learn how to use this powerful... Learn about: Grand Totals, Insurance Policy, Pivot table...

...Calculating the tme between two dates using DATEDIF(), Calculating elapsed time , Creating time sheets Maths functions ROUND() and MROUND()... Learn about: IT Auditing, Microsoft Excel, Database training...

...Practical uses for the random number functions RAND and RANDBETWEEN; Converting a value between measurement systems with CONVERT; Using the powerful AGGREGATE... Learn about: Text Functions, MS Excel, Blank cells...

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

...Our Excel VBA Level 2 course is designed for experienced Excel users who have already begun to create macros and know their way around Excel’s Visual Basic Editor... Learn about: Alerts property, Dialogue boxes, MS Excel...

...Formatting Cells in the Top 10 or Bottom 5 File manipulation Opening a text file, Writing a text file, Importing data from a text file, Searching for text in files... Learn about: Color Scales, Data Visualizations, MS Excel...

...suitable for beginners and experienced users, respectively; and we can also organise in-house training anywhere in the... Learn about: Network drawing, Web site maps, Office plans...

...Delegates will also learn to add images to a diagram, work with layers and be shown the various commands for merging shapes as well as working with shapesheets and hyperlinks... Learn about: Report wizard, Layer properties, Microsoft Visio...

...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: Setting Printer Options, Microsoft Word, Correcting Mistakes...

...Templates And Styles Using Existing Templates, Creating A Template, Modifying A Template, Applying Quick Styles, Changing The Style Set, Creating A Style... Learn about: Microsoft Word, Deleting Rows, Column Layout...

...Documents Outline Basics, Viewing and Organizing the Outline, Numbering Outline Items, Printing or Copying an Outline, Using AutoSummarize Using Master... Learn about: Data Sharing, Embedding Data, Ms Word...

...Model Understanding the Word Object Model, Working with Object Methods, Working with Object Properties, Referring to objects within a collection... Learn about: Visual Basic, Macro Programming, VBA Macro...

...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: Adding master, Page setup, Microsoft Visio...

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

...Add a validation rule to a column, Add a validation rule to a list, Sorting and filtering lists, Creating and selecting a list view, Sorting or filtering a list... Learn about: Team sites, Office IT, SharePoint products...