Mike's Office
Mike's Office
  • Видео 134
  • Просмотров 2 639 782
Create a status bar in Excel with formulas!
You can do a lot with conditional formatting, but did you know you can create a growing status bar with it as well. In this video, we'll go over two ways that you can you conditional formatting formulas to enhance the look of your worksheets!
Просмотров: 6 968

Видео

Convert Word to PDF from Laptop
Просмотров 17 тыс.Год назад
Turn any Word document into a PDF file in two ways! You don't need to pay for an adobe subscription or download a converter from a suspicious website. Just use one of these two features in Microsoft Word to get the job done.
This Excel practice exam was saved by....
Просмотров 11 тыс.Год назад
This Excel practice exam will show you how to alter text, colours, and add data tables to your charts.
Import Data from your cell to Excel!
Просмотров 5 тыс.Год назад
Take a picture of data and import it to Excel. Does it actually work? I tested out a hand drawn table to see if it would...
Secret Excel Exam Project 3 (auto gallery)
Просмотров 4,6 тыс.Год назад
This Excel practice exam will show you how to add alt text to graphs and tables, how to use the IF function and how to print certain sections of an Excel worksheet!
Easily Share a Word doc like a Google Doc
Просмотров 6 тыс.Год назад
You can now share a Word document and edit it in real time with other people just like you could a Google Doc, but is it really the same? In this video I'll show you how you can share a word document and start working on it with other people in real time.
Excel Exam Secrets (Part 2) from a Canadian
Просмотров 6 тыс.Год назад
Someone tried to ban you from seeing these Excel practice skills and tricks. This is the second Excel project in our secret Excel practice exam series. Do you want to ensure that you get the highest mark possible? Check out my Excel Exam prep course on Udemy to guarantee your success! : www.udemy.com/course/mo-200-microsoft-excel-3652019-associate-certification/?couponCode=7B60D4DCB584F3F1F42B ...
Align Text the right way with Tab Stops
Просмотров 4 тыс.Год назад
Learn how to properly insert tab stops in Microsoft Word. In this video, you'll learn the two main methods for adding tab stops in Word, including the easiest method that very few Word users are aware of because there is a Word feature that is hidden to most users.
Can YOU pass this secret Excel exam?
Просмотров 7 тыс.Год назад
This Excel practice exam was banned but with a lot of hard work, we have it back! This is the first project of 6 that can help you pass an Excel interview test, or even the official Excel Microsoft Office Specialist exam! Timestamps: 0:00 Intro 0:12 Navigate to a name range 0:57 Decrease decimals number formatting 1:35 Delete a TABLE row not a worksheet row! 2:13 Average function 3:30 Concat Fu...
Working with Word Tables
Просмотров 646Год назад
Working with Word Tables should be easy! It just takes three steps, 1. Create a table, 2. fill in the information in the table, and lastly, formatting the table. But, we also take a look at how to add formulas to a table, how to merge rows, and how to create a heading row in this tutorial!
Insert Citations and Bibliography Quickly!
Просмотров 1,6 тыс.Год назад
Learn how to insert citations and bibliography quickly in Microsoft Word.
Outlook Signature setup with Logo (The Easiest Way)
Просмотров 21 тыс.Год назад
Adding a logo to your Outlook Email signature can be challenging. Luckily we can create a professional email signature with Google Docs, then transfer it to our Microsoft Outlook signature block.
Creating A Table Of Contents In Word
Просмотров 1,7 тыс.Год назад
Creating a table of contents in Word, when done right, can help you easily navigate through any document. But there are a few challenges that come up when you try to create, edit, or update it. We're going to solve these challenges and create an error-free, yet stylish-looking table of contents in Word!
Design a newsletter in Word
Просмотров 1,4 тыс.Год назад
This Microsoft Word tutorial will help with your Newsletter design! We will take a plain document and in just under 20 minutes, turn it into a well-polished Newsletter by using a ton of useful Microsoft Word features such as Drop caps, columns, section breaks, and more! Time Stamps: 0:00 Hockey Intro 0:36 Insert Section breaks 2:54 Format a newsletter with margins! 4:50 Insert Textboxes in Word...
Custom Headers and Footer in Microsoft Word
Просмотров 16 тыс.Год назад
I'll show you how to make a better letter head design in the headers and footers sections of your Microsoft Word document.
How to Set Page Margins for Different Types of Documents
Просмотров 9 тыс.Год назад
How to Set Page Margins for Different Types of Documents
How to Make a Goal Thermometer in Excel (step by step)
Просмотров 25 тыс.Год назад
How to Make a Goal Thermometer in Excel (step by step)
START using mail merge with these 7 steps!
Просмотров 2,6 тыс.Год назад
START using mail merge with these 7 steps!
How to insert page number in Word
Просмотров 93 тыс.Год назад
How to insert page number in Word
Don't FAIL your next Excel Exam! Watch this instead...
Просмотров 86 тыс.Год назад
Don't FAIL your next Excel Exam! Watch this instead...
Flip ONE page horizontally (Landscape) in Word!
Просмотров 9 тыс.2 года назад
Flip ONE page horizontally (Landscape) in Word!
Use the IF function to make better choices (7 examples)
Просмотров 3,8 тыс.2 года назад
Use the IF function to make better choices (7 examples)
I help people stand out with MOS exams; Here's why! (Funny story)
Просмотров 2,2 тыс.2 года назад
I help people stand out with MOS exams; Here's why! (Funny story)
Plan Events in Microsoft Outlook!
Просмотров 1,5 тыс.2 года назад
Plan Events in Microsoft Outlook!
How this channel can help YOU!
Просмотров 8 тыс.2 года назад
How this channel can help YOU!
Manage Your Inbox with these 7 Easy Outlook Features!
Просмотров 2,4 тыс.2 года назад
Manage Your Inbox with these 7 Easy Outlook Features!
Save time inserting lines in Word with these keyboard shortcuts!
Просмотров 17 тыс.2 года назад
Save time inserting lines in Word with these keyboard shortcuts!
Create Outlook out of office replies (Desktop and Web based)
Просмотров 1,7 тыс.2 года назад
Create Outlook out of office replies (Desktop and Web based)
Microsoft Excel certification exam part 2
Просмотров 66 тыс.2 года назад
Microsoft Excel certification exam part 2
Microsoft Excel certification exam (Part 1)
Просмотров 203 тыс.2 года назад
Microsoft Excel certification exam (Part 1)

