Digi Academy

Intermediate Microsoft Excel 2013

Digi Academy
A Milano

Chiedi il prezzo
Chiedi informazioni a un consulente Emagister

Informazioni importanti

Tipologia Corso
Luogo Milano
Inizio Scegli data
  • Corso
  • Milano
  • Inizio:
    Scegli data
Descrizione

Using Named Ranges in Formulas Using Formulas That Span Multiple Worksheets Using the IF Function Using the PMT Function Using the LOOKUP Function Using the VLOOKUP Function Using the HLOOKUP Function

Strutture (1)
Dove e quando
Inizio Luogo
Scegli data
Milano
Via Valtellina, 63, 20124, Milano, Italia
Visualizza mappa
Inizio Scegli data
Luogo
Milano
Via Valtellina, 63, 20124, Milano, Italia
Visualizza mappa

Programma

Using the CONCATENATE Function


Using the TRANSPOSE Function


Using the PROPER, UPPER, and LOWER Functions


Using the LEFT, RIGHT, and MID Functions


Using Date Functions


Creating Scenarios


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


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 VLOOKUP function.


Use the HLOOKUP function.


Use the CONCATENATE function to join the contents of numerous cells.


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.


This module explains how to work with lists in Microsoft Excel 2013.


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


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


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.


Adding illustrations to Microsoft Excel worksheets is a great way to improve their look and feel, and also to illustrate your points. Fortunately, it's easy to add pictures (your own or choose from a large library of pictures provided by Microsoft) and shapes.


Working with Clip Art


Using Shapes


Working with SmartArt


Working with Clip Art


Adding Shapes


Add pictures to your worksheets.


Use Clip Art to illustrate your worksheets.


Insert shapes into Microsoft Excel worksheets.


Use SmartArt to illustrate your worksheets.


This module explains how to use techniques for visualizing your data.


Inserting Charts


Add and Format Objects


Insert a Text Box


Create a Custom Chart Template


Inserting Charts


Editing Charts


Changing the Layout of a Chart


Changing the Style of a Chart


Adding a Shape to a Chart


Adding a Trendline to a Chart


Adding a Secondary Axis to a Chart


Adding Additional Data Series to a Chart


Switch between Rows and Columns in a Chart


Positioning a Chart


Modifying Chart and Graph Parameters


Watching Animation in a Chart


Showing, Hiding, or Changing the Location of the Legend in a Chart


Show or Hiding the Title of a Chart


Changing the Title of a Chart


Editing Charts


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.


This Working with tables in Excel 2013 can help you organize your data. In Excel, you can group data together into a table and then manipulate that table.


Format Data as a Table


Move between Tables and Ranges


Modify Tables


Define Titles


Creating and Modifying a Table in Excel


Format data in Excel as a table.


Modify Excel tables.


This module explains how to use advanced formatting techniques in Excel 2013.


Applying Conditional Formatting


Working with Styles


Creating and Modifying Templates


Working with Styles


Use conditional formatting to display cells differently based on their values.


Quickly format tables using styles.


Format cells using styles.


Excel 2013 provides a number of new functions and tools to help make working with worksheets easier and more efficient.


New Functions in Excel 2013


Using New Chart Tools


Using the Quick Analysis Tool


Using the Chart Recommendation Feature


Using the New Excel Functions


Using the New Excel 2013 Chart Tools


Using the Quick Analysis Tool


Use new functions available in Excel 2013.


Use the new chart tools in Excel 2013.


Use the Quick Analysis tool.


Use the Chart Recommendation feature.



Gli utenti che erano interessati a questo corso si sono informati anche su...
Leggi tutto