## Curs Excel 2016 Nivel Mediu – Curs 55166

Inregistrati-va

This module explains how to work with formulas.
Lessons

• 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
• Using Named Ranges in Formulas
• Entering a Formula Using Data in Multiple Worksheets
• Using the IF Function
• Using the PMT Function
• Using the VLOOKUP Function
• Using the CONCATENATE Function
• Using the PROPER Function
• Using the LEFT and RIGHT Functions
• Using the YEAR, MONTH, and DAY Functions

After completing this module, students will be able to:

• Name and label cells and ranges of cells.
• Use names and labels in formulas.
• Create formulas that span multiple worksheets.
• Use the conditional IF function and its variants in formulas.
• Use the PMT function to calculate payments for loans.
• Use the LOOKUP function.
• Use the VLOOKUP function.
• Use the HLOOKUP function.
• Use the CONCATENATE function to join the contents of numerous cells.
• Use the TRANSPOSE function.
• Use the PROPER, UPPER, and LOWER functions to alter the casing of text.
• Use the LEFT, RIGHT, and MID functions to return characters from the
• start or end of a string, or a specific number of text characters.
• Use various date functions.

#### Module 2: Working with Lists

This module explains how to work with lists.

Lessons

• 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
##### Lab 1: 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

After completing this module, students will be able to:

• Convert data into tables.
• Remove duplicates from tables.
• Sort data in Excel.
• Filter data in Excel.
• Use subtotals to automatically total related data.
• Group and ungroup data.

#### Module 3: Working with Illustrations

This module explains how to work with illustrations.

Lessons

• Working with Clip Art
• Using Shapes
• Working with SmartArt
##### Lab 1: Working with Illustrations
• Working with Clip Art

After completing this module, students will be able to:

• U use Clip Art to illustrate your worksheets.
• Insert shapes into Microsoft Excel worksheets.
• Use SmartArt to illustrate your worksheets.

#### Module 4: Visualizing Your Data

This module explains how to work with charts, objects, and text boxes.

Lessons

• Creating a Custom Chart Template
• Inserting Charts
• Insert a Text Box
• Create a Custom Chart Template
##### Lab 1: Visualizing Your Data
• Inserting Charts
• Editing Charts

After completing this module, students will be able to:

• Create charts that enable you to visualize your data.
• Choose what data is displayed in your charts.
• Show and hide data labels.
• Show and hide the legend.
• Show and hide the chart title.
• Add a picture or shape to a chart.
• Change the way text displays in a chart.
• Change the fill color of a chart.
• Add and format objects in a worksheet.

#### Module 5: Working with Tables

This module explains how to work with tables.

Lessons

• Format Data as a Table
• Move between Tables and Ranges
• Modify Tables
• Define Titles
##### Lab 1: Working with Tables
• Creating and Modifying a Table in Excel

After completing this module, students will be able to:

• Format data in Excel as a table.
• Modify Excel tables.

This module explains how work with formatting options in Excel.

Lessons

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

After completing this module, students will be able to:

• Use conditional formatting to display cells differently based on their values.
• Quickly format tables using styles.
• Format cells using styles.

#### Module 7: Microsoft Excel Features that Were New in 2013

This module explains how to use some features that were new in 2013.

Lessons

• New Functions in Excel 2013
• Using New Chart Tools
• Using the Quick Analysis Tool
• Using the Chart Recommendation Feature
##### Lab 1: Microsoft Excel Features that Were New in 2013
• Using the New Excel Functions
• Using the New Excel 2013 Chart Tools
• Using the Quick Analysis Tool

After completing this module, students will be able to:

• Use the new chart tools in Excel.
• Use the Quick Analysis tool.
• Use the Chart Recommendation feature.

#### Module 8: Features New in 2016

This module explains how to use the new charts in 2016.

Lessons

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

After completing this module, students will be able to:

• Use the new charts in Excel 2016.

Inregistrati-va

Locatia de desfasurare a cursului:

Sediul Learning Solution: Str. Transilvaniei nr. 24, Sector 1, Bucuresti

Cine susține cursul?

##### Durata Curs
2 zile: 9:00 – 17:00

##### Cunostinte prealabile

Familiarity with Microsoft Office applications – particularly Excel