r/Excel247 • • 1h ago

Auto population for reoccurring charges

Thumbnail reddit.com
1 Upvotes

r/Excel247 • • 9h ago

All type of date

23 Upvotes

r/Excel247 • • 9h ago

After 8 years in data jobs, the one Excel habit I wish I’d started on day 1: Ctrl+T

Thumbnail reddit.com
1 Upvotes

r/Excel247 • • 11h ago

How to count cells that contain specific value in Excel? - Excel Tips and Tricks

23 Upvotes

Learn how to count cells that contain specific value in Excel. In our case, we are trying use a numeric value rather than a text value to count cells. Essentially, in excel count cells with specific text. You can also use the same technique in excel to count cells with text or numbers.

Excel is a powerful tool used for organizing, analyzing, and presenting data. One of the most basic and commonly used functions in Excel is the ability to count cells that meet certain criteria. This function is particularly useful when you need to analyze large datasets and want to quickly find the number of cells that contain a specific value. In this context, counting cells that contain a specific value in Excel can be incredibly helpful in streamlining workflows and improving productivity. In this article, we'll explore different methods to count cells that contain a specific value in Excel, which can be applied to a wide range of tasks and projects.

This is the formula feature in our video.

Column C Formula

=IF(B2="Paid",100,0)

Number of people who have not paid.

=COUNTIF(C2:C204,"$0.00")

How to count cells that contain specific value in Excel?,

how do i count cells with text in excel,excel count cells with specific text,excel count cells with text or numbers,countif excel,excel count how many times a value appears in a column,how to count text in excel,how to count specific names in excel,excel count cells with numbers,

how do i count cells with text in excel?,excel count cells with specific text,excel count cells with text or numbers,countif excel,how to count text in excel,how to count specific names in excel,

Check out my complete suite of Microsoft Excel Tips and Tricks.

https://www.youtube.com/@jjnet247/shorts

https://www.tiktok.com/@exceltips247

https://www.instagram.com/exceltips247/

https://www.dailymotion.com/ExcelTips247

https://www.pinterest.com/ExcelTips247/excel-tips-and-tricks/

https://x.com/ExcelTips247/media

https://www.reddit.com/r/Excel247/

https://www.facebook.com/XyberneticsInc/reels/

#microsoft #excel #exceltips #tips #exceltricks #tricksandtips


r/Excel247 • • 14h ago

Excel w pracy – jakie funkcje i triki naprawdę ułatwiają Wam życie?

2 Upvotes

Cześć!

Od pewnego czasu rozwijam swój kanał YouTube poświęcony Microsoft Excel.

Publikuję na nim praktyczne tutoriale i porady, które pomagają szybciej pracować z Excelem, automatyzować powtarzalne zadania i lepiej wykorzystywać jego możliwości.

Poruszam między innymi takie tematy jak:
\- Funkcje i formuły Excela.
\- Tabele przestawne.
\- Power Query i automatyzacja.
\- Raporty i dashboardy.
\- Przydatne triki i skróty klawiaturowe.

Kanał znajdziecie tutaj:
https://www.youtube.com/@LukaszBielski

Chętnie poznam Waszą opinię i dowiem się, jakie problemy z Excelem najczęściej napotykacie w pracy.

\*\*Gdybyście mogli zautomatyzować jedną czynność wykonywaną w Excelu, co by to było?\*\*

Chętnie wykorzystam Wasze pomysły do przygotowania kolejnych tutoriali!


r/Excel247 • • 1d ago

Draw Lines without inserting line shapes - Excel Tips and Tricks

36 Upvotes

Discover how we can draw lines without inserting line shapes. We will learn how to draw straight lines in Excel. As in draw lines without inserting line shapes multiple shortcut, or draw lines without inserting line shapes multiple formula in Excel.

Excel is a widely used spreadsheet program that provides various tools for data analysis and visualization. While most users are familiar with the basic features of Excel, there are some hidden tricks that can significantly enhance productivity. One such technique is the ability to draw lines without inserting a line shape directly onto the spreadsheet. This feature enables users to create visually appealing charts, graphs, and diagrams without cluttering the worksheet with additional objects.

Instead of using the traditional method of inserting a line shape, Excel offers a practical alternative through its built-in drawing tools. By selecting the "Insert" tab in the Excel ribbon and navigating to the "Shapes" section, users can find a range of drawing options, including lines. With this tool, users can simply click and drag to draw lines directly on the spreadsheet, eliminating the need for a separate line shape. Moreover, Excel allows users to customize the line's style, color, and thickness to match their desired visual representation.

