GCOM Solutions courses

...Deleting Rows And Columns, Formatting A Table, Totaling Data In A Table, Sorting Data In A Table, Sorting Multiple Columns, Filtering Data Using Autofilter... Learn about: Financial Training, Excel Intermediate in-house training, MS Excel...

...Creating column and bar charts Creating line and area charts Creating scatter charts Treemap visualizations Using charts as slicers Using maps with geographical... Learn about: Data sources, MS Excel, BI Desktop...

...Merging Cells And Centering Text, Adding Cell Borders, Applying Colors And Shading To Cells, Applying Cell Styles, Hiding And Unhiding Rows And Columns... Learn about: Excel training, Excel on-site training, Office IT...

...Embedding style names in XML files, Creating repeating elements, Using XSL stylesheets Using DTDs Industry-standard DTDs, Importing DTDs, Validating documents... Learn about: InDesign and XML in-house training, InDesign and XML training, XML training...

...Changing The Color Scheme, Creating A New Image, Saving Your WorkOn Your Own Working With Colors And Painting Setting The Foreground And Background Color... Learn about: Changing Screen Modes, Editing Tools, Color Scheme...

...You will learn how to share dashboards and reports, with colleagues, business partners and potential clients. And how to use Power BI’s sophisticated security... Learn about: Database Design, Excel Formula, Microsoft Excel...

...This course is designed for experienced Excel users who are used to working with formulas and functions. No knowledge of XML, XPath or XSLT is assumed... Learn about: Microsoft excel training, Microsoft Excel, Microsoft Office...

...The Word VBA video tutorials in this course are designed to give you all the ammunition you'll need to start creating your own custom macros to automate... Learn about: Ms Word, Microsoft Word, Microsoft Office...

...have a look at the Udemy course "Microsoft Word VBA Macro Programming – Introduction". This advanced Word VBA course carries on from where the above Introductory course finishes... Learn about: Microsoft Word, Ms Word, Microsoft Excel...

...Deleting Files And Folders 7. Processing All Files In Folder 8. Worksheets and Charts 1. Targeting Worksheets Efficiently 2. Copying Worksheets... Learn about: Visual Basic, Object-oriented programming, Programming Application...

...This course is suitable for those with a basic knowledge of Excel, who have perhaps had some basic training in using the program, or those who are self-taught... Learn about: Visual Basic 6, Microsoft Excel, VBA (Microsoft Access / Office)...

...This course provides clear and easy-to-follow instructions on how to build formulas for analysis, projection and data cleansing. • The course starts... Learn about: Excel training, Office IT, Excel Formula...

...The drill can either be performed with the keyboard only or using standard Ribbon commands with the mouse. Drill 2: Reverse sheets This drill tests your Excel dexterity... Learn about: MS Excel, Microsoft Office, Excel Formula...

...Power BI Desktop the Power BI Service and Power BI Mobile Apps. 1. Welcome 1. Welcome to Microsoft Power BI Introduction 2. Download the Course Files Here... Learn about: Microsoft Power, Query editor, Excel data...

...Calculating Issues Resolved for the Entire Year 5. Calculating Employee Rating for the Entire Year Section 5: Creating the Filtered Visuals... Learn about: Details Table, SLA breakdown, DAX Implicit Measures...

...for example displaying the user’s Windows login name, or the names of all the worksheet tabs; or displaying information from the folder in which a workbook is saved... Learn about: Nesting VLOOKUP, Optimizing Lookup, Excel Formulas...

...Improving a recorded macro 13. Assigning a macro to a button 14. Testing a macro on another worksheet 2. Key Components of VBA Code 1. The Excel object model... Learn about: VBA Code, MS Excel, Visual Basic...

...2. Working with Document Events (Part 2) 3. Using Built-in Dialogs 4. Creating a User Form (Part 1) 4. Creating a User Form (Part 2) 5. Creating User Form Event Handlers... Learn about: VBA Windows, Access Toolbar, . Variable Data...

...as well as the validation of XML data, using schema documents, both on import and export. Next, we explore online XML, as we use Excel's WEBSERVICE... Learn about: XML Document, Microsoft excel training, MS Excel...

...clean up data prior to creating reports; functions like TRIM, UPPER, LOWER, PROPER, LEFT, RIGHT, MID and CONCATENATE. Next, we turn our attention to conditional... Learn about: CHAR function, Basic Formulas, Mixed References...