Mike's Office
Mike's Office
  • 134
  • 2 848 756
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!
zhlédnutí: 10 084

Video

Convert Word to PDF from Laptop
zhlédnutí 26KPřed rokem
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....
zhlédnutí 13KPřed rokem
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!
zhlédnutí 7KPřed rokem
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)
zhlédnutí 5KPřed rokem
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
zhlédnutí 8KPřed rokem
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
zhlédnutí 7KPřed rokem
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
zhlédnutí 6KPřed rokem
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?
zhlédnutí 7KPřed rokem
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
zhlédnutí 715Před rokem
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!
zhlédnutí 2,4KPřed rokem
Learn how to insert citations and bibliography quickly in Microsoft Word.
Outlook Signature setup with Logo (The Easiest Way)
zhlédnutí 29KPřed rokem
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
zhlédnutí 2KPřed rokem
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
zhlédnutí 1,9KPřed rokem
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
zhlédnutí 23KPřed 2 lety
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
zhlédnutí 15KPřed 2 lety
How to Set Page Margins for Different Types of Documents
How to Make a Goal Thermometer in Excel (step by step)
zhlédnutí 32KPřed 2 lety
How to Make a Goal Thermometer in Excel (step by step)
START using mail merge with these 7 steps!
zhlédnutí 2,9KPřed 2 lety
START using mail merge with these 7 steps!
How to insert page number in Word
zhlédnutí 115KPřed 2 lety
How to insert page number in Word
Don't FAIL your next Excel Exam! Watch this instead...
zhlédnutí 95KPřed 2 lety
Don't FAIL your next Excel Exam! Watch this instead...
Flip ONE page horizontally (Landscape) in Word!
zhlédnutí 10KPřed 2 lety
Flip ONE page horizontally (Landscape) in Word!
Use the IF function to make better choices (7 examples)
zhlédnutí 4KPřed 2 lety
Use the IF function to make better choices (7 examples)
I help people stand out with MOS exams; Here's why! (Funny story)
zhlédnutí 2,2KPřed 2 lety
I help people stand out with MOS exams; Here's why! (Funny story)
Plan Events in Microsoft Outlook!
zhlédnutí 1,7KPřed 2 lety
Plan Events in Microsoft Outlook!
How this channel can help YOU!
zhlédnutí 8KPřed 2 lety
How this channel can help YOU!
Manage Your Inbox with these 7 Easy Outlook Features!
zhlédnutí 3,3KPřed 2 lety
Manage Your Inbox with these 7 Easy Outlook Features!
Save time inserting lines in Word with these keyboard shortcuts!
zhlédnutí 21KPřed 2 lety
Save time inserting lines in Word with these keyboard shortcuts!
Create Outlook out of office replies (Desktop and Web based)
zhlédnutí 2,2KPřed 2 lety
Create Outlook out of office replies (Desktop and Web based)
Microsoft Excel certification exam part 2
zhlédnutí 71KPřed 2 lety
Microsoft Excel certification exam part 2
Microsoft Excel certification exam (Part 1)
zhlédnutí 226KPřed 2 lety
Microsoft Excel certification exam (Part 1)