Untitled @afateamofficial - Tumblr Blog

Creating an Excel file on the system and phone

Excel is another widely used office software that is mostly used for data display, management and analysis. You can use this software for mathematical and statistical calculations, data management and financial balances. In this article, we will teach you how to create an Excel file so that you can create an Excel file.

Recommended reading: Working with the File tab in Excel

Creating an Excel file Note that to create an Excel file, you first need to download and install the Excel software from various sites.

Creating an Excel file One of the easiest and first methods you can use to create an Excel file is to use the system search, which first enters its name and searches for it in your system.

Click on the Excel program in the search results.

Save the Excel file After the program opens, click on the Save option using the Ctrl + S shortcut key or the File tab.

On the page that opens, enter the name of your file in the File name section.

And after selecting the path to your Excel file, click Save to create and save your file.

Creating an Excel file from the desktop Creating an Excel file from the desktop Another way to create an Excel file from the desktop is to first right-click on your files or the desktop.

Click on New in the menus that open.

Select Excel from the options.

Enter the name of your file and click on Enter, and finally, you can open and edit your file by double-clicking.

Creating an Excel file on your phone Creating and editing Excel files on different phones is not possible without software, and you must use different software to create and create Excel files on your phones. The program used in this section of the article to create Excel files is the WPS Office software, which you can install through the Play Store or various other means.

Creating an Excel file on your phone First, enter the software and click on the floating + button on the right and bottom of the image.

Creating an Excel file on Android phones In the opened section, click on Spreadsheet.

Creating a blank page in Excel on your phone In the opened page, click on + to create a blank page for you in Excel.

Saving Excel on Android Your Excel file has been created on the Android system, and just click on the option specified in the image to save the Excel file on your phone.

Saving Excel on Android In the Other location section, select the path to your file.

In the Workbook section, also select your file name.

Finally, click on the Save option to save your Excel file to your phone.

Creating an Excel file on a MacBook On a MacBook, like on Windows, you first need to download and install the Excel software.

Then open Excel.

Select the New Workbook option from the File menu.

Or use templates and save the file (.xlsx format).

Using Google Sheets (online): Another way to create an Excel file on different devices is to use the online Google Sheets site, where you can create and edit your file and finally download the file you want.

How to use:

First, log in to sheets.google.com.

Create a new page. To download in Excel format: File → Download → Microsoft Excel (.xlsx)

آموزش ذخیره و ایجاد فایل اکسل (Excel) در ویندوز، گوشی، مک بوک و استفاده از سایت آنلاین برای ساخت فایل اکسل و ذخیره آن در سیتسم های مختلف

#technology #excel #learning #icdl

Creating a link in Word

Creating links in Word is one of the tasks that you should learn because you can improve the reading experience and help, and sometimes for various reasons you need to create links inside the Word file or other sites. In this article, you will learn how to add links to your Word document with a few simple methods. In addition to creating links in Word, you will learn about various types of internal linking, websites, systems, new Word files, and links to emails step by step and with pictures. Finally, you will learn how to delete links so that the link file in Word is closed forever. You will learn everything you need at the end of this article, so stay tuned.

How to create a link in Word? There are different ways to add a link to Word, and below you will learn about all the methods of creating a link in Word so that you can choose the desired method for adding a link to Word according to your use and needs.

The first way to create a link in Word is to use the Insert menu and the Hyperlink option, which you can add links to your texts.

How to create a link in Word? Before doing anything to create a link, it is better to select the text you want to link. Then enter the Insert menu from the menu above. Click on Hyperlink and enter the link you want in the Address field and finally click on the OK button. Linking text in Word The second and easiest way to create a link in Word is to use a shortcut key, which means that you no longer need to go to the Insert menu.

To use the shortcut key, just select the text you want as in the first figure and then press the shortcut key Ctrl+K to add a link to the text in Word until the Add Link page appears for you as in the second figure. Then enter the link you want in the Address field and finally use the OK button.

Adding a link to Word In the third method, to add a link, select the text you want as in the previous two methods and right-click on the selected text, options will be displayed for you. Just select the Hyperlink option and then enter the desired link in the Address field on the page that opens and finally click on the OK button.

ایجاد لینک در ورد یکی از کاربردی ترین ابزار های ورد است که علاوه بر ساخت لینک با انواع لینک دهی و حذف لینک در ورد به صورت تصویری آشنا می شوی

#technology #icdl #word #news

Installing and adding fonts to Excel

