Category: Excel
-
Excel training (online)!
•
https://www.fiverr.com/s2/845e59e2ce?utm_source=org.wordpress.android_Mobile
-
Goal Seek in MS Excel !
•
Goal Seek In MS Excel ! When you know the desired result of a single formula but not the input value the formula needs to determine the result, you can use the Goal Seek feature available by clicking, Data —> What-If Analysis —> Goal Seek When goal seeking, Microsoft Excel…
-
Excel HLOOKUP
•
HLOOKUP Searches for a value in the top row of a table or an array of values, and then returns a value in the same column from a row you specify in the table or array. Use HLOOKUP when your comparison values are located in a row across the top…
-
Excel VLOOKUP
•
VLOOKUP Searches for a value in the leftmost column of a table, and then returns a value in the same row from a column you specify in the table. Use VLOOKUP instead of HLOOKUP when your comparison values are located in a column to the left of the data you…
-
Computer .. Important shortcut keys !
•
Computer…. Important Shortcut Keys System CTRL+A. . . . . . . . . . . . . . . . . Select All CTRL+C. . . . . . . . . . . . . . . . . Copy CTRL+X. . . . . . . .…
-
Excel in MS Excel
•
Now a day there are many software (ERP System) such as SAP, Oracle etc as well as some local developed ERP System adopted by every Company to develop / keep check on their systems, way of working, Inventory, Purchase, Production, Sales, Income Statement, Balance Sheet etc, but importance of MS Excel in…
-
Working with MS Excel – AVERAGEIF
•
Working with MS Excel – AVERAGEIF Hi, We can easily calculate average by ignore the zero (0) in the list e.g. Formula is = AVERAGEIF(B2:B13,”0″)
-
How to convert a numeric value into English words in Excel
•
How to convert a numeric value into English words in Excel I am sharing link to download Excel Addin for converting Numbers to Words Click to download This Addin will make it easier to use. This Addin can be installed on any computer having Excel 2007 and above versions. Once…