By leveraging this feature, Excel users can create more dynamic and flexible visuals within their worksheets. Whether it's designing flowcharts, illustrating relationships between data points, or highlighting specific trends, the ability to draw lines without inserting line shapes provides a streamlined approach to data visualization. With Excel's diverse set of drawing tools, users can unlock their creativity and present information in a visually engaging manner while maintaining the efficiency and functionality of the spreadsheet program.

These are the steps outlined in my video.

Draw Lines without inserting line shapes

  1. Highlight cells

  2. Ctrl + 1

  3. Number tab

  4. Custom

  5. @*_

  6. OK

excel draw lines without inserting line shapes multiple,how to draw straight line in excel,excel draw lines without inserting line shapes multiple shortcut,excel draw lines without inserting line shapes multiple formula,

how to add divider lines in excel,how to draw straight line in excel,how to draw line in excel column,how to connect lines to shapes in word,how to draw a line between two points in excel,how to insert lines in excel between data,

Check out my complete suite of Microsoft Excel Tips and Tricks.

https://www.youtube.com/@jjnet247/shorts

https://www.tiktok.com/@exceltips247

https://www.instagram.com/exceltips247/

https://www.dailymotion.com/ExcelTips247

https://www.pinterest.com/ExcelTips247/excel-tips-and-tricks/

https://x.com/ExcelTips247/media

https://www.reddit.com/r/Excel247/

https://www.facebook.com/XyberneticsInc/reels/

#microsoft #excel #exceltips #tips #exceltricks #tricksandtips


r/Excel247 • • 1d ago

Tip: Use LET to return real empty values

Thumbnail reddit.com
1 Upvotes

r/Excel247 • • 2d ago

Help to sort data into categories by non-numeric traits.

Thumbnail reddit.com
1 Upvotes

r/Excel247 • • 2d ago

Excel/VBA or Python to automate boring paperwork at my job? Need some advice

Thumbnail reddit.com
1 Upvotes

r/Excel247 • • 2d ago

Compare two lists to find missing values using XLOOKUP in Excel - Excel Tips and Tricks

35 Upvotes

Learn how to compare two lists to find missing values using XLOOKUP in Excel.

Discover how you can compare two lists to find missing values using XLOOKUP in Excel.

Essentially using XLOOKUP to compare two columns for matches, or in other words, compare two lists to find missing values using XLOOKUP in excel multiple. Some people like to use XLOOKUP to find missing data in two columns, like I'm demonstrating in this video. Also, they like to compare two columns in excel using XLOOKUP and return a third value. But in a nutshell, I'm using the XLOOKUP to compare two lists. And compare two columns and find missing values in excel.

Ok let answer this question, how to do a XLOOKUP in Excel to find missing data? Or how do you compare two lists in Excel to see if they match? Well.... you came to the right place, and this video explain just that.

🔗🔗 LINKS TO SIMILIAR VIDEOS 🔗🔗

How to compare two lists to find missing values WITHOUT FORMULA in excel - Excel Tips and Trick

https://youtube.com/shorts/pJtB8dbbimw?si=iL8qnDJ_WVAhKhAX

Compare two lists to find missing values using XLOOKUP in Excel - Excel Tips and Tricks

https://youtube.com/shorts/nOwMXkZJ5HU?si=N80igNW7Vr-xCK5x

Compare two lists to find missing values using VLOOKUP in Excel - Excel Tips and Tricks

https://youtube.com/shorts/1XGIPzsvS_Y?si=cu3ajNdT3lXFX3LB

How to compare two lists in Excel using Conditional Formatting - Excel Tips and Tricks

https://youtube.com/shorts/GX-BYEgcnRA?si=16oLe6kcxZExM4Df

How to compare two lists to find missing values in excel - Excel Tips and Tricks

https://youtube.com/shorts/dl75Lz_jaPs?si=-UTAvmCRdTl6ZZgm

Excel Tips and Tricks - Compare Two Lists In Excel And Highlight

https://youtube.com/shorts/xJoy-nboV6A?feature=share

Summarize Duplicates in Excel - Excel Tips and Tricks

https://youtube.com/shorts/-IYUTWVmVTU?si=aN-hfbyQD0QEPcgm

Find difference quickly in Excel Comparing 2 List - Excel Tips and Tricks

https://youtube.com/shorts/8_-lN-yKf04?si=itTI-rcCKOaG7zVc

How to do a XLOOKUP in Excel to find missing data?, How do you compare two lists in Excel to see if they match?,