You probably also needed to add your favorite font to Excel at some point or add different Persian fonts that are not included in the default Excel fonts to this program. In this article, we will teach you how to add fonts to Excel so that you can easily add your favorite font to Excel.

Adding Fonts to Excel Font Fonts in Excel First, you must download your font and enter your font folder.

Right-click on your font.

Among the displayed options, to install the Persian font in Excel, just click on the Install option.

Using the Favorite Font in Excel As shown in the image above, the favorite font is installed in Excel and you can search for your favorite font from the Font section and apply it to the desired texts.

فقط در چند ثانیه با استفاده از 2 روش نصب و افزودن فونت اکسل (Excel) فقط با چند کلید را به صورت ساده و تصویری یاد بگیرید!

#technology #icdl #excel

How to install and use a plugin in Word?

Add-ons play a significant role in Office programs, and Word is no exception. By installing and managing Word add-ons, you can add various features that are not available in the normal mode to Word using these add-ons. In the rest of this article, we will learn how to install add-ons in Word and how to use them, which will help you easily install and manage the add-ons you need.

How to install add-ons in Word To install the add-on, go to your Word file.

Go to the Insert tab in Word.

How to install add-ons in Word In the Insert tab, as shown in the image above, click Store to install the add-on in Word.

Popular add-ons in Word You can search for the desired plug-in in the Search section on the opened page. In the second section, the plugins are categorized, and you can choose any of the categories according to your needs, for example, educational plugins. In the third section, which is related to Sort by, you can choose to categorize categories according to scores or suggestions for you. And finally, after selecting the plugin, click on the Add button. Confirm to install the plugin in Word. After clicking on Add, you will be asked to confirm the installation of the plugin. Click on the Continue option to install the desired plugin.

#technology #icdl #word #learning

How to add a new font to Word?

Certainly, one of the most important parts of your Word file is your font files, which, in addition to beauty and readability, play an important role in your files. In some cases, your desired font may not be among the Word fonts. In this article, we will teach you how to add a new font to Word, so you can easily add your desired fonts to Word.

Installing a font in Word First, download the font you want and unzip it if it is compressed.

Installing a font in Word After unzipping, enter the font folder and if the number of your fonts is more than one or two, select all the fonts using the Ctrl + A shortcut keys, and if you only have one font, select it and right-click on it.

In the window that opens, click Install to install your font or fonts on the system and Office software, especially Word.

آموزش کامل افزودن فونت جدید به ورد با استفاده از دو روش در ویندوز های مختلف و حذف نصب فونت در ورد + آموزش تصویری نصب و حذف فونت در ورد

#technology #news #icdl #learning

Persianizing numbers in Word

In the continuation of the zero to hundred Word tutorial, most users face the problem of numbers being in English in Word, even if the language is Persian. In this tutorial, we will discuss various methods of Persianizing numbers in Word to solve this problem, so stay with us until the end of this article.

There are permanent methods for Persianizing numbers. You can use the option you apply to display all numbers after applying Persian settings, or in another method, you can convert only the numbers in the current document to Persian.

Persianizing numbers in Word (permanent) The first method for Persianizing numbers in Word is to use Word settings.

File section in Word To Persianize numbers in Word, first enter the File tab in Word.

Options in Word Select the Options option in the File tab.

Advanced in Word Select the Advanced option on the page that opens.

Converting numbers to Persian in Word Arabic (0, 1, 2, …) Always displays numbers in Persian/Arabic (Hindi), even if the text language is English. Suitable for Persian texts. Hindi (0, 1, 2, …) It works exactly like Arabic and displays numbers in Persian. In some versions of Word, this option may be displayed as Arabic. System (1, 2, 3, …) It displays numbers according to the operating system settings. If your system is in Persian, Persian numbers are displayed and if it is English, English numbers are displayed. Context (depends on the context) It works intelligently: if the text is Persian/Arabic, it displays numbers in Persian (123) and if the text is English/Latin, it displays numbers in English (123). Scroll down the Advanced section and find the Numeral option and select the ConText option and finally click the Ok button to apply your changes.

By setting the Context option, if your keyboard language is Persian, numbers will also be written and displayed in Persian.

آموزش تصویری فارسی کردن اعداد در ورد و فارسی کردن اعداد انگلیسی در Word فقط در کسری از ثانیه به همراه آموزش تصویری به صورت رایگان

#icdl #word #learning #technology

Add stamp and signature to Word

Did you know that you can easily add your signatures to Word in different ways? This will help you add a signature or stamp to your Word documents with a simple click, and in this article, we will explore the different methods for adding a signature in Word, so stay with us until the end of this article.

