About this course
Excel is a powerful Data Analysis and Reporting tool. You could use Excel to gain new insights into the information and data that you work with in your job. The proper use of Excel features can greatly enhance the design of your report and help you to analyze your organization’s data more effectively.
If you find yourself struggling with duplicated data or require an efficient way to analyze and retrieve your data from Excel table, if you deal with budgets, P&L, Sales or other administrative data and need to display the data using interactive Excel charts and reports, if you need to present your data using impressive report format, this is the right course for you.
This course will train participants how to use Excel better and design the spreadsheet report to be more interactive and effective for data analysis purposes.
Who is this course for?
This course is aimed at anyone who has to analyse data of any sort and create solid professional reports for the organization.
This is a fast pace Intermediate level course and is not suitable for beginners who only know some basic functions and seldom use Microsoft Excel at work. This course is for frequent Excel users who know how to create simple PivotTable and perform simple data analysis tasks. You MUST have a thorough understanding of spreadsheet fundamentals and be confident creating complex functions and formulas and creating simple charts.
This course will be running and taught based on the PC Windows software and not Mac versions. (All Laptops and materials will be provided)
*Important disclaimer for participants attending the 2016 version:
Participants are encouraged to inquire which version they have at work to realise which features may, or may not, be present on their work-based application.
Look at the FILE tab and search for ACCOUNT. It will either highlight ‘PRODUCT ACTIVATED’ or ‘SUBSCRIPTION’. Product Activated applications are typically a one-time purchase license and will not carry the same updated features as the Subscription versions. Companies may vary in polices of software purchase depending on the suitability of products. Subscription versions tend to be continually updated
As an example, one the features not available in the Product Activated version is IFS and MAXIFS Functions. Impress Training will be using the 365 subscription version for training purposes.