Practical course of Neuro-Linguistic Programming (NLP)

Manage emotions and improve your thinking with NLP techniques
/6571 learners
4, 6
Boost your career
with bonus training

Study face-to-face online

Training duration

5
practical workshops
per week
week
course
2
each workshop
is 2 hours
Request a call back
We will contact you within 15 minutes to give you all the information you need.
By clicking on the button, you agree to the privacy policy.
You want to learn effective communication

The course will be suitable if:

You often make a small talk or give a speech at work
You want to learn something new
You want improve your personal development skills
NLP courses will help you understand the motives of others and their perception of reality. You will be able to avoid manipulation and learn how to achieve goals effectively.
NLP skills allow you to build better communication with customers, partners and colleagues. You will learn how to give high-quality feedback, resist manipulation and manage the state of your own productivity.
The course will be useful for psychologists who want to learn new skills and immerse themselves in the field of NLP
Are you interested in psychology and communication and intend to expand your horizons? This NLP course will teach you how to influence yourself and others, and you will be able to use the acquired skills in everyday life.
We'll help you to achieve the profession you dream of, from scratch to your first earnings
We will teach you to use Excel tools and functions for data visualisation
You will understand the different types of data in Excel and use appropriate functions to work with them
/ 01
We will help you create a portfolio
You will use powerful Excel and tools to arrange the data into the desired formats and create useful visualisations
/ 02
We will teach you how to work with Power BI
You will learn how to create Power Bi dynamic reports and visualisations for financial data analysis
/ 03
You will learn how to use Named Ranges and Tables to automate your analysis
You will master a broad range of charts and create interactive dashboards
You will build reports easily and generate informative charts from each report
You can choose powerful visuals to highlight information on a dashboard
You will learn which steps are key to making an effective financial report dashboard
You will get to know how to connect your report for dynamic visualisations
Do you need
the detailed curriculum?
No, I don't
Yes, I do

Course programme

You will do
face-to-face virtual workshops
You will study online with a live teacher
with whom you can communicate and fully interact in real-time

Power BI function

1
content and tools
- Learning the interface of the Power BI data analysis program
- Loading data in different formats into Power BI, collecting information for analytics from sites
Tools
1. Analytics in Power BI
2. Power BI interface
3. Programme goals
4. Data for work
5. Data sources
6. Ways of loading data
7. Work with requests
8. Preparation of data for analysis
You will practice
You will learn
Requests
Data import
Data sources
Power BI desktop

Data sources

2
content and tools
- Loading data into BI and forming a clear table
- Grouping data and combining queries
Tools
1. Data operations
2. Interface Power Query
3. Data preparation
4. Grouping in Power BI
5. Creating of custom column
6. Ways of connecting the data
7. Combining data from different sources
You will practice
You will learn
Updating requests
Data conversion
Grouping
Power Query

Data modeling

3
content and tools
- Loading data from a file and creating a summary of income
- Create links between data from different sources
- Working with filters for visualisation and tables
Tools
1. Principles of building a data model
2. Organising tables into a complex structure
3. Schemes for building data models
4. Managing connections between tables
5. Creating Data Models
6. Setting up data models
7. DAX data analysis language
8. Creating directories
You will practice
You will learn
Breaks
Tables
Managing connections
Data connections

DAX Data analysis language

4
content and tools
- Creating calculated columns, writing measures
- Creating a calculated table, visualising the result in a table
Tools
1. Built-in calculations
2. Creating and Applying Measures
3. Function sum, average, count
4. Function sumx, averagex, countax
5. Function distance count function, filter
6. Calculated columns
7. Creating calculated tables
8. Group by function
You will practice
You will learn
Calculated tables
Measures
Calculated columns
DAX language

Data visualisation

5
content and tools
- Preparing a visual component for data
Tools
1. Creating visual elements
2. Visual elements setting
3. Design tools
4. Types of visualisation
5. Creating Graphs and Tables
6. Applying filters
7. Preparing reports for external users
You will practice
You will learn
Filter
Diagrams
Schemes
Charts

Excel tools for working with data

6
content and tools
- Creating a simple table
- Sort cells based on the selected criteria
- Multi Level sorting
- Applying simple filtering
- Creation of utm tags
Tools
1. Program workspace
2. Working with data in cells
3. Sorting cells based on criteria
4. Change the style and colour of cells
5. Making hyperlinks
You will practice
You will learn
Hyperlinks
Formats and Values
Sorting in cells
Data entry and processing