XLOOKUP to compare two columns for matches,compare two lists to find missing values using XLOOKUP in excel multiple,XLOOKUP to find missing data in 2 columns,compare two columns in excel using XLOOKUP and return a third value,XLOOKUP to compare two lists,compare two columns and find missing values in excel,XLOOKUP to find matches in two sheets,how to compare two excel sheets using XLOOKUP step by step,

Check out my complete suite of Microsoft Excel Tips and Tricks.

https://www.youtube.com/@jjnet247/shorts

https://www.tiktok.com/@exceltips247

https://www.instagram.com/exceltips247/

https://www.dailymotion.com/ExcelTips247

https://www.pinterest.com/ExcelTips247/excel-tips-and-tricks/

https://x.com/ExcelTips247/media

https://www.reddit.com/r/Excel247/

https://www.facebook.com/XyberneticsInc/reels/

#microsoft #excel #exceltips #tips #exceltricks #tricksandtips


r/Excel247 • • 3d ago

Online Table Errors

Post image
1 Upvotes

On excel binary files stored in SP, Anyone here experienced regular and pivot tables asking to be refreshed even thought the raw data is on the sheet beside it? Then it crashes after refreshing.

For other users they can navigate and click on slicers, but for you it will pop up this error every time you reopen the file with a pivot table.

Any one knows the Fix? I already reinstalled my O365 and relogged in after a password change.


r/Excel247 • • 3d ago

Excel fromulas and shortcuts

11 Upvotes

Where can I find all excel formulas with explaintion and shortcuts ?? The best Source easy to go through


r/Excel247 • • 3d ago

Compare two lists to find missing values using VLOOKUP in Excel - Excel Tips and Tricks

80 Upvotes

Discover how you can compare two lists to find missing values using VLOOKUP in Excel.

Essentially using VLOOKUP to compare two columns for matches, or in other words, compare two lists to find missing values using VLOOKUP in excel multiple. Some people like to use VLOOKUP to find missing data in two columns, like I'm demonstrating in this video. Also, they like to compare two columns in excel using VLOOKUP and return a third value. But in a nutshell, I'm using the VLOOKUP to compare two lists. And compare two columns and find missing values in excel.

Ok let answer this question, how to do a VLOOKUP in Excel to find missing data? Or how do you compare two lists in Excel to see if they match? Well.... you came to the right place, and this video explain just that.

How to compare two lists to find missing values WITHOUT FORMULA in excel - Excel Tips and Trick

https://youtube.com/shorts/pJtB8dbbimw?si=iL8qnDJ_WVAhKhAX

Compare two lists to find missing values using XLOOKUP in Excel - Excel Tips and Tricks

https://youtube.com/shorts/nOwMXkZJ5HU?si=N80igNW7Vr-xCK5x

Compare two lists to find missing values using VLOOKUP in Excel - Excel Tips and Tricks

https://youtube.com/shorts/1XGIPzsvS_Y?si=cu3ajNdT3lXFX3LB

How to compare two lists in Excel using Conditional Formatting - Excel Tips and Tricks

https://youtube.com/shorts/GX-BYEgcnRA?si=16oLe6kcxZExM4Df

How to compare two lists to find missing values in excel - Excel Tips and Tricks

https://youtube.com/shorts/dl75Lz_jaPs?si=-UTAvmCRdTl6ZZgm

Excel Tips and Tricks - Compare Two Lists In Excel And Highlight

https://youtube.com/shorts/xJoy-nboV6A?feature=share

Summarize Duplicates in Excel - Excel Tips and Tricks

https://youtube.com/shorts/-IYUTWVmVTU?si=aN-hfbyQD0QEPcgm

Find difference quickly in Excel Comparing 2 List - Excel Tips and Tricks

https://youtube.com/shorts/8_-lN-yKf04?si=itTI-rcCKOaG7zVc

How to do a VLOOKUP in Excel to find missing data?, How do you compare two lists in Excel to see if they match?,

vlookup to compare two columns for matches,compare two lists to find missing values using vlookup in excel multiple,vlookup to find missing data in 2 columns,compare two columns in excel using vlookup and return a third value,vlookup to compare two lists,compare two columns and find missing values in excel,vlookup to find matches in two sheets,how to compare two excel sheets using vlookup step by step,


r/Excel247 • • 3d ago

If someone can Help, i will share my Sheet

14 Upvotes

r/Excel247 • • 4d ago

Get unique mail server domain name with this simple Excel formula - Excel Tips and Tricks

82 Upvotes

Learn how to get the unique mail server domain name with this simple formula.

