[12/01, 21:03] Sʜᴀʜʙᴀᴢ Aʟᴀᴍ 😘: CTRL+ALT+C Tally Se kuch Bhi Copy Karne Ke liye
CTRL+ALT+V Tally me Kuch Bhi Paste Karne ke Liye
ALT+D Kisi Bhi Ledger, Item, Group, Entry Ya Phir Company Ko Delete Karne ke liye
ALT+R Kisi Bhi Ledger ka Statement Check Karte Waqt Kisi bhi Entry ko Temporally Hatane
ke Liye
ALT+U Hatai Gai Entry ko Wapas Lane ke Liye.
CTRL+U Ek Se Jyada Hatai Gai Entry ko Ek Sath Wapas Lane ke liye
SPACE Kisi Bhi Ledger Ka Statement Check Karte Waqt Kisi Bhi Entry ko Select Karne Ke liye
CTRL+SPACE Kisi Bhi Ledger Ka Statement Check Karte Waqt Sari Entries ko Ek Sath Select Karne ke
Liye.
CTRL+END Tally Ke Kisi Bhi Shuru ke Option Se Aakhri ke Option me Jane ke liye
CTRL+HOME Wapas Kisi Bhi Aakhri Option se Shuru ke Option me Aane ke liye.
END Kisi Bhi Ledger Ka Statement Check Karte Waqt Sidha Uski Aakhri Entry Par Jane ke
liye
HOME Wapas Aakhri Entry se Pehli Entry Par Aane Ke Liye
PAGE DOWN Next Entry Me Jane Ke Liye
PAGE UP Previous Entry Me Aane Ke Liye
CTRL+R Kisi Bhi Voucher me Ki Gai Last Entry Ke Ledger aur Narration ko Repeat Karne Ke Liye
ALT+R Jis Ledger me Jo Narration Dala Jata hai Us Narration ko Repeat Karne Ke Liye
ALT+C Koi Bhi Naya Ledger, Group ya Item Banane Ke Liye aur Sath Me Immediate
Calculation ke Liye Bhi Iska Use Kiya Jata hai.
CTRL+ENTER Kisi Bhi Ledger, Items aur Group ko Turant Edit Karne Ke Liye
ALT+P Kisi Bhi Report, Statement Ya Bill ko Print Dene Ke Liye
ALT+E Kisi Bhi Report, Statement Ya Bill Ko PDF, Excel Ya Image File Me Export Karne Ke liye
CTRL+Q Tally ke Kisi Bhi Page Se Bahar Aane ke Liye
ALT+X Kisi Bhi Entry ko Cancel Karne Ke Liye
ALT+2 Kisi Bhi Entry ki Duplicate Entry Karne Ke Liye
ALT+J Statement Entry Karte Waqt Koi Bhi Naye Voucher Me Entry Add karne Ke liye
ALT+I Statement Entry Karte Waqt Koi Bhi Naye Voucher Me Entry Add karne Ke liye
CTRL+ALT+V Tally me Kuch Bhi Paste Karne ke Liye
ALT+D Kisi Bhi Ledger, Item, Group, Entry Ya Phir Company Ko Delete Karne ke liye
ALT+R Kisi Bhi Ledger ka Statement Check Karte Waqt Kisi bhi Entry ko Temporally Hatane
ke Liye
ALT+U Hatai Gai Entry ko Wapas Lane ke Liye.
CTRL+U Ek Se Jyada Hatai Gai Entry ko Ek Sath Wapas Lane ke liye
SPACE Kisi Bhi Ledger Ka Statement Check Karte Waqt Kisi Bhi Entry ko Select Karne Ke liye
CTRL+SPACE Kisi Bhi Ledger Ka Statement Check Karte Waqt Sari Entries ko Ek Sath Select Karne ke
Liye.
CTRL+END Tally Ke Kisi Bhi Shuru ke Option Se Aakhri ke Option me Jane ke liye
CTRL+HOME Wapas Kisi Bhi Aakhri Option se Shuru ke Option me Aane ke liye.
END Kisi Bhi Ledger Ka Statement Check Karte Waqt Sidha Uski Aakhri Entry Par Jane ke
liye
HOME Wapas Aakhri Entry se Pehli Entry Par Aane Ke Liye
PAGE DOWN Next Entry Me Jane Ke Liye
PAGE UP Previous Entry Me Aane Ke Liye
CTRL+R Kisi Bhi Voucher me Ki Gai Last Entry Ke Ledger aur Narration ko Repeat Karne Ke Liye
ALT+R Jis Ledger me Jo Narration Dala Jata hai Us Narration ko Repeat Karne Ke Liye
ALT+C Koi Bhi Naya Ledger, Group ya Item Banane Ke Liye aur Sath Me Immediate
Calculation ke Liye Bhi Iska Use Kiya Jata hai.
CTRL+ENTER Kisi Bhi Ledger, Items aur Group ko Turant Edit Karne Ke Liye
ALT+P Kisi Bhi Report, Statement Ya Bill ko Print Dene Ke Liye
ALT+E Kisi Bhi Report, Statement Ya Bill Ko PDF, Excel Ya Image File Me Export Karne Ke liye
CTRL+Q Tally ke Kisi Bhi Page Se Bahar Aane ke Liye
ALT+X Kisi Bhi Entry ko Cancel Karne Ke Liye
ALT+2 Kisi Bhi Entry ki Duplicate Entry Karne Ke Liye
ALT+J Statement Entry Karte Waqt Koi Bhi Naye Voucher Me Entry Add karne Ke liye
ALT+I Statement Entry Karte Waqt Koi Bhi Naye Voucher Me Entry Add karne Ke liye
❤1👍1
Computer Notes
Computer Basics and Advance Videos Toturial & PDF Books for Beginners. Please add your friends and relatives.
Computer Basics and Advance Videos Toturial & PDF Books for Beginners. Please add your friends and relatives.
Join this channel right now for get best computer skills....
Ms Word, Excel, Power point, and Tally ERP9 with GST
Ms Word, Excel, Power point, and Tally ERP9 with GST
Dear Friends,
In this group will try to learn the basics of MS Word, MS Excel and PowerPoint one by one. Than as will increase subscriber we will start.
Thank you 👍
In this group will try to learn the basics of MS Word, MS Excel and PowerPoint one by one. Than as will increase subscriber we will start.
Thank you 👍
Some shortcut keys of MS Excel
Ctrl+A - Select All
Ctrl+B - Bold
Ctrl+C - Copy
Ctrl+D - Fill Down
Ctrl+F - Find
Ctrl+G - Goto
Ctrl+H - Replace
Ctrl+I - Italic
These shortcuts are related to formatting only.
Ctrl+A - Select All
Ctrl+B - Bold
Ctrl+C - Copy
Ctrl+D - Fill Down
Ctrl+F - Find
Ctrl+G - Goto
Ctrl+H - Replace
Ctrl+I - Italic
These shortcuts are related to formatting only.
Q:- What is MS Excel?
A:- MS Excel is spreadsheet tool which help us to work in different cells and that is beneficial for different type of calculations and table presentation.
A:- MS Excel is spreadsheet tool which help us to work in different cells and that is beneficial for different type of calculations and table presentation.
Some shortcut keys of MS Excel
F10 - Activate Menubar
F11 - New Chart
F12 - Save As
Ctrl+: - Insert Current Time
Ctrl+; - Insert Current Date
Ctrl+" - Copy Value from Cell Above
Ctrl+’ - Copy Formula from Cell Above
Shift - Hold down shift for additional
F10 - Activate Menubar
F11 - New Chart
F12 - Save As
Ctrl+: - Insert Current Time
Ctrl+; - Insert Current Date
Ctrl+" - Copy Value from Cell Above
Ctrl+’ - Copy Formula from Cell Above
Shift - Hold down shift for additional
Dear Friends
Please do share this chennal with others so that they can also get the benefits.
Please do share this chennal with others so that they can also get the benefits.
🔴*IMPORTANCE OF MS EXCEL IN OUR DAILY AND BUSINESS LIVES:*🔴
1. Easy Arithmetic Solutions.
2. Formatting Options.
3. Charts for Analysis.
4. Bring all the data in one place.
5. Human Resource Planning.
6. Multiple formulas.
7. Multiple functions.
1. Easy Arithmetic Solutions.
2. Formatting Options.
3. Charts for Analysis.
4. Bring all the data in one place.
5. Human Resource Planning.
6. Multiple formulas.
7. Multiple functions.
Some shortcut keys of MS Excel
Ctrl+Tab - In a workbook: activate next workbook
Ctrl+9 - Hide rows
Ctrl+0 - Hide columns
Ctrl++ - Insert
Ctrl+- - Delete
Ctrl+Tab - In a workbook: activate next workbook
Ctrl+9 - Hide rows
Ctrl+0 - Hide columns
Ctrl++ - Insert
Ctrl+- - Delete
Question:- Difference between Workbook and Worksheet
Answer:- The worksheet is single page spreadsheet or page in Excel, where you can write, edit and manipulate data, whereas the collection of such worksheets is referred as a workbook. It is very similar to a single page (worksheet) and a complete book (workbook).
Answer:- The worksheet is single page spreadsheet or page in Excel, where you can write, edit and manipulate data, whereas the collection of such worksheets is referred as a workbook. It is very similar to a single page (worksheet) and a complete book (workbook).
Question:- What is Function in Excel.
Answer:- A function is a predefined formula that performs calculations using specific values in a particular order. Excel includes many common functions that can be used to quickly find the sum, average, count, maximum value, and minimum value for a range of cells.
Answer:- A function is a predefined formula that performs calculations using specific values in a particular order. Excel includes many common functions that can be used to quickly find the sum, average, count, maximum value, and minimum value for a range of cells.
Question:- What is Formula Bar?
Answer:- The Formula Bar is where data or formulas you enter into a worksheet appear for the active cell. The Formula Bar can also be used to edit data or formula in the active cell. The active cell displays the results of its formula while we see the formula itself in the Formula Bar.
Answer:- The Formula Bar is where data or formulas you enter into a worksheet appear for the active cell. The Formula Bar can also be used to edit data or formula in the active cell. The active cell displays the results of its formula while we see the formula itself in the Formula Bar.