Loading...

Terminy kursów:

21.10.2019 - 21.10.2019
25.11.2019 - 25.11.2019
16.11.2019 - 16.11.2019

Oficjalny konspekt Microsoft Pozostałe szkolenia

MS-55167 Advanced Microsoft Excel 2016

Czas trwania kursu: 1 dzień
Cena: 499zł

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

CERTYFIKACJE ZAWODOWE

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

MOS   MOE MOM 

 Dowiedz się więcej o certyfikacjach Microsoft

 POZIOM SZKOLENIA

podstawowy średniozaawansowany zaawansowany ekspercki
100 200 300 400

 

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

AZ-500 Microsoft Azure Security Technologies
18.11.2019 - 22.11.2019
DP-100 Designing and Implementing a Data Science Solution on Azure
12.11.2019 - 14.11.2019
AZ-103 Microsoft Azure Administrator
28.10.2019 - 31.10.2019
MS-55039 Windows PowerShell Scripting and Toolmaking
16.09.2019 - 20.09.2019
DP-201 Designing an Azure Data Solution
05.09.2019 - 06.09.2019
MS-201T01: Defining a Hybrid Messaging Strategy
MS-201 Implementing a Hybrid and Secure Messaging Platform
24.06.2019 - 27.06.2019
MD-100 Windows 10
30.09.2019 - 04.10.2019
DP-200 Implementing an Azure Data Solution
02.09.2019 - 04.09.2019
MS-201T02 Managing Messaging Security, Hygiene, and Compliance
AI-100 Designing and Implementing an Azure AI Solution
17.06.2019 - 19.06.2019
AZ-203T06 Connect to and consume Azure, and third-party, services
AZ-203T05 Monitor, troubleshoot, and optimize Azure solutions
AZ-203T04 Implement Azure security
AZ-203T03 Develop for Azure storage
AZ-203T02 Develop Azure Platform as a Service compute solutions
AZ-203 Developing Solutions for Microsoft Azure
06.05.2019 - 10.05.2019
AZ-203T01 Develop Azure Infrastructure as a Service compute solutions
MS-200T02 Managing Client Access and Mail Flow
MS-200 Planning and Configuring a Messaging Platform
23.09.2019 - 27.09.2019
MS-200T03 Managing Messaging High Availability and Disaster Recovery
MS-200T01 Understanding the Modern Messaging Infrastructure
MS-500T01 Managing Microsoft 365 Identity and Access
MS-500T04 Administering Microsoft 365 Built-in Compliance
MS-500T03 Implementing Microsoft 365 Information Protection
MS-500T02 Implementing Microsoft 365 Threat Protection
MS-301T01 Implementing SharePoint 2019 Infrastructure
MS-301T02 Implementing SharePoint 2019 Service Applications
MS-301T03 Implementing SharePoint Hybrid Scenarios
MS-301T04 Migrating to SharePoint Online
MS-301 Deploying SharePoint Server Hybrid
07.10.2019 - 11.10.2019
MS-300T01 Managing Office 365 Content Services
MS-300T02 Managing SharePoint Online
MS-300T03 Enabling Microsoft Teams for Collaboration
MS-300T04 Enabling Office 365 Workloads for Collaboration
MS-300 Deploying Microsoft 365 Teamwork
14.10.2019 - 18.10.2019
MD-101T03 Protecting Modern Desktops and Devices
MD-101T01 Deploying the Modern Desktop
MD-101T02 Managing Modern Desktops and Devices
MD-101 Managing Modern Desktops
09.09.2019 - 13.09.2019
MD-100T03 Protecting Windows 10
MD-100T02 Configuring Windows 10
MD-100T04 Maintaining Windows 10
MS-900 Microsoft 365 Fundamentals
19.09.2019 - 19.09.2019
AZ-400T07 Designing a DevOps Strategy
AZ-400T06 Implementing Continuous Feedback
AZ-400T05 Implementing Application Infrastructure
AZ-400T04 Implementing Dependency Management
AZ-400T03 Implementing Continuous Delivery
AZ-400T02 Implementing Continuous Integration
AZ-400 Microsoft Azure DevOps Solutions
23.09.2019 - 01.10.2019
AZ-900 Microsoft Azure Fundamentals
30.09.2019 - 30.09.2019
MS-500 Microsoft 365 Security Administration
14.10.2019 - 18.10.2019
MD-100T01 Installing Windows 10
AZ-400T01 Implementing DevOps Development Processes
MS-10987 Performance Tuning and Optimizing SQL Databases
28.10.2019 - 31.10.2019
MS-10991 Troubleshooting Windows Server 2016 Core Technologies
27.05.2019 - 31.05.2019
MS-101T02: Microsoft 365 Compliance Management
MS-100T01: Office 365 Management
MS-100T02: Microsoft 365 Tenant & Service Management
MS-100T03: Microsoft 365 Identity Management
MS-101 Microsoft 365 Mobility and Security
18.11.2019 - 22.11.2019
MS-100 Microsoft 365 Identity and Services
20.05.2019 - 24.05.2019
AZ-301T02 Designing a Data Platform Solution
MS-40551 Microsoft Security Workshop: Enterprise Security Fundamentals
MS-40555 Microsoft Security Workshop: Implementing PowerShell Security Best Practices
MS-40552 Microsoft Security Workshop: Managing Identity
MS-40553 Microsoft Security Workshop: Planning for a Secure Enterprise – Improving Detection
Microsoft Security Workshop
13.05.2019 - 17.05.2019
MS-20467 Designing Business Intelligence Solutions with Microsoft SQL Server 2014
SQL Server 2012/2014
MS-20466 Implementing Data Models and Reports with SQL Server 2014
SQL Server 2012/2014
17.06.2019 - 21.06.2019
MS-20465 Designing Solutions for Microsoft SQL Server 2014
SQL Server 2012/2014
20.05.2019 - 22.05.2019
MS-20464 Developing Microsoft SQL Server 2014 Databases
SQL Server 2012/2014
07.10.2019 - 11.10.2019
MS-40554 Microsoft Security Workshop: Implementing Windows 10 Security Features
AZ-301T01 Designing for Identity and Security
AZ-301T03 Designing for Deployment, Migration, and Integration
AZ-301T04 Designing an Infrastructure Strategy
AZ-301 Microsoft Azure Architect Design
27.05.2019 - 30.05.2019
AZ-300T06 Developing for the Cloud
AZ-300T05 Implementing Authentication and Secure Data
AZ-300T04 Creating and Deploying Apps
AZ-300T03 Understanding Cloud Architect Technology Solutions
AZ-300T02 Implementing Workloads and Security
AZ-300T01 Deploying and Configuring Infrastructure
AZ-300 Microsoft Azure Architect Technologies
18.11.2019 - 22.11.2019
MS-101T01: Microsoft 365 Security Management
MS-101T03: Microsoft 365 Device Management
MS-10986 Updating Your Skills to SQL Server 2016
SQL Server 2016
03.06.2019 - 05.06.2019
MS-10985 Introduction to SQL Databases
SQL Server 2012/2014
03.06.2019 - 05.06.2019
MS-10994 Data Analysis Fundamentals using Excel
SQL Server 2016
13.05.2019 - 14.05.2019
MS-20537 Configuring and Operating a Hybrid Cloud with Microsoft Azure Stack
MCSA
06.05.2019 - 10.05.2019
MS-55224-2 Operationalize Cloud Analytics Solutions with Microsoft Azure
MCSE
15.05.2019 - 16.05.2019
MS-55224-1 Microsoft Azure Big Data Analytics Solutions
SQL Server 2016
27.06.2019 - 28.06.2019
MS-55021 Configuring and Administering Hyper-V in Windows Server 2012
Windows Server 2012/2012R2
23.04.2019 - 25.04.2019
MS-20778 Analyzing Data with Power BI
SQL Server 2016
09.09.2019 - 11.09.2019
MS-20779 Analyzing Data with Excel
SQL Server 2016
24.06.2019 - 26.06.2019
MS-20417 Upgrading Your Skills to MCSA Windows Server 2012
Windows Server 2012/2012R2
16.12.2019 - 20.12.2019
MS-20414 Implementing an Advanced Server Infrastructure
Windows Server 2012/2012R2
20.05.2019 - 24.05.2019
MS-20413 Designing and Implementing a Server Infrastructure
Windows Server 2012/2012R2
21.10.2019 - 25.10.2019
MS-10982 Supporting and Troubleshooting Windows 10
Windows 10
26.08.2019 - 30.08.2019
MS-20412 Configuring Advanced Windows Server 2012 Services
Windows Server 2012/2012R2
27.05.2019 - 31.05.2019
MS-20411 Administering Windows Server 2012
Windows Server 2012/2012R2
15.04.2019 - 19.04.2019
MS-20410 Installing and Configuring Windows Server 2012
Windows Server 2012/2012R2
18.11.2019 - 22.11.2019
MS-55200 SharePoint 2016 Power User Training
SharePoint 2016
23.05.2019 - 24.05.2019
MS-55199 SharePoint 2016 End User Training
SharePoint 2016
20.05.2019 - 22.05.2019
MS-20745 Implementing a Software-Defined DataCenter
System Center
30.09.2019 - 04.10.2019
MS-10997 Office 365 Administration and Troubleshooting
Office 365
04.09.2019 - 06.09.2019
MS-20703-2 Integrating MDM and Cloud Services with System Center Configuration Manager
System Center
23.04.2019 - 25.04.2019
MS-20703-1 Administering System Center Configuration Manager
System Center
07.10.2019 - 11.10.2019
MS-20489 Developing Microsoft SharePoint Server 2013 Advanced Solutions
SharePoint 2013
06.05.2019 - 10.05.2019
MS-55247 Designing and Implementing Cloud Data Platform Solutions
08.10.2018 - 10.10.2018
MS-20487 Developing Windows Azure and Web Services
Programowanie
14.10.2019 - 18.10.2019
MS-20486 Developing ASP.NET MVC 4 Web Applications
Programowanie
24.06.2019 - 28.06.2019
MS-20483 Programming in C#
Programowanie
03.06.2019 - 07.06.2019
MS-20480 Programming in HTML5 with JavaScript and CSS3
Programowanie
13.05.2019 - 17.05.2019
MS-10962 Advanced Automated Administration with Windows PowerShell
MCSA
20.05.2019 - 22.05.2019
MCSA: Cloud Platform
MCSA
08.04.2019 - 29.05.2019
MS-55154 Office 365 for the End-User
Office 365
26.04.2019 - 26.04.2019
MS-55179 Advanced Microsoft Outlook 2016
13.09.2019 - 13.09.2019
MS-55178 Introduction to Microsoft Outlook 2016
12.09.2019 - 12.09.2019
MS-55177 Advanced Microsoft PowerPoint 2016
PowerPoint 2016
11.09.2019 - 11.09.2019
MS-55176 Introduction to Microsoft PowerPoint 2016
PowerPoint 2016
10.09.2019 - 10.09.2019
MS-55167 Advanced Microsoft Excel 2016
Excel 2016
09.09.2019 - 09.09.2019
MS-55166 Intermediate Microsoft Excel 2016
Excel 2016
06.09.2019 - 06.09.2019
MS-55165 Introduction to Microsoft Excel 2016
Excel 2016
05.09.2019 - 05.09.2019
MS-55175 Advanced Microsoft Word 2016
Word 2016
04.09.2019 - 04.09.2019
MS-55174 Intermediate Microsoft Word 2016
Word 2016
03.09.2019 - 03.09.2019
MS-55173 Introduction to Microsoft Word 2016
Word 2016
02.09.2019 - 02.09.2019
MS-10993 Integrating On-Premises Identity Infrastructure with Microsoft Azure
14.11.2019 - 15.11.2019
MS-10992 Integrating On-Premises Core Infrastructure with Microsoft Azure
24.04.2019 - 26.04.2019
MCSA: Windows Server 2016
MCSA
14.10.2019 - 27.01.2020
MS-20768 Developing SQL Data Models
SQL Server 2016
15.04.2019 - 17.04.2019
MS-20767 Implementing a SQL Data Warehouse
SQL Server 2016
23.09.2019 - 27.09.2019
MS-20334 Core Solutions of Skype for Business 2015
Skype for Business 2015
15.04.2019 - 19.04.2019
MS-20744 Securing Windows Server 2016
Windows Server 2016
18.11.2019 - 22.11.2019
MS-20337 Enterprise Voice and Online Services with Microsoft Lync Server 2013
Lync Server 2013
20.05.2019 - 24.05.2019
MS-20336 Core Solutions of Microsoft Lync Server 2013
Lync Server 2013
13.05.2019 - 17.05.2019
MS-10964 Cloud & Datacenter Monitoring with System Center Operations Manager
System Center
13.05.2019 - 17.05.2019
MS-55004 Installing and Configuring System Center 2012 Operations Manager
System Center
15.04.2019 - 19.04.2019
MS-20765 Provisioning SQL Databases
SQL Server 2016
06.05.2019 - 10.05.2019
MS-20764 Administering a SQL Database Infrastructure
SQL Server 2016
25.11.2019 - 29.11.2019
MS-20762 Developing SQL Databases
SQL Server 2016
30.09.2019 - 04.10.2019
MS-20761 Querying Data with Transact-SQL
SQL Server 2016
16.09.2019 - 20.09.2019
MS-50255 Managing Windows Environments with Group Policy
Windows Server 2012/2012R2
23.09.2019 - 27.09.2019
MS-20339-2 Advanced Technologies of SharePoint 2016
SharePoint 2016
13.05.2019 - 17.05.2019
MS-20339-1 Planning and Administering SharePoint 2016
SharePoint 2016
06.05.2019 - 10.05.2019
MS-20741 Networking with Windows Server 2016
Windows Server 2016
14.10.2019 - 18.10.2019
MS-20740 Installation, Storage, and Compute with Windows Server 2016
Windows Server 2016
09.09.2019 - 13.09.2019
MS-20742 Identity with Windows Server 2016
Windows Server 2016
16.09.2019 - 20.09.2019
MS-20345-2 Designing and Deploying Microsoft Exchange Server 2016
Exchange Server 2016
13.05.2019 - 17.05.2019
MS-20345-1 Administering Microsoft Exchange Server 2016
Exchange Server 2016
20.05.2019 - 24.05.2019
MS-20743 Upgrading Your Skills to MCSA: Windows Server 2016
Windows Server 2016
08.04.2019 - 12.04.2019
MS-10972 Administering the Web Server (IIS) Role of Windows Server
Windows Server 2012/2012R2
09.09.2019 - 13.09.2019
MS-10967 Fundamentals of a Windows Server Infrastructure
Windows Server 2012/2012R2
13.05.2019 - 17.05.2019
MS-10971 Storage and High Availability with Windows Server
Windows Server 2012/2012R2
24.06.2019 - 27.06.2019
MS-10969 Active Directory Services with Windows Server
Windows Server 2012/2012R2
04.11.2019 - 08.11.2019
MS-20488 Developing Microsoft SharePoint Server 2013 Core Solutions
SharePoint 2013
15.04.2019 - 19.04.2019
MS-20332 Advanced Solutions of Microsoft SharePoint Server 2013
SharePoint 2013
10.06.2019 - 14.06.2019
MS-20331 Core Solutions of Microsoft SharePoint Server 2013
SharePoint 2013
03.06.2019 - 07.06.2019
Bezpieczeństwo Microsoft Azure, Office 365 oraz Intune
Microsoft Azure / Office 365 / Windows Intune
23.04.2019 - 25.04.2019
Automatyzacja zabezpieczeń w środowiskach Windows 10 oraz Windows Server 2016
Windows 7/8.1/10 & Windows Server 2008R2/2012R2/2016
23.04.2019 - 25.04.2019
Bezpieczeństwo w środowiskach Windows 10 oraz Windows Server 2016
Windows 7/8.1/10 & Windows Server 2008R2/2012R2/2016
12.11.2019 - 14.11.2019
Podstawy bezpieczeństwa w środowiskach Microsoft
Windows 7/8.1/10 & Windows Server 2008R2/2012R2/2016
06.05.2019 - 08.05.2019
MCSA: Office 365
MCSA
09.04.2019 - 30.05.2019
MCSA: SQL Server 2014
MCSA
11.10.2018 - 20.12.2018
MS-10961 Automating Administration with Windows PowerShell
MCSA
30.09.2019 - 04.10.2019
MS-20342 Advanced Solutions of Microsoft Exchange Server 2013
Exchange Server 2013
27.05.2019 - 31.05.2019
MS-20341 Core Solutions of Microsoft Exchange Server 2013
Exchange Server 2013
27.05.2019 - 31.05.2019
MS-10979 Introduction to Microsoft Azure for IT Professionals
28.10.2019 - 29.10.2019
MS-10748 Planning and Deploying System Center 2012 Configuration Manager
System Center
06.05.2019 - 08.05.2019
MS-20347 Enabling and Managing Office 365
Office 365
03.12.2018 - 07.12.2018
MS-20463 Implementing a Data Warehouse with Microsoft SQL Server
SQL Server 2012/2014
24.06.2019 - 28.06.2019
MS-20462 Administering Microsoft SQL Server Databases
SQL Server 2012/2014
10.06.2019 - 14.06.2019
MS-20461 Querying Microsoft SQL Server
SQL Server 2012/2014
03.06.2019 - 07.06.2019