Intermediate Level
2 x 8 school hrs.
Price: 550 PLN net / person
Terminarz szkoleń
Target audience
- Users with basic MS Excel
- Users creating reports, tables and charts in MS Excel
What you will learn:
- How to work independently with MS Excel
- How to use essential tools for data analysis
Content
Microsoft Office Excel - Touring the
application
- Microsoft Excel know-how
- Basic operations in Excel - Open, Save
- MS Excel interface
Editing and formatting a worksheet
- Cells and data types
- Comments
- Editing data
- Working with large files - Frozen spreedsheet, etc.
- Formatting cells
- Formatting numbers
- Formatting tables
- Removing formatting
- Copy, Paste, Cut
- Series and custom lists
Working with database
- Creating database in Excel
- Data validation tools
- Sort & Filter
- Autofilter
- Advanced Filter
Formulas and Functions
- Introduction to formulas
- Functions
- Correcting errors in formulas
- Copying formulas
- Names in formulas
Data Visualization
- Using Charts
- Charts Formatting
- Printing charts
Database Tools
- Data Consolidation
- Subtotals
- PiovotTables
- PiovtCharts
- Importing Data
Using functions
- Nesting functions
- Math functions
- SUMIF
- SUMIFS
- SUMAPRODUCT
- ROUND
Logical Functions
Information Functions
Search Functions
- HLOOKUP, VLOOKUP
- MATCH
- OFFSET
Text Functions
- UPPER
- LEFT
- RIGHT
- MID
- LEN
- FIND
Database Functions
- DAVERAGE
- DCOUNT, DCOUNTA
- DMAX
Date & Time Functions
Security & Protection in Excel
Worksheet protection
- Locking Cells
- Hiding Cells
Workbook file protection
- Password Security
- Workbook Structure Protection
- Window Protection
