Microsoft Excel is the standard spreadsheet application for both the business world and personal use. Our courses for Microsoft Excel will teach you Intermediate to advanced features of Excel. Whether you are new to Excel or an advanced user, our Excel courses will cover what you need to know to become an Excel power user.
At the end of the course, learners will be able to:
|Understand basis formulas and functions||Create and manipulate a Powerview Sheet|
|Use the Quick Analysis features||Analyze data using multiple tables|
|Format worksheets and data and print and share workbooks||Use Smartart and other objects in worksheets|
|Understand permissions, versions and Excel options||Trace precedent cells and dependent cells, as well as use other auditing tools|
|Track changes and share workbooks||Create and work with charts, pivot tables and pivot charts|
|Perform advanced formula auditing and calculation||Record and run macros|
|Create arrays and additional ways to run a macro||Solve formula errors|
|Create a form using a variety of controls||Use What if Analysis tools|
|Use trend lines, secondary axes and chart templates||Use tools to manage rows, columns, duplicates and validation|
|Work with slicers in Pivot tables||Group and outline data|
Who is the target audience?
Anyone using Microsoft Excel in a travel company