24 thoughts on “Microsoft Excel 2007/2010”

1. Krishna Theja March 2, 2014 at 11:58 am

   Hi,

   Thank You very much for all your videos which are very help full.

   As I am taking Excel 2010 Expert certification exam, I need your guidance to clear the exam with 95% of score.
   Please help me in which topics do I need to concentrate more and some tips for clearing the exam.

   Thank You.

   Regards,
   Krishna Theja
   email- krishnatheja.kamadani@gmail.com

   Reply ↓
2. Dragana December 1, 2014 at 2:24 pm

   Dear Amir,

   Thank you so much for the useful videos.
   May I ask several questions that I have trouble with.
   In the video 5, my Special option for entering Phone number in Excel is empty. How can I find it??
   When I use Sort (from A to Z for example), my title is also part of it, how can I exclude my title(Company for example)?
   I use Excel 2007 by the way!
   Thanks again and warm greetings from Macedonia.
   Dragana

   Reply ↓
   1. amir parmar Post authorDecember 1, 2014 at 11:29 pm

      Hi Dragana,
      Glad to know that you found my YouTube tutorials useful in your learning. here are some answers to your questions:
      1. in the Special, look for LOCALE and change it to United states and see what happens.
      2. For the Sorting issues. Highlight your Data and go to INSERT and click on TABLE, in the box make sure to Check “My table has headers.”
      Hope this helps.
      Amir

      Reply ↓
      1. Dragana December 2, 2014 at 5:05 am

         It works, thanks!

         Reply ↓
3. Dragana December 3, 2014 at 3:45 pm

   Hi Amir, it’s me again. I need to ask you, is it possible to find hidden column if I totally close workbook and open it again?
   Thanks,Dragana

   Reply ↓
   1. amir parmar Post authorDecember 3, 2014 at 10:36 pm

      Hi Dragana, if you hide Column C, you will find that it will only show Column A, B & D, this way you will know that column C is hiding. And you can expand column C to unhide it.
      Hope this answers your question.
      Amir

      Reply ↓
4. Paul July 3, 2015 at 2:29 am

   Hie Amir
   I would like to express my gratitude to you. Your video tutorials are very useful and enlightening. May the Lord richly bless you

   Reply ↓
   1. amir parmar Post authorJuly 3, 2015 at 3:49 am

      Thanks for your good wishes Paul. All the Best.
      Amir

      Reply ↓
5. HAKKIM November 3, 2015 at 3:50 pm

   Dear Amir,
   I would like to learn about all Microsoft Office product.So I searched video tutorial and found it yours on youtube, it is very useful for me. and I need to know about what is the usage of Ms office Access?

   Reply ↓
   1. amir parmar Post authorNovember 9, 2015 at 11:31 am

      Watch and understand the video on Relationship to get the benefits of Access. With Excel you cannot create Relationship, so you may need to make changes in multiple places. Here is the benefit of Access, say you have a Saving Account, Checking account, Visa card, Fixed deposit with a Bank. All these data is saved in a different table and they are Related to the table that has the Customer Info. The benefit is, when you change you address, you only have to call once and change the Customer table, no need to call all departments. The other departments are looking at the Customer Table to get up to date info. Hope this helps.

      Reply ↓
6. liaquat usman November 10, 2015 at 12:01 pm

   Wonderful work

   Reply ↓
7. liaquat usman November 10, 2015 at 12:02 pm

   Well done

   Reply ↓
8. Yara April 2, 2016 at 10:31 pm

   Hello Amir,

   Can I watch Microsoft Excel 2007 Exam Test Q & A anywhere else as it is deleted from YouTube.

   Thank you

   Reply ↓
   1. amir parmar Post authorApril 4, 2016 at 5:37 am

      Hi, unfortunately I don’t have the video uploaded anywhere else. Since I received the copyright infringement Take Down notice; I am trying to be figure out where I went wrong. And I don’t plan to have that video up, as the company might take me to court.
      All the best.

      Reply ↓
9. Mohamed Naasar April 12, 2016 at 2:01 pm

   Assalamu Alaikum
   Mr. Amir,
   I’m really enjoyed watching your MS Excel Videos, when I started to watch ur tutorials I had a very basic knowledge in Excel. And Alhamdulillah by the grace of Almighty Allah I learned so many things through your tutorials. Still I’m continuing to improve my Excel knowledge, and hope many more videos from you will make my studies easier. Thanks a lot for.
   Jazzakallahu Khaira.

   Reply ↓
10. Chandra Silva January 25, 2017 at 6:39 pm

    Dear Mr. Amir,

    MS Excel 2007/2010 Videos you have in u tube, can they be used in excel 2013 as well.
    or Do you have videos for excel 2013. This is required to do the keenex prove it test ?
    If you do Can I watch Microsoft Excel 2013 Exam Test Q & A in YouTube.
    Appreciate your advice

    Thanks

    Reply ↓
    1. amir parmar Post authorJanuary 27, 2017 at 8:31 am

       sent you an email. see spam/junk folder if you don’t see it.

       Reply ↓
11. Abdinasir February 21, 2017 at 9:31 am

    Thanks Amir.
    Amir may God bless you. Really appreciating.

    Reply ↓
12. Tyler April 1, 2017 at 1:08 pm

    Hey Amir,

    Quick question I was looking at your you tube channel and couldn’t find the video for pt 1 for (Exam Prep Microsoft Excel 2007/2010). In the past, before taking an excel test I would always review that video to brush up on the basics.

    Is it possible to get a link for that video, or has that video been removed permanently?

    Thank you

    Reply ↓
    1. amir parmar Post authorApril 1, 2017 at 1:39 pm

       I have sent you an email. If you don’t see it, please check your Spam/Junk folder.
       amir

       Reply ↓
       1. Emily April 3, 2018 at 5:51 pm

          Hi Amir,

          Am I able to review this video as well? Your videos have been amazingly helpful for my job applications – thank you 🙂

          Many Thanks,
          Emily

          Reply ↓
          1. amir parmar Post authorApril 3, 2018 at 8:19 pm

             Which video did you want? were you looking for the exam prep video?

             Reply ↓
13. Jayanta dev February 20, 2018 at 1:52 am

    Speechless…….
    What a technique to explain the whole…
    I am beginner but I can say now I know word , Excel and PowerPoint very well only because of you. Everyone can learn from your videos,who have basic ideas of computer.
    I have no more words to thanking you…
    Thanks a lot sir…..

    Reply ↓
    1. amir parmar Post authorFebruary 20, 2018 at 8:49 pm

       Hi Jayanta, very happy to read your comments. I am glad that you found my YouTube tutorials useful in your learning. You have learned well! All the best.
       Amir

       Reply ↓