Catalogue Cognity 2014 - OFFICE APPLICATIONS AND GRAPHICS EDITORS

CATALOGUE 2014 OFFICE APPLICATIONS AND GRAPHICS EDITORS

COGNITY Practical, effective trainings and consultations Krak贸w-Kazimierz, tel.(12) 421 87 54, kom. 533 98 66 33, e-mail: biuro@cognity.pl WWW.COGNITY.PL

1

ABOUT THE FIRM

SELECTED CLIENTS

We are a training and consulting firm predominantly specialized in trainings of MS Office suite and other applications supporting work of modern organisations.

COGNITY is the team of trainers who share their knowledge and skills with passion, have broad experience in the business and are experts in their fields.

Quality of our trainings and customer satisfaction are our top priorities:  We cooperate only with experienced trainers with real-life experience in their areas of expertise

 We continuously improve training plans, learning materials and our teaching methods  We survey both expectations and the level of satisfaction of our customers, adjust learning plans to demands and needs of our customers

 We offer post-training assistance which is provided free of charge.

Participants actively solve practical problems based on real-life situations.

Training groups no bigger than 10 participants.

90 minutes-long practical and dynamic training sessions

Trainings tailor-made for client's needs and characteristics Delivery of Cognity trainings - "learning by doing" COGNITY Practical, effective trainings and consultations Kraków-Kazimierz, tel.(12) 421 87 54, kom. 533 98 66 33, e-mail: biuro@cognity.pl WWW.COGNITY.PL

2

SELECTED CLIENTS

Carrying out a training project  To meet expectations of our clients we developed a unique approach to preparations of employee training programmes based on our experience which is summarised by the following graph:

Training needs analysis

Practical training

Measurement and evaluation of results

Post-training report

We conduct a free of charge evaluation of training needs, on the basis of which we estimate

the

level

of

participants’

knowledge

before

the

training

starts,

so the programme of the training and its content are most adequate to expectations, and the training itself is most effective.

In the price we include:

 lunch  coffee breaks with cakes, hot and cold baverages served

THE COGNITY OFFER INCLUDES:



Open training sessions



Enterprise dedicated trainings



Consultations



Post-training assistance



IT advisory services COGNITY Practical, effective trainings and consultations Kraków-Kazimierz, tel.(12) 421 87 54, kom. 533 98 66 33, e-mail: biuro@cognity.pl WWW.COGNITY.PL

3

OPEN TRAINING SESSIONS:

SELECTED CLIENTS

Participants may be both employees delegated by the company as well as other individuals. 

Sessions carried out in small groups (4 – 10 people) which provides comfortable learning environment



A specific date of the training is advertised on the Cognity website



The sessions have a fixed training plan



The sessions are conducted between 9:00 and 16:00 in our training rooms located in the Krakow’s district of Kazimierz

ENTERPRISE - DEDICATED TRAININGS

The dedicated trainings are the sessions perfectly aligned to requirements and needs of a company.

Each training session provided by Cognity can be arranged as a closed company-exclusive event.

 We adjust the range of topics, the training plan and the session date to expectations of our customer

 We modify the thematic range and create custom training plans  Each training can also be carried out in English  We prepare an evaluation report  We can flexibly adjust the place and time of the training to fit requirements of our customer.

COGNITY Practical, effective trainings and consultations Kraków-Kazimierz, tel.(12) 421 87 54, kom. 533 98 66 33, e-mail: biuro@cognity.pl WWW.COGNITY.PL

4

The adventages of purchasing the enterprise-dedicated training session:  A workshop based on real-life examples  Certificate of completition confirming the attendance  Post-training assistance – support within the thematical range of the course after its completition

 The unlimited time access to excersises and training materials published in a digital version on our website www.cognity.pl via a personal account in the “knowledge zone” assigned during the training

 Printed training materials  A workstation for each course participant  Each project is priced individually – possible negotiation of prices.

CONSULTATIONS Each training session may be carried out as series of individual consultations.

Advantages of individual consultations:



A form of education closely adjusted to customer’s needs.



Within short time period the customer is provided with exact specific knowledge from within his area of his or her interest



Consultations are arranged on the most convenient date and time



Each program and scope of the consultations is arranged with the customer

COGNITY Practical, effective trainings and consultations Kraków-Kazimierz, tel.(12) 421 87 54, kom. 533 98 66 33, e-mail: biuro@cognity.pl WWW.COGNITY.PL

5

POST-TRAINING ASSISTANCE After each of our trainings we provide a cost-free post-training assistance.

A post-training assistance is a possibility of consulting the trainer after the training session is over.

If our customer encounters future problems related to the thematic scope of our training, may without hesitation ask the trainer for help.

Possible forms of the post-training consultation: 

Personal contact with the trainer who carried out the training session arranged in the Cognity office ( For 2 hours)



Contacting the trainer who carried out the training session on the phone or via e mail (For 1 year after the training session)

IT CONSULTANCY SERVICES In reply to an increasing number of customer inquiries we introduced a new service – IT consultancy services.

Within the scope of this offer we provide complete tools, solutions and applications using – MS Excel, Access and the VBA code – which automate, spead up and make the daily tasks easier.

The IT consultancy services are delivered in accord to the following scheme: 1. The customer informs about the scope of technical issues that should be addressed 2. A cognity expert carries out an initial interview identifying the type of each issue

and its background (issue diagnostics) 3. The Cognity expert collects the data and then prepares the plan and scope

of the consultancy 4. The Cognity expert suggests best solutions which are then implemented upon

a customers approval 5. The customer evaluates the effectiveness of provided solutions

COGNITY Practical, effective trainings and consultations Kraków-Kazimierz, tel.(12) 421 87 54, kom. 533 98 66 33, e-mail: biuro@cognity.pl WWW.COGNITY.PL

6

In accord to customer’s preferences the meeting with the expert may be arranged :



At our premises



At customer’s premises – the Cognity expert will visit on an agreed date



The cooperation can be remote – ready solutions may be delivered by e-mail

We hope that the catalogue presented below will meet your expectations and will bring your interest to our offer!

In case of any questions – please feel free to contact us anytime!

COGNITY Practical, effective trainings and consultations Kraków-Kazimierz, tel.(12) 421 87 54, kom. 533 98 66 33, e-mail: biuro@cognity.pl WWW.COGNITY.PL

