MS-55167 Advanced Microsoft Excel 2016

KLUCZOWE ZAGADNIENIA

• Tworzenie tabel przestawnych i wykresów.
• Śledzenie w formułach poprzedników i zależności.
• Konwersja tekstu, sprawdzenie poprawności i konsolidacja danych.
• Współpraca z innymi z użyciem ochrony arkuszy i skoroszytów.
• Tworzenie, wykorzystanie, edycja i zarządzanie makrami.
• Importowanie i eksportowanie danych.

Paweł Kiraga, Microsoft Certified Trainer

Tematyka szkolenia pokrywa zagadnienia wymagane na ścieżkach: MOE: Excel Expert 2016, MOM: 2016 Master

TEMATYKA ZAJĘĆ

• Module 1: Using Pivot Tables
  Creating Pivot Tables
  Inserting Slicers
  Working with Pivot Tables
  Inserting Pivot Charts
  More Pivot Table Functionality
  Lab: Using Pivot Tables

• Module 2: Auditing Worksheets
  Tracing Precedents
  Tracing Dependents
  Showing Formulas
  Lab: Auditing Worksheets

• Module 3: Data Tools
  Converting Text to Columns
  Linking to External Data
  Controlling Calculation Options
  Data Validation
  Consolidating Data
  Goal Seek
  Lab: Data Tools

• Module 4: Working with Others
  Protecting Worksheets and Workbooks
  Tracking Changes
  Marking a Workbook as Final
  Lab: Working with Others

• Module 5: Recording and Using Macros
  Recording Macros
  Running Macros
  Editing Macros
  Adding Macros to the Quick Access Toolbar
  Lab: Recording and Using Macros

• Module 6: Random Useful Items
  Sparklines
  Preparing a Workbook for Internationalization and Accessibility
  Importing and Exporting Files
  Lab: Random Useful Items

• Module 7: Microsoft Excel Features that Were New in 2013
  Using Slicers to Filter Data
  Creating a PivotTable Timeline
  Creating a Standalone PivotChart
  Workspaces in Excel 2013
  Lab: Microsoft Excel Features that Were New in 2013

• Module 8: Features New in 2016
  PivotTable Updates
  Ink Equations
  Multi-Select Option in Slicers
  Quick Shape Formatting
  Sharing with SharePoint or OneDrive