At the end of the course participants will be able to:
Analyze data using complex functions and tools.
Effectively organize data into a spreadsheet.
Get external data into Excel with power query.
Manage Excel reports in an advanced pivot and power pivot.
Apply advanced formatting to the worksheet.
Course description and objectives
The course is aimed to analyze the main advanced features of Excel, including complex functions, what-if analysis, pivot tables, and macros, with specific examples and exercises that can be immediately applied to one’s study and work. The goal is to improve the advanced skills of Excel users, to give them the tools for an effective and qualified approach to both academic and professional activities.
Benefits of this course
At the end of this advanced Excel course you will have a complete understanding of the higher functions of Excel.
You will be able to perform the most advanced calculations and functions, manipulate data using pivot tables and ‘advanced’ analysis, record macros and integrate with other office applications.