Aug 31, 2025 · 1 min read · For decades, Excel was the king of data. From balance sheets to pivot tables, it gave businesses control over numbers. But as data grew massive and decisions became faster, Excel started showing cracks. That’s where Power BI stepped in. 🔹 Where Exce...
Join discussion
Oct 16, 2024 · 4 min read · 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...
Join discussion
Sep 7, 2024 · 5 min read · 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...
Join discussion
Jul 1, 2024 · 2 min read · 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...
Join discussion
Jun 27, 2024 · 3 min read · 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...
Join discussion
Jun 25, 2024 · 2 min read · 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...
EesProc commented
Jun 24, 2024 · 1 min read · 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...
EesProc commented
Jun 19, 2024 · 3 min read · 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 ...
Join discussion
Jun 13, 2024 · 2 min read · 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...
EesProc commented
Jun 12, 2024 · 3 min read · 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...
EesProc commented