r/Excel247 • • Aug 25 '26

برنامج إكسل Excel

Post image
0 Upvotes

Excel is the most important computer program that helps organize your daily tasks.


r/Excel247 • • Mar 25 '26

Excel Tips and Tricks - Three Way To use Excel... and 2 Are FREE

0 Upvotes

How To Use Excel Online For Free

Learn how to use Excel online for free, and share the Excel sheets or workbook with your friends and colleagues.

Essentially there are three ways to use Excel, and the two ways are FREE.

  1. Microsoft Excel Application

  2. Office 365.

    a) Enter the following URL.

excel.new

b) You will need a Microsoft account (Hotmail) to access Excel.

b) You can share with everyone.

3) Google sheets.

a) Enter the following URL.

sheets.google.com

b) You will need Google account (Gmail) to access Google sheet.

c) You can share with everyone.

how to use excel free in windows 10,microsoft excel free download,excel online free,excel online,free word online,free microsoft word,office online,microsoft office,

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 • • Mar 13 '26

Your Data Looks BORING—Do THIS Instead! (In-Cell Bars in Excel)

2 Upvotes

Your Data Looks BORING—Do THIS Instead...In-Cell Bars in Excel.

The Excel REPT function repeats a given characters for a user specified number of times. For example, =REPT("x",5) returns "xxxxx".

Use the Windows character map hexadecimal number to show in cell.

=REPT(CHAR(HEX2DEC("CB")),C3)

=REPT(CHAR(HEX2DEC("75")),C3)

=REPT(CHAR(HEX2DEC("53")),C3)

After watching his video, you should be able to answer the following questions.

How do I create a chart in a cell in Excel?

What is a chart within a cell called?

How do you make a bar graph within a cell in Excel?

How do I graph specific cells in Excel?

How do I create a chart in a cell in Excel?,What is a chart within a cell called?,How do you make a bar graph within a cell in Excel?,How do I graph specific cells 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 • • Mar 21 '26

Installing Barcode Font For Word And Excel

2 Upvotes

Learn how to install barcode font for Word and Excel.

There are two ways to install fonts on your Microsoft Windows, but the one I am demonstrating in this video is the simplest.

How do I download a barcode font in Word?

  1. Search for "download fonts" in Google.

  2. Download font from web site. I download mine from dafont.com

  3. Search for the font you want and download it.

  4. Unzip the downloaded file.

  5. double click on the .ttf file.

  6. Click on install button (on the top left hand side of the popup window).

  7. Start using the new font in Microsoft Word. You do not need to restart your Microsoft Word.

How do I download a barcode font in Excel?

  1. Search for "download fonts" in Google.

  2. Download font from web site. I download mine from dafont.com

  3. Search for the font you want and download it.

  4. Unzip the downloaded file.

  5. double click on the .ttf file.

  6. Click on install button (on the top left hand side of the popup window).

  7. Start using the new font in Microsoft Word. You do not need to restart your Microsoft Word.

Where can I get a barcode font?

I get mine from dafont.com

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

barcode font download,how to install barcode font in excel,download barcode font for excel,install barcode font windows 10,barcode font for windows 10,code 39 barcode font for excel,code 39 barcode font for excel free download,how to install 3 of 9 barcode font windows 10,

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 • • Mar 29 '26

How to Enable or Disable Mini Toolbar in Excel

1 Upvotes

r/Excel247 • • Feb 02 '26

Day 10/30 sort in excel

1 Upvotes

I'm sorry I forgot to highlight the column after sort


r/Excel247 • • Aug 31 '26

Learn excel baigner

1 Upvotes

Dear team

I want to learn excel and and SQL for carrier change but stock from where to start how i should start

Any advice I'm ready to hear it all


r/Excel247 • • Sep 27 '26

Built a personal finance dashboard in Excel — what would you improve?

0 Upvotes

I’ve been working on a personal finance dashboard in Excel and would love some feedback from other Excel users.

The workbook currently includes:

• Income & expense tracking
• Monthly budget planning
• Bills & subscriptions
• EMI/debt tracking
• Investment tracking
• Savings goals
• Net worth tracking
• Cash-flow analysis
• Annual financial summary
• Dashboard with charts and KPIs

I’m particularly interested in improving the Excel structure, formulas, dashboard layout and usability.

If you were using this workbook yourself:

What feature would you add?
What would you remove or simplify?
What would you change about the dashboard?

I’m still refining it, so honest feedback is welcome.


r/Excel247 • • Mar 20 '26