Комментарии

  • @talentedidiot
    @talentedidiot 3 дня назад

    THANK YOU. I STUDIED LAST MINUTE AND GOT 950/1000 thank you for the amazing tutorial, I would have gotten my certificate without this 🥹🥹

  • @JamalsPookiedookibear
    @JamalsPookiedookibear 3 дня назад

    Hey, just want to say as of today I am Microsoft certified (basic IBCA)

  • @Swizzletwice
    @Swizzletwice 3 дня назад

    Excellent presentation. Organized, to the point, and great personality. Thank you.

  • @Swizzletwice
    @Swizzletwice 3 дня назад

    Excellent presentation. Well-organized, well-taught, and great personality. Thank you.

  • @Swizzletwice
    @Swizzletwice 3 дня назад

    I really liked your video. It's well-planned and organized, and you have a great teaching style. I'm wondering if one of your answers might be marked incorrect on the test. At the 11:28 mark in the video, Player Stats Task 3 says to add a total row and configure the row to display the total goals each month. Your answer added the total row, but configured it to display a single total for all months. I'm wondering if the second half of your answer would be marked incorrect. The word "each" seems to imply a separate total for each month. I don't know how literally one needs to read the questions.

  • @zanderalberto3576
    @zanderalberto3576 4 дня назад

    20m time lmit for 35 questions though

  • @taharana5859
    @taharana5859 4 дня назад

    Punjab college se kon hai❤

  • @treshawnisiaah7540
    @treshawnisiaah7540 5 дней назад

    OMG THANK YOU I PASSED IT

  • @righteyedguitarist426
    @righteyedguitarist426 5 дней назад

    My friend got a 93/1000 the first time he took this 💀

  • @alekseyvalentinov9361
    @alekseyvalentinov9361 5 дней назад

    Lmao dude has his pronouns in the signature XD. Pathetic

  • @raniajan4912
    @raniajan4912 6 дней назад

    Mike, you are the best! I just passed my Excel Certification Thank you sooooo much for your help.🙏

  • @fatibenkhaled7343
    @fatibenkhaled7343 7 дней назад

    Thank you.took the exam yesterday and I passed. Thank you for all the videos .

  • @MaksNikolaevich-yt9gx
    @MaksNikolaevich-yt9gx 8 дней назад

    Hi guys! How are you have got additional feature like <<Table design>>, <<Layout>>,<<Developer>>,<<EndNote X7>>?? In my Microsoft Word 2019, I have not these option. How can I get it?

  • @CaliGirly12
    @CaliGirly12 8 дней назад

    Is this still valid?

  • @raniajan4912
    @raniajan4912 9 дней назад

    I passed the MOS Word Certification exam with a score of 975 just a few weeks ago Thank you so much, Mike. 🙏Your video is very , very helpful , and now I am going to take the Excel, I hope I will pass

  • @pumpkinman9341
    @pumpkinman9341 9 дней назад

    Why do half of the comments start with “hi mike” litteral npc’s in the comments Still good vid tho very helpful thx.

  • @user-fq2nx6yr3h
    @user-fq2nx6yr3h 10 дней назад

    I am forced to comment again today immediately after my MO-100 Word 2019 certiport exam. I watched the training videos posted in this channel this morning, and attended the certiport exam in the evening. To my surprise, I got 4 - 5 questions which were same as I watched in these videos and practiced. Happy to say that I passed the test, scoring 975/1000. Thank God for this channel and my successful test.

  • @honda_doc6826
    @honda_doc6826 10 дней назад

    Thanks.

  • @briannaortiz6813
    @briannaortiz6813 10 дней назад

    I passed with 925!! these videos helped me greatly, thank youuuuu

  • @user-fq2nx6yr3h
    @user-fq2nx6yr3h 11 дней назад

    Thanks a lot. Super presentation.

  • @user-qh5jn1tv9z
    @user-qh5jn1tv9z 12 дней назад

    Hi Mike. Thanks so much for your amazing videos, they've been great help. I saw this question while practicing, it said I should merge a group of cells. But these cells were all column headings! There was no way I could merge them while also leaving all the headings, I could only have one heading (the first one) show. What can I do? My exam is tomorrow morning and I wouldn't be able to access a computer system to check your response after the next 2 hours. I really need your help.

  • @concert_connoisseur22
    @concert_connoisseur22 12 дней назад

    Hey!!! I took my Excel Associates exam and got a 831/1000!!! I kid you not!!! The Sports task was the exact same one as on my exam. What was hard for me was the IF function on the exam because I forgot to put the " " around the words like: "Books Sold" > 10,000. I was so nervous and also the proctor kinda shook me up before the test so I feel like it might've made me more nervous. Causing me to forget.

  • @brotono12oogabooga
    @brotono12oogabooga 12 дней назад

    thanks for showing us how to do this I watched your Microsoft powerpoint video 30 mins before the test and I passed with a 700 and then with the outlook I passed with a 856 after watching your videos Gonna watch this video and pass my test and get my Microsoft cert tomorrow thank you so much

  • @JustinMatson
    @JustinMatson 15 дней назад

    I just took the Excel 2019 exam (through SHL) and it had tool tips turned off, couldn’t turn them on. It made it super hard to tell between the style options! I have to take the PowerPoint one next and without tool tips, it feels like I’m supposed to memorize all of the styles or something ahead of time which feels extreme.

  • @braytonsky7275
    @braytonsky7275 15 дней назад

    I’m curious. For the Concat portion, would I be penalized for not using the built in function? For problems, like that, I prefer to do ={selected cell}&”@example.org” it does the same thing but would I be penalized for this? If anything this shows a deeper understanding of text functions. If I take the test, should I be worried about how I write the formula if the results are the same?

  • @ciroadolfo01
    @ciroadolfo01 15 дней назад

    Realmente, Muchas Gracias

  • @allyrail5420
    @allyrail5420 16 дней назад

    Saved my report from looking sooo boring!! Thank you!

  • @eastonknight290
    @eastonknight290 18 дней назад

    I’m still gonna fail but less 👍thank youuuuu

  • @harleycraig782
    @harleycraig782 19 дней назад

    passed with a 900, forgot about that =left function and had to skip it, but a lot of what you mentioned in this video and more recent videos were spot on and on the test. thank you

  • @Omi_Chan123
    @Omi_Chan123 20 дней назад

    Thanks so much for the video, it really helped me understand what to do on PowerPoint, I hope I pass the test

  • @KIKI-ok5nc
    @KIKI-ok5nc 20 дней назад

    YALL I PASSED! THANK YOU SM MIKE

  • @bryceharvey5572
    @bryceharvey5572 20 дней назад

    Thanks for your help Mike this video helped me get a 943 on my Microsoft Certification test. I was really worried about how the exam would go and this video helped me surpass my fears and expectations. Thanks for all your help Mike

  • @ritalagana565
    @ritalagana565 24 дня назад

    Hello. By any chance do you have a tutorial for 2016 Access? Thank you.

  • @faithhopejoywithpastormari9069
    @faithhopejoywithpastormari9069 24 дня назад

    Thank you!!

  • @tashafoster3249
    @tashafoster3249 24 дня назад

    I just took my exam and scored a 906/1000 simply from watching this video and Part 1 a couple times! Thank you so much this was soooo helpful!!! You officially have a new Subscriber :)

  • @kidyugi1
    @kidyugi1 25 дней назад

    Sooooo no one saw his search history at the beginning of the video. Lmaoooo

    • @MikesOffice
      @MikesOffice 24 дня назад

      LOL! Next Google search: How to delete part of a RUclips video.

  • @zackbass5126
    @zackbass5126 25 дней назад

    Just go to Design when a question specifically says "entire document" instead of selecting everything. Thank you. Keep up the great work. Nice hat.

  • @leon5586
    @leon5586 25 дней назад

    are these the only formulas we need to know fo the intermediate exams?

  • @ninoalfonsomahinay6464
    @ninoalfonsomahinay6464 25 дней назад

    I JUST PASSED THE EXAM THANKS TO THIS VIDEO! THANK YOU SO MUCH❤

  • @kateleeth
    @kateleeth 25 дней назад

    Questions on the exam were literally the same exact ones you showed, thank you!

  • @user-ky4zb4uk3i
    @user-ky4zb4uk3i 27 дней назад

    This Helped me, I Practiced This Almost Everyday After B day From School And during Technology Class, I feel Ready To Do my Test. After Working on this Project for 3 weeks.

  • @AlexisMontgomery-mn3qs
    @AlexisMontgomery-mn3qs 27 дней назад

    I just took mine using this video and got an 887/1000 he is amazing!!

  • @brendenaebersold2761
    @brendenaebersold2761 28 дней назад

    This dude is a legend. I watched this like 4-5 times before my exam and this was basically a carbon copy of my exam. I highly recommend this to anyone looking to take it. Thank you Mike!!!

    • @notgracie6153
      @notgracie6153 3 дня назад

      I’m so glad you said this mines tomorrow

  • @aminatasene5726
    @aminatasene5726 28 дней назад

    Do you offer any coupons for your course on udemy?

  • @fatibenkhaled7343
    @fatibenkhaled7343 28 дней назад

    Hi mike .where is part 2 pls!

  • @valeriavacsi6979
    @valeriavacsi6979 29 дней назад

    I managed but it added me a blank page before my first page! What did I do wrong? 😭

  • @mylojathnielmangana2282
    @mylojathnielmangana2282 Месяц назад

    Thank you Mike! I watched your video to review before my exam and I've got 900 plus points and it makes me feel confident to take the exam. It really helps! Godspeed!!!

  • @josesuk9968
    @josesuk9968 Месяц назад

    Good, but how to make it open on the Word desktop? Thats challenging

  • @dkvedbraaten
    @dkvedbraaten Месяц назад

    Are you planning on doing exam practice videos for Word 365 Expert and Excel 365 Expert?

  • @robertengland6981
    @robertengland6981 Месяц назад

    Failed my first exam a month ago because I was confused on some of the wording. Been studying but still needed some better explanations found your video today and watched both about 2 hours before my exam. You explained everything so clearly and I went in confident and scored a 975/1000 and finished with 20 minutes to spare Thank you!