7

Excel (Standard) ...................................................................................................................................... 9 Excel Basics ........................................................................................................................................ 10 Excel Intermediate............................................................................................................................. 11 Excel Advanced .................................................................................................................................. 12 Excel Cross-sectional............................................................................................................................. 13 Excel Basics (Cross-sectional) ............................................................................................................ 14 Excel Advanced (Cross-sectional) ...................................................................................................... 15 Excel for Financiers and Accountants................................................................................................ 17 Excel in Sales Analysis........................................................................................................................ 18 Excel in Logistics ................................................................................................................................ 19 Statistical Analysis in Excel ................................................................................................................ 20 Excel (Thematic) .................................................................................................................................... 21 Excel Pivot Tables .............................................................................................................................. 22 Excel Charts – Presentation i Data Visualisation ............................................................................... 23 VBA in Excel........................................................................................................................................... 25 VBA in Excel Cross-sectional .............................................................................................................. 26 VBA in MS Excel Advanced ................................................................................................................ 28 PowerPoint ........................................................................................................................................... 29 PowerPoint - Practical Tools.............................................................................................................. 30 PowerPoint - The Essence ................................................................................................................. 32 Word...................................................................................................................................................... 33 Word Intermediate............................................................................................................................ 34 Word Advanced ................................................................................................................................. 36 Project ................................................................................................................................................... 38 Project Basics..................................................................................................................................... 39 Project Advanced .............................................................................................................................. 41 Access .................................................................................................................................................... 43 Access Basics ..................................................................................................................................... 44 Access Advanced ............................................................................................................................... 46 Outlook ................................................................................................................................................. 48 Outlook .............................................................................................................................................. 49

COGNITY Practical, effective trainings and consultations Kraków-Kazimierz, tel.(12) 421 87 54, kom. 533 98 66 33, e-mail: biuro@cognity.pl WWW.COGNITY.PL

8

Excel (Standard)

COGNITY Practical, effective trainings and consultations Krak贸w-Kazimierz, tel.(12) 421 87 54, kom. 533 98 66 33, e-mail: biuro@cognity.pl WWW.COGNITY.PL

9

Excel Basics

16 lesson units / 2 days

FOR THOSE WHO:

  

have no previous experience or only a brief knowledge of Microsoft Excel want to learn basic actions and formulas want to create clear and legible reports, charts and summaries

AFTER THE TRAINING YOU WILL KNOW HOW TO:

  

correctly input and format different kinds of data enter and edit formulas and use them to create analytical reports create data comparisons and analyse them with basic tools

TRAINING PROGRAMME:

1. All that is important for the start – an introduction to work with Excel Get familiar with the terminology and the working environment of MS Excel

 

Getting about the workbook Keyboard shortcuts

2. What can you do with data i.e. data operations  Input, modification and deletion of data  Selecting data  Various ways to copy and paste data  Filling cells with data series 3. Data clarity and cell formatting  Alignment, font and its size, borders and fill  Number, currency, percentage, text, date and time formatting  Table formatting  Format painter 4. Automatic value highlights i.e. conditional formatting  Formatting cells containing text  Formatting cells containing values 5. Yellow sticky notes – entering and editing comments 6. A better calculator – or formulas and functions  Calculations done directly in cells  Calculations using cell addresses  Relative and absolute references  Copying formulas  Using sum, average, maximum and minimum functions  Mathematical, logical, date and time functions and their usage in calculations  Text functions 7. Data visualisation or creating and formatting charts 8. Putting data in order i.e. data sorting 9. Displaying desired results – data filtering with the Autofilter tool 10.Counting the data up according to given criteria - data analysis with aid of the Sumifs function.

COGNITY Practical, effective trainings and consultations Kraków-Kazimierz, tel.(12) 421 87 54, kom. 533 98 66 33, e-mail: biuro@cognity.pl WWW.COGNITY.PL

10

Excel Intermediate

16 lesson units / 2 days

FOR THOSE WHO:

  

want to quicken and improve their daily work want to broaden their knowledge about data input and formatting want to explore possibilities of advanced analysis and presentation of data

AFTER THE TRAINING YOU WILL KNOW HOW TO:

  

use many various functions to sum up and lookup the data create functions made of several other nested functions create a pivot table and use its basic functions

THE TRAINING PROGRAMME: 1. The „Go To” Tool

  

Copying range with hidden rows Formatting only the cells with data Filling empty cells

2. Conditional formatting  Formatting cells containing a certain string or values, formatting cells containing a certain string or values

 

Data bars, color scales, icon sets Setting the conditional formatting

3. Formulas and functions  Average, maximum, minimum, count  Logical functions - if, or, and  Statistical and methematical functions - countif , sumif, round  Combining several functions into one – function nesting 4. Date calculations and functions  A difference between two dates, adding a number of days to a date, calculating end date  Date and time functions – day, month, year, weekday 5. Texts  Correcting the entered text with text functions, Splitting texts according to the number of characters and the “Text to columns” tool

6. Subtotals 7. Creating and editing charts  Creating advanced charts, changing source data range  Advanced settings – changing chart colours, layout and scale  Detailed settings of the data layout shown on a graph, chart with dual axes 8. Data analysis and lookup  Sorting – changing the order of sorting, advanced options  The autofilter, custom filter, the “Find and replace” method 9. Basics of creation and usage of pivot tables

COGNITY Practical, effective trainings and consultations Kraków-Kazimierz, tel.(12) 421 87 54, kom. 533 98 66 33, e-mail: biuro@cognity.pl WWW.COGNITY.PL

11

Excel Advanced

16 lesson units / 2 days

FOR THOSE WHO:

 

use MS Excel in their daily work as a data analysis tool work on a large amount of data and want to improve their work with advanced tools like pivot tables or macros

AFTER THE TRAINING YOU WILL KNOW HOW TO:

  

use advanced date and time, informational and statistical functions create a pivot table and use its capabilities to process data record and manage macros

THE TRAINING PROGRAMME: 1. The „Go To” Tool

 

Copying ranges with hidden rows Formatting only the cells with data

