office@goforth.eu Sofia, Bulgaria

Trainings

Excellent user scores

Excellent user scores

Our trainings receive average user scores in the 9 out of 10 range

Step-by-step Guides

Step-by-step Guides

Every participant receives detailed step-by-step guides to always be able to rehearse the course contents.

Personal Attention

Personal Attention

Every course attendant can ask questions freely and receive personal attention during the training

Small groups

Small groups

Trainings are conducted for small groups of up to 10 people to ensure that everyone receives the attention they deserve.

Feedback matters

Feedback matters

Every participant submits feedback and evaluates the course,  which is always taken into account when adjusting course contents and teaching style.

Certificate of Completion

Certificate of Completion

A certificate of completion can be issued out to each participant on request.

Available courses

The contents of the courses presented below should only be taken as guidelines. All courses can be changed on demand and entirely new courses can be created specifically according to your needs! Modules can be freely removed, adapted or added to a course on demand.

Simply cotact us and we will craft a solution just for you! Contact Us

Ms Excel

In this course, learn about:

  • The basic elements of Ms Excel
  • The fundamentals of data entry and formula/ function usage
  • Opening, closing and saving a workbook
  • Changing sheet names
  • Using statistical functions
  • Inserting graphs, graph types
  • Resizing, moving and formatting graphs
  • Adding, removing and formatting chart elements
  • Using the IF function
  • Creating nested IF functions
  • Using the AND & OR functions
  • Data Sorting and Data Filtering
  • Excel Reference Types and their uses

… and more!

In this course, learn about:

  • Using advanced filters to filter out duplicate values
  • Using advanced statistical functions such as AVERAGEIF and RANK
  • Using the IF functions in conjunction with MIN and MAX
  • The basics of PivotTables
  • Inserting PivotTables (using shortcuts)
  • Using the Value Field Settings menu in PivotTables
  • Conditional formatting
  • Using the VLOOKUP function
  • Problems with the VLOOKUP function
  • Other lookup functions – INDEX and MATCH

… and more!

In this course, learn about:

  • How to produce descriptive statistics with functions
  • Install and use the Data Analysis ToolPak
  • Install and use a third-party statistical add-in
  • Use named ranges for quick navigation and more
  • Create a dynamic chart
  • Create VBA Combo Boxes and other controls
  • Use the INDEX function for data extraction
  • Produce a dynamic histogram using three different methods
  • Effectively use the VLOOKUP function
  • Use additional statistical functions

… and more!

In this course, learn about:

  • How to quickly inset a PivotTable
  • How to insert and use Filters
  • How to use Slicers
  • How to use multiple Slicers
  • How to connect multiple Slicers to multiple PivotTables
  • Using PivotCharts
  • Grouping of Dates
  • Grouping of Numbers
  • Converting Row labels to Tabular form
  • Using Timelines
  • Formatting of values
  • Performing advanced calculations with the PivotTable
  • Revealing the data used by the PivotTable
  • Creating Report Filter Pages
  • Using Calculated Fields
  • Using the Data Model to combine PivotTables

… and more!

In this course, learn about:

  • What is VBA
  • The Ms Excel object model
  • How to record a macro
  • Using the Developer Tab
  • Running a macro
  • Creating buttons to run macros
  • Add macros to the Quick Access Toolbar
  • Using and understanding the Visual Basic Editor
  • Where to find the code
  • Understanding the code structure
  • The basics of debugging
  • Saving a file containing a macro
  • Using Message Boxes and Input Boxes
  • The types of Message boxes and their properties
  • Interacting with the user
  • The structure of Input boxes and their properties

… and more!

In this course, learn about:

  • Declaring variables
  • The types of variables
  • Using the Option Explicit statement
  • Using If – Then – Else statements for data analysis, modification and filtering in Excel
  • Using For – Next loops for data analysis, modification and filtering in Excel
  • Using the Locals window to track variables’ behavior
  • Running the code in Break Mode and using Code Breaks
  • Searching within the code
  • Using Do Until and Do While loops for data analysis, modification and filtering in Excel

