MS Excel - for intermediate users (MSE2)
The course is suitable for broadening and deepening knowledge of MS Excel spreadsheet. The aim of the course is to teach students how to create complex tables with high graphical level, to present information in the form of graphs, and to fully and effectively exploit the possibilities of the program.
|The course is included in the following category:||
Kancelářské aplikace → Microsoft Office → Microsoft Excel
Difficulty of the course: Advanced
Course duration: 2 days
Contents of the course:
workspace settings (bookmarks, buttons, Add-Ins)
- Formula and Function
purpose and use, formula, nested functions, Formula Auditing
- Data Validation
purpose and use, Settings, Input Message, Error Alert
purpose and use, Protect Sheet, Cells protection, Formulas protection, File protection
- Linking Data
purpose and use, in sheet, between sheets, between files (How to use, possible problems and their solutions)
- Pivot table
purpose and use, settings, How to create
- Pivot table editing
Pivot table styles, style options, various design options of Pivot table, various options data view
- Editing functionality
function change, Reflesh, Change Data Source, Groups and Subtotals view
AutoFilter, Slicer, Timeline
Calculated Field, Calculated Item
- Power Pivot
purpose and use, How to install (Add-Ins), repair, data types and saving files, Add to Data Model (import), relationship, creating hierarchies, Pivottable from Power Pivot
other informations, info resources.
Expected knowledge: User knowledge of MS Windows and knowledge on level of course MSE1: MS Excel - for beginners.
The price includes books in the value of: 500 CZK
Time schedule: 9:00 - 17:00.
Recommended previous and follow-up courses:
Recommended previous and follow-up courses