ICAI Hyderabad

ABCD of Microsoft Tools

A 6-day workshop covering Excel, Power Query, Power Pivot, Power BI and other Microsoft tools. Session files will be posted here as each day progresses.

Day 1: Essentials of MS Excel

5 files

Day1_CaseStudy_Participant.xlsx
29.2 KB
Download
Essentials.xlsx
6.0 KB
Download
GST Case Study.xlsx
32.3 KB
Download
Income Tax Case Study.xlsx
45.1 KB
Download
Session1_ClassNotes.pdf
195.6 KB
Download

Day 2: Advanced MS Excel

6 files

Lookup Functions.xlsx
11.1 KB
Download
Sales Register_Class Working.xlsx
1.9 MB
Download
Sales Register.xlsx
1.1 MB
Download
Session 1 Warmup_Class Working.xlsx
30.2 KB
Download
Session 1 Warmup.xlsx
24.8 KB
Download
Session2_ClassNotes.pdf
206.2 KB
Download

Day 3: Consolidation using Power Query

4 files

1. Intro to Power Query.xlsx
46.4 KB
Download
2. First Transformation in PQ.xlsx
19.8 KB
Download
3. Learning Path.xlsx
9.8 KB
Download
4. Jan.xlsx
11.1 KB
Download

Day 4: Data Modeling using Power Pivot

2 files

Power Pivot_Basics.xlsx
21.4 KB
Download
RBI Stat Audit UCN Transformation.xlsx
466.4 KB
Download

Day 5: Visualization using Power BI

2 files

Data Set.zip
1.8 MB
Download
Power Bi Download Instructions.pdf
644.3 KB
Download

Day 6: Other Microsoft Tools (Word, PPT, etc.)

0 files

Files for this day have not been posted yet.