… and more!

In the following modules, learn about:

Module 1: Form Controls and ActiveX Controls

  • Using Form Controls and ActiveX Controls to create a custom user dashboard
  • Manipulating the properties of ActiveX Conrols using VBA code

Module 2: Creating and Using UserForms

  • What are UserForms?
  • Creating a UserForm
  • Manipulating the properties of controls from the Toolbox
  • Creating lists for ComboBoxes
  • Creating buttons and linking code to them
  • Feeding UserForm code to macros and executing it

Module 3: Arrays and Matrices

  • Working with variables of multiple dimensions
  • Populating and extracting data from arrays

and much more!

Excel Special Courses

In this course, learn about:

  • The fundamentals of simulation and its uses
  • Its benefits over other methods
  • Monte Carlo simulation outside of Excel – the top-hat method
  • Building a Monte Carlo simulation model in Excel
  • Defining the simulated system and its necessary elements
  • Preparing the model with formulae and functions
  • Generating random numbers with functions
  • Different statistical distributions and their use in simulation
  • Creating a macro to run the model once
  • Creating a macro to run the model multiple times
  • Interpreting the simulation results
  • Deriving the necessary statistics after n simulations
  • The warm-up period and why it’s important
  • Changing model parameters and the effect on results

… and more!

In this course, learn about:

  • The basics of Linear Programming
  • The SIMPLEX algorithm
  • Formulating the problem and deriving a solution
  • Defining decision variables, objective and constraints
  • Building the model
  • The Solver Add-in
  • How to install and use the Solver Add-in
  • Using macros to run Solver
  • Adding Solver functions to the library

and much more!

Open Office Calc

In this course, learn about:

  • The Open Office Calc fundamentals
  • The basic elements of Open Office Calc
  • Opening, closing and saving a file
  • Changing sheet names
  • Using basic statistical functions
  • Creating and formatting graphs
  • Adding, removing and formatting chart elements
  • Creating histograms and scatterplots
  • Using the IF function
  • Creating nested IF functions
  • Using the AND & OR functions
  • Using absolute and relative references

… and more!

In this course, learn about:

  • Understanding and manipulating data
  • Using advanced filters to filter out duplicate values
  • Using advanced statistical functions
  • Using the IF function in conjunction with MIN and MAX
  • The basics of using PivotTables
  • Conditional Formatting

… and more!

Ms PowerPoint

In this course, learn about:

  • The fundamentals of PowerPoint
  • Opening, closing and saving a file
  • Inserting and manipulating objects in the presentation
  • Inserting a title slide and choosing a theme
  • Inserting a slide number
  • Inserting and formatting images
  • Inserting and working with shapes
  • Inserting and working with SmartArt
  • Inserting and formatting graphs
  • Adding and working with animations
  • Adding and working with transitions
  • Adding and working with hyperlinks

…and more!

In this course, learn about:

  • Working with templates
  • Choosing colors, styles and fonts
  • Using the Slide Master
  • Creating a template
  • Reusing slides from an existing presentation
  • Using the Outline View
  • Creating slides from an Ms Word Outline
  • Creating slides from an existing Ms Word document
  • Creating slides from a text file
  • Creating a Custom Slide Show
  • Recording a presentation
  • Managing slide timings, rehearsing and recording options
  • Exporting a presentation as a video file
  • Using the screen recording function
  • Exporting the screen recording as a video file
  • Tracking changes made to a presentation
  • Accepting and rejecting changes
  • Using third-party productivity add-ins
  • Instantly resizing objects
  • Instantly mapping objects to specific coordinates on slide
  • Inserting automated GANTT diagrams
  • Importing icon sets, pre-made infographics
  • Instantly replacing fonts in presentations
  • Creating magnifying glasses, zoom and re-coloring effects

… and more!

