課程簡介
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.
客戶評論 (12)
Tworzenie tabel i kalkulacja ich danych.
Katarzyna Ciunajcis
Course - Working with spreadsheet in Microsoft Excel
主題的窮盡
Karol - VOLKSWAGEN POZNAŃ SP. Z O.O.
Course - Excel Advanced with VBA
機器翻譯
舉例說明,說明翻譯方式
Aneta - LKQ Polska Sp. z o. o.
Course - Visual Basic for Applications (VBA) in Excel (intermediate level)
機器翻譯
非常準確的翻譯,注意學生在做什麼。與該主題相關的廣泛問題。非常有用的培訓!
Magdalena - DataConsult S.A.
Course - Microsoft Office Excel - working effectively with the spreadsheet
機器翻譯
培訓師的靈活性。全面回答每個問題。
Krystyna Szpala - Sogecap SA Branch in Poland
Course - Visual Basic for Applications (VBA) for Analysts
機器翻譯
“有趣的事實”——如何以相反的方式實現相同的目標。
Paulina - Noble Drilling Poland
Course - Microsoft Office Excel - poziom średnio zaawansowany
機器翻譯
有趣的練習
Kacper - LKQ Polska Sp. z o. o.
Course - Excel Advanced
機器翻譯
I learned new things so that is a good point
Daria - LKQ Polska Sp. z o. o.
Course - Analysing Financial Data in Excel
材料與小組的完美適應,詳細討論問題,能力非常高,與小組有很好的聯繫,知識轉移能力強,
Malgorzata - LKQ Polska Sp. z o. o.
Course - Excel Basics
機器翻譯
我喜歡大量的任務和友好的氣氛。
Paulina - LKQ Polska Sp. z o. o.
Course - Excel Data Analysis
機器翻譯
Trainer's knowledge and experience.
Paweł Dykowski - LKQ Polska Sp. z o. o.
Course - Excel Modelling
訓練期間的節奏很快。知識淵博,教學風格
James - Gilead Sciences Ireland
Course - Excel to Power BI
機器翻譯