Skip to main content

Microsoft Excel Video Tutorials

Comments

Post a Comment

Popular posts from this blog

Discount Formula in Excel

  Discount Formula in Excel To Discount Formula   an original price minus 5 is the same as Calculate to 95 of that value so if you have the Product Price (4585) in A2 use the Discount Formula Here the Below Example for Discount Formulas : -   5% Discount formula is =A2*0.95 10% Discount formula is =A2*0.90 15% Discount formula is =A2*0.85 20% Discount formula is =A2*0.80 25% Discount formula is =A2*0.75 30% Discount formula is =A2*0.70 40% Discount formula is =A2*0.60 50% Discount formula is =A2*0.50 Another Way to Calculate Discount Formula in Excel How to Find Discounted Amount in Excel Column A is Product Price, Column B is Discount Percentage, Column C is Discounted Amount and Column D is After Discount Amount     Discounted Amount Formula is  =A2*5%   After Discount Amount Formula is =A2-C2 Another Easiest Way to Calculate Discount F ormula  Col umn A is Product Pr ice, Col umn B is Discou...
22 comments
Read more

IFERROR With VLOOKUP And LEN AND LENB FUNCTION

Combining the IFERROR Function Formula with Logical VLOOKUP Functions Formula IFERROR Function With VLOOKUP Function Formula Description : -  Returns a value you specify if a formula evaluates to an error; otherwise, returns the result of the formula. Use the IFERROR Function With VLOOKUP function to trap and handle errors in a formula Below Following Values if Error : - #N/A, #VALUE!, #REF!, #DIV/0!, #NUM!, #NAME?, or #NULL! For Example A                          B                    C                         D Description         Value          Description       Value Lookup Product               #N/A            Product                0 Produ...
32 comments
Read more
Excel Some Useful Shortcuts Excel Some Useful Shortcuts Shortcut key Action Menu equivalent comments Alt or F10 Menu Go to Menu bar Alt+’ Format Style dialog box Format the Style Alt+= AutoSum Sum Formaula Showing in Cell Alt+Down arrow Display AutoComplete list Displaying Auto Complete Data List Alt+F1 Insert Chart Insert the Chart Alt+F11 Visual Basic Editor Tools, Macro, Visual Basic Editor Alt+F2 Save As Save File to Save As Alt+F4 Exit File Exit Alt+F8 Macro dialog box Macro dialog box Tools Alt+Shift+F1 New worksheet Insert New Worksheet Alt+Shift+F2 Save Save the File Ctrl + Shift + L Filter Filter the Row Ctrl W Close Close the Open File Ctrl+- Delete Delete the Rows, Columns and Cells Right or Down Depends on selection Ctrl+! Format cells dialog box Font Tab Open in F...
21 comments
Read more