☆ 1、如有部分内容理解不透或消化不好，可免费在以后培训班中重听；
      ☆ 2、在课程结束之后,授课老师会留给学员手机和E-mail,免费提供半年的课程技术支持，以便保证培训后的继续消化；
      ☆3、合格的学员可享受免费推荐就业机会。
      ☆4、合格学员免费颁发相关工程师等资格证书，提升您的职业资质。

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