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 allow the participants to learn some powerful new features of Excel 2013 and train the participants how to convert raw data into Excel Table that will enable effective data filtering and sorting, format data in Excel table or PivotTable to highlight important figures using different colors based on pre-defined rules, extract useful information from the database using VLookup & Lookup functions, and advanced filter, group data into category to calculate subtotals and grand totals automatically, outline complex worksheet data to show and hide details, validate data entry to accept only valid data, protect confidential contents from unauthorized access using passwords, linking worksheet formulas and consolidate data from multiple worksheets and workbooks. Participants will also learn how to use PivotTables to analyze large database more efficiently, use PivotCharts to summarize important figures, drop-down list, filter and database functions to create interactive and impressive reports for data analysis.
At the end of each session, a case study which related to the topics learned will be given. Participants will have chance to discuss the case study scenario and come out with the solution. These case studies will also help participant to have better understanding on the topics they learned and know exactly how to apply the skills in their work. Model answers of the case studies and samples Excel worksheets will be given to participants for reference and revision after the course.
This course will be running on PC Based windows software and not Macintosh.
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. This course is for frequent Excel users .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)