Functions and formulas

7
content and tools
- A task with a mathematical function.
- Analyse the number of requests on a particular topic. Sorting this information into the table
Tools
1. Apply formulas in tables
2. Simple and complex calculations using mathematical functions
3. Data Analysis with Logic Functions
4. Statistical functions for analysing data in cells
5. Working with Text Functions
6. Absolute and relative links
You will practice
You will learn
Links
"if" function
Mean
Calculations and formulas

Working with date and time functions

8
content and tools
- Calculation of dates
- Creating names for cells and ranges
Tools
1. Adding and subtracting dates
2. Subtract dates with functions
3. Adding days, weeks, months to a date
4. Creating Named Cells and Ranges
5. Conditional Data Formatting
You will practice
You will learn
Named cells
Summation
Formatting
Data and time

Work with data

9
content and tools
- Calculation of profitability of sales
- Summarising subtotals in the table
- Data protection in the table.
Tools
1. Adding subtotals
2. Merging multiple tables into one
3. Standard Filtration
4. Working with advanced filter
5. Lock Cells and Sheets for protection
6. Hiding data in a cell
You will practice
You will learn
Data protection
Data aggregation
Advanced Filter
Subtotals

Analyse data with pivot tables

10
content and tools
- Create a pivot table for total sales
- Creation of a pivot table on the results of sales with a breakdown by region and seller
- Calculation of % completion of the plan.
Tools
1. Building pivot tables
2. Filtering Data in a pivot table
3. Adding fields for calculation
4. Sorting and grouping data
5. Pivot table Formatting
6. Consolidation of data in one document
You will practice
You will learn
Consolidation
Filter
Sorting & Formatting
Pivot tables

Data visualisation

11
content and tools
- KPI calculation
- Building a chart with company performance data
- Create a complex chart with sales growth data
Tools
1. Creating diagram
2. Multilevel axis labels
3. Binding labels to cells
4. Complex diagram
5. Scatter plot
6. Lollipop diagram
You will practice
You will learn
Template
Complex diagram
Secondary axle
Basic Diagrams

Dynamic diagrams

12
content and tools
- Creating diagram to track daily sales
- Application of automatic data addition
- Making a chart of the exchange rate by years with time control
Tools
1. Building dynamic diagrams
2. Automatic data addition
3. Tracking data with diagrams
4. Adding a Series to a diagram
5. Diagrams with controls
6. Diagrams with a choice of displayed data
You will practice
You will learn
Data adding
Diagram management
Automation
Dynamic diagrams

Working with histograms and graphs

13
content and tools
- Making sparklines
Tools
1. Create a standard chart
2. Working with dynamic charts
3. Histogram with overlap
4. Normalized distribution histogram
5. Stacked histogram
6. Construction and design of the sparkline
You will practice
You will learn
Sparkline
Dynamic charts
Histogram
Standart charts

External sources

14
content and tools
- Setting up Power Query and Power Pivot
- Import and export of documents
Tools
1. Export and import of information
2. Transferring data to Google Sheets
3. Working with databases
4. Using the Power Query add-in
5. Power Pivot add-in features
6. Differences between Power Query and Power Pivot
You will practice
You will learn
Power Pivot
Power Query
Import to Google Sheets
Data export

Dashboard in Excel

15
content and tools
- Creating a dashboard
Tools
1. Data visualisation with a dashboard
2. Fields of using a dashboard
3. Collecting data for visualisation using a dashboard
4. Dashboard design
6. Tools for formatting and analysing data
You will practice
You will learn
Data Analytics
Adding data
Creating a Layout
Construction algorithm
You will do
face-to-face virtual workshops
You will study online with a live teacher
with whom you can communicate and fully interact in real-time
Compare course delivery methods
Face2face
training with us

Recorded
courses
In class
courses
Timesaving on travel
Have access to recorded webinars
Increase your motivation level
Have the ability to ask personalized questions and get feedback
Compare course delivery methods
Face2face
training with us

Recorded
courses
In class
courses
Timesaving on travel
Have access to recorded webinars
Increase your motivation level
Have the ability to ask personalized questions and get feedback
A Data analyst is an in-demand profession
> 950 vacancies are currently open in the UK
Data analyst junior focus on taking complex data and communicating it in ways non-experts can understand.
Related Jobs
You can get a job in a company with data analytics or work on a freelance basis.