Advanced Microsoft Excel_1

Overview

Microsoft Excel 2016 is the spreadsheet application in the MS Office 2016 suite. Get help organizing and calculating data in this Excel 2016 tutorial. Learning how to use Excel is an investment in both your personal and professional life. Excel makes it easy to monitor financial performance, such as business profit or loss, calculate payments on large purchases, plan a budget, or stay organized with checklists.

Objective

This program has been specifically designed for Excel users who have basic skills but want to get really, really good or anyone hoping to expand their analytics skill set, work more efficiently with data, and take their career to a new level. This course will give you a deep understanding of the advanced formulas and functions that transform Excel from a basic spreadsheet program into a dynamic and powerful analytics tool. At the end of this training course, the participants will be able to understand and apply:

  • Calculate with advanced functions & formulas;
  • Manage list function effectively;
  • Use conditional formatting tools;
  • Apply data tools effectively:
  • Organize worksheet and table data using multiple techniques;
  • Create and modify charts & graphs;
  • Deploy workbook with PivotTable and PivotChart;
  • Work with Macro tools effectively.

Content

  • Module 1: Working with Formula and Function Cell References and Excel Functions
  • Module 2: List Management
  • Module 3: Conditional Formatting
  • Module 4: Data Validation
  • Module 5: Working with Table
  • Module 6: Enhancing a Workbook with PivotTable and PivotChart
  • Module 7: Working with Macro

Who should Attend?

This training program is specially designed for all level from officer to manager of excel user who have an extensive knowledge and basic skills of Excel and want to get really, REALLY good or anyone hoping to expand their analytics skill set, work more efficiently with data, and take their career to a new level.

Trainer's Profile

Specialties: Information and Communication Technology, which Includes Back-End Software, Programming, Microsoft Project, Network and Security, New Software Development & Implementation, Graphic Design and Printing, and Hardware & Software Repairing.

Fee Charged

  • USD 200 (Registration makes before 29 July 2022)
  • USD 250 (Normal Fee)

The course fees are inclusive of course materials, handouts, meals, refreshments, and certificates of completion but do exclude 10% of VAT amount.