Certified Professional Accountant (CPA)

Logical Functions, Data Management:

Data Collection Method With Data Quality, Collaboration and Security Like Share Your Workbook On Share Drive With Quality

Analysis:

Single/Multidimensional Analysis, Like Three Dimensional (3D) Tables Sensitive Analysis Like Data Table, Manual What-If Analysis, Threshold Values, Goal Seek, One-Variable Data Table

Lookup and Reference Functions:

• Retrieve approximate matched value instead of position, find the value in the last non-empty cell in a row or column, etc.

• How to retrieve the value at the position returned by MATCH & INDEX function?

• How to map cell values directly to cell ranges

• Retrieving value, based on a text string.

Mathematical Functions, Text Functions and Data Validation, Date & Time Functions:

Storing and manipulating dates and times in Excel, inserting days and months to particular dates; create dynamic date-based fields; and perform complex time-based calculations.

Mathematical calculations, including basic arithmetic, conditional sums & products, exponents & logarithms, and the trigonometric ratios.

Advanced Chart, Graph and Dashboard:

Advanced Chart Technique, How To Make Dynamic Charts, Bar Charts, Pie Charts, Scatter Chart, Line Chart, Column Chart, Speedometer Chart, Gantt Chart, Two-Variable Data Table

Advanced Sort &Filter, Validation and Pivot Table:

• Filters (Basic, Advanced, Conditional), Sort (Ascending, Descending, Cell/Font Color), Conditional Formatting, Data Validation, Group and Ungroup, Data Split.

• Pivot Table and Charts, Import and Export data, Protect/Unprotect sheets/workbooks. Worksheet formatting and Print Display