PTR Blog - Opinions, top tips, and questions from the classroom

Microsoft Word Tables

Microsoft Word offers a very powerful table feature, but it can be a bit of an art working with tables sometimes. In a series of blogs I aim to run through some simple, but essential tasks when working with tables in Word.

It is easy enough to copy and paste a data set into Word from a source such as a Microsfot Excel workbook as a lot of default formats are applied when the data is pasted, but formatting it to your requirements is then often the challenge.

In Working with Tables in Microsoft Word - Part 1 we will look at:

Last week while teaching a PowerPivot course I was asked if it was possible to import data into a Power Pivot table from text files with non-standard delimiters.

The answer is – YES!!

ODBC Desktop Text File Driver

PowerPivot uses the Microsoft ODBC Desktop Database Drivers.

Here we will learn how to design an SSRS report that will export each region to a separate worksheet in Excel.

The following report contains four Tablix regions. Each one is a table with a single row group representing a calendar year. The Dataset contains a SELECT statements that aggregates sales amount by year and country:

No two businesses are alike, so it stands to reason that a single fixed training course won't work for every one. We recognise this so - as well as our standard scheduled courses - we design, build and deliver tailored training specific to individual business needs.