Excel Course

By
Dear Excel Users,

We are offering Basic as well as Advanced Excel course. This course will be conducted online by Microsoft Certified Excel Expert.

To register click on the below link:

For any other details please contact +91 9860735867


Regards,
Excel Tricks with Tejraj

Comments

  1. high technologies solutionsAugust 18, 2021 at 2:03 PM

    You write this post very carefully I think, which is easily understand to me. Not only this, other post is also good. As a newbie this info is really helpful for me. Thanks to you. if you looking for the best Advanced Excel Training Institute in Delhi So Contact Us-9311002620 Or Visit Our Website-https://www.htsindia.com/Courses/Business-Analytics/adv-excel-training-course

    ReplyDelete
    Replies
    1. TejrajAugust 18, 2021 at 11:42 PM

      Glad to hear that you are finding our content helpful..!! Keep reading our newly published posts as well..!!

      Delete
  2. high technologies solutionsAugust 25, 2021 at 5:26 PM

    I really got a good knowledge while reading your blog . your blogs are very usefull. if anyone want to learn Advanced Excel can contact me at 9311002620 or can visit our website https://www.htsindia.com/Courses/Business-Analytics/adv-excel-training-course

    ReplyDelete
    Replies
    1. TejrajAugust 25, 2021 at 9:13 PM

      Glad to hear that you are finding our blog posts useful. Keep reading our newly published posts as well..!!

      Delete
  3. SOL Technologies SolutionsOctober 6, 2021 at 6:14 PM

    Great Work. I always use to follow your valuable contents. Thanks for sharing this kind of knowledge. It is very helpful and very informative and I really learned a lot from it.

    Best Excel and Advanced Excel Training in Delhi with Professional Trainer
    AutoCAD Training Course in Delhi with Fee and Duration
    Tally Course Complete Details – Eligibility, Fees, Job and Salary

    ReplyDelete
    Replies
    1. TejrajOctober 10, 2021 at 12:39 AM

      Thank you for your kind words and following our content. Keep reading our newly published posts as well..!!

      Delete
  4. UnknownDecember 2, 2021 at 9:57 AM

    Great Article Artificial Intelligence Projects

    Project Center in Chennai

    JavaScript Training in Chennai

    JavaScript Training in Chennai Project Centers in Chennai

    ReplyDelete
  5. Zawar kanjuMarch 22, 2022 at 11:22 AM

    Great set of tips from the master himself. Excellent ideas. Thanks for Awesome tips Keep it up
    advanced-xls-converter-crack

    ReplyDelete
    Replies
    1. TejrajApril 6, 2022 at 8:16 PM

      Glad to hear that you are finding our content helpful..!! Keep reading our newly published posts as well..!!

      Delete
  6. TrainYouCan Accredited Training NetworkMarch 30, 2022 at 7:27 PM

    Great job for publishing such a nice article. Your article isn’t only useful but it is additionally really informative. Thank you because you have been willing to share information with us.Moderator course

    ReplyDelete
    Replies
    1. TejrajApril 6, 2022 at 8:19 PM

      Glad tp hear that you are finding our articles useful. Keep reading our newly published blog post every week.

      Delete
  7. High Technologies SolutionsApril 22, 2022 at 3:15 PM

    Thank you for sharing an amazing & wonderful blog. This content is very useful, informative and valuable in order to enhance knowledge. Keep sharing this type of content with us & keep updating us with new blogs. Apart from this, if anyone who wants to join the Advanced Excel Training institute in Delhi, can contact 9311002620 or visit our website-
    https://htsindia.com/Courses/Business-Analytics/adv-excel-training-course

    ReplyDelete
    Replies
    1. TejrajApril 24, 2022 at 4:26 PM

      Glad to hear that you are finding our content helpful..!! Keep reading our newly published posts as well..!!

      Delete
  8. CrackUrl.InfoJuly 30, 2022 at 7:01 PM

    I enjoy visiting this place. Contains valuable information for visitors. Thank you very much!. I enjoy all your posts.They helped me a lot Crackurl.info I hope you have more information Great blog.

    Total Excel Converter Crack

    ReplyDelete
    Replies
    1. TejrajSeptember 1, 2022 at 1:07 PM

      Thank you very much. Please keep on reading our newly updated blog posts as well.

      Delete

