Excel tutorials, functions and advanced formula examples, page 34

View two or more Excel sheets side by side

When it comes to comparing worksheets in Excel, the most obvious solution is to place tabs side by side. Luckily, it's as easy as it appears to be :) Continue reading

Look up with Lookups in Excel

When you need to find information in a table of data, the lookup functions in Excel can help you do it. While there was a lookup wizard in earlier versions of Microsoft Excel that made the process of creating a lookup quite easy, this is no longer available in Excel 2010. Now, when you need a lookup formula you'll have to create it manually. Read this post to harness the power of lookups for your Excel worksheets... Continue reading

Get rid of "The file is corrupt and cannot be opened" in Excel 2010

Usually when upgrading you expect nothing but improvements. So it can be really disappointing when after moving to Excel 2010 you have no chance to access your xls. file. You understand what I’m talking about if you ever encountered the "The file is corrupt and cannot be opened" error in Excel 2010. Still think it can’t open? Actually it can! Continue reading

Managing Outlook Auto-Complete to your advantage

Don't you like it when you start typing the recipient's name and Outlook already knows who you want to put in there? Learn how to easily turn the AutoComplete list on and off, delete certain addresses or clear them all and have the same list pop up on your different PCs. Once you understand what you are working with you’ll find yourself using Outlook much more efficiently… Continue reading

Applying multiple Subtotals to your Excel table

Using Subtotals is much more flexible than I put in my previous post about it. Here I would like to expand – literally - the Subtotal function to show some other options that might help you do the work ... Continue reading

How to Consolidate Data in Excel

There are many ways to consolidate data in Microsoft Excel. You can use the Table feature and its associated filters, you can create PivotTables, or you can consolidate large amounts of data into a summary form. In this post I'll show you how to use the Consolidate data feature in Excel to take data from a series of worksheets – or workbooks – and summarize them into a single worksheet. Continue reading

Creating and using Custom Lists in Excel

If you have to work with a spreadsheet that will always have the same list of information, or maybe you just don't want to use copy/paste every time, it would be most beneficial to have a pre-set list stored so that Excel can help you with what you are trying to do. Having a Custom List is the way to go and I'm going to show you how you can create a custom list in Excel. Continue reading

Merge all your Students' Data into a single Excel File

School has begun again as hot summer days gave way to classrooms full of students. With tighter budgets we are facing classrooms with more students and less time for getting to know them. With all the data scattered in different reports, let me show you how quickly you can create a single Excel data binder using Merge Tables Wizard… Continue reading

How to group data in an Excel Pivot Table to help further summarize and analyze your data

When you're working with a PivotTable in Excel you may find that you have a lot of data in the table that needs to be summarized even further. This can be done by grouping the data and in this post I'll explain how to do this Continue reading

Interactive elements in Excel with Spin Buttons and Scroll Bars

Whenever your user has a discrete number of choices to make for inputting data into an Excel worksheet you can save time by automating how they enter this data. You can do this in a number of ways and one of them is to use a spin button or a scroll bar to do the work... Continue reading

How to create custom lists in Excel and get every benefit from Random Generator

Random Generator has a trick for those of you who often work with set lists and would like to get the most of Excel custom list feature. See how much more helpful it can be if you always have your custom lists at hand and you can add not only text, but dates, numbers and other formats to your custom lists. See totally new ways of using the lists: select random entries from them or create worksheets named as custom list values in 1 click... Continue reading

Quick way to standardize and streamline email responses with Outlook Template Phrases add-in

Political organizations across the U.S. are increasingly using email as the dominant form of communication to supporters and potential voters. From local races all the way up to presidential campaigns, email lists are growing and more and more campaigns are sending regular email updates... Continue reading

Conditional formatting in Excel Pivot Tables

With the release of Excel 2007, Microsoft provided some additional conditional formatting options such as data bars and icon sets which makes it easy to apply formats to cells to show visually the relative values in those cells. Microsoft also changed how conditional formatting is applied to PivotTables which gives you a greater flexibility when using conditional formats with data summarized in a PivotTable... Continue reading

Hello, World - why we are starting one more blog for Office users

We initially started creating our add-ins for Microsoft Office applications to make some common tedious tasks simple and fast. A few thousand support requests later, we decided to start this blogging tips site... Continue reading

Ukraine flag War in Ukraine! To support Ukraine and save lives please visit this page.