Category: MS Office
-
Microsoft Excel – Course outline
•
Are you want to learn MS Excel online? A free training session available for short time. What topic you want to learn? comments here Question Y/N Question Y/N Write basic formulas, eg = A1*A2 Write formulas using brackets where required, eg =(A1+A2)/A3 Write basic functions, eg SUM, AVERAGE,MAX, MIN Selecting…
-
Excel training (online)!
•
https://www.fiverr.com/s2/845e59e2ce?utm_source=org.wordpress.android_Mobile
-
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…