Curs Excel 2016 Nivel Incepator

Curs Excel 2016 Nivel Incepator Curs 55165

Inregistrati-va

Module 1: Creating a Microsoft Excel Workbook

This module explains how to create workbooks in Microsoft Excel.
  • Start Microsoft Excel.
  • Create a Microsoft Excel workbook.
  • Save a Microsoft Excel workbook.
  • Add and delete Microsoft Excel worksheets.
  • Copy and move worksheets.
  • Split the worksheet window.
  • Close a Microsoft Excel workbook.

Module 2: The Ribbon

This module explains how to work with the Ribbon.
  • Work with tabs.
  • Work with groups.
  • Work with commands.
  • Understand which groups and commands are found on which tabs.

Module 3: The Backstage View (The File Menu)

This module explains how to work with the Backstage View aka the File menu.
  • Open a Microsoft Excel workbook.
  • Start a new Microsoft Excel workbook.
  • Use Microsoft Excel templates.
  • Print a Microsoft Excel workbook.
  • Personalize your copy of Microsoft Excel.

Module 4: The Quick Access Toolbar

This module explains how to work with the Quick Access Toolbar.
  • Add common commands to the Quick Access Toolbar.
  • Add additional commands to the Quick Access Toolbar.
  • Move the Quick Access Toolbar.

Module 5: Entering Data in Microsoft Excel Worksheets

This module explains how to how to enter data in Excel worksheets.
  • Enter text in Microsoft Excel worksheets.
  • Add or delete cells in worksheets.
  • Add an outline for your data.
  • Enter a hyperlink in a worksheet.
  • Use AutoComplete.
  • Enter numbers and dates in Microsoft Excel worksheets.
  • Use the Fill Handle to add data to cells.

Module 6: Formatting Microsoft Excel Worksheets

This module explains how to format Excel worksheets.
  • Select a range of cells within a worksheet.
  • Hide worksheets.
  • Add color to workbook tabs.
  • Add themes to worksheets.
  • Apply bold, italics, and underlining to text.
  • Add borders to cells.
  • Change text and cell colors.
  • Change the font and font size.
  • Align text.
  • Wrap text.
  • Indent text.
  • Merge and center text.
  • Change number formats.
  • Change date formats.

Module 7: Using Formulas in Microsoft Excel

This module explains how to use formulas in Excel.
  • Enter basic formulas.
  • Use AutoSum to sum data with one click.
  • Understand absolute, relative, and mixed cell references.
  • Copy formulas and functions.

Module 8: Working with Rows and Columns

This module explains how to work with rows and columns.
  • Insert rows and columns in Microsoft Excel worksheets.
  • Delete rows and columns in Microsoft Excel worksheets.
  • Transpose rows and columns.
  • Change row heights.
  • Change column widths.
  • Hide and unhide rows and columns.
  • Freeze panes.

Module 9: Editing Worksheets

This module explains how to edit worksheets.
  • Locate information in your worksheet using Find.
  • Use Find and Replace to quickly replace data with other data.
  • Use the Cut, Copy, Paste and Format Painter commands to edit worksheets.
  • Manage comments.

Module 10: Finalizing Microsoft Excel Worksheets

This module explains how to finalize worksheets.
  • Set margins in Microsoft Excel worksheets.
  • Set the page orientation to portrait or landscape.
  • Set the print area in a worksheet.
  • Scale a worksheet so that all data prints on one page.
  • Add headers and footers to a worksheet.

Module 11: Microsoft Excel Features that Were New in 2013

This module explains how to use some of the features that were new in the 2013 version of Excel.
  • Use the one workbook per window feature.
  • Use Flash Fill.

Module 12: Features New in 2016

This module explains how to use two new features in 2016.
  • Use the Tell Me feature.
  • Use the Smart Lookup feature.
Inregistrati-va Locatia de desfasurare a cursului: Sediul Learning Solution: Str. Transilvaniei nr. 24, Sector 1, Bucuresti Cine susține cursul?
Master Office 2013 Cristi

Master Office 2013 Cristi

Durata Curs
2 zile: 9:00 - 17:00
Cunostinte prealabile
Familiarity with Microsoft Office applications – particularly Excel
Cursuri Conexe
Curs Creare Dashboards Cu PowerPivot Power View Si SharePoint - Curs 55103 Curs 50450 - Curs Excel Creating and Analyzing Database Using Microsoft Excel Curs 55084 – Curs Excel 2013 Self-Service Analytics with No Code for the End User Curs Excel 2013 – Advanced Microsoft Excel 2013 Curs Excel 2013 PowerPivot – PowerBI Curs 50448 Maximizing PivotTable Microsoft Excel Curs 55143 Microsoft Office Excel Basic Workbooks Formulas and Functions Curs Microsoft Excel 2016 – Incepator Curs Microsoft Excel 2016 – Mediu Curs Microsoft Excel 2016 – Avansat Curs Microsoft Excel 2013 – Incepator Curs Microsoft Excel 2013 – Mediu Curs Microsoft Excel 2013 – Avansat Curs Microsoft Excel 2010 – Incepator Curs Microsoft Excel 2010 – Mediu Curs Microsoft Excel 2010 – Avansat Curs Microsoft Excel 2007 – Incepator Curs Microsoft Excel 2007 – Mediu Curs Microsoft Excel 2007 – Avansat
Abonați-vă la newsletter
Program
Luni - Vineri: 9:00 - 17:00
Sambata, Duminica: Inchis
Ne găsiți la
Telefon/Fax: 021 367 0092
Telefon: 0748.11.23.23
Str. Transilavaniei, nr. 24, Sector 1, Bucuresti, Cod Postal 010798, ROMANIA