Post a Comment

Related Topics..

Fill Up, Down, Right & Left in Excel

By
Image
Excel has many great tricks which can help us to save our time while working on big data. In this blog post we are going to see one of those tricks where we can fill the data to the upwards of the selected cells, to the downwards of the selected cells, to the right of the selected cells and to the left of the selected cells. There are many situations where we may need to copy the data from selected cell to the upward, downward, left and right cells. But how can we do so?? In excel we can do so with the help of “Fill” command. This command we can found in: Home Tab --> Editing Group --> Fill Command. Let’s take an example. We have inserted a text “Tejraj” in a cell “D5”. Now we will see how to fill this text from cell D5 to Up, Down, Right & Left. Fill Down: 1. Let’s assume that we have to fill the data from cells D5 to D10. For this, select the Cell Range D5:D10. Keep in mind that the data from 1st cell of the selected Cell Range will fill down in entire selection. 2. Select ...
Read more

Select all cells highlighted with specific color at a time

By
Image
Many times we apply colors to cells in excel sheet which will help us to identify important cells just by looking at the data. But what if we use multiple colors to highlight data and later on want to select all the cells which are highlighted with specific color only???  YouTube Video: For example, we have listed some values in excel sheet and highlighted few cells with red color and few cells with yellow color. Now, we want to select all cells which are highlighted with only yellow color at a time. But how????  Don't worry... We will provide you a fantastic solution for this!! Follow below steps:  1. Select entire data. 2. Press Ctrl + F. "Find and Replace" window will appear. 3. Click on Options button. 4. "Find and Replace" window will expand with some additional options. Click on Format button. 5. "Find Format" window will appear. Click on Fill tab and select yellow color. You will s...
Read more

Title Bar in Excel

By
Image
Title Bar is the bar holding title of the excel file. But apart from showing title, it also contains many other important functionalities. so let's get familiar with Title Bar in this blog post. Title Bar is divided in 03 parts: 1. Quick Access Toolbar 2. File Name 3. Minimize, Maximize/Restore, Close buttons Let’s see in detail about this. Quick Access Toolbar:  The commands which we are using frequently can be added to Quick Access Toolbar. Following steps will help you to add desired commands here. 1. Right click on the desired command. (In below screenshot we have selected “ Format Painter ” as a desired command) 2. Select option “Add to Quick Access Toolbar”. 3. Now, you will see “ Format Painter ” command is added in the Quick Access Toolbar. 4. To remove desired command from Quick Access Toolbar, just right click on the command and then select option “Remove from Quick Access Toolbar”. 5. No...
Read more

Excel Pivot Table

By
Image
Pivot Table in excel is a very powerful feature which helps us to to organize and summarize the data in very effective manner, that too without using any complex excel formula or functions. In this blog post we will see how to create Pivot Table in Excel. Below is the dummy sales data for last three years (2018, 2019 & 2020). In this sales data employees A, B, C & D sales various electronic components like Resistor, Capacitor, Inductor, Diodes & LED in all South, East, North & West region of India. Creating Pivot Table: Now we will see how to create Pivot Table in Excel. Pivot Table feature is available in Insert Tab. Pivot Table command is available in "Insert Tab" under "Tables Group" as shown in below image. Once you click on Pivot Table command, “Create Pivot Table” dialog box will appear on screen. This is like as shown in below image. This “Create Pivot Table” dialog box is very important to create Pivot Table. There are two important options a...
Read more

Insert Multiple Rows in Excel Based On Cell Value

By
Image
In this blog post we will learn to Insert Multiple Rows in excel based on cell value with the help of VBA Code. For this we have prepared dummy data as shown in below image. In this data we have listed few “Products”, their “Quantities” and their “Unit Price”. Now we want to insert multiple rows based on their “Quantities”. For example, “Product 1” has 04 quantities so we have to add 04 rows below the Product 1, “Product 2” has 02 quantities so we have to add 02 rows below the Product 2 and so on. To avoid wasting our time by manually inserting rows one by one, we can use VBA code which will do our work within seconds. To do this, just follow the below steps: 1. Add “Developer Tab” on the Ribbon if it is not already added. If you are not aware about how to add Developer Tab on the Ribbon then click here . Once added on the Ribbon, “Developer Tab” will looks like as highlighted with red in below image. 2. Now, click on the “Visual Basic” command as highlighted in below image. 3. Once ...
Read more