Adding a Signature to Word via Picture Adding a Signature to Word via Picture One of the best and easiest ways to add a signature to Word is via a picture. To do this, first enter the Insert tab in Word.

Click on the Pictures option in the Word tab.

Find your signature and click on Insert by selecting the picture to add to your file.

Adding a Signature in Word Finally, your signature will be added to the document, and to adjust it, just adjust your signature through the position and other various tools. For more information, you can also read the article Adding a Picture to Word in the System and Phone.

Adding a signature place in Word Adding a signature place in Word Another way to add a signature in Word is to use Word's own features, using this section you can add a signature line to your Word, which you will learn more about later.

To do this, first enter the Insert tab in Word.

Select the Signature Line option.

In the box that opens, first enter the first and last name, in the third box the person's position, in the third box the email of the person in question, and finally, if additional explanations are needed, add them, and finally click the Ok button.

Signature place The signature place has been added, and to add the signature itself, first click on the signature place.

Adding a signature instead of a signature in Word On the page that opens, select your signature through Select image and click on Sign to add your signature.

Adding and saving stamps and signatures in Word Adding stamps and signatures in Word In this method, you must first add the signature or stamp you want to your file.

Select your stamp or signature.

Go to the Insert tab and select the Quick Parts option.

In this section, first select Auto Text.

Click on the Save Selection to AutoText Gallery option

Save the stamp in Word In the opened section, select a name for your signature or stamp and click on Ok.

Save the signature in Word Now, according to the above path, you can add a stamp or signature to Word every time using the Auto Text section, which has the feature that you can easily add the saved stamp or signature to Word in other files with one click and you do not have to add it through different methods each time.

Final Words In various jobs, documents and files usually include seals or signatures. As someone who deals with Word, you should know how to add seals and signatures in Word. In this article, we examined different methods for adding a signature in Word. In the first method, you can add the desired signature or seal to Word by adding a photo. Then, you learned how to add a signature placeholder in Word. Finally, we examined how to save seals and signatures in Word. By saving the signature, you no longer need to add the signature again in each file. With one click, you can add the desired seal or signature to your file.

Do you know of another method for adding a signature to Word?

آموزش 3 روش ساده برای ذخیره و افزودن مهر و امضا (Signature) به ورد (Word) و افزودن جای امضا و اثر انگشت در ورد + آموزش تصویری

#technology #icdl #word

Changing page size in Word

In some cases, such as sending a file for printing or printing and other cases, due to the problem of page size, the files are printed out untidy or messy, or in cases where you need to make changes, you will learn how to change the page size in Word at the end of this article.

The international standard for official documents is A4, which can vary in different cases, and sometimes you need to use different sizes for different purposes, such as printing brochures, posters, or different documents. In addition to learning how to change the size of Word pages and changing the default page size, you will also be provided with a table of A and B series page sizes so that you can adjust the size of your pages in Word files based on your needs.

Read more: Creating a Word file

Changing the size of pages in Word The size of Word pages is usually set to A4 by default, and to change the size of pages in Word, follow the steps below.

Changing the size of pages in Word First, enter the file you want. Enter the Layout tab and select the Size option from the Page Setup section. As you can see in the image below, the most commonly used page sizes along with their sizes are A4, A3 and A2, which are most commonly used. Depending on your needs, you can choose the option you want. Changing the page size to A4 But in some cases, the size you want may not be among the options. Now what is the solution? If the size you want is not among the options, click on More Paper Sizes in the last page list.

Choosing the desired page size in Word In the opened page, you can enter your desired width and height and then click on the Ok button. Also note this point.

Changing the default size of Word pages In some cases, you want the set size or one of the sizes, for example A4, to be applied to files forever and not set every time you enter your files. For this, you need to change the default size of your pages.

Change the default page size in Word: To do this, go to the More Paper Sizes section from the Size menu, and on the page that opens, you can select the desired page from the Page Size section, or select your default page through Width and Height, and finally click Set As Default to change your default pages to the size you want.

آموزش تغییر سایز صفحات در ورد (Word) و تغییر اندازه پیش فرض برگه های ورد به همراه راهنمای اندازه برگه های سری A و B + {آموزش تصویری}

#word #icdl #learning #technology

Creating various types of Word pages

Hello, Afateam users, we are at your service with the second part of the zero to one hundred Word tutorial by creating different types of pages in Word and explanations of the Word File section.

