Learning Outcomes: 

In this course, participants will:

• Copy macros between workbooks
• Reference data in other workbooks
• Enable macros in a workbook
• Manage workbook versions
• Prepare workbooks for collaboration
• Use and configure language options
• Create custom number formats
• Configure data validation
• Group and ungroup data
• Calculate data by inserting subtotals and totals
• Create and modify the pivot table
• Create and modify pivot chart
• Use advanced date and time functions
• Use advanced date and time functions

 Investment:

*Onsite Training price to be discussed

Curricula:

• Manage workbook options and settings.
• Manage and format data.
• Create advanced formulas and macros.
• Manage advanced charts and tables.