2. Conditional formatting  Highlighting cells containing certain text or values  Data bars, color scales, icon sets  Marking duplicates and unique values  Setting the conditional formatting 3. Advanced functions  Logical functions - if, or, and  Mathematical and statistical functions - countif, sumif, sumifs, countifs  The lookup and referrence functions - vlookup, hlookup, index, match  The date and time functions – today, day, month, year, weekday, networkdays, workday  Text functions – left, right, mid, len, upper, lower, concatenate, proper  Combining several functions into one – function nesting 4. Solver and Goal Seek tools 5. MS Excel Data import methods  Usage of proper text string processing tools 6. Pivot tables  Creating a pivot table  Refreshing source data, grouping data, filtering and sorting in pivot tables

 Changing analytical functions, calculated fields and items 7. Advanced charts – data visualisation  Displaying data of different order of magnitude  Creating advanced charts, changing source data range  Advanced settings – changing chart colours, layout and scale  Detailed settings of the data layout shown on a graph  Chart with dual axes, trendlines 8. Macros  Recording, activation, macro security

COGNITY Practical, effective trainings and consultations Kraków-Kazimierz, tel.(12) 421 87 54, kom. 533 98 66 33, e-mail: biuro@cognity.pl WWW.COGNITY.PL

12

Excel Cross-sectional

COGNITY Practical, effective trainings and consultations Krak贸w-Kazimierz, tel.(12) 421 87 54, kom. 533 98 66 33, e-mail: biuro@cognity.pl WWW.COGNITY.PL

13

Excel Basics (Cross-sectional) 24 lesson units / 3 days FOR THOSE WHO:

  

do not know MS Excel at all or who know the program only superficially want to create clear reports, charts and summaries want to explore possibilities of advanced data analysis and presentation

AFTER THE TRAINING YOU WILL KNOW HOW TO:

  

use many functions to summarise and lookup data create multi-function formulas create pivot tables and make use of its basic capabilities

THE TRAINING PROGRAMME: 1. Data processing

  

Input, modification and deleting data Data selection, different methods of copying and pasting Data series, find and replace command

2. Cell formating

 

Font parameters, alignment and borders Correct usage of formatting – numbers, currency, percentages, text, dates

3. Conditional formatting

  

Formatting cells containing a certain string or values Highlighting duplicates or unique values Setting the conditional formatting

4. Formulas and functions

  

relative and absolute references Basic functions – sum, average, maximum, minimum, count, logical functions – if, or, and Mathematical and statistical functions – countif, sumif, round, Combining several functions into one – function nesting

5. Date calculations and functions

 

A difference between two dates, adding a number of days to a date, calculating end date displaying current date and performing calculations on it The date and time functions – day, month, year, weekday

6. Texts

 

Correcting the entered text with text functions, Splitting texts according to the number of characters

7. The „Go To” Tool

 

Copying ranges with hidden rows Formatting only the cells with data

8. Data analysis and lookup



Sorting, Autofilter

9. Creating and editing charts



Different kinds of charts, changing source data ranges

10.Basics of creation and usage of pivot tables COGNITY Practical, effective trainings and consultations Kraków-Kazimierz, tel.(12) 421 87 54, kom. 533 98 66 33, e-mail: biuro@cognity.pl WWW.COGNITY.PL

14

Excel Advanced (Cross-sectional) 24 lesson units / 3 days FOR THOSE WHO:

 

use Excel in their daily work as a tool of a data analysis process large amounts of data and want to improve their work with advanced tools

AFTER THE TRAINING YOU WILL KNOW HOW TO:

  

use advanced date and time , text, lookup and statistical functions create a pivot table and use its capabilities to process data record and manage macros

THE TRAINING PROGRAMME: 1. The „Go To” Tool

  

Copying ranges with hidden rows Formatting only the cells with data Filling empty cells

2. Conditional formatting

  

Formating rules, data bars, color scales, icon sets Formatting cells containing a certain string or value, Setting the conditional formatting

3. Advanced functions

    

logical functions – if, or, and Mathematical and statistical functions – countif, sumif, sumifs, countifs The lookup and referrence functions – vlookup, hlookup, index, match The date and time functions – today, day, month, year, weekday, networkdays, workday Text functions – left , right, mid, len, upper, lower, concatenate, proper, Combining several functions into one – function nesting

4. Solver and Goal Seek tools 5. MS Excel Data import methods



Importing data from text files, databases and websites

6. Advanced charts – data visualisation

    

Displaying data of different order of magnitude Rules of a proper chart selection, chart types Creating advanced charts, changing source data range, Detailed settings of the data layout shown on a graph A chart with dual axes, trendlines

7. Pivot tables

 

Creating a pivot table refreshing source data, grouping data, changing analytical functions Filtering and Sorting in pivot tables, calculated fields and items, a pivot table based on external data

8. Macros



Recording, activation, macro security

COGNITY Practical, effective trainings and consultations Kraków-Kazimierz, tel.(12) 421 87 54, kom. 533 98 66 33, e-mail: biuro@cognity.pl WWW.COGNITY.PL

15

EXCEL Business Area Specific

COGNITY Practical, effective trainings and consultations Krak贸w-Kazimierz, tel.(12) 421 87 54, kom. 533 98 66 33, e-mail: biuro@cognity.pl WWW.COGNITY.PL

16

Excel for Financiers and Accountants 16 lesson units / 2 days FOR THOSE WHO:

  

who process financial or accounting data want to gain knowledge about financial analysis and about the art of building advanced models allowing decisions based on specific and reliable data want to optimise time required for preparation of analyses, processes and costs

AFTER THE TRAINING YOU WILL KNOW HOW TO:

  

solve analysis and optimisation problems in finance and accounting create models calculating costs, prices and profit create charts and pivot tables and use their capabilities in data analysis

THE TRAINING PROGRAMME: 1. Data processing with functions used for financial analysis

     

Errors in invoicing and methods of avoiding them Using excel functions to create formulas Correct cel referrencing methods Using formula tables refferences Comparing and seeking differences in data records Mathematical, logical, lookup and referrence, date, financial, rounding functions as a tool of proper cost accounting

2. Statistical data analysis 3. Importing data from external sources



Text files, databases, websites, XML files, using the Microsoft Query tool

4. Text data processing  Text functions - left, right, mid, len, upper, lower, concatenate, proper, Text to Columns tool 5. Working with multiple workbooks and worksheets



Linking workbooks, data consolidation

6. Financial forecasting 7. Building multiple-case models with scenarios 8. Data analysis and lookup



Displaying the dynamics of changes in ascending order – sorting, changing the order of sorting, advanced options



