(Excel Tips For You)| Day - 4 |Topic:-Work in cells or the formula bar by using shortcut keys

(Excel Tips For You)| Day - 4 |Topic:-Work in cells or the formula bar by using shortcut keys #exceltips #shorcutkeys #accountantexcel *----------------------------------------* 🔥🔥🔥🔥🔥🔥🔥🔥🔥🔥🔥🔥🔥 Subscribe our channel For latest *GST UPDATES* and *other Relevant Videos* :- *https://www.youtube.com/c/teacherbypassion* __________________________________________ 🤩 *HAPPY TO SERVE YOU THANK-YOU* 🎉 *GST की राह में , आपके दोस्त ।* *×××××××××××××××××××××××××××××××××* 📊 *_[ Excel Tips For You ]_* 📈 📍 *DAY - 4* 📍 ************************************ 🌾 *Topic : Work in cells or the formula bar by using shortcut keys* *👉👉 To 👉👉 Press* 👉 Enter the time : *CTRL+SHIFT+: (COLON)* 👉 Insert a hyperlink : *CTRL+K* 👉 Complete a cell entry : *ENTER* 👉 Copy the value from the cell above the active cell into the cell or the formula bar : *CTRL+SHIFT+" (QUOTATION MARK)* 👉 Alternate between displaying cell values and displaying cell formulas : *CTRL+` (SINGLE LEFT QUOTATION MARK)* 👉 Copy a formula from the cell above the active cell into the cell or the formula bar : *CTRL+' (APOSTROPHE)* 👉 Enter a formula as an array formula : *CTRL+SHIFT+ENTER* 👉 Display the Formula Palette after you type a valid function name in a formula : *CTRL+A* 👉 Insert the argument names and parentheses for a function, after you type a valid function name in a formula : *CTRL+SHIFT+A* 👉 Display the Auto Complete list : *ALT+DOWN ARROW* Video Gear 👇🏻👇🏻👇🏻👇🏻👇🏻👇🏻👇🏻👇🏻👇🏻👇🏻👇🏻 My mic :- https://amzn.to/2lvwgMA My camera (cheapest price Video quality higher) :- https://amzn.to/2InZypj Lights used in Video :- https://amzn.to/2ImRoh3 Mobile /camera stand :-https://amzn.to/2lvmOJ1 My mobile phone {best camera phone} :- https://amzn.to/2tyWgdv Laptop :- https://amzn.to/2yCY4YW Mobile Telescope:- https://amzn.to/2ziXM9Y _ GST BOOK {FOR PRACTIONER} :- https://amzn.to/2MQWJR8 GST BOOK FOR ALL {BE THE EXPERT IN GST} :- https://amzn.to/2tFkXFx _ CA STUDENTS SPECIAL 💥 IPCC STUDENTS:- 👉🏻 Best book for A/c's subject :- 👉🏻 Self preparation of Law subject :- https://amzn.to/2m27m7P 👉🏻 COSTING & FINANCIAL MANAGEMENT :- refer you past year questions paper Download :- http://bit.ly/2BDMAm4 👉🏻 Taxtion :- please Go through with ICAI MODULE :- http://bit.ly/2QMpVhV 👉🏻 Advance Accounts:- past year questions papers:- http://bit.ly/2BB7jqF 👉🏻 Audit :- https://amzn.to/2KBAW2n /Or/ https://amzn.to/2lYh2jo 👉🏻 ITSM:- https://amzn.to/2lZ1oV6 ___ GST For Professionals & Businessman {हिंदी}: https://www.youtube.com/playlist?list=PLJhUBdmBIuJ2J-QZPa3iboL0MoEwqSAkT GST - AUDIT { Applicability, procedure & rules}: https://www.youtube.com/playlist?list=PLJhUBdmBIuJ2BkQckpHbPGgtRZZmUTgp3 Motivational & Lifestyle special VIDEOS: https://www.youtube.com/playlist?list=PLJhUBdmBIuJ0-i-ATb451D1lGxqbl1lBq Audit Videos (For CA IPCC & B.COM): https://www.youtube.com/playlist?list=PLJhUBdmBIuJ16W6j2T4zvtUL333Dr_smc COMPANY LAW {B.COM & CA,CS AND CMA}: https://www.youtube.com/playlist?list=PLJhUBdmBIuJ1rYwca0kb1Wwr9M1sQo2pv ================================================= Instagram Page :- http://bit.ly/2QJtrcO SUBSCRIBE FOR STAY UPDATED:- https://www.youtube.com/channel/UC-pFA9W0jwf4aHwTJu1aBqg Whatsapp group :- http://bit.ly/2BzNKPt Telegram chat group:- t.me/teacherbypassion Fb page :- http://bit.ly/2QJC4El Copyright Disclaimer Under Section 107 of the Copyright Act 1976, allowance is made for "fair use" for purposes such as criticism, comment, news reporting, teaching, scholarship, and research. Fair use is a use permitted by copyright statute that might otherwise be infringing. Non-profit, educational or personal use tips the balance in favor of fair use.