Managing & Tabulating Data in Excel

You will learn: Powerful data aggregation features like sub-totals & pivot reports, Data selection features, Data Validation and data entry features, and Linking Excel data sheets to enterprise or other database sources Contents1 Saving (Opening) In (From) Different File Formats 2 Data Entry Form 3 Reducing Errors In Data Entry Validation & AutoCorrect 4 Using Fill And Other Tools To Save On Typing time 5 Conditional Formatting 6 Sorting 7 Filter (Hiding The Data You Do Not Want To View) 8 Selecting All Cells/Content That Satisfy A Criterion 9 Subtotals 10 Pivot Reports 11 Scenarios And Goal Seek 12 Linking To A Database 13 Reading ASCII Text Data 14 Paste Special 15 Saving Or Transforming To Web And Document Formats