In the first part of the tutorial, we discussed how to create a Word file in two ways in video and image format, where you will see the tutorial on creating a Word file, and then in this article I intend to teach you how to create different types of pages.

In the following Microsoft Word tutorials, you will learn how to create different types of pages and use ready-made Word templates so that if you need to design pages, you can use ready-made Word pages to save time and use professional and standard formats.

Creating different types of pages in Word: To create different types of Word pages, first create a Word file and enter it.

Click on the file tab in Word Like the image above, click on the File tab.

The File tab in Word After clicking on the file tab, the image above will appear for you to click on New.

Ready-made Word file templates In the image above, you can see the ready-made templates and click on any one you like according to your needs.

Selecting a ready-made template in Word After selecting the desired file, it will provide you with an explanation about the selected file and display the size of the template at the bottom. If confirmed, click Create to display the selected template on your file.

Edit a ready-made Word template The selected template will be loaded for you and you can completely edit all parts of the template.

Different and default Word templates: Ready-made Word file templates Well, as we explained at the beginning of the tutorial, Word shows us these 10 templates by default, which will be loaded as a default Blank document for you without selection.

Blank document: Well, this is the Blank document template that comes up by default in Word on this page.

This template does not have many options and you can design it yourself according to your creativity.

Blue grey resume: The Blue grey resume template is a very beautiful and designed template for your resume and records.

Well, by watching this video, you have generally understood the use of the Blue grey resume template.

You can customize the template with your own creativity and use it.

For example, instead of NAME HERE, write your name and replace your photo with your photo.

snapshot calendar: This default template (snapshot calendar) is also made for a calendar, as its name suggests.

You can write and save your monthly plans in this template.

View more pages: In the templates section, you can view and select more templates in two ways, the first method is to use the search section, which you can search according to your needs.

In the second method, there are categories for different jobs at the bottom of the search section, which you can click on different categories to view templates specific to that field.

Recommended Reading: Creating a Table in Word

Concluding Remarks By using ready-made pages and various Word templates, you can use more professional formats for designing pages, or you can make changes to the pages by selecting default templates and ultimately choose professional and standard files for different jobs.

#technology #word #learning #icdl

Remove extra spaces in Word

Extra spaces in Word files cause irregular appearance and reduce readability in your documents. If you are also facing the problem of removing extra spaces in Word, join Afatim to explore various methods for removing extra spaces in Word. In the meantime, don't miss the free training from zero to one hundred words.

What are the causes of extra spaces in Word? The cause of extra spaces in Word can have various reasons, such as:

Paragraph settings: The space before and after paragraphs can cause extra spaces. Empty space: The presence of empty space or "Empty Paragraph" can cause extra spaces. Line spacing settings: If the space between lines is set too high, it can appear that there are extra spaces. Removing Extra Spaces in Word with Different Methods There are different methods to remove extra spaces in Word, whether for paragraphs or text. After reviewing these methods, you can design your Word files more professionally and regularly as quickly as possible.

Removing Extra Spaces in Word Text

To remove extra spaces between words in Word, simply press the Ctrl + H shortcut key or select the Replace option from the Home tab, and in the Fine section, enter the phrase w^ and in the Replace section, a space, and finally click the Replace All button to remove all spaces between texts, which is one of the easiest ways to remove extra spaces in Word.

Another method to remove extra spaces between paragraphs and texts is the same as the method above, but instead of the phrase w^, enter the phrase p^p^ and in the Replace section, enter the phrase p^ to remove extra spaces.

If you have trouble learning how to work with the Home tab in Word, you can learn the full tutorial of this section by reading this article.

Another way to remove spaces is manually, which you can do by detecting extra spaces using the Backspace key.

Detecting extra spaces in Word Detecting extra spaces in Word To find extra spaces in Word, as shown in the image above, first click on the option drawn with an arrow from the Home tab to display the spaces between text with . and the spaces between paragraphs with its symbol.

Final words Removing extra spaces in Word creates beauty and better readability in the texts of your Word file. In just a few seconds, using different methods, you can design your Word files in a professional and user-friendly way, which in addition to increasing the quality of your Word file, makes your files more professional.

Which method do you think is more user-friendly and easier to use for removing extra spaces in Word?

آموزش حذف فاصله های اضافی در ورد در بین پاراگراف ها و مابین متن ها با 3 روش مختلف و آسان به صورت رایگان [ نحوه تشخیص فاصله های اضافی در ورد]

#technology #learning #icdl #news

Trending Blogs

Recently Viewed Blogs

Untitled