Essentially this is how you extract domain name from e-mail address in Excel. Or in other words, Split e-mail address in Excel? Some people like to ask how to extract e-mail address from excel column. Or extract domain from e-mail.

If you're using Microsoft 365, there are additional functions available that can further simplify the process of obtaining a unique mail server domain name. Alongside the CONCATENATE function, you can leverage the TEXTAFTER and UNIQUE functions to generate distinct domain names effortlessly.

The TEXTAFTER function allows you to extract specific text after a given delimiter, such as a dot or an underscore, from an existing domain name. This function is particularly useful when you have a list of domain names and want to extract the unique portions to create new combinations. By combining TEXTAFTER with the CONCATENATE function, you can easily merge these extracted elements with other desired prefixes or suffixes to generate unique domain names.

In addition to TEXTAFTER, the UNIQUE function plays a crucial role in ensuring the uniqueness of the domain names. This function eliminates any duplicates from a list of values, allowing you to work with only the unique entries. By applying the UNIQUE function to your list of domain names, you can avoid repetition and ensure that each generated domain name is distinct.

By combining the CONCATENATE function with TEXTAFTER and UNIQUE, Microsoft 365 users have access to a powerful set of tools within Excel. These functions enable the creation of unique mail server domain names swiftly and efficiently, providing a seamless solution for both personal and professional purposes.

Here's the formula that's being used in my video.

Get Mail Server Domain Name

=TEXTAFTER(A2:A205,"@")

Get Unique Mail Server Domain Name

=UNIQUE(TEXTAFTER(A2:A205,"@"))

Now you might ask, why would you want to extract the e-mail domain name? Well, extracting the email domain name from an email address can be useful in various scenarios. Here are a few use cases:

  1. Email marketing segmentation: If you're managing an email marketing campaign, extracting the email domain can help you segment your subscriber list based on domains. This segmentation allows you to target specific domain groups with tailored content or offers. For example, you might want to send different promotions to users with Gmail addresses versus those with Yahoo addresses.

  2. Email filtering and organization: By extracting the email domain, you can set up filters or rules in your email client or server to automatically sort or prioritize incoming emails. For instance, you could create a rule to route emails from a specific domain to a designated folder or apply a specific label.

  3. Data analysis and statistics: Analyzing email domains can provide insights into the distribution and composition of your email contacts. It can help you identify patterns or trends, such as the popularity of certain email providers among your audience. This information can be valuable for market research, customer profiling, or identifying potential target demographics.

  4. Security and fraud detection: Extracting the email domain can aid in identifying suspicious or potentially fraudulent emails. For example, if you notice a high volume of emails originating from unfamiliar or suspicious domains, it may indicate a phishing or scam attempt. By examining the domain names, you can quickly assess the legitimacy of incoming emails.

  5. Troubleshooting and technical support: When assisting users with email-related issues, knowing the email domain can provide useful context. It can help diagnose and troubleshoot problems specific to certain email providers or domains. Additionally, if you're managing a network or system that involves email communications, extracting the domain can help identify potential issues related to specific domains or email servers.

  6. Email deliverability analysis: By analyzing the email domain names of bounced or undeliverable emails, you can identify patterns or trends that might affect your email deliverability. For example, if you notice a high bounce rate from a specific domain, it could indicate a deliverability issue with that domain or potential spam filtering problems.

  7. Partner collaboration: When collaborating with partners or external organizations, knowing the email domain can help you identify and categorize contacts based on the organizations they belong to. This can be particularly useful when managing large-scale partnerships or conducting joint projects where you need to track and communicate with various partners.

  8. Domain-specific email policies: Different email domains may have varying policies or restrictions in place. By extracting the domain names, you can tailor your email communication to adhere to specific domain requirements. This can include adjusting email formatting, optimizing email content for specific email clients, or complying with domain-specific anti-spam guidelines.

  9. Email server management: If you manage an email server or infrastructure, separating email domain names can aid in monitoring and troubleshooting. By examining the domain names of incoming and outgoing emails, you can identify any issues specific to certain domains, such as mail delivery delays, spam complaints, or configuration problems related to particular email providers.

  10. Domain-based email routing: Some organizations or systems implement domain-based routing for email handling. By extracting the email domain names, you can route or redirect emails based on the domain they originate from. This can be useful for managing email flows within complex organizations, forwarding emails to specific departments, or implementing different routing rules for different domains.

get unique mail server domain name with this simple excel formula 365,how to extract domain name from email address in excel,excel extract domain from url,split email address in excel,how to extract email addresses from excel column,extract domain from email,extract name from email address,

