Hello @itslesley1698, You can add more entries to the worktops cells by extending the range of your schedule. Here's how: Manual Method: If you're working with a manual schedule, simply insert new rows in the worktops section to add more tasks or data. Adjust Formatting: Ensure that any formatting (borders, colors, etc.) applied to the existing cells is extended to the new rows for consistency. Combo Box Method: If you’re using the Combo Box method, ensure that the data validation or linked cell ranges include the newly added rows. If you’re following along with the tutorial, double-check that any formulas or conditional formatting rules are updated to cover the extended range. Let me know if you need further help! Regards ExcelDemy

Hello @jairtzinio, I’m sorry to hear you’re having trouble with this! Could you share a bit more about what specifically isn’t working? For example, are you facing issues with setting up the hierarchy, formatting the chart, or using the Visio Data Visualizer add-in? If you provide more details, I’d be happy to help troubleshoot and make sure you can create your organizational chart successfully. Excel can be challenging sometimes, but there’s always a solution. You can also follow our article: www.exceldemy.com/create-an-organizational-chart-in-excel-from-a-list/ Regards ExcelDemy

Hello @ktsd3727, The negative values you're seeing are due to the mean (24) being close to the standard deviation (13.56), which causes the lower range of the 99.7% (mean - 3*std dev) to fall into negative territory. Since a bell curve is symmetrical, this is mathematically correct. However, if your data cannot be negative (e.g., age, weight), you may need to adjust the visualization or interpret the results differently. To ensure a full bell curve: 1. Increase the range of values on your X-axis to include more of the curve. 2. Check if the data is appropriate for a normal distribution or if transformations are required. Let me know if you need further clarification! Regards ExcelDemy

Hello @chavalastechunofficial8619, Thank you for pointing that out! The template is now available in the description box. For your convenience, I'm also attaching it here: www.exceldemy.com/wp-content/uploads/2022/06/how-to-make-a-family-budget-in-excel.xlsx Let me know if there's anything else you need. Regards ExcelDemy

Hello @sanmani7116, Month names showing as "1, 2, 3, 4..." happens because Excel interprets the data numerically. To fix this, ensure the column is formatted as text or date. Select the column, right-click, choose Format Cells, and select a date format like "MMM" or "MMMM" to display proper month names. Regards ExcelDemy

Well, I discovered a simple way to do this, I'll just hide the column I don't need :D

Hello @kubahlemon, Thank you for your kind words! If you want to extract only specific columns using VBA without hiding others, you can modify the code to specify which columns to include. For example, you can loop through only the required columns or use an array to define the desired column numbers. Regards ExcelDemy

@@exceldemy2006 Okay, Sir. I'll definitely try to modify the code! Thank You! I'll get back here if I have another questions

@kubahlemon, you are most welcome. Keep exploring Excel with ExcelDemy! Let us know whenever you need help. Regards ExcelDemy

Hello @MDAnamulAhsanRifat, The exclamation mark (!) in Excel is not a standalone function but part of a formula that references cells from another sheet. For example, =SheetName!CellReference links a cell from another sheet. If this isn't working for you, here are a few things to check: 1. Ensure the sheet name is correct and matches exactly, including spaces (use single quotes for names with spaces, e.g., 'Sheet Name'!A1). 2. Verify the formula syntax. 3. Check if the workbook or sheet is protected, which might restrict editing. Regards ExcelDemy

Hello @jorrgeroldan, The VBA code is in the article, and it is explained properly. Copy the code from the article or Excel file. Both links are available in the description box. For your better understanding, I am attaching the link here. Article: www.exceldemy.com/how-to-create-a-database-in-excel-with-pictures/ Excel File: www.exceldemy.com/wp-content/uploads/2023/05/how-to-create-a-database-in-excel-with-pictures-1.xlsm Regards ExcelDemy

Hello @eyriqueetiqazz3053, Thanks for your question! To edit the autofill form setup in Google Sheets, you can create a similar form using Google Forms linked to your sheet, or use built-in features like Data Validation or App Scripts for automation. Regards ExcelDemy

