ExcelBook
Share
15/11/2025
Product: Excel Custom Formatting
Excel Tip for WhatsApp: Scaling Numbers with Custom Formatting 🎓
Want to make your Excel sheets look cleaner when handling large numbers? Use custom formatting to display values in lakhs, crores, or simply in thousands or millions—while the actual number remains unchanged for calculations!
•1️⃣Quick Shortcut: Press Ctrl + 1 to open Format Cells.
• 2️⃣Show in Hundreds: Use 0"."00/- to display as if divided by 100 (2 decimal places).
• 3️⃣Show in Thousands: Try #, # # #, (no decimals) or # # #.00/- (2 decimals)—displays numbers divided by 1,000.
• 4️⃣Show in Millions: Use #, # # #,, (no decimals) or # # #.00,,/- (2 decimals)—divides by 10 lakh (1,000,000).
• 5️⃣Show in Billions: Format with # # #,,, (no decimals) or # # #.00,,,- (2 decimals)—divides by 100 crore (1,000,000,000).
📢Pro Tip: Add commas at the end of your format to scale numbers automatically! Only the display changes, not the actual value—so your formulas and calculations stay accurate. 📊
09/11/2025
We are discussing ways to use Python in Excel. In this scenario we are trying Square function. 📊💻🔥
Microsoft Forms integration with Microsoft Excel.✍️
Microsoft introduces a powerful Forms functionality in desktop versions of Excel that is set to transform your data collection process into more efficient, effective, accurate and systematic. With this integration, we can create Form directly within an Excel tab, linking the Form to the tab seamlessly. This feature was previously available in Excel for the Web, and now it is available in the Window. However, this feature works with OneDrive and SharePoint as this feature required AutoSave to be turned On.
How it works:
Insert ➡️ Forms ➡️ New Form:
A new browser tab will open, presenting with a blank form to customize accordingly to our need. Simultaneously, a linked table will appear in our tab, ready to synchronize with the Form. As we Edit the Form or Receive new submissions, the linked table in our tab will automatically update, ensuring that our data is always real time and accurate as filled.
Insert ➡️ Forms ➡️ Preview Form: This option will open the Form in preview mode in a new browser tab, allowing you to see how our Form will look to respondents.
Insert ➡️ Forms ➡️ Edit Form: This option will open the Form in edit mode in a new browser tab, so we can make changes to the Form as required.
Insert ➡️ Forms ➡️ Send Form: This option will open the Form in a new browser tab and show the dialog letting us send the Form out to respondents and begin collecting responses.
In our example, posted in the screenshot. We created a Form to collect Traffic related data from various people. In a similar way, this can be used anywhere data collection would be integral such as Entrepreneur collecting feedback for his latest service or product from customers etc.
Please Keep a Note: The new Microsoft Forms integration is available to all Current Channel users running Version 2410 (Build 16.0.18227.20000) or later.
Please refer to the screenshot provided with this post for more clarity. 📊💻📈💡
Product: MS-Excel (M365) [Functionality]
Improvement in TEXT 📝 Functions along with adding Compatibility Versions functionality.
TEXT Functions such as LEN, MID, SEARCH, FIND and REPLACE have been upgraded to work better with Unicode characters along with introducing Compatibility Versions, which will allow to improve functions without changing the results in the existing file 🗃️.
Earlier there were major pain points for the excel users and those who use emojis, because these TEXT functions have been double-counting certain characters. There is one more thing for which this update is important as these TEXT functions are now consistent with Excel more other modern text functions, which did not have this issue.
Existing TEXT function behaviour where LEN(😊) = 2, that’s a bit confusing!
With this update, the LEN, MID, SEARCH, FIND, and REPLACE functions now count each character once, no matter what that character is.
To ensure that calculations in existing workbooks don’t change, these improvements are being rolled out as Compatibility Version 2️⃣.
This Compatibility Version are set per workbook. Version 1️⃣ – Recommended reflects historical calculation behaviour while Version 2️⃣ – Latest, contains the improvement to TEXT functions as mentioned above as to count each character once. Default settings will always be on Version 1️⃣ – Recommended, so their calculations will remain consistent.
To change a workbook’s compatibility Version, select Formulas ➡️ Calculation Options ➡️Compatibility Version.
Let Explore 😊👁️🗨️
06/10/2025
🟠Product: MS-Excel (M365) [Formula]🟠
MS-Excel introduces the new excel function ‘GROUPBY’. These functions allow to perform data aggregation and summary using a single formula. These functions are extremely powerful, simple and useful for our day-to-day operation.🏦🏙️🧑💻
GROUPBY:
This function replica of SQL command ‘GROUPBY’ and can be effectively used to capture similar output. This function requires three arguments ‘What to group by’, ‘the values to aggregate’ and ‘the function’ we would like to aggregate.
GROUPBY(row fields, values, function, [field headers], [total depth], [sort order], [filter array]🖥️💻⌨️
1) Row Fields (Required) - A column-oriented array or range that has the values which are used to group rows and generate row headers. [A1:B76]
2) Values (Required) – A column-oriented array or range of the data to aggregate. [D1:D76]
3) Function (Required) - SUM, MAX, AVERAGE, COUNT, PERCENTOF etc.) that is used to aggregate values. [SUM]
4) Field Headers (Optional) - A number that specifies whether the row fields and values have headers and whether field headers should be returned in the results. The possible values are: (0: No, 1: Yes and don't show, 2: No but generate, 3: Yes and show) [3]
5) Total Depth (Optional) - Decides whether the row headers should have totals. The possible values are: (0: No Totals, 1: Grand Totals, 2: Grand and Subtotals, -1: Grand Totals at Top, -2: Grand and Subtotals at Top) [1]
6) Sort Order (Optional) - A number showing how rows should be sorted. Numbers correspond with columns in row fields followed by the columns in values. If the number is negative, the rows are sorted in descending/reverse order. [-1]
Our Example for Practice:
We created data with columns ‘Year’, ‘Category’, ‘Product’ and ‘Sales’ from column A to D. Let's try to use our ‘GROUPBY’ function in cell ‘F2’. In the formula, for Row Fields provided column A [Year] and B [Category], for Values provided column C [Sales], for Aggregation providing SUM, provided 3 as input to show the Header, provided 1 to provide Grand Total at Bottom of table and -1 provided to Sort based on the first column in descending order.
Output of the above Formula:
A summary table grouped by Year and Category, Total Sales for each combination, a Header Row at the top, a Grand Total row at the bottom and Sorted by Year (Descending).
For more insight please follow our WhatsApp Channel:
https://whatsapp.com/channel/0029VaTjo3p5fM5goFWxNm28
Let's explore and Practice 😊
📊📈📋🖨️💶
Click here to claim your Sponsored Listing.
Category
Contact the school
Website
Address
Pune
