Data Analysis (MS Excel):
Data Analysis (MS Excel): Read More »
Excel
Advanced Topics in Excel :
Excel over view The Date in Excel Excel Conditional Formatting Excel VLOOKUP Excel HLOOKUP Using Excel’s Goal Seek Feature Create Excel Pivot Tables Microsoft Excel Sort Feature Introduction to Using Macros in Microsoft Excel 2003 Protect Excel Sheet Data base in excel Copy, paste special function Links (Sheet / work book) Data showing thru Chart
Advanced Topics in Excel : Read More »
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 ranges with cells together and
Microsoft Excel – Course outline Read More »
Excel training (online)!
https://www.fiverr.com/s2/845e59e2ce?utm_source=org.wordpress.android_Mobile
Excel training (online)! Read More »
Excel training (online)!
https://www.fiverr.com/s2/845e59e2ce?utm_source=org.wordpress.android_Mobile
Excel training (online)! Read More »
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.