Name Box in Excel

By
Image
The box which we see on the left side of the Formula Bar is called as “Name Box”. YouTube Video                                                             As name suggests itself, this box shows the name or address of the active cell. For example if we select the cell “B2” with mouse pointer which becomes our active cell is “B2”. This cell address we can see in the Name Box.  One more advantage is that, we can jump to any cell address with the help of this Name Box. For example, if we want go to cell “XFD10” (which is row no: 10 and last column in excel), then just type this cell address in Name Box and press enter key on keyboard. We can see our active cell is now changed to “XFD10”. We can also move quickly on a cell range with the help of this Name Box. For example, if we want to...
Read more

Excel Shortcuts Ctrl A to Ctrl Z

By
Image
Use of keyboard shortcuts while working in excel will be a great help for us. It will save a lot of time. In this post we are going to see Excel Keyboard Shortcuts for alphabets A to Z while using Ctrl key. Below table will give you a brief idea for each shortcut and its functionality: Now, we will see in detail how each of above listed shortcut combinations will work: Ctrl + A :  It will select all content present on the worksheet. If active cell is in the table then it will select entire table. Ctrl + B :  It will convert selected text into Bold . Ctrl + C : It will copy the selected content. The content which is copied can be seen in the Clipboard. Ctrl + D :  It will fill down the content from upper cell. For example we have inserted a number “1” in the cell A1. If we select the cell range from A1:A5 and press Ctrl + D, then this number “1” will automatically fill down in the entire cell range . ...
Read more

Exploring Font Colors and Fill Colors in Excel

By
Image
Many times we use colors in our excel files to make our work attractive. We can apply colors to the texts as well as to the cells.  If we want to change the color of text available in cells then we use the various color options available from “font color” command. Similarly, if we want to change the color of cells itself then we use the various color options available in “fill color” command. But have you ever wondered that what are names of different colors available which we can apply to texts and cells?? YouTube Video In this post we will see details about this.  The color options which are available in “font color” and “fill color” commands are as below: Fill Color: Font Color: If we compare above two images, we can see these color options are categorized into two categories. 1. Theme Colors 2. Standard Colors Theme Colors: There are total 60 different colors available in (06 rows x 10 columns) in Theme Colors category  (These colors w...
Read more

Cell Address and Cell Range in Excel

By
Image
If you are following my blog regularly, then till now you might aware that Cell is an area of intersection of row and column. But do you know how many total cells available in a single excel worksheet?  In the very first topic which I have posted on this blog titled as “ Introduction to Excel ”, I have mentioned that there are 16,384 columns and 10,48,576 rows available in excel sheet. So if we multiply no of columns to the no of rows then we will get the total no of cells. i.e. 16,384 x 10,48,576 = 17,17,98,69,184 cells are available in a single excel sheet. Now, important point to be considered here is that how we will come to know that exactly on which cell we are working? To know this we should be aware of cell address of each cell. This cell address will define exactly on which position we are working. This will help us when we will use various formulas. (We will cover excel formulas in our subsequent blog posts. Stay tuned for this!!!). So let’s see what are the...
Read more

PRODUCT Function in Excel

By
Image
In this blog post we will learn about PRODUCT function in excel. PRODUCT function can be used when we want to multiply multiple values provided in the arguments. Importance of PRODUCT Function? In mathematics, PRODUCT of a number is calculated by multiplying all the input numbers. So in case we want to multiply the numbers then we can use the PRODUCT function. Usage of this function is more effective whenever we want to multiply huge numbers together. Where to find PRODUCT function on Excel Screen: PRODUCT function can be found under “Math & Trig” function category under “Formulas” tab and under “Function Library” group as shown in below image: Once we click on “Math & Trig” function category, we can see list of various Math & Trig functions available in excel. PRODUCT function is highlighted in blue in below image. Once we click on PRODUCT option as highlighted above, we will get the function argument dialog box as shown in below image. Syntax of PRODUCT Function: The Synt...
Read more