In this course, learn about:

  • The latest trends in PowerPoint template and slide design
  • Using the Morph Transition and shape manipulation
  • Removing background from images
  • Merging shapes for use with morph
  • Creating a puzzle effect with Morph
  • Creating the parallax effect
  • Creating motion paths and working with them
  • Creating video slides
  • Adjusting video playback settings
  • Creating custom text Picture Holders
  • Creating custom Picture Holders from shapes
  • Using brush fonts
  • Converting text to shapes and shapes to Picture Holders
  • Using Zoom
  • Creating overview slides with zoom-in areas

… and more!

Ms Word

In this course, learn about:

  • The fundamentals of Ms Word
  • Working with and changing the Quick Access Toolbar
  • The File menu, overiew of Ms Word Options
  • Opening, closing and saving a file
  • The fundamentals of entering and editing text
  • Using shortcuts
  • Undertanding the paragraph marker
  • Creating random text
  • Searching for text and navigation within the document
  • Text formatting
  • Adding bulleted and numbered lists
  • Working with Styles, changing Styles and creating new Styles
  • Changing the Page Layout
  • Working with Page breaks and Section breaks
  • Changing the page orientation
  • Adding Headers and Footers
  • Adding watermarks and changing the background
  • Working with Autocorrect
  • Working with Find & Replace
  • Working with the Word Spell Checker
  • Printing the document
  • Saving the file as a PDF
  • Automatically attaching the document to an email and sending it
  • Working with Tabs
  • Adding and formatting Tabs
  • Adding Tab Stops, types of Tab Stops
  • More Tab Stop options, removing Tab Stops
  • Working with Tables
  • Adding calculations to tables, working with formulae
  • Working with Templates
  • Creating and saving a template
  • Loading and modifying a template

… and more!

In this course, learn about:

  • Organizing the document using the Heading Styles
  • Creating an Outline using Heading Styles
  • Rearranging the document content using the style
  • Working with the Outline View
  • Inserting online and offline images to the document
  • Resizing and cropping images
  • Adding borders and additional effects to an image
  • Using Text Wrapping
  • Embedding a video into the document
  • Working with Mail Merge
  • Creating a Data Source for the Mail Merge
  • Creating Mailing Labels
  • Creating Form Letters
  • Creating Word Forms
  • Introduction to the Developer Tab
  • Working with Text Boxes, Radio Buttons, Combo Boxes and Check Boxes
  • Protecting the file
  • Adding and removing different types of protection to the document
  • Using the Review menu
  • Using the Track Changes menu
  • Adding and removing comments
  • Adding an automatic Table of Contents
  • Formatting and updating the Table of Contents
  • Adding Footnotes
  • Using the Citation Manager
  • Creating an automatic Bibliography
  • Working with Captions and Cross-References
  • Adding a Table of Figures
  • Adding Cross-References
  • Adding an Index to the document
  • Marking words to add to the index
  • Working with Ms Word Add-ins

… and more!

Google Analytics

In this course, learn about:

Setting up Google Analytics, Google Analytics Basics

  • Google Analytics basics, Google analytics key terms and concepts
  • How to create a Google Analytics account
  • Using the Google Analytics demo account
  • Basics of Accounts, Properties and Views
  • Account User Management
  • Creating and managing Views
  • Using Exclude filters to remove internal and spam traffic
  • Using include filters to monitor specific traffic
  • Setting up Goals, Goals basics

Basics of Google Analytics Reporting

  • Working with Realtime reports
  • Working with Audience reports to understand audience composition
  • Working with Acquisition reports to understand traffic sources and channels
  • Working with Behavior reports to better understand users’ behavior
  • Working with Conversions reports to track goal completions

Basics of Google Analytics customization

  • Creating and using Dashboards
  • Creating and using Custom reports
  • Setting up custom alerts
  • Creating and using Segments

… and more!

In this course, learn about:

Advanced Audience reports

  • New vs Returning users
  • Frequency and Recency reports
  • Engagement reports
  • Working with User Explorer reports to analyze user behavior in-depth

Advanced Acquisition reports

  • Setting up marketing campaign tracking using UTM parameters
  • Tracking campaigns
  • Google Analytics and Google Ads integration
  • Working with the Google Ads reports in Google Analytics
  • Google Analytics and Google Search Console integration
  • Working with the Search console reports
  • Working with Social reports to understand the contribution of social media

