Why you should take this training?

The training is designed to demonstrate the possibilities provided by Microsoft Excel using real-life examples. Participants will gain the skills allowing them to smoothly navigate the Microsoft Excel environment and to use a wealth of options to enter, edit and process data collected as spreadsheet files.

Who is it for?

The training is intended for those who begin their journey with Microsoft Excel, who use the program to a limited extent only, and those who want to consolidate their knowledge based on practical examples. It is designed for employees whose job requires them to create numerical data sets, analyse them and draw logical conclusions.

Having completed the training, the participants will be able to:

1. Navigate the spreadsheet environment and identify its uses,
2. Save, close and open files,
3. Enter data into worksheet cells using easy-to-use keyboard modes, dragging methods as well as relative and absolute addressing,
4. Make the sheets look better and easier to read by using direct and conditional formatting,
5. Apply the chart type best suited to a specific data range,
6. Create and delete sheets,
7. Readily find the information needed by using filtering, sorting and other database-related tools. 

Agenda of the training:

I. Working with the sheet – the basics:

1. Definition of a spreadsheet using MS Excel as an example
2. Using spreadsheets
   1. Complex calculations
   2. Presenting charts
   3. Databases
   4. Data analysis
   5. A starting point for new fully functional applications
3. Software working environment and navigation
4. First steps:
   1. Starting the programme
   2. Creating a new workbook
   3. Saving a file
   4. Closing the application

II. Generating content:

1. Entering and editing cell contents
   1. Entering data into a cell
   2. Selecting cells
   3. Keyboard modes
   4. Entering data into multiple cells
   5. Paste Special command...
   6. AutoComplete
   7. Fill Series
   8. Creating Named Ranges
   9. Deleting data
   10. Data search
   11. Inserting and adjusting graphics
2. Relative and absolute cell addressing
3. Basic functions
4. Basic software options
5. Customising the view of the software window
6. Inserting and editing comments
7. Undoing changes 

III. Formatting:

1. Cell formatting
   1. Numbers
   2. Alignment
   3. Font
   4. Framing
   5. Patterns
2. Formatting rows and columns
3. Formatting the sheet
4. Autoformatting
5. Styles
6. Copying formats
7. Introduction to conditional formatting

IV. Charts:

1. Using charts
   1. Basic chart types
   2. Custom chart types
   3. Combining chart types
2. Formatting charts
   1. Formatting charts
   2. Data series
   3. Labels
   4. Chart scale
   5. Customising charts
   6. Adding a Trendline
3. Making a chart based on several tables
4. Using diagrams
   1. Types of diagrams
   2. Inserting and editing diagrams

V. Working with the sheet:

1. Creating a new workbook from a template
2. Inserting and deleting Sheets and Charts
3. Inserting and deleting cells
4. Hiding and showing columns and rows
5. Merging cells
6. Moving cells and sheets
7. Inserting and modifying links
8. Data preparation and printing
9. Saving files using appropriate formats
10. Organising workbooks into folders

VI. Databases – the basics:

1. The concept of a database in Excel
2. Filtering data using the Autofilter tool
3. Advanced filter
4. Data sorting
5. Subtotals
6. Grouping