Hello @NormanCreel, Thank you for your question, If you already have all the data and want to create a filterable database to sort by 8 data points, here’s how you can achieve it: Use Excel’s Built-in Features: 1.Convert your data into an Excel Table: Select your data and press Ctrl + T . This automatically enables filters for all columns. Use the dropdown filters to sort and filter data by multiple criteria. Automating with VBA for Custom Filtering: If you want a more automated solution, you can use VBA to filter based on specific criteria. Here's an example: Example VBA Code: Sub FilterDatabase() Dim ws As Worksheet Dim criteriaRange As Range ' Set your worksheet Set ws = ThisWorkbook.Sheets("Sheet1") ' Clear any existing filters If ws.AutoFilterMode Then ws.AutoFilterMode = False ' Apply filters ws.Range("A1:H100").AutoFilter Field:=1, Criteria1:="Specific Criteria 1" ws.Range("A1:H100").AutoFilter Field:=2, Criteria1:="Specific Criteria 2" ' Repeat for all fields up to 8 ' Optional: Set criteria dynamically ' Set criteriaRange = ws.Range("K1:K8") ' Example criteria range ' For Each cell In criteriaRange ' ws.Range("A1:H100").AutoFilter Field:=cell.Row, Criteria1:=cell.Value ' Next cell End Sub Steps: Replace "Sheet1" with the name of your sheet. Adjust the range A1:H100 to match your database. Specify the Criteria1 for each Field as needed. Regards ExcelDemy

Hello @umutkutay8980, You are most welcome. Thanks for your feedback and appreciation. Glad to hear that our tutorial is really helpful to you. Keep exploring Excel with ExcelDemy! Regards ExcelDemy

Hello @SpinBaaz81, You are most welcome. Thanks for your feedback and appreciation. Glad to hear that our tutorial is useful to you. The article provides an overview. You can also download the Excel file for further use. www.exceldemy.com/create-leave-tracker-in-excel/ Regards ExcelDemy

Hello @CorinnaLo, Thank you for pointing that out! The x-axis labels in a butterfly chart should display positive values on both sides with the center at 0. To fix the issue: 1. Right-click the x-axis in your chart and select Format Axis. 2. Under the Axis Options, ensure the minimum and maximum bounds match your data range. For example, set the minimum to -20k and the maximum to 20k if your values range within this. 3. In the same menu, set the horizontal axis crosses at 0 to center the chart correctly. Let us know if these steps help resolve the issue! Regards ExcelDemy

Hello@magpakankipeti123, Yes, this is possible to do in Google Seets. While Google Sheets doesn’t directly support features like shapes or buttons to create interactive tabs, you can achieve a similar experience using hyperlinks or Google Apps Script. Using Hyperlinks: 1. Create a new sheet for each tab. 2. In your main sheet, list the names of the tabs and link them to the corresponding sheets: 3. Select a cell and press Ctrl+K or use the Insert > Link option. 4. Choose Sheets in this spreadsheet and select the desired sheet. Using Apps Script for a Menu: 1. Go to Extensions > Apps Script and paste a script to create a custom menu. 2. Copy and paste the code in the Apps Script Editor, function onOpen() { const ui = SpreadsheetApp.getUi(); ui.createMenu('Navigate') .addItem('Go to Sheet1', 'goToSheet1') .addItem('Go to Sheet2', 'goToSheet2') .addToUi(); } function goToSheet1() { const sheet = SpreadsheetApp.getActiveSpreadsheet().getSheetByName('Sheet1'); SpreadsheetApp.setActiveSheet(sheet); } function goToSheet2() { const sheet = SpreadsheetApp.getActiveSpreadsheet().getSheetByName('Sheet2'); SpreadsheetApp.setActiveSheet(sheet); } 3. Save and reload the sheet to see a Navigate menu at the top. Regards ExcelDemy