Excel Tips and Tricks - Excel Shortcut to Repeat Your Last Action

6 Upvotes

Here is how you can repeater your last action in Microsoft Excel.

Excel will simply repeat your last operation if you simply click the F4 key on your keyboard. This shortcut can save you a tonne of time, especially if the work at hand involves a lot of repetition. Therefore, the next time you find yourself performing the same action in Microsoft Excel repeatedly, try using the F4 shortcut to save time.

How do I make F4 repeat in Excel?

Press the F4 key on your keyboard.

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

excel f4 repeat not working,excel repeat last action shortcut,how to repeat a set of actions in excel,repeat last action excel mac,repeat function in excel shortcut,shortcut key to repeat the last action,repeat last action word,excel repeat formula,

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 • • Mar 17 '26

Excel Tips and Tricks - How to filter data with pictures?

10 Upvotes

How to filter data with pictures - Excel Tips and Tricks

Learn how to filter data with pictures in Excel.

In our daily work with Microsoft Excel, we typically filter data based on particular criteria to only display the data we want. However, if there are images/pictures present alongside the values, Microsoft Excel's filter function will only remove the images from the data. This video, I will explains how to use Microsoft Excel's combined picture and data filtering feature.

  1. Select any of the pictures.

  2. Ctrl + A

  3. Right-click on any picture.

  4. Select Format Object.

  5. Select Size and Properties

  6. Expand Properties

  7. Select Move and size with cells.

*** Pokemon data From this webpage ***

https://bulbapedia.bulbagarden.net/wiki/List_of_Pok%C3%A9mon_by_base_stats_(Generation_VIII-present)

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

excel images not sorting,select all pictures in excel,how to lock images in excel when filtering,multiple picture lookup in excel,how to filter images in excel,excel image function,how to sort images in excel,how to unlock picture 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 • • Sep 09 '26

How can I get the latest Excel version for free?

4 Upvotes

Hi everyone,

I currently have an older version of Microsoft Excel on my PC, and I want to use a newer version — preferably Excel 2021 or the latest version.

I’ve watched many YouTube videos showing ways to download/install newer Excel versions for free, but most of them either stop working after a few days/months or eventually ask for a product key/activation.

So what is the safest way to use a newer version of Excel for free?

I’m mainly looking for a free option, not something that will suddenly stop working or ask for activation later.

One more concern: I currently have an older Excel installed. If I uninstall it and install a newer version, and then the new one doesn’t work, I’ll be stuck without Excel.

Is there any way to:

  • Install/test the newer Excel without losing my current version?

  • Keep a backup of my existing Excel so I can restore it if needed?

  • Or use the latest Excel for free without constantly needing a product key?

Any suggestions from people who have actually done this would be really helpful.

Thanks, friends!


r/Excel247 • • Mar 29 '26

Merging Columns in Multiple Sets of Rows at Once - Excel Tips and Tricks

7 Upvotes

Learn how to merge columns in multiple sets of rows at once.

To merge columns in Excel for multiple rows, select the cells you want to merge, then use the "Merge & Center" option in the Home tab. If you want to merge two columns while keeping rows intact, you can combine their contents using symbols like "&" or CONCATENATE. For consolidating data from various rows and columns, consider combining cells vertically or horizontally depending on your data arrangement. If you need to merge multiple rows into one column, utilize the same merging techniques vertically.

At the end of the video you will be able to answer these question.

How to merge columns in Excel for multiple rows?

How do I merge two columns in Excel but keep rows?

How do I consolidate data from multiple rows and columns in Excel?

How to merge multiple rows in one column?

Combine Multiple Row Matching Values in One Cell,multiple rows into one row excel,combine multiple rows into one row excel,merge rows in excel,how to merge rows in excel without losing data,how to merge rows in excel,how to merge two rows in excel,concatenate multiple rows into one cell excel,how to concatenate multiple rows in excel,how to merge rows in excel with same value,how to merge rows in excel mac,

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 • • Mar 14 '26

EASY Trick - Delete All Blank Rows - Excel Tips and Tricks

14 Upvotes

Discover how you can delete all blank rows with a simple clicks.

If you have many blank rows in between your table, there is a more productive way to delete them altogether.

Here are the steps.

Deleting All Blank Rows

  1. Ctrl + G

  2. "Special" button

  3. Select "Blank"

  4. Ok

  5. Ctrl + - (minus)

  6. Select "Entire Row"

  7. Ok

After the video you should be able to answered the following questions.

Can you Delete blank rows in Excel all at once?

How do I Delete millions of blank rows in Excel?

