GCOM Solutions courses

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

...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, New Publication...

...Spell Checking Your Worksheet, Inserting Symbols Editing A Worksheet Working With Ranges, Copying And Pasting Data, Using The Office Clipboard... Learn about: Average Functions, Cell borders, 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: Totaling Data, MS Excel, Chart Text...

...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: Data tables, Custom Filters, MS Excel...

...a Pivot Table Controlling the Report Layout, Adding Blank Rows in the Layout, Using a Pivot Table Style, Adding Row and Column Shading, Formatting the Row and Column Headers... Learn about: PivotTable Style, Table Layout, Insurance Policy...

...#DIV/0!, #NAME, #REF, #NULL!, #N/A, Using conditionals to anticipate error values, Using IFERROR(), Using the formula error checker, Auditing a worksheet... Learn about: Database training, IT Auditing, Microsoft Excel...

...Using the INT and TRUNC functions to extract integer data; Finding the remainder with MOD and using MOD with conditional formatting; Practical uses... Learn about: MS Excel, Blank cells, Tabulating blank...

...Basics Excel VBA overview, Understanding macro steps, Modifying macro steps, Calling one macro from another, Storing values in variables, Adding comments to your... Learn about: Visual Basic, Adding comments, Value of cells...

...Excel object model About classes and objects, Objects and collections, The hierarchy of objects, Properties, methods and events, The Locals Window... Learn about: Alerts property, Dialogue boxes, MS Excel...

...Adding Color Scales to a Range, Adding Icon Sets to a Range, Specifying an Icon Set, Specifying Ranges for Each Icon, Creating an Icon Set for a Subset of a Range... 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 Training, Web site maps, Microsoft Visio...

...Our Advanced Visio course shows users with some experience how to use more sophisticated features such as styles, templates, stencils, master shapes and background pages... Learn about: Adding a hyperlink, Smartshape wizard, Layer properties...

...Setting Margins, Setting Page Orientation, Setting Paper Size, Inserting/Modifying Page Numbers, Inserting And Removing Page Breaks, Inserting A Watermark... Learn about: Correcting Mistakes, 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, Microsoft Word, Totaling Rows...

...available in Word for creating and managing long documents. A good knowledge of all of Word’s basic and intermediate features is assumed. Copying... Learn about: Microsoft Word, Updating Fields, Ms Word...

...Number Variables, Date Variables, Declaring Constants, Using Object Variables, Variables Versus With Statements Subroutines and Functions Defining and Calling Subroutines... Learn about: Macro Recorder, Macro Security, Access Toolbar...

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

...and seamlessly collaborate across the organization... Learn about: Microsoft sharepoint, Manage content, Empower teamwork...

...Drag multiple documents to a library, Upload multiple files with Explorer, Checking documents in and out, Sharing documents, Moving documents... Learn about: Team sites, Office IT, SharePoint roles...