GCOM Solutions courses

...Queries About Action Queries, Creating A Make-­‐Table Query, Creating An Append Query, Creating An Update Query, Creating A Delete Query Importing And... Learn about: Delete Query, Exporting Data, Data Macro...

...Resizing Images, Cropping Images, Adding A Border Around An Image, Adjusting Brightness & Contrast, Applying Picture Quick Styles To Images... Learn about: New Publication, Rearranging Text, Font & Font Size...

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

...Web Page Preview, Converting Worksheets Into Web Pages, Inserting Hyperlinks, Viewing And Editing Comments Financial & Logical Functions Using The If Function... Learn about: Chart Text, MS Excel, Financial Training...

...working with macros; data analysis tools; techniques for summarizing data; and performing what-if data analysis. Lookup and Reference Functions Nesting VLOOKUP functions... Learn about: Advanced Filters, Data tables, Pivottable Data...

...Applying Conditional Formatting, Setting Format Options Pivot Charts and Graphics Creating a Default Pivot Chart, Creating a Line Pivot Chart... Learn about: PivotTable Style, Insurance Policy, Grand Totals...

...Applying names to formulas, Understanding external references Working with functions Inserting functions, Supplying function arguments, Supplying range arguments... Learn about: IT Auditing, MS Excel, Microsoft Excel...

...Using INDIRECT with data validation for two-tiered pick list scenarios; 11. Text Functions; Locating and extracting data with FIND, SEARCH, and... Learn about: MS Excel, Excel date, Tabulating blank...

...Stepping through macros, Getting help on macros Objects, properties and methods About Excel objects, Using the Object Browser , Range object... Learn about: Targetting cells, Visual Basic training, Visual Basic...

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

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

...Inserting fields, Embedding an object, Linking an object Working with shapesheets Understanding the shapesheet, Changing shapesheet properties... Learn about: Microsoft Visio, Adding a hyperlink, Layer properties...

...Using HelpOn Your Own Editing Text Selecting Text, Copying And Pasting Text, Cutting And Pasting Text, Using Drag-And-Drop, Using The Office Clipboard... Learn about: Ms Word, Font Dialog Box, Microsoft Word...

...Creating A New Style, Modifying A Style, Managing StylesOn Your Own Columns And Tables Creating Columns, Adding A Column Break, Modifying Column Layout... Learn about: Column Width, Totaling Rows, Quick styles...

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

...Assigning a keyboard shortcut to a macro, Editing a Recorded Macro, The Benefits and Limitations of the Macro Recorder Writing Macros in the Visual Basic... Learn about: Access Toolbar, Macro Programming, Macro Security...

...Closing a Visio file, Using print preview, Using page setup, Printing a drawing Creating a drawing Starting a drawing, Adding master shapes to a drawing... Learn about: Connector tool, Master shapes, Microsoft Visio...

...and seamlessly collaborate across the organization... Learn about: SharePoint courses, Microsoft sharepoint, Empower teamwork...

...Saving a site as a template List and library essentials Add an app on SharePoint, Add an app from the SharePoint Store, Create a list or library... Learn about: Team sites, Office IT, SharePoint products...