No video

Advanced Tables in Word: Table Styles, Breaks and Formulas

  Рет қаралды 104,514

Simon Sez IT

Simon Sez IT

Күн бұрын

✅ Download the free course exercise files to follow along
➡️ www.simonsezit...
In this Microsoft Word tutorial, we teach you some advanced tricks and tips when using Tables in Word.
We start by looking at how to convert text to a table, create a new style, and then apply it to the table. After that, we move onto how to split and merge a table and repeat columns headings on each page. Finally, we show you how to use the SUM, COUNT and IF functions to perform calculations in a Word Table
Follow along and download the Word files for this tutorial here:
✅www.simonsezit...
🌍 Get unlimited training with Simon Sez IT’s 150+ courses ⏩ www.simonsezit...
🚀 Level up your skills with a free 30-day trial to our complete training library of 8,500+ videos ⏩ www.simonsezit...
💻 Watch more free popular training tutorials from Simon Sez IT:
🔥Check out our FREE 300+ hour training course playlist here ➡️
• Simon Sez IT Long Trai...
✅ Check out our free video playlist for Microsoft Office 👉 • Microsoft Office 2021 ...
✅Microsoft Word Tutorials for Beginners video playlist 👉 • How to Use Microsoft W...
✅ Microsoft Excel Tips and Tricks 👉 • Microsoft Excel Tips a...
✅ Daily Tools: Simon's top tips for Zoom, Microsoft Teams, Outlook, and Word here 👉 • Daily Tools: Simon's t...
💬Stay in touch!
SimonSezIT.com: www.SimonSezIT...
LinkedIn: / simon-sez-it
FaceBook: / simonsezit
🔔 Subscribe to our channel:
www.youtube.co...
If you enjoyed the video, please give a thumbs up 👍🏽 ;-)

