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
Video Tutorial
More Important for You:
1. How to use Indirect Formula in Excel
2. How to use Forecast Formula in Excel in (Hindi)
3. Excel Magic Formula in Hindi
4. Excel में Income Tax Calculator बनाना सीखें
Join Our WhatsApp Group
Nazim Khan (Author) 📞 +91 9536250020
[MBA in Finance]
Nazim Khan is an expert in Microsoft Excel. He teaches people how to use it better. He has been doing this for more than ten years. He is running this website (TechGuruPlus.com) and a YouTube channel called "Business Excel" since 2016. He shares useful tips from his own experiences to help others improve their Excel skills and careers.