Hello @_-wv4ez, You are most welcome. Keep exploring Excel with ExcelDemy! Regards ExcelDemy

Hello @RohitKadam-pw4hp, In the summary sheet, in the Year field, change the year. The year is in C6 column. Regards ExcelDemy

Hello @pala_Bapak_Kau, Thanks for visiting the channel! We appreciate your support and hope you find the content helpful. Feel free to explore more videos! Regards ExcelDemy

Hello @pala_Bapak_Kau, You are most welcome! Thanks for your interest. Hope you find it useful. Keep exploring Excel with ExcelDemy! Regards ExcelDemy

Hello @pala_Bapak_Kau, Thanks for your feedback. We're glad you're enjoying our channel! We strive to make Excel accessible to everyone. Keep exploring Excel with ExcelDemy! Regards ExcelDemy

Hello @pala_Bapak_Kau, You are most welcome. Thanks for your feedback. I am glad to hear that you are interested in our tutorial. Keep exploring Excel with ExcelDemy! Regards ExcelDemy

Hello @BugumProjects, Our video shows the steps of how to create a roaster for different months. Please watch our videos from 22 minutes to the end. Regards ExcelDemy

Hello @rowalk42, Thanks for sharing your feedback. Glad to hear that it worked like a magic and saved your loads of time. Keep exploring Excel with ExcelDemy! Regards ExcelDemy

Hello @hassanfazeel6853, Your dates are showing as number instead of date, It's a formatting issue. Select the Date format from the Numbers group. Regards ExcelDemy

Hello @che89lavi, You are most welcome. Formulas must work after changing the year in summary sheet. Formulas will calculate leave based on the dates. The Year change update Months. It doesn't affect the any formula. Please check out this Excel file: www.exceldemy.com/wp-content/uploads/2024/12/Create-Leave-Tracker-2025.xlsx Regards ExcelDemy

@@exceldemy2006 Hi, tnx, but for some reason, when you try to adjust it on Office 365, it does not work. Even if you click Undo, formulas still showing error in values.

Hello @che89lavi, Thank you for your feedback. Since the file was created in Excel 365, it should work as expected when you change the year. Here are a few possible reasons for the issue and how to fix them: Recalculate Formulas: Press Ctrl + Alt + F9 to force a full recalculation of all formulas. Check Date Formats: Ensure the date cells are properly formatted as dates and not as text, as this may disrupt calculations. Formula References: If any formulas rely on named ranges or absolute references, make sure they adjust correctly with the year change. Check for Errors: Look for any circular references or cells showing #VALUE! or #REF! errors, as they might need to be corrected. Regards ExcelDemy

Hello @Babu8e, In the summary sheet, change the Year from 2023 to 2024 or 2025. This will automatically update the whole sheet according to the year. Download the Excel file: www.exceldemy.com/wp-content/uploads/2024/12/Create-Leave-Tracker-2025.xlsx Regards ExcelDemy

Hello @shanesalmon3379, You are most welcome! Thanks for your appreciation and feedback. Keep exploring Excel with ExcelDemy! Regards ExcelDemy

Hello @dwindyloumarinas2268, Sorry to hear it's not working for you! It could be an issue with the cell format or the formula used. Use the SUMPRODUCT or FILTER approach as shown in the tutorial. If your text and numbers are in the same cell, try using =SUMPRODUCT(--TEXTSPLIT(A1,{" ","-","/"})) to extract and sum the numbers. If you'd like, share your formula or a brief example of your data, and I’d be happy to guide you further! 😊 Regards ExcelDemy

@@exceldemy2006 Thank you for the response. My problem is this ( 7:02 - How to SUM Cells with Text in Excel) the sum is wrong. I want to send my excel format to you so i will understand more. 🙏

Hello @dwindyloumarinas2268, You are most welcome. You can share your workbook in our ExcelDemy Forum: exceldemy.com/forum/ We are happy to help. Regards ExcelDemy

