Microsoft Office 2013 - Advanced Excel

MODULE 1 - Data visualization and automation
• The View tab
• Manage the zoom
• The display modes
• Set up a custom view
• The visualization tools
• Lock the worksheet titles
• Divide the worksheet
Compare two worksheets
• Compare multiple worksheets
• Manage windows
• Making macros
• Manage macros

MODULE 2 - Data modification
• Custom numeric formats
• Automatic filling
• Custom lists
Validation of data
• Apply data validation

MODULE 3 - Data review
• The audit activity
• Spell checking
• Apply spell checking
• Use synonyms and antonyms
• Use the multilingual dictionary
• Enter a comment
• Manage comments
• Protect the worksheet
• Protect the workbook
• Share the workbook
• View revisions
• Accept or decline revisions

MODULE 4 - Importing data
• Introduction
• Import data from Access
• Text file
• Import data from Testo
XML files
• Import data from XML

MODULE 5 - The organization of data
• Define a database
• Organize your data
• Sort the data
• Sort the data by multiple criteria
• Perform a sorting of data based on multiple criteria
• Filter the data
• Run the Filter command
• Criteria for filtering
• Divide the text into a column
• Text to Column Conversion Wizard
• Remove duplicates
Calculate the subtotals
• Find and replace information
• Use a list of Excel data in the mail merge procedure in Word
• How to use a list of Excel data in the mail merge procedure in Word

MODULE 6 - Advanced formulas
• Use formulas
• Know the SE function
Understand the syntax of the SE formula
• Enter the formula SE
• Use the Insert Function command
• Know the CONTA.SE formula
• Enter the formula COUNTIF
• Know the formula DB.SOMMA
• Enter the formula DB.SOMMA
• Know the DB.MEDIA formula
• Know the formula VLOOKUP
• Know the syntax of the SEARCH.VERT formula
• Enter the formula VLOOKUP
• Know the STRINGA.ESTRAI formula
• Enter the formula STRINGA.ESTRAI

MODULE 7 - The tables and the pivot chart
• Know the pivot table
• Examine a pivot table
• Insert a pivot table
• Modify a pivot table
• Update data and view detailed data
• Filter the data of a report
• Group data
• Grouping text elements
• Group by date and time or by numerical ranges
• Pivot chart
• Insert a pivot chart
• Filter and edit data in a pivot chart