GCOM Solutions courses

...formatting numbers; working with ranges; working with macros; customizing excel; data analysis tools; summarizing data; what-if data analysis... Learn about: Excel Advanced on-site training, Excel Advanced training, XML training...

...Refreshing All Pivot Tables in a Workbook, Retaining Deleted Items, Changing an Access Data Source, Refreshing the Pivot Table Regularly, Saving Source... Learn about: Excel Pivot Tables training, MS Excel, Excel Pivot Tables in-house training...

...Writing a text file, Importing data from a text file, Searching for text in files, Verifying if a file exists, Listing all files in a given folder Class... Learn about: Excel training, Excel on-site training, Excel in-house training...

...Using the VBA debugger, Making decisions, If statements, Select Case, Looping structures, Different types of loops, Manipulating arrays Interactivity Assigning... Learn about: Visual Basic, MS Excel, Visual Basic training...

...Saving And Opening Attachments E-Mail Management Marking Messages As Unread, Flagging Messages, Using Categories, Arranging Messages, Deleting Messages... Learn about: Outlook in-house training, Using Reading View, Email Message...

...Inserting A Word Document Into A Slide, Adding Audio To Slides, Adding Video To Slides, Trimming Video, Formatting Video, Exporting A Presentation To... Learn about: PowerPoint Advanced in-house training, Ms PowerPoint, PowerPoint Advanced training...

...and finalizing the plan. This course is designed for beginners and covers: the basics; working with tasks; linking & scheduling tasks; resources & costs... Learn about: Setting Project Options, Launching Microsoft Project, Project training...

...Creating Custom Tables, Creating Custom Views, Creating Custom Groups, Using Drawing Tools, Creating A Macro, Running A Macro... Learn about: Copy Picture Command, Filtering Tasks, Displaying Variances...

...Printing A Document Previewing A Document, Setting Printer Options, Printing An Envelope, Printing Labels... Learn about: Word in-house training, Word training, Ms Word...

...Creating Custom Tables, Creating Custom Views, Creating Custom Groups, Using Drawing Tools, Creating A Macro, Running A Macro... Learn about: PowerPoint training, Ms PowerPoint, PowerPoint on-site training...

...Linking Camera Focus Distance To A Layer, Behaviors And Presets That Use Expressions, Scripts For Editing And Adding Expressions Reacting To Sound Creating... Learn about: After Effects Expressions training, After Effects training, After Effects Expressions in-house training...

...With Applications Opening Applications From The Start Screen, Switching Between Programs, Opening And Closing A Document, Entering And Editing Text In Wordpad... Learn about: Windows 10 on-site training, Windows 10 training, Internet searching...

...techniques and introduces them to the Microsoft Word object model. By the end of the training, delegates will know how to write VBA macros from scratch... Learn about: Visual Basic, Word VBA in-house training, Word VBA training...

...This basic SharePoint training course is aimed at anyone who will be working within the SharePoint environment, either as a user or an administrator... Learn about: Basic IT, SharePoint training, SharePoint in-house training...

...Calculated Fields Using DAX aggregate functions in a PowerPivot PivotTable Using CountRows and DistinctCount Functions The difference between evaluations... Learn about: Excel on-site training, Excel training, MS Excel...

...Publishing And Sharing Forms, Using Forms Effectively Using Templates Working With E-Mail Templates, Using Other Outlook Template Types, Editing Templates... Learn about: Outlook Advanced training, Outlook Advanced in-house training, Outlook Advanced on-site training...

...Using Track MattesUnderstanding Animation, Adding And Adjusting Keyframes, Understanding Keyframe Interpolation, Adjusting Keyframes In The Graph Editor... Learn about: IT Project Management, Project Management, After Effects...

...users will be confident in using Visio to create basic diagrams and drawings. Our Introduction to Visio course assumes no prior knowledge of the program... Learn about: Using print preview, Creating a drawing, Visio on-site training...

...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: Advanced Visio, Intersect command, Creating a master shape...

...Adding A Picture From A File, Adding Shapes, Formatting Drawing Objects, Resizing And Moving Objects, Adjusting Graphics, Cropping Images, Applying Picture Styles To Images... Learn about: Word Intermediate in-house training, Ms Word, Word Intermediate training...