How to Format Proper Data when Export from Tally to Excel

1. Introduction

When we export data from Tally to Excel Software it doesn’t show in the proper format in excel. So here in the below video, I will explain to you how to do proper formatting for data exported from TALLY to EXCEL.

2. Command Used

To format Data properly in Excel I have used Filter Command, “Alt :” Shortcut & Fill above data to blank rows as below of data.

Also Read: Sales Analysis Report in Excel

3. Purpose

To make the report easy & understandable.

Raw Data

Final Data

Download Practice File

✪ DOWNLOAD FILE

Download More Excel Files

Video Tutorial

Join Our Telegram Group

Join Our WhatsApp Group

Nazim Khan — Founder & Editor, TechGuruPlus.com
[MBA in Finance]

Nazim Khan has spent over ten years working with Excel, Tally and office documentation in accounts, finance and MIS roles. He has been running TechGuruPlus.com since 2016, where he publishes free editable templates for office work, and the YouTube channel Business Excel. He has trained more than 50,000 people online. Every template on this site is built and checked by him before it is published.

Contact · Excel Course

1. Introduction

2. Command Used

3. Purpose

Leave a Comment Cancel reply