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?

Familiarity with Microsoft Office applications – particularly Excel 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