Sales analysis according to various criteria - autofilter and custom filter, the ‘find and replace’ command

9. Optimisation of complex problems with the Solver tool 10.The ‘Find’ tool 11.The pivot table as a tool of analysis of company activities 12.Charts – financial data visualisations

COGNITY Practical, effective trainings and consultations Kraków-Kazimierz, tel.(12) 421 87 54, kom. 533 98 66 33, e-mail: biuro@cognity.pl WWW.COGNITY.PL

17

Excel in Sales Analysis

16 lesson units / 2 days

FOR THOSE WHO:

  

want to speed up and improve their work and enhance their knowledge manage or work in a sales department want to optimise time required do prepare analyses of processes and costs

AFTER THE TRAINING YOU WILL KNOW HOW TO:

  

solve analytical and optimisational problems with sales create models calculating costs, proces and profit and implement useful functions and tools of MS Excel create pivot tables and use their capabilities in data analysis

THE TRAINING PROGRAMME: 1. MS Excel Data import methods

 

Importing data from text files, databases and websites Import and analysis of data imported from text files, usage of proper text string processing tools

2. Applications of the MS Query tool

 

Introduction of selected elements of relational databases Data filtering and joining content from multiple tables within a query

3. Formulas and functions

     

Relative and absolute references The ABC classification – usage of mathematical and statistical functions Logical functions Lookup and referrence functions Date and time functions, text functions Combining several functions into one – function nesting

4. Working with multiple workbooks and worksheets and linking them together 5. Data analysis and lookup

   

Displaying the dynamics of changes in ascending order – sorting changing the order of sorting, advanced options A sales analysis performed according to different criteria - an autofilter and a custom filter The find and replace command Building a multi-variant models with scenarios

6. Goal seek and solver

    

Seeking the markup on a retail price to reach a planned profit level Seeking the optimal price growth indicator for the appropriate profit level Optimisation of product prices Optimisation of transport costs Optimisation of marketing expeditures

7. Pivot tables – a tool for enterprose performance analysis 8. Charts – diagrammatic representation of financial data

COGNITY Practical, effective trainings and consultations Kraków-Kazimierz, tel.(12) 421 87 54, kom. 533 98 66 33, e-mail: biuro@cognity.pl WWW.COGNITY.PL

18

Excel in Logistics

16 lesson units / 2 days

FOR THOSE WHO:

  

work in a logistics department or another related branch want to explore practical tools which are useful in daily work want to speed up and improve their work and enhance their knowledge

AFTER THE TRAINING YOU WILL KNOW HOW TO:

  

use MS Excel formulas and functions in a practical way search the data with advanced tools and filters create charts and pivot tables and use their capabilities for data analysis

THE TRAINING PROGRAMME: 1. Economic analysis of logistic processes performed with Excel functions

     

Relative and absolute references Logical functions – if, or, and Mathematical and statistical functions – countif, sumif, sumifs, countifs The lookup and referrence functions – vlookup, hlookup, index, match The date and time functions – today, day, month, year, weekday, networkdays, workday Text functions – left, right, mid, len, upper, lower, concatenate, proper, combining several functions into one – function nesting

2. Showing indicators and measures

   

Influence of purchase prices over operational costs Analysis of stock size and structure, logistic costs Stock productivity indicators Influence of logistic processes on profitability

3. Analysing dynamic performance of logistic indicators 4. Building reporting systems for subordinates

  

Building example logistical reports Drop-down lists, data validation Worksheet data protection, external links

5. Logistics department’s data analysis

  

Building example reports Conditional formatting and sorting Report filtering, custom filters

6. Data analysis with a pivot table

   

Rules of building and usage of pivot tables Filtering and sorting in pivot tables Grouping data in pivot tables ( grouping by time, numbers, text ) Examples based on a sales report, an aging of receivables, a logistical report

7. Charts - the graphic representation of report data

COGNITY Practical, effective trainings and consultations Kraków-Kazimierz, tel.(12) 421 87 54, kom. 533 98 66 33, e-mail: biuro@cognity.pl WWW.COGNITY.PL

19

Statistical Analysis in Excel 16 lesson units / 2 days FOR THOSE WHO:

   

know Excel well use Excel in their daily work as a tool of statistical data analysis process large amounts of data and want to effectively manage results and create progress reports want to assume practical approach to the statistical analysis

AFTER THE TRAINING YOU WILL KNOW HOW TO:

     

carry out an analysis of empirical distributions in quantitative and qualitative data assess compatibility with normal distribution calculate and interpret descriptive statistics create Charts analyse qualitative data analyse interdependencies among the variables

THE TRAINING PROGRAMME: 1. Review of selected tools of MS Excel

 

Standard and array functions Tables, naming variables

2. Analysis Toolpack – installation 3. Introduction to the statistical methodology

  

Basic concepts: a population, a sample, random variables, hypothesis, statistical significance Methods of sampling Collecting data, stages of data analysis, creating questionnaires and surveys

4. Descriptive statistics

   

Basic concepts of the descriptive statistics: averages, variance, standard deviation, variance, range, skewness, kurtosis Empirical probability, frequency and cumulative; dominant and quartiles Histograms and stemplots, data variability analysis, Data visualisation and descriptive statistics: charts, histograms, pivot tables, dynamic charts

5. Mathematical statistics

       

Basic concepts: probability, distribution, most common distributions (F-test with two variance samples) T-test: associated pairs with two samples for an average T-test: with two samples and paralel variance T-test: with two samples and unequal variance Z-test: with two samples for averages Charts: creating a chart of normal distribution, how to compare distribution within a sample with the distribution on a chart Generating random numbers within different distributions Data correlation analysis – correlation and covariance, variance analysis with one and two factors, regression analysis, prognostics

6. Data continuance analysis and prognostics – moving average, expotrntial smoothing

COGNITY Practical, effective trainings and consultations Kraków-Kazimierz, tel.(12) 421 87 54, kom. 533 98 66 33, e-mail: biuro@cognity.pl WWW.COGNITY.PL

20

Excel (Thematic)

COGNITY Practical, effective trainings and consultations Krak贸w-Kazimierz, tel.(12) 421 87 54, kom. 533 98 66 33, e-mail: biuro@cognity.pl WWW.COGNITY.PL

21

Excel Pivot Tables

8 lesson units / 1 day

