Introduction to Microsoft Excel 2016

Cena

110.00

Lokacija

Beograd,
Online,
In-house

Trajanje kursa

1 dan / 7 sati

Datum

Po dogovoru

Prijava

Plan obuke:

Module 1: Creating a Microsoft Excel Workbook

  • Starting Microsoft Excel
  • Creating a Workbook
  • Saving a Workbook
  • The Status Bar
  • Adding and Deleting Worksheets
  • Copying and Moving Worksheets
  • Changing the Order of Worksheets
  • Splitting the Worksheet Window
  • Closing a Workbook

Module 2: The Ribbon

• Tabs
• Groups
• Commands

Mobile 3: The Backstage View (The File Menu)

  • Introduction to the Backstage View
  • Opening a Workbook
  • New Workbooks and Excel Templates
  • Printing Worksheets
  • Adding Your Name to Microsoft Excel
  • Managing Workbook Versions

Module 4: The Quick Access Toolbar

  • Adding Common Commands
  • Adding Additional Commands with the Customize Dialog Box
  • Adding Ribbon Commands or Groups
  • Placement

Mobile 5: Entering Data in Microsoft Excel Worksheets

  • Entering Text
  • Expand Data across Columns
  • Adding and Deleting Cells
  • Adding an Outline
  • Adding a Hyperlink
  • Add WordArt to a Worksheet
  • Using AutoComplete
  • Entering Numbers and Dates
  • Using the Fill Handle

Module 6: Formatting Microsoft Excel Worksheets

  • Hiding Worksheets
  • Adding Color to Worksheet Tabs
  • Adding Themes to Workbooks
  • Adding a Watermark
  • The Font Group
  • The Alignment Group
  • The Number Group

Module 7: Using Formulas in Microsoft Excel

  • Math Operators and the Order of Operations
  • Entering Formulas
  • AutoSum (and Other Common Auto-Formulas)
  • Copying Formulas and Functions
  • Relative, Absolute, and Mixed Cell References

Module 8: Working with Rows and Columns

  • Insert lesson titles in a bulleted list.
  • Inserting Rows and Columns
  • Deleting Rows and Columns
  • Transposing Rows and Columns
  • Setting Row Height and Column Width
  • Hiding and Unhiding Rows and Columns
  • Freezing Panes

Module 9: Editing Worksheets

  • Find
  • Find and Replace
  • Using the Clipboard
  • Managing Comments

Module 10: Finalizing Microsoft Excel Worksheets

  • Setting Margins
  • Setting Page Orientation
  • Setting the Print Area
  • Print Scaling (Fit Sheet on One Page)
  • Printing Headings on Each Page/Repeating Headers and Footers
  • Headers and Footers

Module 11: Microsoft Excel Features that Were New in 2013

  • One Workbook Per Window Feature
  • Using Flash Fill

Module 12: Features New in 2016

  • Tell Me
  • Smart Lookup

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

Dalje usavršavanje:

Intermediate Microsoft Excel 2016 (MS55166)

Advanced Microsoft Excel 2016 (MS55167)