Table Of Contents 1.Introduction for Excel 2.Tabs in the Ribbon of Excel 3.Data type conversion in Excel 4.Conditional Formatting 5.Format as Table 6.Mathematics in Excel 6.1 Calculations for Structured data 6.2 IF 6.3 AND and OR 7.Conclusion 1.INTRO...
Shortcuts ctrl + A=select all ctrl+9 = hide a row ctrl + shift + 9 = unhide a row ctrl + o = hide a column Editing & Customizing data f2 = editing any cell Freezing view --> window --> Freeze Panes Splitting view --> window --> new window Copy & Pas...
Problem description & analysis: Below is an irregularly categorized detail table. Column A and column B are categories and both have duplicate values. Column C contains detailed data consisting of strings separated by "comma+space", and there are dup...
Problem description & analysis: We have a comma-separated txt file that has a total of 10 columns. As certain values of the 3rd column do not have separators, that column is missing and the corresponding rows only have 9 columns, as shown in the last...
Problem description & analysis: The following Excel table has several columns of numbers: ABC 1100204200 2202100102 3260270108 41199100 512100100 Task: With a given parameter, find the first same number in each row and hide the columns o...
Problem description & analysis: In the following table, value of cell A1 is made up of names of several people and their attendances in four days. For example, c is 1100 expressed in hexadecimal notation, meaning the corresponding person has attendan...
Problem description & analysis: The column below contains numeric values only: A 113 221 346 421 549 69 734 823 96 101 1137 1249 1342 1440 1515 1631 1717 181147 1918 2030 2122 224 2325 2419 2513 2627 2738 2830 2916 ...
Problem description & analysis: Below is a grouped table having detailed data under each group: ABC 1ClientLocationSales 2ABCNew York5,000 3Florida4,000 4Texas3,000 5California2,000 6Georgia1,000 7XYZTennessee10,000 8New Jersey8,000 9W...
Problem description & analysis: In the following Excel table, column A contains codes and the other columns are grouping columns having different meanings and containing comma-separated values. ABCDEFG 1Assembly#ProductTypeUnit ConfigNominal C...
Problem description & analysis: In column F, every four rows correspond to one record: ABCDEF 1NameAddressCityShort IDCompany 1 22222 al street 3Blue cheese 41 5Company 2 61111 arm rd 7Ranch 82 9Company 3 103333 raindrop drive 11Pean...
