Finance : With UPI Apps becoming mainstream nowadays, cash is garnering the status of a rare and exclusive commodity. Right from a small car...
CA, CS, CMA : Learn how to draft an accurate Balance Sheet in Excel within 2 minutes using formulas like VLOOKUP, HLOOKUP, and XLOOKUP for error...
Finance : Learn how to automate filling blank cells in Excel using VBA. Save time and reduce errors with our step-by-step guide for efficien...
Finance : Convert Excel data to PDF effortlessly for a polished look. Enhance presentation, maintain formatting, and ensure compatibility wi...
CA, CS, CMA : Discover essential Google Sheets keyboard shortcuts to boost productivity. Learn time-saving tips and tricks for efficient spreads...
Goods and Services Tax : Join Certification Course on GST Compliances, Excel For professionals, Income Tax and Customs, Import & Export by TaxGuru Edu at ...
Finance : Test anxiety can affect not just the result of your certification exam but also your wellbeing. It may lead to exam failure, or wo...
Haven’t you always wanted to create those lovely drop down list boxes to enter data in lists or forms for uniformity and standardisation? These are called data validation list boxes. Here’s how create them. In our example, Let us consider that you want the user to enter season in column B from a list of valid seasons. To create the List box for all cells in that column, select the entire column, except cell B1, and on the ribbon click à
Yes, there is. It’s called Data validation Input message. Select the cell(s) in which you want to see the message. On the ribbon, click the tab then click . Click the [Input Message] tab .Check the option ‘Show input message when cell is selected’. Type your message heading text in the Title box. This text will appear in bold print at the top of the message. Type your message in the Input message box. Click OK.
Suggest what is to be entered in a cell? (Cell Comment) Cell Comment Suggest the user as regards what is to be entered in the cell 1. Select the cell wherein you wish to see the message, 2. Right click and select
Many times in a list, especially so when it is imported from a database, cells down below that have same headings or subheadings are left blank for the sake of easier readability. For eg. See the screenshot below. Excel Tips-3
Use the AutoFill feature. It inserts a series of values or text items in a range of cells. Drag the AutoFill handle (the small box at the lower right of the Active cell) to copy the cell or automatically complete the series
Create Shortcuts for commonly used words or phrases? Use the AutoCorrect feature. It creates shortcuts for commonly used words or phrases.Click – Files →Options → proofing → AutoCorrect Options. On the [AutoCorrect] tab check the option ‘Replace Text As You Type’
