Finance : Learn Excel basic formulas, shortcut keys, and important functions. Get guides for bank reconciliation, loan EMI calculation, pivo...
CA, CS, CMA : Enhance client management for professionals like Chartered Accountants, Company Secretaries, and Cost Accountants using Excel-base...
Finance : Benford's law describes the relative frequency distribution for leading digits of numbers in datasets. In this article we are disc...
Finance : Microsoft Excel is extensively used across the globe to store and analyze. Despite various new data analytics tools in the market,...
Finance : Following the previous post, we are here with some unknown yet useful features of Pivot that can enhance our work quality on a day...
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...
Conditional Formatting – Top/Bottom Rules- 1. Select the Range. 2. On the [Home] tab click [Conditional Formatting] à Top/Bottom Rules à Top 10 items…. 3. In the Top 10 items dialogue box specify the number of top items that you wish to highlight and the format for the same. Click
Automatically format cells (e.g. change font color) based on a certain condition? Use the conditional Formatting. Conditional formatting allows you to set rules for cell formatting. If the rules (conditions) are met, then the formatting is applied. To do this: 1. Select the cells to be formatted 2. On the [Home] tab of the ribbon click [Conditional Formatting]3. Leave the first drop-down box set to ‘Cell Value Is’
Combine Text from Multiple Cells? Use the & operator – Lets you combine text from multiple cells
Suppose you have entered the full name of a person in a particular cell and you now want to have Surname, First Name and Middle Name in three different cells. To do this, simply select the cell that contains the Full Name of the person, Click
Use the Data Validation + Countif function. It Prevents the user from entering Duplicate data. To do this: 1. Select a range of cells, for example, A2:A20. 2. On the Ribbon click <Data> à <Data Validation> 3. Select the [Settings] tab.
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
