- 17
- 25 015
Simple MS Office Tips
Приєднався 29 січ 2012
A channel to share little tricks I've found useful in my day to day adventures with Microsoft Excel and Microsoft Word.
I'm not an expert, but I'll share with you what works for me and, hopefully, it'll help you too :)
I'm not an expert, but I'll share with you what works for me and, hopefully, it'll help you too :)
Using Tabs in Word and Converting Text to Table
This video shows how to use tabs in word to create columnar format.
It also shows how to convert text to a table.
Introduction to tabs in word:
ua-cam.com/video/I3l7xP_8wh8/v-deo.htmlsi=zqyuUr3YttBrfU0Y
Link to copy table from excel:
ua-cam.com/video/3ylK2R4V_qo/v-deo.htmlsi=zHIYHEfVCHRFG34N
0:00 Introduction
0:19 Recommendation to use tables instead of tabs
1:05 Adding headers to columns
2:46 Entering data under headers
3:42 Moving and re-sizing columns
4:12 Using decimal tab stops to align numbers
5:47 Converting text to a table
6:43 Copying data only from Excel and using tabs to create column formats
It also shows how to convert text to a table.
Introduction to tabs in word:
ua-cam.com/video/I3l7xP_8wh8/v-deo.htmlsi=zqyuUr3YttBrfU0Y
Link to copy table from excel:
ua-cam.com/video/3ylK2R4V_qo/v-deo.htmlsi=zHIYHEfVCHRFG34N
0:00 Introduction
0:19 Recommendation to use tables instead of tabs
1:05 Adding headers to columns
2:46 Entering data under headers
3:42 Moving and re-sizing columns
4:12 Using decimal tab stops to align numbers
5:47 Converting text to a table
6:43 Copying data only from Excel and using tabs to create column formats
Переглядів: 70
Відео
Introduction to tabs in Microsoft Word
Переглядів 23314 днів тому
This video shows how to use tabs in Microsoft word to create a simple 2 columned table. Link to Quick Access Toolbar: ua-cam.com/video/bL8cj1tRekg/v-deo.htmlsi=Tlgz_8VdqwNr1SZA You can also create a table in Microsoft Excel and copy it across to Word. (my preferred method of adding tables to Word) Please see my video below with tips on how to copy from Excel and mistakes you should avoid. Link ...
Fix for issues with widening or reducing column widths in Word
Переглядів 29214 днів тому
This video shows you how to fix issues that arise when you try to widen or reduce column width in MS Word. For a tips on how to easily copy a table from excel to word, please check out my video below: ua-cam.com/video/3ylK2R4V_qo/v-deo.htmlsi=llBYp09jMrNabiAt
Change how the comma button formats numbers in excel
Переглядів 26221 день тому
This video shows how to change the formatting style of the comma button. Formatting code: _(* #, 0.00_);_(* (#, 0.00);_(* "-"??_);_(@_)
Present negative numbers in brackets (if clicking "comma style" does not show brackets)
Переглядів 64421 день тому
This video shows how to show negative numbers in brackets when the "comma style button" does not format with brackets. To change how the comma button formats numbers, you can check the video below: ua-cam.com/video/O9VXUTHuL7o/v-deo.html Format code: _(* #, 0.00_);_(* (#, 0.00);_(* "-"??_);_(@_)
Copying table from Excel to Word
Переглядів 131Місяць тому
This video shows tips to copy across tables from Microsoft Excel into Microsoft Word. Link to Quick access toolbar video: ua-cam.com/video/PjqswphGxwI/v-deo.htmlsi=eJ5hNgDdHoMqOe2j Link to Ruler and Hidden characters: ua-cam.com/video/PjqswphGxwI/v-deo.htmlsi=oizhl4FZCgofcjNz
Microsoft Word Formatting: Indents, page break, spacing before and after paragraphs
Переглядів 1,2 тис.Місяць тому
This video shows how to neaten the format of a MS Word document and makes use of the following tools: - A page break - Spacings before and after paragraphs - Indents Quick access toolbar: ua-cam.com/video/bL8cj1tRekg/v-deo.htmlsi=EnejRb7qH6gNlV7t Ruler and show/hide non-printable characters: ua-cam.com/video/PjqswphGxwI/v-deo.htmlsi=Co80jMcUS3MJs7xa
Formatting Microsoft Word - Introduction (Ruler and Hidden Characters)
Переглядів 113Місяць тому
This video introduces 2 simple but essential tools for formatting in MS Word: - Ruler - show hidden characters Quick access toolbar: ua-cam.com/video/bL8cj1tRekg/v-deo.htmlsi=i0fqsfVzEWdwKUUd Formatting of MS Word document with tools in this video : ua-cam.com/video/MKBQxMOLJoU/v-deo.htmlsi=VMclpnOaKo6_1oFV
Excel and Word - Quick Access Toolbar
Переглядів 1182 місяці тому
This video gives an introduction to the quick access toolbar and shows how to set up and customise the tool bar to suit your shortcut needs. Link to my customiation files: Word: drive.google.com/file/d/1IUGFWO_MI9a2wWDM5q5Axq0aKNiXTffm/view?usp=drive_link Excel: drive.google.com/file/d/1tYRdxIOG_7NSh2X8SteOw7vuZzWCFy_g/view?usp=sharing
Cash flows: how to treat with gain/loss on disposals, revaluations and leases (IFRS 16)
Переглядів 4748 місяців тому
This video shows how to prepare a cashflow with: - Disposal of property, plant and equipment - Revaluation of land and building - new leases and lease payments - Loans - Investment revaluation (FVOCI) - Bank overdraft Link to completed cash flow: docs.google.com/spreadsheets/d/15_Sb-VU79TiGeG7orlQiuBC47RBK3a1-/edit?usp=drive_link&ouid=115834596641469140103&rtpof=true&sd=true Link to basic cashf...
Simple xlookup
Переглядів 1009 місяців тому
This video shows how to start using xlookup instead of vlookup for exact matches. I hope you give xlookup a try after seeing this!
Excel formula gives incorrect nil/zero balance - Circular references
Переглядів 1249 місяців тому
This video will show: - how to correct errors in formulas that give incorrect nil balances. - what are circular reference errors and how to find them - how to fix circular reference errors - how to avoid circular reference errors
Fix cash flow errors
Переглядів 2184 роки тому
This method will show you how to easily create a cash flow that is guaranteed to balance. More complex cashflow: ua-cam.com/video/uav2zkVKg1c/v-deo.htmlsi=IllC03-UNp1JiAWu
VLOOKUP: Combining trial balances
Переглядів 21 тис.9 років тому
Using vlookup formula to compile two trial balances into one. (2023 edit) xlookup was added to excel after 2019, you can see how to use xlookup instead of vlookup here: ua-cam.com/video/YxmyH-TwWXM/v-deo.html&ab_channel=SimpleMSOfficeTips
How do you make this the default when you click the comma thingie?
Hi there. Thank you for your feedback. You can change what your comma button does by changing the cell style. I've made a short video to show you how to do this. at the link below: ua-cam.com/video/O9VXUTHuL7o/v-deo.htmlsi=gRTcwwId6dUj5kRV
Quick question. What to do if your formatting from excel is not pasting on word?
Hi, thanks for your question. - go to MS Word Options ( File -> More -> Options) - go to the Advance tab - scroll to section "cut, copy, paste" and change the first two dropdowns to "keep source formatting" - close and re-open MS Word. I hope this helps!
@@simple_office_tips yes it did thanks
Thank u for this 😊
You're welcome 😊
Thank you for this !!!! 😊
I like your voice ♥
Thank you. It's the Trini accent 😊
16:50 Not sure if I missed something but what happened to the loan repayment?
You're right and thanks for your feedback. The video did skip a bit after I added the interest to the loan repayment. It picks up again soon right after.
Thank you! 🙂 Will like to see more of these shorts!
Will do. Thanks for watching!
🙌🏽🙌🏽
💛
thank you so much ctr g is great jop
You're welcome! I'm glad I could help 😊