Advanced Behavior reports

  • Setting up Site search
  • Using Site search reports
  • Setting up events
  • Using Events reports to track important user actions

Advanced Conversions reports

  • Understanding Attribution models
  • Using Assisted conversions reports

Advanced Google Analytics and Google Ads integration

  • Creating Google Analytics audiences using segments
  • Importing audiences into Google Ads
  • Using Google Analytics Goals to set up Google Ads Conversions

… and more!

Google Ads

In this course, learn about:

Setting up Google Ads, Google Ads fundamentals

  • Google Ads fundamentals
  • Setting up a Google Ads account
  • Managing billing

Setting up a Google Ads Search campaign

  • Understanding the Google Search and Display networks
  • Understanding Google search partners
  • Understanding locations targeting and exclusions
  • Understanding language targeting
  • Understanding Audiences and audience targeting
  • Setting a campaign budget
  • Understanding bidding strategies
  • Setting up Conversions
  • Understanding Ad rotation

Understanding and creating Extensions

  • Types of extensions, extension fundamentals
  • Setting up different types of extensions

Setting up Ad Groups

  • Understanding the Account, Campaign, Ad Group, Ad and Keyword hierarchy
  • Setting up Ad Groups and adding keywords
  • Basics of keyword types
  • Basics of negative keywords

Creating Ads

  • Text ad guidelines and best practices
  • Writing effective and appealing text ads

Basics of Campaign management and reporting

  • Understanding and using Campaign and Ad Groups reports
  • Understanding Ads & extensions reports
  • Understanding Keywords reports
  • Applying and monitoring the effects of changes on existing campaigns
  • Adding and removing Keywords, Ads, AdGroups, Campaigns

… and more!

In this course, learn about:

Keyword Research

  • Keyword theory and match types
  • Using the Keyword Planner tool
  • Using other keyword research tools and practices
  • Creating keywords lists using Ms Excel formulas
  • Creating and applying negative keyword lists
  • Using dynamic keywords

Understanding the Google Ads auction

  • Understanding the Google Ads auction
  • The Quality score and its determinants
  • Understanding Ad Rank and its calculation

Calculating ad profitability

  • Basics of conversion tracking
  • Using profitability metrics (ROAS, ROI)

Adjusting Search campaigns

  • Setting up an Ad schedule
  • Understanding Demographics and making exclusions
  • Introducing new search and negative keywords from search terms
  • Using device targeting
  • Using scripts
  • Importing and targeting audiences from Google Analytics
  • Changing and measuring the effects of bidding strategies

… and more!

Business English

In this course, learn about:

Basic business vocabulary

  • Vocabulary for describing one’s job, occupation and responsibilities
  • Vocabulary for talking about one’s hobbies, interests and plans
  • Vocabulary for describing work relations
  • Vocabulary for understanding key business and managerial concepts

English for interviews

  • Vocabulary for looking for a job, headhunting, recruiting
  • Business small talk
  • Common interview questions and how to answer them
  • Describing one’s strengths and weaknesses
  • Asking questions during interviews

Commonly used English in the workplace

  • Describing common items in the workplace
  • Interacting with colleagues
  • Asking questions, asking for help, giving advice
  • Arranging meetings and appointments, asking for availability

Describing the organizational structure and compensation

  • Describing the structure of the top management
  • Describing functions and departments
  • Describing the ownership structure of a company
  • Describing promotions, demotions and shifts in the structure
  • Describing different types of compensation
  • Describing vacations, medical leave, maternity leave arrangements
  • Describing different types of fringe benefits

Vocabulary for telephone conversations

  • Vocabulary for beginning business calls
  • Taking and leaving messages, clarifying and correcting information
  • Finishing the call
  • Vocabulary for leaving voicemail messages

Presentation skills

  • Vocabulary for structuring the beginning, middle and end of a presentation or talk
  • Vocabulary for presenting positive and negative arguments
  • Vocabulary for describing causes and effects
  • Describing parts, slides, handouts of a presentation
  • Correcting mistakes during a presentation
  • Phrases for connecting ideas

