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

3 files

Lookup Functions.xlsx
11.1 KB
Download
Sales Register.xlsx
1.1 MB
Download
Session 1 Warmup.xlsx
24.8 KB
Download

Day 3: Consolidation using Power Query

0 files

Files for this day have not been posted yet.

Day 4: Data Modeling using Power Pivot

0 files

Files for this day have not been posted yet.

Day 5: Visualization using Power BI

0 files

Files for this day have not been posted yet.

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

0 files

Files for this day have not been posted yet.