Excel training (online)!
https://www.fiverr.com/s2/845e59e2ce?utm_source=org.wordpress.android_Mobile
Excel training (online)! Read More »
Excel
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 varies the value in one
Goal Seek in MS Excel ! Read More »
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 of a table of data,
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 want to find. The V
Computer .. Important shortcut keys !
Computer…. Important Shortcut Keys System CTRL+A. . . . . . . . . . . . . . . . . Select All CTRL+C. . . . . . . . . . . . . . . . . Copy CTRL+X. . . . . . . . . . . . .
Computer .. Important shortcut keys ! Read More »
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 any working office always there.
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″)
Working with MS Excel – AVERAGEIF Read More »
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 Installed you can use SpellCurr()
How to convert a numeric value into English words in Excel Read More »