Hello @dwindyloumarinas2268, The sum shows 0 because Excel may be treating numbers as text, combining text and numbers in one cell, or due to hidden spaces/special characters. Use this formula to sum numbers in text: =SUMPRODUCT(--TEXTSPLIT(A1,{" ","-","/"})) If numbers are in multiple cells, use: =SUMPRODUCT(--(ISNUMBER(A1:A10)*A1:A10)) Check for spaces or text issues in your data. Regards ExcelDemy

Hello @johanshibumathew2911, It seems that the chart is interpreting your data layout incorrectly. To fix this, follow these steps: 1. Right-click on the chart and select "Select Data". 2. In the Select Data Source window, ensure that the X-axis and Y-axis values are set correctly. I3. f needed, click "Edit" for each series and manually specify the correct data range for the X and Y values. If your data is arranged vertically but Excel is reading it horizontally, you may need to transpose the data using Paste Special > Transpose or adjust the data references. Regards ExcelDemy

Hello @Rumplestiltskin97, You are most welcome. Thanks for your feedback and appreciation. We are glad to hear that our channel is helping you. Keep learning Excel with ExcelDemy! Regards ExcelDemy

Hello @gladys100011, You are most welcome. Thanks for your feedback and appreciation. Glad to hear that our guide worked for you. Regards ExcelDemy

Hello @mohandjaber, Copying and pasting into merged cells can be tricky since Excel treats merged cells as one large cell. Here’s how you can do it: 1. Select and copy the cells you want to paste. 2. Click on the merged cell where you want to paste the data. 3. Press Ctrl + V to paste. Note: If you're pasting multiple cells, Excel may show an error because merged cells only accept one value. To avoid this, unmerge the cells, paste the data, and then re-merge if needed. Regards ExcelDemy

Hello @JonelMartinez-d9x, To merge and update your online database with your offline one, you can follow these steps: 1. Export Offline Data: Save your offline database as a CSV or Excel file. 2. Upload & Merge: Import this file into your online database. If the platform allows, use a "merge" or "update" option to avoid duplicate entries. 3. Use Unique Identifiers: Ensure both databases have a unique ID for each record to prevent duplicates. 4. Automate Updates (Optional): Consider automation tools like Power Query, Power Automate, or Google Sheets scripts for continuous syncing. Regards ExcelDemy

Hello @ΛαμπροςΛαμπρος-λ6σ, To download Google Maps to a Garmin GPS Astro 320, you would typically need to use a program like Garmin BaseCamp to import Google Maps data. First, save the Google Maps data as a compatible file (such as KML or GPX), then upload it to BaseCamp. From there, transfer the data to your Garmin device. You may need to ensure that the map data is compatible with Garmin devices. You can find detailed instructions in the Garmin user manual or related resources. Regards ExcelDemy

@exceldemy2006 Thank you for your answer I have seen in Google maps an option (maps offline)And you can download it to SDK card.If I downolad and add it to my Garmin's what do you think it will play?Can you please make a video with the steps if it's possible?Thank you very much you are a life saver!!

I want Google maps because it shows better the trees lakes etc Garmin have also but they are not so good

Hello @ΛαμπροςΛαμπρος-λ6σ, It’s unlikely that directly downloading offline Google Maps and placing them on a Garmin Astro 320 will work, as Garmin devices use their own map format (.IMG) rather than standard Google Maps files. However, you can create custom maps using Garmin BaseCamp or convert Google Maps data to Garmin-compatible formats (like KML to GPX) and then load them onto your SD card. Regards ExcelDemy

@exceldemy2006 Thank you very much for your answer I am interested only for Google maps can you please tell me the steps how to download and then convert the maps to this form Thank you

Hello @emmakeane8902, You can use a whole number for the weight in a weighted scoring model. However, if you use whole numbers instead of percentages, you'll need to ensure that the sum of the weights still equals the total weight for the model (e.g., 100 or any other scale). This way, the relative importance of each criterion remains proportional. Regards ExcelDemy