FOR THOSE WHO:

 

want to learn how to proficiently use pivot tables want to speed up and improve their work and enhance their knowledge and optimise time required for report building and performing multidimensional analyses.

AFTER THE TRAINING YOU WILL KNOW HOW TO:

 

properly prepare data to be later used in a pivot table present values as non-standard numbers and aplying calculation fields

THE TRAINING PROGRAMME: 1. Correct preparation of data

  

Proper form of source data Importing data from a text or a web page Correction of an incorrect decimal separator in datasets from databases or accounting applications

2. Creating a pivot table

    

Building a pivot table – a field list, row and column headers, values the values filter, embedding and moving a pivot table Selecting source data to a pivot table Adding multiple fields to rows, columns, values and the report filter, hiding and displaying data in a pivot table Changing pivot table field names, changing pivot table data source, refreshing source data of a pivot table Displaying filtered data in separate sheets

3. Pivot table formatting

 

Layout and style of a pivot table Formatting the displayed data

4. Various ways to display numeric values in a pivot table

  

Different ways to summarize pivot table data Showing values as non standard calculations Pivot table data formatting

5. Grouping data in a pivot table 6. Calculated fields and items 7. Sorting data in a pivot table

 

Manual sorting, alphabetical sorting Sorting by a custom list

8. Data filtering in a pivot table



Custom filters, slicers

9. Drill down i.e. getting down to details 10.Creating advanced pivot tables

  

Creating a pivot table out of many consolidated source data ranges A pivot table based on external data Refreshing source data in pivot tables

11. Pivot charts COGNITY Practical, effective trainings and consultations Kraków-Kazimierz, tel.(12) 421 87 54, kom. 533 98 66 33, e-mail: biuro@cognity.pl WWW.COGNITY.PL

22

Excel Charts – Presentation i Data Visualisation 8 lesson units / 1 day FOR THOSE WHO:

  

mastered basics of MS Excel want to learn how to make proficient use of tools creating and editing charts analyse various datasets during their daily work

AFTER THE TRAINING YOU WILL KNOW HOW TO:

  

properly prepare data to be later used in a chart editor modify the created chart and to adjust it to user’s needs copy charts to other MS Office applications

THE TRAINING PROGRAMME: 1. Rules of proper data visualisation

  

Interpretation and drawing conclusions on the basis of the graphic representation of data Proper type of a chart Graphic method of highlighting certain data on a graph

2. Creating charts

   

Matching data with a proper chart type Standard chart types Column charts, bar charts, line charts and other Keyboard shortcuts

3. Chart midifications

  

Selecting chart elements Modifying chart area and plot area Changing chart properties with a Ribbon menu

4. Working with data series

     

Adding and removing Proper usage of the axis scale, non-linear scale Labels Error bars and tradlines 3D Charts Advanced charts and displaying the secondary axis

5. Creating custom charts

 

Introduction to custom charts Creating an own custom chart

COGNITY Practical, effective trainings and consultations Kraków-Kazimierz, tel.(12) 421 87 54, kom. 533 98 66 33, e-mail: biuro@cognity.pl WWW.COGNITY.PL

23

6. Chart tricks

      

Drawing charts Thermometer chart Guage chart Creating a comparative histogram Gannt chart The self-updating chart Charts with mathematical functions (one or two variables)

7. Pasting chart sinto other applications (PowerPoint, Word, Outlook)

 

Pasting an Excel object Pasting as a Picture

COGNITY Practical, effective trainings and consultations Kraków-Kazimierz, tel.(12) 421 87 54, kom. 533 98 66 33, e-mail: biuro@cognity.pl WWW.COGNITY.PL

24

VBA in Excel

COGNITY Practical, effective trainings and consultations Krak贸w-Kazimierz, tel.(12) 421 87 54, kom. 533 98 66 33, e-mail: biuro@cognity.pl WWW.COGNITY.PL

25

VBA in Excel Cross-sectional 24 lesson units / 3 days FOR THOSE WHO:

    

want to improve their skills in VBA to the intermediate level have no prior experience with programing or have ceased programming a while ago have an intermediate level of MS Excel user proficiency want to know the rules of algorithm coding want to automate repetitive tasks or create applications which may be used by other users as well

AFTER THE TRAINING YOU WILL KNOW HOW TO:

      

record and edit recorded macros read and understand the code written in Visual Basic for Applications create loops and procedures and use them in the MS Excel environment use variables handle and work with text files in .csv and .txt formats prepare messages for users and create forms optimize the code and eliminate errors

THE TRAINING PROGRAMME:

1. Macros

 

Recording and executing Protecting the code

2. Editing and management of the VBA code

  

The structure of the VBA editor window toolbars Archiving and transferring of the code Important keyboard shortcuts.

3. Introduction to programming

  

Procedures and functions Operators VBA data types - variable and constants

4. Text processing



Functions processing text strings

5. Conditional statements and loops

    

Executing macros in Break Mode Conditional statements " If ... Then ... Else If ... Else ... End If “ Multi-scenario conditional statement " Select Case " Loops: " For ... Next ", " For Each ... In ... Next" , " Do ... Loop " Early termination of the loop command - “Exit”

6. VBA and Excel Workbook

  

Objects in spreadsheets Classes and collections Referring to cells, ranges of cells , columns , rows, and worksheets

COGNITY Practical, effective trainings and consultations Kraków-Kazimierz, tel.(12) 421 87 54, kom. 533 98 66 33, e-mail: biuro@cognity.pl WWW.COGNITY.PL

26

7. Work with text files in the .csv or .txt format



Saving and opening files

8. Variables:

  

Defining scope and passing a variable to another macro Verification of stored values Array variables

9. Communicating with a user

 

Message Box – execution of a macro based on user’s decision Input Box - collecting input from the user

10.Events



Events related to workbooks and worksheets

11.Forms

   

Creating forms Using text fields Using checkboxes Radio Buttons

12.Code optimization

  

Variables naming conventions Disabling screen refresh Information about the current stage of the macro execution

13.Error handling



Types of errors ways to eliminate them

COGNITY Practical, effective trainings and consultations Kraków-Kazimierz, tel.(12) 421 87 54, kom. 533 98 66 33, e-mail: biuro@cognity.pl WWW.COGNITY.PL

27

VBA in MS Excel Advanced

16 lesson units / 2 days