What is the shortcut to delete all blank rows in Excel?

How do I Delete thousands of rows in Excel?

Can you Delete blank rows in Excel all at once?,How do I Delete millions of blank rows in Excel?,What is the shortcut to delete all blank rows in Excel?,How do I Delete thousands of rows in Excel?,blank, rows, blank rows, delete blank rows, Go to, entire row,

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

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 • • Mar 18 '26

How To Create Dynamic Numbering List - Excel Tips and Tricks

5 Upvotes

Here is the Microsoft Excel macro that was used in this video.

="Num " & SEQUENCE(COUNTA(B2:B21))

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

How To Create Dynamic Numbering List, dynamic, numbering, list, sequence,

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 • • Mar 27 '26

Insert Blank Space Between Rows - Excel Tips and Tricks

9 Upvotes

Learn how to insert blanks space between rows fast!!

Here are the steps highlighted in the video.

  1. Enter 1 and 2 on the first two records.

  2. Populate the entire column with

    sequential numbers.

  3. Ctrl + C

  4. Select last cell

  5. Ctrl + V

  6. Data -- Filter

  7. Sort Smallest to Largest

🔗🔗 LINKS TO SIMILIAR VIDEOS 🔗🔗

Insert Blank Space Between Rows FAST!! - Excel Tips and Tricks

https://youtube.com/shorts/37i6EDBfGHI?si=uoMiIVlwltH1tObQ

Insert a blank row after every row or every Nth row - Excel Tips and Tricks

https://youtube.com/shorts/mY9_1mbL4hQ?si=b8ioiCkGm3kpZIV1

how to insert blank rows in excel automatically,excel formula insert row if,how to insert a row within a cell in excel,insert blank rows in excel shortcut,how to insert blank row after every row in excel,how to insert row after specific text in excel,how to insert a cell within a cell 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 • • Mar 19 '26

Fill Blanks In Excel - Excel Tips and Tricks

7 Upvotes

Fill Blanks In Excel - Excel Tips and Tricks

Here is how you can fill out blanks in Microsoft Excel using some simple key strokes.

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

Fill Blanks In Excel, blanks,how to fill blanks in excel with value above,how to fill blank cells with 0 in excel,how to fill blank cells in excel with go to special,how to fill blank cells with value above in excel shortcut,how to fill blank cells with value above in google sheets,excel fill blank cells with text,how to select empty cells in excel,excel fill blank cells with dash,

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 • • 27d ago

5 simple tricks I use to clean messy data fast

Thumbnail reddit.com
0 Upvotes

r/Excel247 • • Oct 11 '26

What's one Excel trick you wish you'd learned earlier?

0 Upvotes

I've been learning Excel and practicing different formulas, shortcuts, and data-cleaning techniques.

One thing I've realized is that you don't need to know every Excel feature to be productive. Sometimes, learning one small trick can save you hours of repetitive work.

For example:

- "XLOOKUP" to find data quickly

- "SUMIFS" to calculate totals based on multiple conditions

- "Pivot Tables" to summarize large datasets

- "Ctrl + Shift + L" to enable filters instantly

- "IFERROR" to handle formula errors cleanly

I'm curious about three things:

  1. What's your most-used Excel formula or shortcut?

  2. What's the most annoying task you still do manually in Excel?

  3. If you could automate one Excel task forever, what would it be?

I'm especially interested in practical tips that save time in real-world work, not just tricks that look impressive in tutorials.

Let's build a useful list of Excel tips that everyone can learn from. 👇


r/Excel247 • • Jul 29 '26

Split Cell Contents by Space, Comma, Line Break, or Other Delimiters in Excel

Thumbnail reddit.com
0 Upvotes

r/Excel247 • • Sep 26 '25

Loan repayment Excel with fixed installments

1 Upvotes

I want to create an Excel repayment schedule where a client will take a loan, and the loan will have the following characteristics:

  • Fixed installations (P+I)

  • Quarterly payments

  • Tenor: 7 Years

  • Amount: USD 7Mio

My problem is that the client wants variable rates, for example SOFR 3 Months + 5%. How would I keep the installments fixed if SOFR changes on daily basis. My understanding is that if SOFR increases, installments will increase, right?


r/Excel247 • • Feb 21 '25

One-Time-Password (OTP) in Excel- Excel Tips and Tricks

0 Upvotes

r/Excel247 • • Sep 17 '26

¿Cómo activar las macros en Excel? | Tutorial rápido ⚙️ #aprenderexcel #...

Thumbnail
youtube.com
0 Upvotes