GCOM Solutions courses

...This course is suitable for those with prior experience and covers: working with tables; working with charts; working with graphics; workgroup collaboration... Learn about: Financial Training, Excel Intermediate on-site training, MS Excel...

...Functions Creating reports Working in report view Creating tables and key metrics Working with matrixes Filtering data with slicers Creating visualizations... Learn about: Creating relationships, Power BI, Power BI Desktop on-site training...

...Grouping Worksheets, Changing Worksheet Tab Colors, Using 3-D Formulas & References... Learn about: MS Excel, Excel on-site training, Excel training...

...Delegates will be given an introduction into XML, DTDs and XSLT as well as importing and exporting XML into and out of InDesign. Fundamentals About markup languages... Learn about: InDesign and XML in-house training, XML training, InDesign and XML training...

...Using The Tools Panel, Using Photoshop Panels, Changing Screen Modes, Using The Zoom Tool And The Navigator Panel, Using The Undo & Step Backward Commands... Learn about: Color Scheme, Editing Tools, Changing Screen Modes...

...and the Power BI Service. You will be able to use the Query Editor to transform and morph data into the right format for your reporting purposes... Learn about: Excel training, Business Intelligence, Data marts...

...and out of Microsoft Excel. You will learn how to use XML mapping to target specific parts of the XML documents you are importing. You will learn how... Learn about: XPath 2.0, Microsoft Excel, Microsoft excel training...

...Variables 2. Variable Data Types 3. String Variables 4. Number Variables 5. Date Variables 6. Declaring Constants 7. Object Variables 4. Subroutines and Functions... Learn about: Ms Word, Programming Application, Excel training...

...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: Ms Word, Microsoft Office, Microsoft Word...

...Sign up for the free trail version of this course. If it meets with your expectations, then enroll for the full course. 1. Getting Started Download course practice files... Learn about: Visual Basic training, Object-oriented programming, MS Excel...

...The IFERROR Function 3. Nested IF Statements 4. The OR Function 5. The AND Function 3. Conditional Number Crunching Functions 1. The COUNTIF Function... Learn about: Microsoft Excel, Visual Basic 6, Microsoft Office...

...in a cell dependent on the results of logical tests. • We then see how conditional functions can be combined with mathematical functions; using COUNTIF... Learn about: Excel for Accounting, VBA (Microsoft Access / Office), Microsoft Office...

...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: How to use Excel, Microsoft Office, Excel for Accounting...

...to start using Power BI with confidence. By the end of the course, you will be confident in using the three main components of Power BI: Power BI Desktop... Learn about: Web URL, Power BI Service, Folder of data...

...its shape, its dimensions and how you can use page backgrounds to add impact to your reports. We also discuss the use of a percentage-based grid and... Learn about: Details Table, DAX Implicit Measures, Adobe Photoshop...

...and make strategic use of indentation. This makes it easier to read complex formulas, since it helps to make it clear when one function is nested inside another... Learn about: Optimizing Lookup, Nesting VLOOKUP, Excel Formulas...

...the meaning of each line is apparent from the syntax, rather than becoming more and more unfamiliar. The course also demonstrates how to get the maximum benefit from IntelliSense... Learn about: Excel VBA, VBA Code, Visual Basic...

...Editing a Recorded Macro 9. The Benefits and Limitations of the Macro Recorder 2. Writing Macros in the Visual Basic Editor 1. Understanding the Project Explorer... Learn about: Ms Word, Access Toolbar, VBE Options...

...Creating new attributes 6. Using xsl-if 7. Using xsl:choose 8. Using attribute value templates... Learn about: Microsoft excel training, MS Excel, XML Document...

...of using functions to analyze your data, beginning with every day functions like SUM, AVERAGE, MIN and MAX. We then examine the use of text functions... Learn about: Excel Formula, CHAR function, TRIM Function...