Intermediate Microsoft Excel 2016

Cena

110.00

Lokacija

Beograd,
Online,
In-house

Trajanje kursa

1 dan / 7 sati

Datum

Po dogovoru

Prijava

Prijavite se

Plan obuke:

Module 1: Advanced Formulas

  • Using Named Ranges in Formulas
  • Naming a Single Cell
  • Naming a Range of Cells
  • Naming Multiple Single Cells Quickly
  • Using Formulas That Span Multiple Worksheets
  • Using the IF Function
  • Using AND/OR Functions
  • Using the SUMIF, AVERAGEIF, and COUNTIF Functions
  • Using the PMT Function
  • Using the LOOKUP Function
  • Using the VLOOKUP Function
  • Using the HLOOKUP Function
  • Using the CONCATENATE Function
  • Using the TRANSPOSE Function
  • Using the PROPER, UPPER, and LOWER Functions
  • The UPPER Function
  • The LOWER function
  • The TRIM Function
  • Using the LEFT, RIGHT, and MID Functions
  • The MID Function
  • Using Date Functions
  • Using the NOW and TODAY Functions
  • Creating Scenarios
  • Utilize the Watch Window
  • Consolidate Data
  • Enable Iterative Calculations
  • What-If Analyses
  • Use the Scenario Manager
  • Use Financial Functions

Module 2: Working with Lists

  • Converting a List to a Table
  • Removing Duplicates from a List
  • Sorting Data in a List
  • Filtering Data in a List
  • Adding Subtotals to a List
  • Grouping and Ungrouping Data in a List

Mobile 3: Working with Illustrations

  • Working with Clip Art
  • Using Shapes
  • Working with SmartArt

Module 4: Visualizing Your Data

  • Creating a Custom Chart Template
  • Inserting Charts
  • Add and Format Objects
  • Insert a Text Box
  • Create a Custom Chart Template

Mobile 5: Working with Tables

  • Format Data as a Table
  • Move between Tables and Ranges
  • Modify Tables
  • Define Titles

Module 6: Advanced Formatting

  • Applying Conditional Formatting
  • Working with Styles
  • Creating and Modifying Templates

Module 7: Microsoft Excel Features that Were New in 2013

  • New Functions in Excel 2013
  • Using New Chart Tools
  • Using the Quick Analysis Tool
  • Using the Chart Recommendation Feature

Module 8: Features New in 2016

  • New Charts
  • Treemap
  • Sunburst
  • Histogram
  • Waterfall
  • Box and Whisker
  • Pareto

Benefiti:

  • Video snimak predavanja u periodu od 365 dana posle kraja obuke
  • Pristup laboratorijama u toku trajanja kursa
  • Materijal u elektronskom obliku
  • Zvaničan Microsoft sertifikat o pohađanju kursa

Poželjno predznanje:

Basic Excel experience

Dalje usavršavanje:

Advanced Microsoft Excel 2016 (MS55167)