Wrepit

🎅📈 Do you every get frustrated having to copy and paste the same tables from to each quarter? We feel your pain, keeping numbers in order is complicated. And let's be real, nothing really changes except for the numbers, right? 🤔💥

But fear not, because Excel2Word is here to be your Christmas miracle!✨🎁

You can actually reuse your own Excel template each quarter. If you already have the previous quarter's numbers linked up in through Excel2Word, simply create a copy of your Excel file, input the new numbers, and replace the file in E2W. Excel2Word will recognize the defined names and swiftly replace all those tables for you!

🎉🎇Merry Christmas and Happy New Year to all!🎆🎀

Follow Wrepit, like and reshare for more tips on Excel and Word this December! 🚀👍

🎅📈 Embed videos easily through Wrepit! ✨🔥

Simply copy the URL into Word (make sure that it is a hyperlink), upload to Wrepit and ta-da! It magically transforms into a video!🌟

Follow Wrepit, like and reshare for more tips on Excel and Word this December! 🚀👍

🎅📈 Tables in !✨🔥 How can "Format as Table" be useful for more than just automatic formatting?

Although powerful, Tables are a feature you should use sparingly. They can confuse more than they help, which is why we believe you should normally use the "Define name" feature for reusing data from tables. However, some Excel features work great with Tables!

Today: How to define tables and basic functionality.
Tomorrow: How to use tables with PowerQuery!

Defining a table is really easy, just find "Format as Table" under the "Home" tab - and click whichever predefined table design you prefer. In the "Table Design" tab you can change the name of your table.

Good and bad things about tables:
✔️ Easily color a data table
✔️ Formulas auto fill to all rows
✔️ You can refer to Tables and table columns by name in formulas outside the table.
✔️ Tables are possible to utilize inside PowerQuery! (see tomorrow's tip)
❌ VLOOKUP and other lookup functionality can be confusing
❌ Adding rows and columns can be a little confusing
❌ Figuring out where to store tables in your workbook can be confusing. Tip: Try to keep them separate, e.g. in their own sheets.
❌ Tables are not supported by our "Excel2Word by Wrepit" addin. We support tables via "define name" though! 💪

In the picture below, notice how we have calculated the EURO value per customer by referring to data in other columns within the table. This is actually very easy, you just click the data you want with your mouse, and the formula turns out like this.

Also try to insert rows within the table where you have a formula in one of the columns - and notice how the formula automatically fills into the new rows. All you need to do then is fill in the missing data, and the calculations apply.

Got any good use cases for tables? Or frustrations? Let us know!

Follow Wrepit, like and reshare for more tips on Excel and Word this December! 🚀👍

🎅📈 Make custom headers with automated numbering in Word, e.g. “Note 1”, “Note 2”, etc. This is a pretty advanced feature in Word. Learn how it’s done!✨🔥 This is a brilliant tip if you have financial reports with note sections.

Microsoft Word's custom heading numbers are like invaluable for document organisation and readability. 📄🌟 They bring structure, simplify navigation, and update themselves, keeping your document coherent. These numbered headings make cross-referencing a breeze (check out our Word tip from Dec. 15th), ensuring accurate section references.

- Type a heading in a new paragraph.
- In the Styles pane, select “Heading 2”. This prepares Heading 2 as a base for your new style.
- Then, in the Styles pane, opt for “Create a Style” followed by “Modify”.
- In the “Modify” dialog, enter details like Name: “Note lvl 2” (or 3, based on your choice), Style based on: Heading 2, and Style for following paragraph: Normal, then click “Ok”.

Now, you have a Note heading style, but it’s not numbered yet.

- Go to the “Home” tab, under “Paragraph” pane, click the “Multilevel List” dropdown, and select “Define new Multilevel list…”.
- In the “Define Multilevel List” dialog, make your adjustments:
- Select the level to modify, here “2”.
- If your document already has numbering, ensure you set “link level to style” values to “No style” for all levels.
- Under “link level to style”, choose your newly created style: “Notes heading 2”.
- For “Number style for this level”, select “1, 2, 3, …”.
- Enter the formatting for the number as “Note [1]” (where [1] represents this heading level’s number).
- Set “Start at” to 1.
- Choose “Restart list after” Level 1 (or Level 2, if based on Heading 3).

With these steps, your document will have a well-defined, custom numbered style for Note headings, enhancing the organisation and professionalism of your work.

Follow Wrepit, like and reshare for more tips on Excel and Word this December! 🚀👍

🎅📈 Refer to shapes, objects and images with cross-references ✨🔥

Tired of endlessly scrolling through your never-ending Word document? 🤦‍♀️ Well, fret no more! We've got a game-changing solution for you!

Make those references clickable, my friend! Simply place your cursor where you want the reference to be and hit that "Cross-reference" button. Easy peasy! 🖱️✨ And guess what? You can refer to anything your heart desires - numbered items, charts, headings, you name it! 📊🔍

But hold on, it gets even better! 🌟 Give Wrepit a whirl and prepare to have your mind blown. Our ingenious cross-reference interface will revolutionize your document experience. No more losing your place! When you click a cross-reference in Wrepit, it'll either pop up in a handy sidebar or transport you directly to the correct section. And guess what? We've even included a nifty back-button to seamlessly bring you back to where you left off. Talk about convenience! 🙌🔀

So, what are you waiting for? Make your colleagues' day and save them from the formatting madness.

Follow Wrepit, like and reshare for more tips on and this December! 🚀👍

🎅📈 Highlighting quotes in like a boss! ✨🔥 Got some brilliant sentences in your report that deserve the spotlight? Don't sweat it – it's as easy as it looks!

With our nifty add-in, "Wrepit Highlights", you can effortlessly sprinkle quotes wherever you fancy. Just hit the "Insert Quote" button, and voila! A fabulous quote template appears in your document. Customize the Quote and Quote Author (or remove it), and you're good to go!

Once you've uploaded it to Wrepit, behold its magnificent glory, adorned with your own brand colors and fonts.

Follow Wrepit, like and reshare for more tips on Excel and Word this December! 🚀👍