Пікірлер: 37
@MM-uw4lc
@MM-uw4lc 3 жыл бұрын
Love the way she explain everything so clearly. Thank you dear. A hug from Puerto Rico. 🇵🇷
@SimonSezIT
@SimonSezIT 3 жыл бұрын
Thank you!!🤗
@LaneWyrick
@LaneWyrick 3 жыл бұрын
Excellent tutorial! I just found a way that you can find the number of the rows rather than just guessing. Instead of selecting the entire table, just click and drag from the first cel of the table all the way down to the cel you want in your formula. Right click, choose Table Properties and click on Row. Now instead of showing Rows 1 - 124, it will say Rows 1 - 55 (or whatever cel you are choosing). Do this again for your final cel if necessary and input them into your formula.
@dolittlediehard1670
@dolittlediehard1670 Жыл бұрын
And of course the same works if you select say rows 52-56 only. I haven't tried but i wonder if you could choose non adjacent rows?
@dolittlediehard1670
@dolittlediehard1670 Жыл бұрын
And it doesn't, it only gives you the last row. Nevertheless a very nice tip all the same.
@dolittlediehard1670
@dolittlediehard1670 Жыл бұрын
I don't know if Debbie covered this or not but if we suppose you wanted to add up all the sales for the USA only. How would you do it? The answer is to sort the table in acending order, so USA would appear at the bottom and then just add up these rows. You would need to select these rows and use Lane Wyrick's trick above to find out the address values for your formula.
@dolittlediehard1670
@dolittlediehard1670 Жыл бұрын
Yes, this works 🎉. One little side problem. I copied and pasted USA sales into excel but even after changing the format of the cells to numbers it gave a sum of 0 because it didn't like the $ sign. After removing the $ sign it worked
@joshuamanampiu6489
@joshuamanampiu6489 Жыл бұрын
So great for me. Solved most of my table issues. Thank you.
@user-dn9vd9xg9p
@user-dn9vd9xg9p 29 күн бұрын
If have drop down list within a table in a form. The ldrpp down list that has data that is too long to show on one line. How do I get the drop down list formatted to wordwrap and move down (not across). I really need assistance with this. Thank you. 😊
@rajeevsinghbais1727
@rajeevsinghbais1727 Ай бұрын
Explain in very easy way, Thanks
@SimonSezIT
@SimonSezIT Ай бұрын
Glad it was helpful! 🤩 We have additional Microsoft Word tips and tricks here 👉kzfaq.info/sun/PLzj7TwUeMQ3i9pvktF22_v-pOFRuaeOaj
@rogerskipleting1901
@rogerskipleting1901 2 ай бұрын
thank you very much i like your style of teach its systematic and its in a manner that new beginner can comrehend
@SimonSezIT
@SimonSezIT 2 ай бұрын
Glad it was helpful! 🤩 Learn more Microsoft Word Tips and Tricks here 👉kzfaq.info/sun/PLzj7TwUeMQ3i9pvktF22_v-pOFRuaeOaj
@eddietaia8310
@eddietaia8310 3 ай бұрын
Great tutorial
@AyoubShinab
@AyoubShinab Ай бұрын
Thank you so much 😇😎
@SimonSezIT
@SimonSezIT Ай бұрын
You are very welcome! Thanks for watching 😃
@lieslswanepoel2563
@lieslswanepoel2563 3 жыл бұрын
Thank you!
@SimonSezIT
@SimonSezIT 3 жыл бұрын
You're welcome!
@mdshibli1009
@mdshibli1009 Жыл бұрын
Thank you
@sarorabdallah3768
@sarorabdallah3768 3 жыл бұрын
nice and useful tutorial thanks
@SimonSezIT
@SimonSezIT 3 жыл бұрын
Glad you liked it
@Ytremz
@Ytremz 3 жыл бұрын
Very comprehensive - would be interesting to know how to handle the formatting (i.e. font, shading) of a title row that is _merged_ across several (or all) columns of the table. Word doesn't seem to handle the formatting of merged cells very well.
@weston.weston
@weston.weston Жыл бұрын
Great tutorial.
@SimonSezIT
@SimonSezIT Жыл бұрын
Glad you liked it!
@tomnolan4406
@tomnolan4406 Жыл бұрын
I have more columns than rows. Is there a way to have the column go over multiple pages ?
@lawrencekazibwe9751
@lawrencekazibwe9751 3 жыл бұрын
Very informative, thanks dear, Keep it up
@SimonSezIT
@SimonSezIT 3 жыл бұрын
So nice of you
@rksingh8447
@rksingh8447 Жыл бұрын
I tried to add the same way you taught with row numbers but not getting correct total. Updated the field but still not. Pls reply
@denisekobrin9338
@denisekobrin9338 3 жыл бұрын
This was an excellent video. I was hoping it would show me how to format numbers in tables as you do in MS Excel. I have numbers in a table where I don't need a formula, I need to format the numbers as an Accounting number. Is there a way to accomplish this? I'd like to format an entire column at once. thanks
@lisalansing1881
@lisalansing1881 2 жыл бұрын
In the past, I have been able to create styles in the style menu for tables. I can't remember how I did that so if anyone know could you let me know. Thanks
@ma7moudabaza638
@ma7moudabaza638 3 жыл бұрын
Good job informativ tutorial
@SimonSezIT
@SimonSezIT 3 жыл бұрын
Why Thank you.
@jonzillaz
@jonzillaz 2 ай бұрын
Could you not have said the word 'use' instead of 'utilize?' One syllable is more efficient than three. Ignore me! Fantastic tutorials, I really am learning so much. I'm very grateful.
@SimonSezIT
@SimonSezIT 2 ай бұрын
Glad it was helpful! 🤩 We have additional Microsoft Word tips and tricks here 👉 kzfaq.info/sun/PLzj7TwUeMQ3i9pvktF22_v-pOFRuaeOaj
@Tomtriandoch
@Tomtriandoch 2 жыл бұрын
none of this works
How to Insert a Column Break in Microsoft Word
3:53
Simon Sez IT
Рет қаралды 57 М.
Word Tables Best Practices - 2023 - The ultimate guide
21:52
Efficiency 365 by Dr Nitin
Рет қаралды 20 М.
Советы на всё лето 4 @postworkllc
00:23
История одного вокалиста
Рет қаралды 5 МЛН
Harley Quinn lost the Joker forever!!!#Harley Quinn #joker
00:19
Harley Quinn with the Joker
Рет қаралды 23 МЛН
Box jumping challenge, who stepped on the trap? #FunnyFamily #PartyGames
00:31
Family Games Media
Рет қаралды 29 МЛН
UNO!
00:18
БРУНО
Рет қаралды 4,2 МЛН
40 Ultimate Word Tips and Tricks for 2020
33:24
Sele Training
Рет қаралды 271 М.
Ten Tips on TABLES in WORD - A Master Class in 20 minutes!
22:48
David's Tutorials
Рет қаралды 62 М.
Microsoft Word Tutorial: Using Tables in Word
15:35
Simon Sez IT
Рет қаралды 128 М.
Top 15 Microsoft Word Tips & Tricks
20:34
Kevin Stratvert
Рет қаралды 1 МЛН
How to Sum Multiple Tables in Microsoft Word | Field Codes in Word
8:41
HBN Infotech - Tutorials
Рет қаралды 23 М.
13 Common Word Tables Problems Solved
14:10
Efficiency 365 by Dr Nitin
Рет қаралды 32 М.
How to use XLOOKUP and XMATCH in Excel 365
8:07
Simon Sez IT
Рет қаралды 1,1 М.
How to Use Word Styles in Microsoft Word
26:48
Simon Sez IT
Рет қаралды 31 М.
Советы на всё лето 4 @postworkllc
00:23
История одного вокалиста
Рет қаралды 5 МЛН