Hello @shahriarnayan646, While adding new employees you must need to include those cell in the formula. Include the 50 employee's cell reference in all the formula. Please remember to update the formula according to your dataset. The initial formula is: =IFERROR(INDEX(Jan!AJ$9:AJ$13,MATCH($B10,Jan!$C$9:$C$13,0)),0)+IFERROR(INDEX(Feb!AJ$9:AJ$13,MATCH($B10,Feb!$C$9:$C$13,0)),0)+IFERROR(INDEX(Mar!AJ$9:AJ$13,MATCH($B10,Mar!$C$9:$C$13,0)),0)+IFERROR(INDEX(Apr!AJ$9:AJ$13,MATCH($B10,Apr!$C$9:$C$13,0)),0)+IFERROR(INDEX(May!AJ$9:AJ$13,MATCH($B10,May!$C$9:$C$13,0)),0)+IFERROR(INDEX(Jun!AJ$9:AJ$13,MATCH($B10,Jun!$C$9:$C$13,0)),0)+IFERROR(INDEX(Jul!AJ$9:AJ$13,MATCH($B10,Jul!$C$9:$C$13,0)),0)+IFERROR(INDEX(Aug!AJ$9:AJ$13,MATCH($B10,Aug!$C$9:$C$13,0)),0)+IFERROR(INDEX(Sep!AJ$9:AJ$13,MATCH($B10,Sep!$C$9:$C$13,0)),0)+IFERROR(INDEX(Oct!AJ$9:AJ$13,MATCH($B10,Oct!$C$9:$C$13,0)),0)+IFERROR(INDEX(Nov!AJ$9:AJ$13,MATCH($B10,Nov!$C$9:$C$13,0)),0)+IFERROR(INDEX(Dec!AJ$9:AJ$13,MATCH($B10,Dec!$C$9:$C$13,0)),0) To add new employee change the ranges of the formula in the Summary sheet. =IFERROR(INDEX(Jan!AJ$9:AJ$14,MATCH($B15,Jan!$C$9:$C$14,0)),0)+IFERROR(INDEX(Feb!AJ$9:AJ$14,MATCH($B15,Feb!$C$9:$C$14,0)),0)+IFERROR(INDEX(Mar!AJ$9:AJ$14,MATCH($B15,Mar!$C$9:$C$14,0)),0)+IFERROR(INDEX(Apr!AJ$9:AJ$14,MATCH($B15,Apr!$C$9:$C$14,0)),0)+IFERROR(INDEX(May!AJ$9:AJ$14,MATCH($B15,May!$C$9:$C$14,0)),0)+IFERROR(INDEX(Jun!AJ$9:AJ$14,MATCH($B15,Jun!$C$9:$C$14,0)),0)+IFERROR(INDEX(Jul!AJ$9:AJ$14,MATCH($B15,Jul!$C$9:$C$14,0)),0)+IFERROR(INDEX(Aug!AJ$9:AJ$14,MATCH($B15,Aug!$C$9:$C$14,0)),0)+IFERROR(INDEX(Sep!AJ$9:AJ$14,MATCH($B15,Sep!$C$9:$C$14,0)),0)+IFERROR(INDEX(Oct!AJ$9:AJ$14,MATCH($B15,Oct!$C$9:$C$14,0)),0)+IFERROR(INDEX(Nov!AJ$9:AJ$14,MATCH($B15,Nov!$C$9:$C$14,0)),0)+IFERROR(INDEX(Dec!AJ$9:AJ$14,MATCH($B15,Dec!$C$9:$C$14,0)),0) Follow this forum post solution for better understanding: exceldemy.com/forum/threads/issue-in-leave-tracker.374/#post-1580 Regards ExcelDemy

Hello @vasilisnikitaras, Thanks for the feedback and appreciation! Glad you liked the video. Regards ExcelDemy

