Tag: 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…
-
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…
-
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. . . . . . . .…