# Tag: Tables

###### Draw complex tables in seconds

How to draw complex tables? Just try it out – Insert – Table – Draw Table – use the pencil cursor to draw. Start  from scratch and keep drawing. It

Read »
###### When to use Banded Columns in Excel Tables

Banded rows are used by default. But Banded columns need to be selected manually. If you select both, the display becomes cluttered. Here is a situation where using ONLY Banded

Read »
###### The curious case of Column Widths in Word tables

There is a story hidden behind these options. The story of how we work and how Word is trying to help us. Learn these options and manage column widths in

Read »
###### Best Practice: Always create a Table before creating Pivot Table

Pivot Table is based upon the current block of data.Sooner or later you are going to update the data. Creating a table eliminates the need for refreshing the new range

Read »
###### Efficiency365 Test 4 : Format Word Tables Solution

Please read the earlier article Efficiency Test 4: Word. The challenge was to format Word tables in the most optimal way. Here is the solution. You need a total of 10 clicks.

Read »
###### Automatic formula copying in Excel (even with blanks)

Imagine that you have 50,000 rows of data. You want to add a new calculated column. Adding the formula is easy. But copying it to 50,000 rows is nothing but

Read »
###### Table going outside the page? Try Autofit to Window

Common problem I am sure you have faced this problem before. Simply frustrating You copy pasted something from Excel to Word and the width of the page was not enough.

Read »
###### How to create complex Word tables in seconds

The best way to show this is a video. These features have been there for at least 15 years. Some features shown are newly added in 2013 version of Word.

Read »

## Pivot Table Pro Course

Yes. You use Pivot Tables everyday. Now it is time to find out the real power and nuances. 5.5 hours video, exercises, samples, Q&A.

## Excel to Power BI Course

Learn Power BI using the concepts you already know in Excel. Fast transition, in-depth coverage and immediately usable.

##### Subscribe to Blog

Join 1,712 other subscribers