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

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

🎅📈 "IFNA" and "IFERROR" in !✨🔥 Do you dread " /A" and " !" errors? Use Excel errors for your benefit, rather than them being an annoyance 😀

With these useful functions you can add a fallback values. It is very simple.

Getting N/A errors from your VLOOKUPs? Just use IFNA: 🖥️=IFNA(VLOOKUP("Another Co";Customers;4;FALSE);"Couldn't find company")

Other errors? Just use IFERROR, e.g. for a fallback for zero-division errors: 🖥️=IFERROR(5/0;0)

Got any good usecases for these functions? Do let us know in the comments!

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

🎅📈 Work smart in with styles ✨🔥 Keep your colleagues happy. There's always someone in the office who will need to collect texts from everyone and correct all of their formatting mistakes.

But they'll be very happy if you just follow this tip. Do NOT change the font (font sizes, colors, variants). Use Styles! Your company probably even has built-in styles to keep you on-brand. Your work in Word will be easier - and your colleagues will thank you! 😜

This is especially important for headings, because (a) the Table of Contents will actually work, and (b) your document will be Accessible and compliant.

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

🎅📈 SYNC your KPIs from Excel to Word✨🔥 Make those KPIs count in your reports. But also - keep them up-to-date!

With our add-in to Word, the Excel2Word by Wrepit, you can keep your KPIs in Excel, and just hit the "Sync" button when you need the updated data in your Word document! 📣✨

