Effective Data Management & Analysis For Finance And HR Professionals

Leverage time effectively and efficiently on technology. Breaking through the conventional way of handling source data. Learn to automate the data processing and allow more time to analyze data for professional and useful business use. Useful data information is the crucial key to succeed in current comparative market.

What You Will Learn:

• Using MS Excel features creatively and effectively for business reporting, learn how to blend in different formula and features.
• Learn how to use Pivot Table to summarize reports efficiently and effectively.
• Present informative pivot charts for business reporting and decision purposes.
• Enhance learning by applying on many case studies and examples on live data base.
• Practical application on real business scenarios and reporting

Who Should Attend:

• HR, Sales, Admin and Finance Executives who are required to manage reporting and analysis using MS Excel.

Course Structure:

• Data preparation from the downloaded source
• Useful Short Cut keys
• Data Cleaning functions: Text to column, Trim, Find/Replace functions, managing date and time, Combine cells, date formula
• Useful Data Analysis Tools
• Auto filter, advanced filter, data base functions, macro recording
• Case study : Summary HR data
• Real life Model : Manage Messy Excel List
• If, Multiple If
• Challenge 1 : Sort out the Messy List
•  Summarize and Analyze Data
• All count functions
• Sumifs
• Index and Match function (work beyond Vlookup)
• Challenge 2 : Summarize sales data
• Pivot Table
• Extract, Amend, filter and sort, group data using Pivot Table
• Integrate the pivot tables using slicers
• Add formula in Pivot Table
• Pivot Chart
• Column chart - Chart Title: Link or Type, make it meaningful
• Column chart - Chart Axis: Show in thousands
• Others: overlapped, reduce gaps
• Axis label, gridlines
• Add data label and number format (positive; negative; zero)