FOR THOSE WHO:

  

already have intermediate-level knowledge of Excel already have basic knowledge of programming wish to gain additional knowledge in this field

AFTER THE TRAINING YOU WILL KNOW HOW TO:

    

work with text files in .csv and .txt format prepare messages to display to users use advanced variables create complex forms optimize the code and eliminate errors

THE TRAINING PROGRAMME: 1. Working with text files in .csv and .txt format

 

Saving Opening

2. Variables

  

Defining the scope of variables Variables usable by several macros Checking a stored value

3. Array variables

 

Creating and assigning values Usage

4. Communication with the user

 

Macro execution based on user’s choice (message box) Collecting input from a user (input box).

5. Events

 

Workbook events Worksheet events

6. Forms

   

Creating forms Using text fields Checkbox input Radio buttons

7. Code optimization

  

Variable naming conventions Disabling screen refreshing Displaying information about the current stage of the procedure execution

8. Error handling

  

Types of errors Ways to eliminate errors Intercepting and handling of "run-time errors"

COGNITY Practical, effective trainings and consultations Kraków-Kazimierz, tel.(12) 421 87 54, kom. 533 98 66 33, e-mail: biuro@cognity.pl WWW.COGNITY.PL

28

PowerPoint

COGNITY Practical, effective trainings and consultations Krak贸w-Kazimierz, tel.(12) 421 87 54, kom. 533 98 66 33, e-mail: biuro@cognity.pl WWW.COGNITY.PL

29

PowerPoint - Practical Tools 16 lesson units / 2 days FOR THOSE WHO:

 

Are not familiar with Microsoft PowerPoint or have only basic-level knowledge of this tool want to learn how to use MS PowerPoint effectively and learn about its most important tools

AFTER THE TRAINING YOU WILL KNOW HOW TO:

   

insert and format elements into a presentation, such as a table, image, shape, etc. use animation to make the presentation look more diversified use themes and create your own template with your company’s logo print presentations and hand-outs

THE TRAINING PROGRAMME:

1. Interface overview

  

Ribbon edition Quick access toolbar customization Presentation views

2. Introduction to the MS PowerPoint

   

Creating a new blank presentation Adding slides Slide layouts Themes

3. Inserting and editing text

 

Font and paragraph formatting Tabs and bullets

4. Inserting and formatting elements

      

Text boxes Tables Images / clips AutoShapes SmartArt components WordArt components The formatting tab

5. Charts

 

Entering chart source data Editing

6. Grouping and aligning items

  

Ruler, gridlines, guides Automatic alignment Selection pane

7. Patterns

 

Template and slide master Create your own template of a presentation

COGNITY Practical, effective trainings and consultations Kraków-Kazimierz, tel.(12) 421 87 54, kom. 533 98 66 33, e-mail: biuro@cognity.pl WWW.COGNITY.PL

30

8. Additional elements on the slide

  

Date and time Slide number Footer and header

9. Outlining and inserting outlines from the MS Word 10.Transitions between slides

 

One transition for all slides Custom transitions

11.Adding animation to texts, graphics or shapes

    

Custom animation Combining animations of a single element Defining the sequence of object animations Triggers Setting intervals between slides

12.Custom Presentation

   

Hiding slides Hyperlinks and action buttons Rehearsing the timing of the presentation Adding sounds and movies to the presentation

13.Additional Options

    

Presentation and the PowerPoint Show Saving a presentation as a web page Creating a photo album Comments Useful keyboard shortcuts

14.Printing setup adjustment

COGNITY Practical, effective trainings and consultations Kraków-Kazimierz, tel.(12) 421 87 54, kom. 533 98 66 33, e-mail: biuro@cognity.pl WWW.COGNITY.PL

31

PowerPoint - The Essence

16 lesson units / 2 days

FOR THOSE WHO:

  

want to know the most important tools of the MS PowerPoint can only spend a single day on learning are interested in a condensed form of training

AFTER THE TRAINING YOU WILL KNOW HOW TO:

   

format and insert into a presentation such elements as tables, images, shapes, etc. use animation to make the style of the presentation more diverse use themes and create your own templates print presentations and materials for the participants

THE TRAINING PROGRAMME:

1. Interface overview  Adjusting the view to user preferences 2. Adding slides  Layouts - arrangement of space on a slide  Themes - background and appearance 3. Inserting and formatting presentation elements  tables  images / clips  AutoShapes  SmartArts  graphs  text boxes  grouping and aligning elements 4. Transitions between slides  Same transitions for the entire presentation  Custom transitions for different objects 5. Adding animations to text, graphics or shapes  Types of animations  Combining animation into a single element  Setting the order of animation appearances 6. Quick creation of presentations with text in a continuous form - the outline 7. Creating a presentation template 8. Custom slide show  Action buttons – action triggers  Hiding slides  Testing the presentation schedule and setting fixed intervals between slides  Different ways to display a presentation 9. Adjusting printing settings

COGNITY Practical, effective trainings and consultations Kraków-Kazimierz, tel.(12) 421 87 54, kom. 533 98 66 33, e-mail: biuro@cognity.pl WWW.COGNITY.PL

32

Word

COGNITY Practical, effective trainings and consultations Krak贸w-Kazimierz, tel.(12) 421 87 54, kom. 533 98 66 33, e-mail: biuro@cognity.pl WWW.COGNITY.PL

33

Word Intermediate

16 lesson units / 2 days

FOR THOSE WHO:

  

do not know Microsoft Word at all or have only a brief experience with the program want to learn how to use the MS Word efficiently want to create professional letters, business writings and enterprise documents

AFTER THE TRAINING YOU WILL KNOW HOW TO:

     

use basic text editing tools freely navigate through the document create an aesthetic and readable document with additional elements, such as tables, images or shapes add a header and footer, automatically number the pages generate a table of contents print documents and set printing parameters

THE TRAINING PROGRAMME:

1. Introduction  Ribbon editing  High-speed edition toolbar  Views  Creating, opening and saving documents 2. Basics of proper text editing  Writing texts exercises  Typical error examples - how to avoid them  Finding help to write correctly  Typesetting – what is this?

3. Writing texts in the editor  Inserting symbols  Correcting Text  Navigating through the document  Different ways of displaying a document  Undoing changes  Selecting text  Copying and moving between documents 4. Hierarchy of editor’s components  Characters, words , paragraphs, pages, sections , documents 5. Formatting texts, paragraphs , pages 6. Inserting elements  Images  Cliparts  Shapes  SmartArts  Charts

