Adjustment of the working environment
Hotkeys, facilities
Create and modify toolbars
Options excel (autosave, input, etc.).
Options paste special (transpose)
Formatting (style, format painter)
Tool - go to
Organization of information
Management sheets (naming, copying, color change)
Assign and manage the names of cells and ranges
Protect worksheet and workbook
Secure and encrypt files
Collaboration and track changes, comments
Inspection sheet
Create your own templates (charts, worksheets, workbooks)
Data analysis
Logic
Basic Features
Advanced Features
Creation of complex / multiple formulas
Scenarios
Search result
Solver
Charts
Graphics support (shadows, charts, AutoShapes)
Database management (list)
Data consolidation
Grouping and outlining data
Sorting data (over 4 columns)
Advanced data filtering
Database Functions
Subtotal (partial)
Tables and Pivot Charts
Cooperation with other applications
Get External Data (CSV, TXT)
OLE (static and link)
Web Queries
Publication sheets on site (static and dynamic)
Publication PivotTables
Automation of work
Conditional Formatting
Create your own formats
Check the validation
Macros - automation tasks in sheets
Registration macros
Understanding and modifying the code macros (VBA items)
Connecting the interface macros or workbook
Create forms on screen or printed
|
合作伙伴與授權機構
shuhaipeixun
1299983702
總部李老師