Describing graphs and trends

  • Vocabulary for presenting and describing graphs and charts
  • Vocabulary for describing trends
  • Describing the degree and direction of change
  • Vocabulary for saying numbers, decimals, fractions
  • Vocabulary for saying dates

Additional business vocabulary

  • Short phrases for everyday English communication
  • Informal communication and slang

… and more!

In this course, learn about:

English for business networking and small talk

  • Conversation starters in English
  • Introducing yourself at a networking event
  • Joining an existing conversation, inviting people into a conversation
  • Ending a conversation, exchanging contact details
  • Following up after a networking event

Writing Business e-mails

  • Review of the most important capitalization and punctuation rules
  • Starting a professional e-mail, salutations
  • Vocabulary for stating the reason for writing
  • Vocabulary for good and bad news
  • Making proposals in an e-mail
  • Concluding e-mails, formal and informal closings

English for Business Meetings

  • Vocabulary for having a meeting
  • Describing the purpose of a meeting, beginning a meeting
  • Introducing people at a meeting
  • Expressing opinions, agreeing, disagreeing
  • Making recommendations, proposing actions and solutions
  • Vocabulary for controlling the flow of a meeting
  • Vocabulary for closing a meeting, arranging the next meeting

English for managing projects and time

  • Vocabulary for describing the properties of a project
  • Vocabulary for beginning a project – setting objectives, targets
  • Vocabulary for planning a project – defining project schedule, milestones
  • Vocabulary for executing a project – in- and outsourcing
  • Vocabulary for project monitoring and reporting
  • Vocabulary for time management, scheduling
  • Vocabulary for talking about disruptions in the project

English for contracts and negotiations

  • Vocabulary for making offers, counteroffers, reaching an agreement
  • Making concessions and demands
  • Vocabulary for describing clauses, conditions, structure of contracts

Additional business vocabulary

  • Common phrases in general business communication

… and more!

Body Language

In this course, learn about:

  • The types of communication – verbal and non-verbal
  • The basics of the science of body language and its history
  • Why body language matters
  • How to read the face of a person
  • The 7 involuntary facial microexpressions and how to recognize them
  • How to read the body of a person
  • How to effectively use body language to increase customer trust
  • How to use body language to increase sales
  • How to address client concerns using body language
  • How to create an effective elevator pitch
  • How to use non-verbal communication in your online presence
  • How to use body language to polish your image
  • The basics of detecting lies
  • How to evaluate if a potential client or partner can be trusted
  • What constitutes Alpha or leader’s behavior
  • How to navigate high-pressure situations
  • How to use body language when speaking in front of an audience
  • How to use body language in negotiations
  • How to use non-verbal communication during cold calling

… and more!

Applied Statistics

In this course, learn about:

  • What is SPSS
  • Using the Data Editor, Output and Script windows
  • Opening, closing and saving files
  • The Data view and the Variable view
  • The types of variables, manipulating variables
  • Naming variables, adding data labels, etc.
  • Handling missing values
  • Transforming variables, calculating new variables from existing ones
  • Using the Chart Builder to create graphs
  • Creating histograms, box plots, bar charts, pie charts, scatterplots
  • Producing and inerpreting descriptive statistics
  • Using the menu Explore…
  • Using the menu Descriptives…
  • Using the menu Frequencies…
  • Pearson, Spearman & Kendall Correlation – comparison and use cases
  • The Normal Distribution and its properties
  • Testing for normality, e.g. the Kolmogorov- Smirnov test
  • Linear Regression
  • Model assumptions and how to check them
  • Simple Linear Regression
  • Interpreting the SPSS SLR output
  • Multiple Liner Regression
  • Interpreting the MLR output
  • ANOVA
  • Model assumptions and how to check them
  • Interpreting the ANOVA output
  • Using and comparing post-hoc tests
  • Using cross tabs
  • Understanding and interpreting the Chi Squared test

… and more!

en_USEnglish
bg_BGБългарски en_USEnglish