Hello @vkas6608, To display names in a drop-down checklist and map corresponding email addresses, you can modify the code to include a lookup feature. Here's a detailed approach: Create a Helper Table: In Excel, create a table where column A contains names, and column B contains the associated email addresses. Modify VBA Code: After selecting a name from the checklist, use a lookup function to fetch the email. You can use VLOOKUP or INDEX-MATCH to search for the corresponding email. For example, assuming your table of names and emails is in the range A2:B100, you can modify the VBA code like this: Dim email As String email = Application.WorksheetFunction.VLookup(listOption, Range("A2:B100"), 2, False) This will pull the email address associated with the selected name and can be displayed in a cell or message box. Update Code for Multiple Selections: If you have multiple names selected, the code must loop through each selected name, perform the lookup, and concatenate the results into a string or update the display accordingly. Example for displaying emails: You can add another section in the code to display the emails next to the names or in a separate cell after the selection. Regards ExcelDemy

Hello @nishamistry9339, To add company holidays in your leave tracker, create a separate list for holidays and mark those days as non-leave days. You can use Excel’s conditional formatting or formula features (such as IF or VLOOKUP) to ensure these dates are excluded from leave calculations. You can also add a "Holiday" column next to your leave tracker and input the dates manually or use a holiday calendar. For more detailed steps, please refer to the guide in the article. Regards ExcelDemy

Hello @richofal, You are most welcome. Thanks for your feedback and appreciation. Keep learning Excel with ExcelDemy! Regards ExcelDemy

Hello @jeffbakker7241, You are most welcome. Thanks for your appreciation and feedback. Keep exploring Excel with ExcelDemy! Regards ExcelDemy

Hello @ravinryandomaoal1873, You are most welcome. Thanks for your feedback and appreciation. We are mainly focused on MS Excel but will update the Google Sheets tutorial sooner. We have some tutorials regarding salary sheets/slips. How to Make Salary Sheet in Excel: kzbin.info/www/bejne/inTdq5aFh7mri68 How to Create Salary Slip Format with Formula in Excel Sheet: www.exceldemy.com/salary-slip-format-in-excel-sheet-with-formula/ How to Make a Payroll System with Payslip in Microsoft Excel: www.exceldemy.com/how-to-make-a-payroll-system-in-microsoft-excel-with-payslip/ How to Create Automatic Salary Slip Generator Using Excel: www.exceldemy.com/automatic-salary-slip-generator-using-excel/ You can apply Excel concepts in Google Sheets. Regards ExcelDemy

Hello @Nat-s2b, You are most welcome. Thanks for your feedback and appreciation. Glad to hear our tutorial is easy to follow and helpful. Keep learning Excel with ExcelDemy! Regards ExcelDemy

Hello @sorindiaconescu8660, Thanks for your feedback and appreciation. Thanks for watching our video. Keep exploring Excel with ExcelDemy! Regards ExcelDemy

Hello @lopsidedxi4162, Yes, you can achieve this using a simple formula in Excel. You can use the COUNTIF function to count the number of times the word "day" appears, and then multiply that count by 9.5 hours. Here's an example formula: =COUNTIF(A1:A10, "day") * 9.5 This will count the occurrences of "day" in the range A1:A10 and then multiply that by 9.5 to give the total number of hours. Adjust the range as needed. Regards ExcelDemy

Thank you. Can you associate a few more words like bank holiday, study leave, induction etc’s that counts to 9.5 hours?

Hello @lopsidedxi4162, You can extend the formula by adding more conditions for different words like "bank holiday," "study leave," and "induction." Here's how you can adjust the formula: =COUNTIF(A1:A10, "day") * 9.5 + COUNTIF(A1:A10, "bank holiday") * 9.5 + COUNTIF(A1:A10, "study leave") * 9.5 + COUNTIF(A1:A10, "induction") * 9.5 This will sum up the total hours for each term. You can add more words by following the same pattern, multiplying by 9.5 for each occurrence. Regards ExcelDemy

can't see it😢

Hello @Venus_rey, In our article, you will get all the formulas to use. The article link is given in the description box. Here I am attaching it again: www.exceldemy.com/create-leave-tracker-in-excel/ Regards ExcelDemy