Advanced Excel Training

Objective:

Participants will learn how to use Excel 2010 effectively for financial calculations, reports and information analysis in Excel 2010, the Excel program most needed and used by companies today.

Participants learn how to use Excel's formulas effectively and use Excel macros. They will be able to complete more time-consuming and labor-intensive tasks and projects while working in Office programs.
Macros make things much easier and faster in order to handle things in a shorter and more useful way.

Starting from getting to know the Excel environment, the training progresses step by step with applications for the questions of how to make a stock tracking program, how to keep a cash account.

Topics such as how to calculate the interest of a loan you receive from the bank are explained in this program.

When you complete this training, you will be able to keep your own stock, make interest calculations and keep your income and expense account in Excel on your own.

Content and Method

1. Using Names
2. Applying Conditional Formatting
3. Validating the Input of Your Data
4. Sorting Lists
5. Filtering Lists
6. Working with subtotals
7. Working with Target Intervals and Scenarios
8. Create a Pivot Table
9. Working with Graphics
10. Date and Time Functions
11. Text and Data Functions
12. Other Frequently Used Functions of Excel
13. Creating a Macro
14. Working with Inspections
15. VBA Introduction