Check out my complete suite of Microsoft Excel Tips and Tricks.

https://www.youtube.com/@jjnet247/shorts

https://www.tiktok.com/@exceltips247

https://www.instagram.com/exceltips247/

https://www.dailymotion.com/ExcelTips247

https://www.pinterest.com/ExcelTips247/excel-tips-and-tricks/

https://x.com/ExcelTips247/media

https://www.reddit.com/r/Excel247/

https://www.facebook.com/XyberneticsInc/reels/

#microsoft #excel #exceltips #tips #exceltricks #tricksandtips


r/Excel247 • • 4d ago

How to map Business Requirement Documents (BRDs) directly to Excel Pivot Tables

17 Upvotes

Most tutorials teach Pivot Tables by showing you how to click buttons, drag fields into boxes, and make numbers move. But when you step into a real-world data analysis or BI role, you aren’t given vague prompts like "make a table of sales."

Instead, you get a Business Requirement Document (BRD) from a stakeholder or client asking specific questions (e.g., "What are our top 3 customers by profit?", "What is our year-over-year profit growth percentage?", or "Can we see a running total of sales?").

I put together a complete tutorial breaking down how to bridge the gap between real business requirements and advanced Pivot Table features.

What You'll Learn in the Tutorial

  1. Top N Filtering in Pivot Tables: How to filter for specific ranks (like top 3 customers by profit) using built-in filters instead of manual sorting.

  2. Advanced "Show Values As" Calculations:

    • Calculating % of Column Total for contribution analysis.

    • Computing Running Totals and cumulative aggregates.

    • Doing Year-over-Year (YoY) Difference and % Difference calculations directly inside Pivot Tables.

  3. Custom Calculated Fields: How to build custom metrics on the fly (like Profit Margin = Profit / Sales) without messing up your raw source data.

  4. Structuring Multi-Question Reports: Best practices for layout, groupings, and handling multiple business insights from a single dataset.

If you want to code/practice along with the exact dataset, BRD template, and see all 10+ business questions solved step-by-step (including running totals, calculated fields, and KPI summaries), you can watch the complete walkthrough here:http://www.youtube.com/watch?v=3z2Ozjn3ZK4

Step-by-Step Example: Finding Top 3 Customers by Profit

If a client asks for Top 3 Customers by Profit, here is the exact workflow you use instead of trying to write complex formulas:

  1. Insert the Pivot Table: Select your data range, go to Insert > Pivot Table, and place it on a new worksheet.

  2. Drag Fields:

    • Drag Customer Name into the Rows area.

    • Drag Profit into the Values area.

  3. Apply Top N Filter:

    • Right-click any customer cell in your pivot table.

    • Go to Filter > Top 10...

    • Change 10 to 3, ensure it is filtering by Profit (largest), and click OK.

Boom—you’ve answered a stakeholder's precise business requirement in under 30 seconds with zero manual filtering.

Let me know in the comments if you have questions about specific Pivot Table calculations or how to structure your reports!


r/Excel247 • • 5d ago

Power Query not returning all of the data.

Thumbnail reddit.com
1 Upvotes

Any help would be appreciated. I can add in whatever pictures are needed


r/Excel247 • • 5d ago

How to Calculate Bonus on Salary in Excel - Excel Tips and Tricks

104 Upvotes

Learn how to calculate bonus on salary in Excel. All how to calculate bonus from salary. I will be using bonus multiplier on a calculator in Excel.

These are the steps as featured in a video.

Calculate Bonus (%)

=VLOOKUP(B2,$G$3:$H$24,2,FALSE)

Calculate Total

=C2*(D2+1)

How to Calculate Bonus on Salary in Excel,how to calculate bonus from salary,bonus calculation excel sheet,bonus calculation template,how to calculate bonus using if function in excel,how to calculate bonus for hourly employees,how to calculate 10 bonus in excel,employee bonus tracker spreadsheet,bonus multiplier calculator,

Check out my complete suite of Microsoft Excel Tips and Tricks.

https://www.youtube.com/@jjnet247/shorts

https://www.tiktok.com/@exceltips247

https://www.instagram.com/exceltips247/

https://www.dailymotion.com/ExcelTips247

https://www.pinterest.com/ExcelTips247/excel-tips-and-tricks/

https://x.com/ExcelTips247/media

https://www.reddit.com/r/Excel247/

https://www.facebook.com/XyberneticsInc/reels/

#microsoft #excel #exceltips #tips #exceltricks #tricksandtips