Advanced Level
2 x 8 school hrs.
Price: 650 PLN net / person
Terminarz szkoleń
Content
Working with database
- Creating database in Excel
- Data validation tools
- Sort & Filter
- Autofilter
- Advanced Filter
Database Tools
- Data Consolidation
- Subtotals
- PiovotTables
- PiovtCharts
- Importing Data
Using functions
Nesting functions
Math functions
- SUMIF
- SUMIFS
- SUMAPRODUCT
- ROUND
Logicat Functions
- Information Functions
- Search Functions
- HLOOKUP, VLOOKUP
- MATCH
- OFFSET
Text Functions
- UPPER
- LEFT
- RIGHT
- MID
- LEN
- FIND
Statistical Functions
- COUNT
- COUNTA
- COUNTIF
- FREQUENCY
Database Functions
- DAVERAGE
- DCOUNT, DCOUNTA
- DMAX
Date & Time Functions
Financial Functions
Security & Protection in Excel
Worksheet protection
- Locking Cells
- Hiding Cells
Workbook file protection
- Password Security
- Workbook Structure Protection
- Window Protection
Data Analysis and Simulation
- GoalSeek
- Solver
- Scenarios
Data Visualization
- Using Charts
- Finding the Best Type of Chart that Fits to Analyzed Data
- Creating and Formatting Charts
- Chart Template
- Combining Different Chart Types into a Single Excel Chart
- Comparative histogram
- Printing charts
Introduction to Macros
- Displaying the Developer Tab
- Record macro
- Macro security
