Data Consolidation and Analysis in Microsoft Excel
offered by ICAI Delhi

Public/Government Institute
Estd. 1949

Data Consolidation and Analysis in Microsoft Excel
at
ICAI Delhi
Overview

Gain hands-on experience through case studies and exercises, preparing them to manage complex accounting data and generate insightful reports using Microsoft Excel

Duration	1 week
Total fee	Free
Mode of learning	Online
Schedule type	Self paced
Official Website	Explore Free Course
Credential	Certificate

Data Consolidation and Analysis in Microsoft Excel
at
ICAI Delhi
Course details

Skills you will learn

Excel Accounting Vlookup MS Office Advanced Excel

Who should do this course?

Preparers, auditors, members and students of ICAI
Other stakeholders involved in financial reporting

What are the course deliverables?

Consolidate data from different text files using the Text Import Wizard and Fill Series
It informs the learner the formula for converting Dates into days and number format features of Microsoft Excel
Standardize data of the Excel Sheet by using Remove Duplicate Entries, Sort Data, Check Consistency, Vlookup Function and If NA/If Error features
Sort and analyse the different data and using Pivot Table feature of the Microsoft Excel for making Top 15 Parties and Transactions Done with Related Parties observations
Use Pivot Table function of Microsoft Excel to analyse transactions with the same party on the same day

More about this course

In this course students will learn techniques to import data from various sources into Excel and organizing data in a structured format for ease of analysis
This course aims to empower accounting professionals with practical Excel skills to handle and analyze financial data effectively