Loading...

Terminy kursów:

09.10.2023 - 09.10.2023
13.11.2023 - 13.11.2023
11.12.2023 - 11.12.2023

Oficjalny konspekt Microsoft Pozostałe szkolenia

MS-55167 Advanced Microsoft Excel 2016

Czas trwania kursu: 1 dzień
Cena: 799 zł netto

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

Wdrażanie i konfiguracja Windows 10 w środowisku domenowym
21.08.2023 - 25.08.2023
MS-55341 Installation, Storage, and Compute with Windows Server (dawniej MS-20740)
21.08.2023 - 25.08.2023
MS-55337 Introduction to Programming
26.06.2023 - 30.06.2023
MS-55238 SharePoint Online for Administrators
20.04.2023 - 21.04.2023
MS-55244 Javascript for Developers (dawniej MS-20480)
26.06.2023 - 30.06.2023
MS-55320 Programming with HTML, CSS, and JavaScript (dawniej MS-20480)
04.09.2023 - 08.09.2023
MS-55348AC Administering Microsoft Endpoint Configuration Manager (dawniej MS-20703-1)
21.11.2022 - 25.11.2022
MS-55349 Networking with Windows Server 2016 (dawniej MS-20741)
26.06.2023 - 30.06.2023
PL-300 Microsoft Power BI Data Analyst
19.06.2023 - 21.06.2023
AZ-801 Configuring Windows Server Hybrid Advanced Services
21.08.2023 - 24.08.2023
AZ-800 Administering Windows Server Hybrid Core Infrastructure
19.06.2023 - 22.06.2023
DP-420 Designing and Implementing Cloud-Native Applications Using Microsoft Azure Cosmos DB
19.06.2023 - 22.06.2023
ASP.NET MVC Core
04.09.2023 - 08.09.2023
SQL SERVER – WYSOKA DOSTĘPNOŚĆ
19.06.2023 - 23.06.2023
AZ-305 Designing Microsoft Azure Infrastructure Solutions
19.06.2023 - 22.06.2023
AZ-030 Microsoft Azure technologies for AWS architects
28.08.2023 - 31.08.2023
AZ-020 Microsoft Azure solutions for AWS developers
26.06.2023 - 28.06.2023
DP-090 Implementing a Machine Learning Solution with Microsoft Azure Databricks
23.06.2023 - 23.06.2023
PL-400 Microsoft Power Platform Developer
19.06.2023 - 23.06.2023
PL-600 Microsoft Power Platform Solution Architect
04.09.2023 - 06.09.2023
PL-200 Microsoft Power Platform Functional Consultant
28.08.2023 - 31.08.2023
PL-100 Microsoft Power Platform App Maker
04.09.2023 - 06.09.2023
AZ-220 Microsoft Azure IoT Developer
19.06.2023 - 22.06.2023
WS-050 Migrating Application Workloads to Azure
28.08.2023 - 29.08.2023
AZ-600 Configuring and Operating a Hybrid Cloud with Microsoft Azure Stack Hub
28.08.2023 - 31.08.2023
AZ-040 Automating Administration with PowerShell
21.08.2023 - 25.08.2023
AZ-700 Designing and Implementing Microsoft Azure Networking Solutions
19.06.2023 - 21.06.2023
MS-55215 SharePoint Online Power User
19.06.2023 - 22.06.2023
DP-080 Querying Data with Microsoft Transact-SQL
26.06.2023 - 27.06.2023
DP-203 Data Engineering on Microsoft Azure
19.06.2023 - 22.06.2023
AZ-140 Configuring and Operating Microsoft Azure Virtual Desktop
21.08.2023 - 24.08.2023
AI-102 Designing and Implementing a Microsoft Azure AI Solution
21.08.2023 - 24.08.2023
SC-900 Security, Compliance, and Identity Fundamentals
26.06.2023 - 26.06.2023
SC-200 Microsoft Security Operations Analyst
28.08.2023 - 31.08.2023
SC-300 Microsoft Identity and Access Administrator
04.09.2023 - 07.09.2023
SC-400 Microsoft Information Protection Administrator
19.06.2023 - 20.06.2023
MS-55300 Microsoft Teams for End Users
26.06.2023 - 26.06.2023
MS-55133 PowerShell for System Center Configuration Manager Administrators
19.06.2023 - 21.06.2023
MS-10984 Deploying and Managing Office 365 Hybrid Deployments
21.08.2023 - 23.08.2023
DP-300 Administering Microsoft Azure SQL Solutions
26.06.2023 - 29.06.2023
MS-203 Microsoft 365 Messaging
28.08.2023 - 01.09.2023
DP-900 Microsoft Azure Data Fundamentals
23.06.2023 - 23.06.2023
WS-012 Windows Server 2019 Hybrid and Azure IaaS
28.08.2023 - 30.08.2023
MS-55371 Windows Server Administration (dawniej WS-011)
28.08.2023 - 01.09.2023
AZ-304 Microsoft Azure Architect Design
28.08.2023 - 31.08.2023
AZ-303 Microsoft Azure Architect Technologies
21.08.2023 - 25.08.2023
MS-050 SharePoint Hybrid Deployment and Migration
26.06.2023 - 30.06.2023
AI-900 Microsoft Azure AI Fundamentals
23.06.2023 - 23.06.2023
AZ-400 Designing and Implementing Microsoft DevOps solutions
26.06.2023 - 29.06.2023
MS-500 Microsoft 365 Security Administration
28.08.2023 - 31.08.2023
AZ-104 Microsoft Azure Administrator
26.06.2023 - 29.06.2023
DP-070 Migrate Open Source Data Workloads to Azure
01.09.2023 - 01.09.2023
AZ-204 Developing Solutions for Microsoft Azure
26.06.2023 - 30.06.2023
PL-900 Microsoft Power Platform Fundamentals
01.09.2023 - 01.09.2023
MS-10990 Analyzing Data with SQL Server Reporting Services
21.08.2023 - 25.08.2023
MS-10988 Managing SQL Business Intelligence Operations
28.06.2023 - 30.06.2023
DP-060 Migrate NoSQL workloads to Azure Cosmos DB
30.06.2023 - 30.06.2023
DP-050 Migrate SQL workloads to Azure
19.06.2023 - 20.06.2023
MS-700 Managing Microsoft Teams
26.06.2023 - 29.06.2023
MS-600 Building applications and solutions with Microsoft 365 core services
26.06.2023 - 30.06.2023
AZ-010 Azure Administration for AWS SysOps
28.08.2023 - 29.08.2023
MS-55354 Administering Office 365 (dawniej MS-030)
26.06.2023 - 30.06.2023
AZ-500 Microsoft Azure Security Technologies
28.08.2023 - 31.08.2023
DP-100 Designing and Implementing a Data Science Solution on Azure
21.08.2023 - 23.08.2023
MS-55039 Windows PowerShell Scripting and Toolmaking
21.08.2023 - 25.08.2023
MD-101 Managing Modern Desktops
26.06.2023 - 30.06.2023
MD-100 Windows Client
19.06.2023 - 23.06.2023
MS-900 Microsoft 365 Fundamentals
19.06.2023 - 19.06.2023
AZ-900 Microsoft Azure Fundamentals
31.08.2023 - 01.09.2023
MS-10987 Performance Tuning and Optimizing SQL Databases
26.06.2023 - 29.06.2023
MS-101 Microsoft 365 Mobility and Security
19.06.2023 - 23.06.2023
MS-100 Microsoft 365 Identity and Services
26.06.2023 - 30.06.2023
MS-20467 Designing Business Intelligence Solutions with Microsoft SQL Server 2014
SQL Server 2012/2014
07.09.2020 - 11.09.2020
MS-20466 Implementing Data Models and Reports with SQL Server 2014
SQL Server 2012/2014
26.06.2023 - 30.06.2023
MS-20465 Designing Solutions for Microsoft SQL Server 2014
SQL Server 2012/2014
28.06.2023 - 30.06.2023
MS-20464 Developing Microsoft SQL Server 2014 Databases
SQL Server 2012/2014
21.08.2023 - 25.08.2023
MS-10986 Updating Your Skills to SQL Server 2016
SQL Server 2016
28.08.2023 - 30.08.2023
MS-55315 Introduction to SQL Databases (dawniej MS-10985)
SQL Server 2012/2014
04.09.2023 - 06.09.2023
MS-10994 Data Analysis Fundamentals using Excel
SQL Server 2016
31.08.2023 - 01.09.2023
MS-20779 Analyzing Data with Excel
SQL Server 2016
21.06.2023 - 23.06.2023
MS-55345 Implementing and Managing Windows 11 (dawniej MS-20697-1)
Windows 10
26.06.2023 - 30.06.2023
MS-55342 Supporting and Troubleshooting Windows 11 (dawniej MS-10982)
Windows 10
26.06.2023 - 30.06.2023
MS-55200 SharePoint 2016 Power User Training
SharePoint 2016
31.08.2023 - 01.09.2023
MS-55199 SharePoint 2016 End User Training
SharePoint 2016
26.06.2023 - 28.06.2023
MS-20745 Implementing a Software-Defined DataCenter
System Center
04.09.2023 - 08.09.2023
MS-10997 Office 365 Administration and Troubleshooting
Office 365
04.09.2023 - 06.09.2023
MS-55313 Administering Configuration Manager, Part I: Fundamentals and Asset Management (część MS-20703-1 oraz MS-55348- podstawy)
System Center
28.08.2023 - 30.08.2023
MS-55247 Designing and Implementing Cloud Data Platform Solutions
19.06.2023 - 21.06.2023
MS-20487 Developing Windows Azure and Web Services
Programowanie
21.08.2023 - 25.08.2023
MS-20486 Developing ASP.NET MVC 4 Web Applications
Programowanie
28.08.2023 - 01.09.2023
MS-55339 Programming in C# (dawniej MS-20483)
Programowanie
26.06.2023 - 30.06.2023
MS-55319 HTML5 and CSS (dawniej MS-20480)
Programowanie
19.06.2023 - 23.06.2023
MS-55318 Advanced Automated Administration with Windows PowerShell (dawniej MS-10962)
MCSA
28.06.2023 - 30.06.2023
MS-55154 Office 365 for the End-User
Office 365
01.09.2023 - 01.09.2023
MS-55179 Advanced Microsoft Outlook 2016
26.06.2023 - 26.06.2023
MS-55178 Introduction to Microsoft Outlook 2016
23.06.2023 - 23.06.2023
MS-55177 Advanced Microsoft PowerPoint 2016
PowerPoint 2016
01.09.2023 - 01.09.2023
MS-55176 Introduction to Microsoft PowerPoint 2016
PowerPoint 2016
21.08.2023 - 21.08.2023
MS-55167 Advanced Microsoft Excel 2016
Excel 2016
26.06.2023 - 26.06.2023
MS-55166 Intermediate Microsoft Excel 2016
Excel 2016
19.06.2023 - 19.06.2023
MS-55165 Introduction to Microsoft Excel 2016
Excel 2016
23.06.2023 - 23.06.2023
MS-55175 Advanced Microsoft Word 2016
Word 2016
28.08.2023 - 28.08.2023
MS-55174 Intermediate Microsoft Word 2016
Word 2016
01.09.2023 - 01.09.2023
MS-55173 Introduction to Microsoft Word 2016
Word 2016
28.08.2023 - 28.08.2023
MCSA: Windows Server 2016 (wzbogacony o elementy Windows Server 2019) – online
MCSA
-
MS-20768 Developing SQL Data Models
SQL Server 2016
26.06.2023 - 28.06.2023
MS-55321 SQL Server Integration Services (dawniej MS-20767)
SQL Server 2016
19.06.2023 - 23.06.2023
MS-20334 Core Solutions of Skype for Business 2015/2019
Skype for Business 2015
26.06.2023 - 30.06.2023
MS-20744 Securing Windows Server 2016
Windows Server 2016
26.06.2023 - 30.06.2023
MS-10964 Cloud & Datacenter Monitoring with System Center Operations Manager
System Center
19.06.2023 - 23.06.2023
MS-55004 Installing and Configuring System Center 2012 Operations Manager
System Center
26.06.2023 - 30.06.2023
MS-20765 Provisioning SQL Databases
SQL Server 2016
28.08.2023 - 01.09.2023
MS-55316 Administering a SQL Database (dawniej MS-20764)
SQL Server 2016
19.06.2023 - 23.06.2023
MS-20762 Developing SQL Databases
SQL Server 2016
26.06.2023 - 30.06.2023
MS-20761 Querying Data with Transact-SQL
SQL Server 2016
26.06.2023 - 30.06.2023
MS-55343 Networking with Windows Server (dawniej MS-20741)
Windows Server 2016
28.08.2023 - 01.09.2023
MS-55324 Installation, Storage, and Compute with Windows Server 2016 (dawniej MS-20740)
Windows Server 2016
26.06.2023 - 30.06.2023
MS-55344 Identity with Windows Server (dawniej MS-20742)
Windows Server 2016
19.06.2023 - 23.06.2023
MS-20345-2 Designing and Deploying Microsoft Exchange Server 2016/2019
Exchange Server 2016/2019
19.06.2023 - 23.06.2023
MS-20345-1 Administering Microsoft Exchange Server 2016/2019
Exchange Server 2016/2019
26.06.2023 - 30.06.2023
MS-20743 Upgrading Your Skills to MCSA: Windows Server 2016
Windows Server 2016
26.06.2023 - 30.06.2023
MS-10972 Administering the Web Server (IIS) Role of Windows Server
Windows Server 2012/2012R2
17.07.2023 - 21.07.2023
MS-10967 Fundamentals of a Windows Server Infrastructure
Windows Server 2012/2012R2
26.06.2023 - 30.06.2023
MS-10969 Active Directory Services with Windows Server
Windows Server 2012/2012R2
19.06.2023 - 23.06.2023
Bezpieczeństwo Microsoft Azure, Office 365 oraz Intune
Microsoft Azure / Office 365 / Windows Intune
19.06.2023 - 21.06.2023
Automatyzacja zabezpieczeń w środowiskach Windows 10 oraz Windows Server 2016
Windows 7/8.1/10 & Windows Server 2008R2/2012R2/2016
26.06.2023 - 30.06.2023
Bezpieczeństwo w środowiskach Windows Client oraz Windows Server
Windows 7/8.1/10 & Windows Server 2008R2/2012R2/2016
23.08.2023 - 25.08.2023
Podstawy bezpieczeństwa w środowiskach Microsoft
Windows 7/8.1/10 & Windows Server 2008R2/2012R2/2016
19.06.2023 - 21.06.2023
MS-10961 Automating Administration with Windows PowerShell
MCSA
26.06.2023 - 30.06.2023
MS-20463 Implementing a Data Warehouse with Microsoft SQL Server
SQL Server 2012/2014
28.08.2023 - 01.09.2023
MS-20462 Administering Microsoft SQL Server Databases
SQL Server 2012/2014
19.06.2023 - 23.06.2023
MS-20461 Querying Microsoft SQL Server
SQL Server 2012/2014
19.06.2023 - 23.06.2023