Intermediate Microsoft Excel 2013
Corso
A Milano
Hai bisogno di un coach per la formazione?
Ti aiuterà a confrontare vari corsi e trovare l'offerta formativa più conveniente.
Descrizione
-
Tipologia
Corso
-
Luogo
Milano
-
Inizio
Scegli data
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
Sedi e date
Luogo
Inizio del corso
Inizio del corso
Opinioni
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.
Hai bisogno di un coach per la formazione?
Ti aiuterà a confrontare vari corsi e trovare l'offerta formativa più conveniente.
Intermediate Microsoft Excel 2013