Pivot tables for Fast Data Analysis, Reviews and Reports
PivotTables is one of the most valuable tools in Excel. Many Excel users are either afraid of using it or are not sure how to fulfil tasks with the use of a pivot table.
It may seem that its use is complicated, however, as soon as you master the work with pivot tables, you will be able to perform your form smarter and faster than ever before and will be armed with endless opportunities for fast data analysis, making reports and effective summaries.
Seminar participants will learn how to use pivot tables very fast in a few clicks, process thousands of numbers, sort those, calculate and process collected data and browse those by using various pivots.
TOPICS OF THE SEMINAR
- Conditions for making a pivot table
- Principles of work with pivot tables
- Data Source
- Refresh
- Copying data
- Types of data organisation in pivot tables
- Sorting
- Filtering
- Grouping
- Work with a date
- Calculations in pivot tables
- Simple calculations
- Interest calculations
- Calculating proportions, relations
- Making separate reports by worksheets
- Making charts
The course is presented by:
Aija Virse
An IT lecturer having more than 20-years’ experience in various types of training for adults at various levels gained in both major and minor projects.
Thanks to Liepaja’s bitter winds, the lecturer was awarded an academic master’s degree in computer sciences and supplemented it with the professional master’s degree in psychology. Therefore, any classes conducted by the lecturer will go smoothly enriching user experience and leading to new conclusions. The most important is students’ motivation and willingness to learn, and the lecturer is responsible for the rest.
The most demanded topics are Microsoft Office applications: Excel, Outlook, PowerPoint and Word. If You have a question what MS Office version? – any version, starting with 1997 up to O365 and more recent.
Duration of the course: 3 hours
This course can be presented by the lecturer in the Latvian, English or Russian language upon the audience’s request.
There are not more than 14 participants in a group!
Find out the price