COGNITY Practical, effective trainings and consultations Kraków-Kazimierz, tel.(12) 421 87 54, kom. 533 98 66 33, e-mail: biuro@cognity.pl WWW.COGNITY.PL

34

7. Editing documents  Headers, footers, page numbers  Simple numbering and bullets  Styles  Using and displaying of non-printable characters  Checking the spelling and grammar  Custom user dictionaries  Keyboard shortcuts  Copying and moving between documents  Inserting hyperlinks.

8. Tables:  Creating of a simple table  Inserting and deleting columns and rows in the table  Resizing columns and rows  Splitting and merging cells  Table formatting 9. Printing  Page settings  Setting margins

COGNITY Practical, effective trainings and consultations Kraków-Kazimierz, tel.(12) 421 87 54, kom. 533 98 66 33, e-mail: biuro@cognity.pl WWW.COGNITY.PL

35

Word Advanced

16 lesson units / 2 days

FOR THOSE WHO:

   

have basic knowledge of MS Word want to freely move around the program want to expand their knowledge of the capabilities and use of the option of MS Word want to make professional letters, lists, create business documents using advanced tools

AFTER THE TRAINING YOU WILL KNOW HOW TO:

      

freely navigate through the document use the advanced features of the word processor use the built-in styles and create your own add a header, footer, and page number and generate the table of contents use mail merge create your own document template set advanced printing parameters

THE TRAINING PROGRAMME:

1. Overview of the interface

  

Ribbon customization Editing of the Quick Access bar Views

2. Advanced editing of text

      

Superscript Subscript Advanced bullets and numbering Small caps and all caps Format painter Alignment and adjustment Paragraphs and line spacing

3. Advanced document editing

      

Title page Headers, footers , page numbers Footnotes Watermark Split into sections Bookmarks Links

4. Table of Contents

   

Processing Update Modifying Horizontal list

COGNITY Practical, effective trainings and consultations Kraków-Kazimierz, tel.(12) 421 87 54, kom. 533 98 66 33, e-mail: biuro@cognity.pl WWW.COGNITY.PL

36

5. Styles

   

Application Update and modifying Create your own style Combined styles

6. Elements

   

Adding images Cliparts , shapes, SmartArts Tables and graphs Editing

7. Mail merge

  

Choosing a right document type (letters, envelopes, labels etc.)

Selecting the data source, sorting , filtering Insert fields

8. Templates

 

Using built-in templates Creating custom templates

9. File protection 10.Advanced printing options

   

Page Orientation Custom margins Mirror margins Simplex / duplex printing

COGNITY Practical, effective trainings and consultations Kraków-Kazimierz, tel.(12) 421 87 54, kom. 533 98 66 33, e-mail: biuro@cognity.pl WWW.COGNITY.PL

37

Project

COGNITY Practical, effective trainings and consultations Krak贸w-Kazimierz, tel.(12) 421 87 54, kom. 533 98 66 33, e-mail: biuro@cognity.pl WWW.COGNITY.PL

38

Project Basics

16 lesson units / 2 days

FOR THOSE WHO:

  

have none or only general knowledge of Microsoft Project want to acquire and develop practical skills of planning projects with help of the program want to gain knowledge to use it to handle daily task and people management

AFTER THE TRAINING YOU WILL KNOW HOW TO

   

create a project and set up its parameters add tasks and set their duration set up a schedule of tasks, add resources along with additional parameters such as types or interdependences and format them with simple commands create a report and print it

THE TRAINING PROGRAMME: 1. Introduction

   

Introduction to the MS Project program Applications Basic definitions Customizing the look of the program so it can suit your needs best - toolbars

2. Project

   

Definition Creating and project limitations The project’s timeframe Methods of time planning

3. Schedules

 

Types Principles of project creation

4. Tasks

     

Defining Task duration and its time constraints Relationships Units of time Work time vs calendar time Control tasks and project summary tasks

5. Calendar options

 

Defining working days/hours and holidays Weekly and monthly workload

6. Additional task options

   

Sorting Filtering Grouping The critical path method

COGNITY Practical, effective trainings and consultations Kraków-Kazimierz, tel.(12) 421 87 54, kom. 533 98 66 33, e-mail: biuro@cognity.pl WWW.COGNITY.PL

39

7. Adding resources

    

Types of resources Allocation of resources , dependencies Cost - the fixing of rates and payment options Sorting resources Analysing resource overload and resource balancing

8. Views

   

Formatting the Gantt chart Calendar view Cost analysis view Additional views

9. Standard reports 10.Plans

   

The base plan Operational plans Checkpoints Progress lines

11.Printing settings

COGNITY Practical, effective trainings and consultations Kraków-Kazimierz, tel.(12) 421 87 54, kom. 533 98 66 33, e-mail: biuro@cognity.pl WWW.COGNITY.PL

40

Project Advanced

16 lesson units / 2 days

FOR THOSE WHO:

  

have a basic knowledge of MS Project want to easily navigate through the program want to expand their knowledge of its capabilities and use the program’s advanced features

AFTER THE TRAINING YOU WILL KNOW HOW TO:

   

easily define the project, its purpose, scope, resources and necessary participants track the progress of the project, correctly understand the information about its status, assess the impact of changes in its course prepare final forecasts coordinate several projects simultaneously and perform calculations using Microsoft Excel

THE TRAINING PROGRAMME:

1. Tasks

        

Defining , setting their duration and estimation Various types of tasks - simple, recurrent Tasks composition methods in the project Task dependencies Tasks ahead of schedule and those delayed Complex dependencies Types of restrictions and their impact on the schedule (flexible , moderate ) External interdependence - connecting tasks from different calendars Critical path and analysis

2. Resources

     

Dependencies Workload and overtime Costs and workload analysis Resource overload and balancing analysis Tasks and over-budget resources Sharing data between projects

3. Calendars

  

Basic settings Transferring calendars between my project and exporting them to other programs Combining tasks from different calendars Resource calendars

4. Costs

 

Analysis of cost types and cash flows Project budget

COGNITY Practical, effective trainings and consultations Kraków-Kazimierz, tel.(12) 421 87 54, kom. 533 98 66 33, e-mail: biuro@cognity.pl WWW.COGNITY.PL