Seamlessly synchronize your data! (Link: https://eu1.hubs.ly/H06x5-Q0)

The best way: When used along with Wrepit, your KPIs will even get a branded look and intriguing animation. Respond in the comments or send a DM and we can talk.

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

🎅📈 Avoid frustration in ✨🔥 "Why does my content skip around? I have NO CONTROL!"

The most common culprit is Anchored images. Always Inline your images. It is important for your sanity - and it is also important for Accessibility.

The settings for this can be found many places. Look for the "Layout Options", "Position" or "Wrap text".

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

🎅📈 "LAMBDA()" in !✨🔥 It is finally time for our favorite feature in Excel - the LAMBDA. The coolest feature? 💣😂💪

Lambda is a programming concept. It allows you to make your own functions in Excel - without the scary Macro programming. Combine it with "Define name" and you have the main tools for a very powerful workbook that may actually make sense to your colleagues!

So what is it? You know how SUM is a function in Excel with a useful name ... Sum... You actually understand what it does. The same goes for Lambdas when you make them right!

Remember the XLOOKUP function we made yesterday?
🖥️ =XLOOKUP("Invoice Value";INDEX(Customers;1;0);XLOOKUP("Quantum Solutions";INDEX(Customers;0;1);Customers))

What if it could look like this instead? 🖥️=x("Invoice Value";"Quantum Solutions";Customers)

You can do it yourself - no macros! 🚀💪 Just follow these steps:
1. In a cell, define the function you want - like we did with XLOOKUP above.
2. Take note of the arguments in your function and give them suitable names. In our case, we do
📈 leftTitle for "Quantum Solutions"
📈 topTitle for "Invoice Value"
📈 table for Customers
3. Then we can write our Lambda function, with the arguments first (in a Lambda, the function always comes last - after as many arguments you want):
🖥️ =LAMBDA(topTitle;leftTitle;table;XLOOKUP(topTitle;INDEX(table;1;0);XLOOKUP(leftTitle;INDEX(table;0;1);table)))
4. Your cell is now supposed to say something scary like " !".
5. Now - copy the whole formula.
6. Find the Formulas tab - and the "Define name" button.
7. Give it your desired name. We did "x" for this reusable function. And most importantly, paste the entire function into the "Refers to" field - don't forget the leading equality sign (=).
8. You can now use it anywhere in your workbook - and Excel will even give hints! Huzzah!

Could you make it work? Please share with us your useful Lambdas in the comments! 🔧

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

🎅📈 "XLOOKUP()" in !✨🔥 Why? You've tried VLOOKUP to get a value from a specific row in a table, and you've tried its sibling - HLOOKUP for columns. But what if you have a table, and you want to get the right cell based on BOTH a row title - AND a column title?

XLOOKUP to the rescue! It is a little clunky and confusing at first - because it doesn't work entirely as expected. It requires you to understand arrays (or just accept them), because we actually need to define what are our row titles and what are our column titles.

For today you should know that:
1. We have named our table 📈 "Customers"
2. We need to find the row with the desired customer name: 🖥️=XLOOKUP("Quantum Solutions";INDEX(Customers;0;1);Customers)
3. We need to find the column with the desired title within the Customers table which we already filtered by customer name: 🖥️ =XLOOKUP("Invoice Value";INDEX(Customers;1;0); THE_ABOVE_XLOOKUP )

This way you can search for any value inside a structured 2-dimensional table. Make sure you "Define Name" for the table so it's easier to reuse.

Stay tuned for tomorrow - we'll show you how to reuse this function with Excel's coolest 💣 feature: LAMBDA!

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

🎅📈 Effective KPIs in Word!✨🔥 Face it - most of us aren't designers, and Word isn't a great design tool. Still - you want to highlight your important numbers...? We have your back!

With our add-in "Wrepit highlights" you can easily add impactful KPIs to your Word document. Just click the "Insert KPI" button, and a KPI template is inserted into the document. Change the number and description to your liking, and voila!

For extra impact, upload your document to Wrepit, and the KPI will sparkle ✨ in your brand colors on all screens.

For "Wrepit highlights", see here: https://eu1.hubs.ly/H06tKmX0
Contact us in the comments, via DM, or this link to start using Wrepit: https://eu1.hubs.ly/H06tKmY0

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

🎅📈 "Concat()" in !✨🔥 In a proper financial table, each cell should be self-sufficient. Yet we often see titles spread out over several rows. Understandable - yet unnecessary!

The old way, split it over 2 cells, and have the second cell type: 🖥️ =CurrentYear
The new way, use Concat: 🖥️ =CONCAT("Accounting Year ";CurrentYear)
Similarly for the previous year: 🖥️=CONCAT("Accounting Year ";CurrentYear-1)

Concat is super powerful. You could combine it with the TEXT function to keep a threshold, e.g. "500000" in one cell, and then writing a useful explanation like: 🖥️ =CONCATENATE("Cash below ";TEXT(Threshold;"0 k");" date:")
Outcome? "Cash below 500k date:" (Cool eh? 💪)

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

🎅📈 Stay Accessible in ✨🔥 Make sure you stay Accessible with your reporting. Accessibility means writing your document so that anyone (regardless of disability) can read it. It's even required by law that you do so! ⚖️

One important aspect of this is to control the "Alt Text" (alternative text) of your images. You can find it in Word by right-clicking the image and selecting "View Alt Text". Make sure you write something which describes the content of your image - it is important that someone unable to see the image is still able to understand it.

With Wrepit, most aspects of accessibility are handled for you, but you must still know how to add the Alt Text! 💪

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

🎅📈 Easily SYNC data from Excel to Word✨🔥 You probably keep numbers and do calculations in Excel. Why not just use Excel to hold these numbers, even while you write in Word?

The old way: Write your content in Word and copy-paste (or even just write) your numbers and tables into the document. Struggle with formats changing (font sizes and colors anyone? 😒) and remembering where you pasted your numbers when they change 😣.

What could have been: Use Microsoft's built-in copy-paste-link between Excel and Word. We actually used to recommend this - but it has turned out to be unstable and buggy. 🤪

The new way: That is why we built "Excel2Word by Wrepit", an add-in directly in Word on desktop that synchronizes with Excel files stored on your company Sharepoint, OneDrive or Teams folders. Seamlessly synchronize your data! (Link: https://eu1.hubs.ly/H06tG5_0)

The best way: When used along with Wrepit, you won't even need to design your tables in Excel - Wrepit will do it for you. Respond in the comments or send a DM and we can talk.

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

🎅📈 Arrays in !✨🔥 Excel calculations can become complex, and require a lot of "real estate" in your spreadsheets. When building a large Excel file over time, that real estate can become a lot of unused clutter. Sometimes it's better to spend less real estate and aggregate data from arrays into single cells.

In the example image below, you could of course make calculations per row and aggregate the sum below. However sometimes this becomes impractical. Then it might be useful to work on arrays instead.

Selecting an array: 🖥️ Hit "=". Drag-select the range you want.
Multiplication: 🖥️ ={drag-select-array-1}*{drag-select-array-2}*{drag-select-array-3}

You now have a cell which actually contains a large array. It will display data OUTSIDE its own cell. To aggregate it, use one of Excel's aggregations, like SUM(), AVERAGE() etc.

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

🎅📈 "Define name" in !✨🔥 How can you understand your large spreadsheet when you abandon it and return a while later? This method will increase the clarity of your Excel formulas, and it is very easy!

The old-old way of writing a formula: 🖥️ =60000*14.1%
What you probably do today: 🖥️ =B2*B3 (referring to the cells)
What you should do: 🖥️ =BaseSalary*EmployerTax

This is a very simple example, but imagine big calculations with nested IF statements and multiple references to several different cells. Wouldn't "EmployerTax" mean more to you than "B3"?

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

Welcome to us, Norsk Hussopp Forsikring 🏘️🍄🚀 We look forward to seeing your impactful reports, and are proud that you will make them in Wrepit. We know that our add-in Excel2Word by Wrepit was pivotal for your selection, because of how much more efficient work can become with it. 🔥

Thanks for trusting our software.

💪 Impressive! SpareBank 1 Østfold Akershus started using Wrepit this summer, and we are genuinely impressed with their reports!

Their team have delivered exemplary results. Take a look at their latest report for Q3: https://eu1.hubs.ly/H06fsNK0. Their use of interactive charts and design elements, along with the solid SpareBank 1 brand, produces a great reading experience!

Congratulations, SpareBank 1 Østfold Akershus on making great reports - faster 🚀. We are privileged to contribute to your success. 🌐🏆

We are excited to welcome Nysnø Klimainvesteringer as a customer. They invest in companies that provide profitable and smart solutions to the challenges of climate change, and they'll be using Wrepit to report on it.

Improving the product is such a rewarding experience! We are thrilled to announce that our Word addin "Excel2Word by Wrepit" is now 10 times faster when synchronizing numbers from Excel to Word!

Since its release earlier this year, Excel2Word by Wrepit has gained immense popularity among our customers. And when combined with Wrepit's automatic Design tool, the process of creating , , and has become incredibly effortless!

Explore the possibilities here: https://eu1.hubs.ly/H05YPRy0