1013 Lizydataanalystjourney.hashnode.dev·Oct 16, 2024Basic Excel – A Detailed OverviewTable 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...10 likesFormatastable
Uzma Usmaniaiskillsbuild.hashnode.dev·Sep 7, 2024Microsoft Excel BasicsShortcuts 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...excel
esProc Desktopesproc-desktop.hashnode.dev·Jul 1, 2024Split & Group Text and Perform Distinct on Each GroupProblem 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...10 likesexcel
esProc Desktopesproc-desktop.hashnode.dev·Jun 27, 2024Import A TXT File Where The Separator Is Missing In A Column To ExcelProblem 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...excel
esProc Desktopesproc-desktop.hashnode.dev·Jun 25, 2024In Excel, Search A Target Value And Hide Columns To Its RightProblem 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...10 likesexcel
esProc Desktopesproc-desktop.hashnode.dev·Jun 24, 2024In Excel, Parse Hexadecimal Numbers And Make QueriesProblem 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...10 likesexcel
esProc Desktopesproc-desktop.hashnode.dev·Jun 19, 2024In Excel, Find the Maximum Value and the Neighboring N Members Before and AfterProblem 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 ...10 likesexcel
esProc Desktopesproc-desktop.hashnode.dev·Jun 13, 2024In Excel, Concatenate the Top 3 Members in Each Group into a StringProblem 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...10 likesexcel
esProc Desktopesproc-desktop.hashnode.dev·Jun 12, 2024In Excel, Expand All Combinations of Multiple ColumnsProblem 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...10 likesexcel
esProc Desktopesproc-desktop.hashnode.dev·Jun 6, 2024In Excel, Combine Every N Row into A New RowProblem 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...10 likesExpress