41

5. Project optimization

          

Estimate task durations using PERT analysis Analysis of project performance using the earned value analysis Analysis of the projects performance and resource utilisation with the Project Server program Server configuration and connecting Creating a project on the server Sharing projects, permissions Reporting progress Tracking progress - progress bars, checkpoints, actual costs, delays Updates Managing multiple projects Templates

6. Plans

  

The base plan Operational plans Lines of project’s progress

7. Adding calculated fields 8. Reports

 

Standard reports Custom reports – task-based , resource-based , mixed

9. Copying and exporting to other programs 10.Advanced Settings view and print

COGNITY Practical, effective trainings and consultations Kraków-Kazimierz, tel.(12) 421 87 54, kom. 533 98 66 33, e-mail: biuro@cognity.pl WWW.COGNITY.PL

42

Access

COGNITY Practical, effective trainings and consultations Krak贸w-Kazimierz, tel.(12) 421 87 54, kom. 533 98 66 33, e-mail: biuro@cognity.pl WWW.COGNITY.PL

43

Access Basics

16 lesson units / 2 days

FOR THOSE WHO:

 

are not familiar with MS Access or possess only a basic knowledge about the program want to gain the knowledge to apply it in daily management of databases

AFTER THE TRAINING YOU WILL KNOW HOW TO:

     

use the basic tools of MS Access design and create a simple database properly enter data set relationships between tables create and use simple queries develop reports/forms and print them

THE TRAINING PROGRAMME:

1. Introduction

    

Application and capabilities of the program Basic concepts of databases User Interface : Ribbon and Quick Access Toolbar Using databases created in Access Opening and closing applications and databases

2. Tables

        

Wizard and templates Creating tables , records and fields Attributes of fields and determining the primary key Indexing Relationships Operations on records and fields Working with data Filters in the tables and forms Searching for data

3. Forms

      

Creating forms using the wizard Designing simple forms Basic properties of a form Dropdown lists, sub forms Usage the control objects Form views Form printing options.

4. Queries

   

Building queries, query types Query wizard Creating and modifying simple queries Sorting and filtering data

COGNITY Practical, effective trainings and consultations Kraków-Kazimierz, tel.(12) 421 87 54, kom. 533 98 66 33, e-mail: biuro@cognity.pl WWW.COGNITY.PL

44

5. Reports

     

Reports types and their applications Creating simple reports Modifications Mathematical operations in reports Reviewing and designing reports Printing

6. Cooperation with other MS Office programs

COGNITY Practical, effective trainings and consultations Kraków-Kazimierz, tel.(12) 421 87 54, kom. 533 98 66 33, e-mail: biuro@cognity.pl WWW.COGNITY.PL

45

Access Advanced

16 lesson units / 2 days

FOR THOSE WHO:

 

have a basic knowledge of working in MS Access want to learn good design the database structure using advanced tools

AFTER THE TRAINING YOU WILL KNOW HOW TO:

    

use advanced MS Access tools, create advanced queries, also using SQL prepare database for external users create complex forms and reports with graphs protect data and privileges.

THE TRAINING PROGRAMME:

1. Tables  Selection of data fields to content  Input mask  Primary keys and foreign keys  Indexes  Validation rule  Enforcing referential integrity 2. Queries - advanced topics  Advanced select queries  Parameterized query  Calculations in a query  Query using the constructor expressions 3. Using queries with SQL  Query connecting  Pass-through queries data 4. Preparing database for external users  Creation of the welcome board  Creation of a switching form  Setting the startup options  Create and use macros  Maintenance of the database 5. Forms - advanced topics  Types of forms  Create a form using Design view  Sections  Data validation  Broadcast your forms look professional  Work with subforms  Charts and pivot tables, forms

COGNITY Practical, effective trainings and consultations Kraków-Kazimierz, tel.(12) 421 87 54, kom. 533 98 66 33, e-mail: biuro@cognity.pl WWW.COGNITY.PL

46

6. Reports - advanced topics  Create and edit reports  Subreports  Formatting reports  Charts on reports 7. Safety and streamline  Securing the database password  Encryption and decryption of data  Sharing database  Database replication  Distributor database  Working groups and permissions  Protection of database design  Distribution base

COGNITY Practical, effective trainings and consultations Kraków-Kazimierz, tel.(12) 421 87 54, kom. 533 98 66 33, e-mail: biuro@cognity.pl WWW.COGNITY.PL

47

Outlook

COGNITY Practical, effective trainings and consultations Krak贸w-Kazimierz, tel.(12) 421 87 54, kom. 533 98 66 33, e-mail: biuro@cognity.pl WWW.COGNITY.PL

48

Outlook

8 lesson units / 1 day

FOR THOSE WHO:

  

have no or only basic knowledge about of the program want to learn how to write e-mails and create tasks in the calendar want to learn practical skills to use them later in contact and task management

AFTER THE TRAINING YOU WILL KNOW HOW TO:

    

create an account and set the mail client parameters add contacts and manage your address book and massage flow set up the calendar and add meetings, appointments and events improve the use of the journal options create tasks and notes

THE TRAINING PROGRAMME: 1. Email management

       

Sending , receiving, replying, forwarding messages Manage folders and messages Grouping, filtering , sorting messages Rules and alerts Searching for messages Options for messages Views

Archiving of messages 2. Contacts

  

Creating contacts Instant messaging

Distribution lists 3. Calendar

     

Configuring the calendar Managing meetings , appointments , recurring events Managing leisure time Managing meeting locations Group schedules

Archiving 4. Outlook Journal

     

Creating journal entries Journal views Recording activities Recording of operations on documents Access, Excel , Word Automatic recording of journal entries Controlling time of different activities

COGNITY Practical, effective trainings and consultations Kraków-Kazimierz, tel.(12) 421 87 54, kom. 533 98 66 33, e-mail: biuro@cognity.pl WWW.COGNITY.PL

49

5. Tasks

    

Assigning and executing tasks Recurring tasks Grouping tasks Cooperation with the journal

Reports 6. Notes

  

Creating notes Available note views Note options

COGNITY Practical, effective trainings and consultations Kraków-Kazimierz, tel.(12) 421 87 54, kom. 533 98 66 33, e-mail: biuro@cognity.pl WWW.COGNITY.PL

50