课程大纲
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
要求
Knowledge of Windows and the basics of using Microsoft Excel.
客户评论 (10)
I learned new things so that is a good point
Daria - LKQ Polska Sp. z o. o.
课程 - Analysing Financial Data in Excel
“有趣的事实”——如何以相反的方式实现相同的目标。
Paulina - Noble Drilling Poland
课程 - Microsoft Office Excel - poziom średnio zaawansowany
机器翻译
Tworzenie tabel i kalkulacja ich danych.
Katarzyna Ciunajcis
课程 - Working with spreadsheet in Microsoft Excel
主题的穷尽
Karol - VOLKSWAGEN POZNAŃ SP. Z O.O.
课程 - Excel Advanced with VBA
机器翻译
I like the hands on training and seeing us solve for issues on the spot.
Jon Matrille - LocumTenens.com
课程 - Visual Basic for Applications (VBA) in Excel - Advanced
举例说明,说明翻译方式
Aneta - LKQ Polska Sp. z o. o.
课程 - Visual Basic for Applications (VBA) in Excel (intermediate level)
机器翻译
非常准确的翻译,注意学生在做什么。与该主题相关的广泛问题。非常有用的培训!
Magdalena - DataConsult S.A.
课程 - Microsoft Office Excel - working effectively with the spreadsheet
机器翻译
我喜欢大量的任务和友好的气氛。
Paulina - LKQ Polska Sp. z o. o.
课程 - Excel Data Analysis
机器翻译
培训师的灵活性。全面回答每个问题。
Krystyna Szpala - Sogecap SA Branch in Poland
课程 - Visual Basic for Applications (VBA) for Analysts
机器翻译
材料与小组的完美适应,详细讨论问题,能力非常高,与小组有很好的联系,知识转移能力强,
Malgorzata - LKQ Polska Sp. z o. o.
课程 - Excel Basics
机器翻译