Wrepit

Wrepit Wrepit generates a stunning web report from your Word document and gives your report readers an all

🎅📈 Do you every get frustrated having to copy and paste the same tables from   to   each quarter? We feel your pain, kee...
24/12/2023

🎅📈 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 Wr...
23/12/2023

🎅📈 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! 🚀👍

🎅📈 Power Query - useful with tables✨🔥 PowerQuery - a powerful but scary feature in Excel AND PowerBI. Learn how power qu...
22/12/2023

🎅📈 Power Query - useful with tables✨🔥 PowerQuery - a powerful but scary feature in Excel AND PowerBI. Learn how power query can be used to combine simple Excel tables into massive data gathering tables - for automation of your Excel workbooks!

Yesterday we talked about tables. In the picture below, you can see that we have created 3 simple tables, for which we want to fetch some data:
- Employees
- Years
- Data Points (for stuff we want to know about each employee)

Imagine we have a table in another worksheet with a lot of data points from different employees from different years, and that we want all combinations of the above 3 tables in a new worksheet? This is a great case for Power Query! This is quite advanced, and we can split it into the following 5 steps:
1. Define the tables (already done)
2. Modify each table in PowerQuery, adding a "Dummy" column of "1" values to each row, and store with a temporary name.
3. Merge all 3 tables together, on the "Dummy" value, with a "Full outer join".
4. Save and Close to store the Query as a new Table in Excel.
5. Use the table in a formula 🖥️=MyNewQuery

🔥Step 2: Right-click your table and click "Get Data from Table/Range", which will open PowerQuery. In the "Add Column" tab, add a "Custom Column". Name the column "Dummy" and set the custom formula to "=1". Rename the query to something helpful, like "YearsWithDummy". Do this for all 3 tables.
🔥Step 3: Within PowerQuery, right-click the "Queries" area, click "New query", then "Combine" and "Merge queries as New". Select e.g. YearsWithDummy and EmployeesWithDummy, click the dummy column in both, and select the "Full Outer Join" option and then "Ok" to apply. The "EmployeesWithDummy" column can then be expanded by clicking the "expand arrows" in the column (no need to keep Dummy). Then find "Home" tab and "Merge queries" to add DataPointsWithDummy as well to the table, and finally remove unnecessary dummy columns.
🔥Step 4: Give your query a useful name (like "EmployeeDataPerYear") and hit "Save and Close".
🔥Step 5: Excel will now have a new tab for the new query, and you can reference the query by name in Excel formulas! Combine this with other functions and data sources and you can fully automate your data collection. 📣✨🚀 (In the image below, we have applied this formula to cell C14: 🖥️=EmployeeDataPerYear)

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 ...
21/12/2023

🎅📈 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! 🚀👍

🎅📈 Long blocks of text can be tiring to read. Give your readers a visual break with some eye candy! And why not sprinkle...
20/12/2023

🎅📈 Long blocks of text can be tiring to read. Give your readers a visual break with some eye candy! And why not sprinkle in our nifty design element called Good pause? It's like a breath of fresh air for your content! ✨🔥

Not only will Good Pauses keep your readers engaged by breaking up the monotony of text, but they also help tell a captivating story or set the perfect context. So whether you're choosing imagery for a cover photo or creating a moment of pause, let those visuals work their magic! 🌟

Simply open Wrepit Highlights in . Select which good pause element you want (custom quote on top, with a background color or image only. Upload your own image and crop for both desktop and mobile view. ✨

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...
19/12/2023

🎅📈 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! 🚀👍

🎅📈 Control your Word document easily by showing paragraph markers.✨🔥Word documents can become messy – especially when yo...
18/12/2023

🎅📈 Control your Word document easily by showing paragraph markers.✨🔥Word documents can become messy – especially when you collaborate and don’t have 100% control all the time. You scratch your head wondering why the spacing is uneven, or why something on the next page keeps moving?

Turn on “Show paragraphs marks and other hidden formatting symbols”. You will suddenly see a bunch of little markers. The document looks uglier, but they tell you exactly what kinds of white-space and breakpoints have been used.

¶: Marks the end of a paragraph (Hit “Enter”)
↵: Marks a “visual only” line break (Hit “Shift+Enter”)
·: Regular space (Hit “Spacebar”)
°: Non-breaking space (Hit “Ctrl + Shift + Spacebar”)

We recommend mostly using "¶" as it ensures uniform spacing between paragraphs. Relying on manual line breaks or spaces for paragraph separation can lead to inconsistent spacing and clutter.

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

🎅📈 Change number separators with ease in Excel2Word! ✨🔥Sick of pulling your hair out trying to format numbers correctly?...
17/12/2023

🎅📈 Change number separators with ease in Excel2Word! ✨🔥

Sick of pulling your hair out trying to format numbers correctly? Trust us, we've got your back!

Introducing the Excel2Word add-in - your secret weapon for effortlessly changing number separators in a snap! 💪 Just click your name, head to preferences, and click on the "Override number separators" toggle. Once you've found the right format, simply sync and save to achieve number formatting perfection.

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

🎅📈 Want to make calculating totals on stacked bar charts in   a piece of cake? Let us show you how! 💪Once you have your ...
16/12/2023

🎅📈 Want to make calculating totals on stacked bar charts in a piece of cake? Let us show you how! 💪

Once you have your stacked bar chart ready, head over to "Chart Design" on the toolbar and click "Select Data". Add a new series, give it the name "Total", and enter the Y-Values from your table under the Total column. You should now have a a new bar on top of each category.

Select the top bar (the new "Total" series) and change the Chart type to "Line chart". Right-click on the line, select "Add data labels", and voila! Numbers appear on top of each bar.

Next, go to "Format data series", click the paint bucket, and click "No line". The line disappears, leaving you with a clear view of the totals for each serie.

Now you're ready to impress with your total-tallying skills! 🌟

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

🎅📈 Refer to shapes, objects and images   with cross-references ✨🔥 Tired of endlessly scrolling through your never-ending...
15/12/2023

🎅📈 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! 🚀👍

🎅📈 How can the Excel language setting make your work easier? ✨🔥 Excel function names are really weird in Norwegian. It m...
14/12/2023

🎅📈 How can the Excel language setting make your work easier? ✨🔥 Excel function names are really weird in Norwegian. It makes "googling" for help quite difficult.

Solution? Just switch to English language. Guides are so much easier to find in English! 💪

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

🎅📈 Highlighting quotes in   like a boss! ✨🔥 Got some brilliant sentences in your report that deserve the spotlight? Don'...
13/12/2023

🎅📈 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! 🚀👍

Adresse

Chr. Krohgs Gate 1
Oslo
0186

Varslinger

Vær den første som vet og la oss sende deg en e-post når Wrepit legger inn nyheter og kampanjer. Din e-postadresse vil ikke bli brukt til noe annet formål, og du kan når som helst melde deg av.

Kontakt Bedriften

Send en melding til Wrepit:

Del