Excel the Basics (Length 1 day) Course description in PDF-Format
According to a Microsoft study, the average person uses only about 5% of this program’s functions. People do not know what they are missing out on. This training course will show you this program’s potential. You will learn how to use formulas and functions and how to setup a workbook. Find out about the various formats to enhance the appearance of your figures. In addition, have a look at the many graphs and charts available in the program.
Excel Advanced (Length 1 day) Course description in PDF-Format
This is the ideal follow-up after the basic course. Learn about more advanced features. This course is a must if you need to work with large amounts of data in Excel. We will show you how to handle large spreadsheets, so that the most important data is always visible. There is also a very handy function to create subtotals with only a couple of mouse clicks. Learn how to organize your data with Pivot tables. Finally, test drive the advanced chart features.
Excel Tips and Tricks (Length 3.5 hours) Course description in PDF-Format
Do you already know how to use Excel but have a feeling that there must be easier way to use this program? Did you know that you can easily convert relative cell references to absolute with the F4 key? In this course, we will show you many practical tricks to work more efficiently. This module is also an ideal “refresher” course.
Excel Pivot Tables and complex analysis (Length 3.5 hours) Course description in PDF-Format
Excel can easily deal with a large amount of data. Do you have data imported from SAP or another ERP system and need to create a professional report? We will show you how to filter and sort your data with just a few mouse clicks. Using pivot tables, you can rotate your numbers and examine them from various angles. In addition, you will learn other interesting features which will help you analyze large quantities of data.
Excel Analysis – What if functions (Length 3.5 hours) Course description in PDF-Format
Learn how to use functions to create forecasts. We will show you how to create what-if analysis and save the different variations as scenarios. Using solver, produce more complex analysis. Additionally, you will learn how to apply different types of charts (combination charts, trend analysis) to visualize your results. Next, learn how to protect your data so that users can only enter data in an unprotected area. Finally, we will show you how to automate recurring tasks using the macro recorder.