New support for query tables on Excel Services improves the workbook, sharing in an organization

This week we are highlighted as part of the SharePoint 2013 release some improvements in Excel Services. This post is brought to you by Prash Shirolkar, Program Manager on the Excel team.

Take a last look: the error message below is now a thing of the past.

With the improvements as part of the new Office, we support in Excel Services now refresh the query table. Workbooks with query tables now can seamlessly on the go will be updated from any browser! No need to convert query table to a pivot table or download of a workbook in Excel-desktop-client, to refresh the query table. In other words, the broad sharing of workbooks in the entire organization just got easier.

Ensure the desktop Excel (2007 or 2013) a workbook that contains a query table you and that it is connected to a data source. On the table, table, click the right mouse button on external data properties. If you have virtually no, follow the steps to create here .

Once you're connected, follow these 5 steps:

Guarantee you a link for 'Name' in the external data properties dialog box.

 

Make sure that your query table updated successfully. Select " Update " on the data Ribbon tab for desktop-Excel (2007, 2010 and 2013).

Make sure is, that your Excel Services configured to 2013, refresh external data, depending on whether the query table uses embedded or external data.

Publish your workbook with the query table to a SharePoint document library in 2013, and then viewing the query table on the file. The steps here , you can publish Excel workbooks on SharePoint.

Choose to see update, all connections to the most recent data.

This is it! The query table is now updateable in the Excel Services deployment.

As always, we will continue to work to enhance Excel Services. One area that we do not yet support is refreshing a specific connection via "Update selected." That is something we are considering, but would love to you important hear in the comments, if this is something that you can find and use often.

Refreshing happy by query tables! Notify us of additional features that you would like to see in future versions.

-Prash Shirolkar, Excel program manager

View the original article here

Quick Trick: Resizing column widths in pivot tables

AppId is over the quota
AppId is over the quota

(Who could be better than a Business Intelligence analyst at teaching us a thing or two about Excel? We asked our own number-crunching wizard Stacey Armstrong to share some Excel tricks she's learned along the way..)

I often work with pivot tables that have URLs as rows of data, and the URLs can be quite long. In the past, whenever I changed the data and refreshed the pivot table, Excel would automatically resize the column width, making the column as wide as the longest URL. This pushed all my other data to the right and out of view. To see it, I had to scroll--an extra eye-wearying, time-consuming step. 

Right-click in the pivot table 

Select Pivot Table OptionsIn the Pivot Table Options dialogue box, click the Layout and Format tab, and then uncheck the box Autofit column widths on update.

Now the column width doesn't change each time the pivot is refreshed, but now you need to define how wide the column with the URLs should be.

Go back to your pivot and select the column with the long URLs. Right-click, and enter a value for the column width. 

Now when you refresh the pivot table, the column doesn't resize. Instead its width corresonds to the value you entered.

View the original article here

Quick Trick: Resizing column widths in pivot tables

AppId is over the quota
AppId is over the quota

(Who could be better than a Business Intelligence analyst at teaching us a thing or two about Excel? We asked our own number-crunching wizard Stacey Armstrong to share some Excel tricks she's learned along the way..)

I often work with pivot tables that have URLs as rows of data, and the URLs can be quite long. In the past, whenever I changed the data and refreshed the pivot table, Excel would automatically resize the column width, making the column as wide as the longest URL. This pushed all my other data to the right and out of view. To see it, I had to scroll--an extra eye-wearying, time-consuming step. 

Right-click in the pivot table 

Select Pivot Table OptionsIn the Pivot Table Options dialogue box, click the Layout and Format tab, and then uncheck the box Autofit column widths on update.

Now the column width doesn't change each time the pivot is refreshed, but now you need to define how wide the column with the URLs should be.

Go back to your pivot and select the column with the long URLs. Right-click, and enter a value for the column width. 

Now when you refresh the pivot table, the column doesn't resize. Instead its width corresonds to the value you entered.

View the original article here

Working with tables in the new Word

AppId is over the quota
AppId is over the quota

Today's post comes from Caitlin Ashley-Rollman, the program manager on the Word team responsible for improving our Tables experience.

It’s all about the little things. 

For this release of Word, we wanted to make your lives a little bit easier by simplifying the tasks you do every day. Since tables play an important role in many documents, they seemed like a good place to start. In our improvements to tables for the new Word, we focused on making it easier for you to create and format basic tables. 

When we started looking into the most common things people do to tables, adding new columns and rows was at the top of the list. 

As a result, we added insert controls that appear right outside your table between two existing columns or rows. Just click on it when it appears, and a new column or row will be inserted at that location.

If you know you want more than one column or row, just select the number you want to insert and click the insert control on the edge of the selection—it’s that easy.

In addition to adding new content, an important part of working with tables is getting them to look the way you want. 

The formatting of the tables in your document can have a huge impact on how polished and professional it looks. To help you pick the right design, we’ve changed the organization of the table styles gallery so that you can easily pick between table styles that work well for presenting lists and those that are designed for data in a grid. In addition, we refined the table styles themselves—including adding a few basic black and white styles for those times when you want the table to sit quietly in your text.

While Table Styles can be a good start to formatting your table, they aren’t specific to your content so you may find that you want to make a few tweaks. For example, sometimes you want to outline a specific cell, or create separate sections within a single table. From user feedback, we know the current methods have intricacies that make the process seem more complicated than it needs to be. With this in mind, we created three new features to make the experience quicker, easier, and more natural.

Border Painter

First, we created a new tool called the Border Painter that is designed to make it easy for you to apply formatting to specific borders in your table. Just choose your formatting, then with the Border Painter active, click on any table border to apply the formatting. You can also click and drag your mouse to apply the formatting to a whole line.

For those of you who have used the Draw Table tool, this is essentially the same thing except it doesn’t create new cells so you can apply formatting with confidence.

Borders Gallery

Second, we now have a gallery of pre-created borders that are designed to work with the new table styles. This gallery combines border widths, colors, and sizes so you choose everything with one click. Just like table styles, they will change color if you change your theme so they always match.

Once you pick a border, we’ll automatically turn on the Border Painter tool so you can go right to applying the formatting to your table.

The handiest part of this gallery is the recently used section that displays all the borders you’ve applied in the current session of Word. It’s great when you need to reuse a few different border styles.

Border Sampler

Probably my favorite feature this release is the border sampler (located at the bottom of the Border Styles gallery). I like to think of it as an eyedropper tool for table borders – all you need to do is activate the tool then click on a table border that you want to sample. It’ll capture the border’s formatting and automatically switch you to the Border Painter tool so you can apply it somewhere else.

I hope you enjoy the new features and, more importantly, find tables in Word 2013 more enjoyable to work with. Tell us what you think in the comments below.

The Tables feature crew is excited to share all this work with you!

View the original article here

Create shapes with tables inside (video)

AppId is over the quota
AppId is over the quota

This is the twelfth in a series of quick video tips for business managers using PowerPoint by guest blogger Bruce Gabrielle, author of Speaking PowerPoint.

Using SmartArt graphics, you can create a pyramid with text rows. But what if you want an upside down triangle, or a circle, or a hexagon instead? Here are a couple of neat tricks for creating your own custom shapes with table rows inside.

Looking for more info about using tables and SmartArt graphics in PowerPoint? Try these links:

-- Bruce Gabrielle

View the original article here

Create shapes with tables inside (video)

AppId is over the quota
AppId is over the quota

This is the twelfth in a series of quick video tips for business managers using PowerPoint by guest blogger Bruce Gabrielle, author of Speaking PowerPoint.

Using SmartArt graphics, you can create a pyramid with text rows. But what if you want an upside down triangle, or a circle, or a hexagon instead? Here are a couple of neat tricks for creating your own custom shapes with table rows inside.

Looking for more info about using tables and SmartArt graphics in PowerPoint? Try these links:

-- Bruce Gabrielle

View the original article here

Format your information Publisher tables

Information is often to consume much easier for the reader if it in a table-no, not restaurant table-tabular rows and columns. For example, check out how much easier is this list of products and prices, if to follow it in a simple table. First the list:

Rhododendron: $15 / foot; Vine Maple: $5 / foot; Maple: $10 / foot; Dogwood (white): $12 / foot; Dogwood (Pink): $15 / foot; Subalpine FIR: $18 / foot; Deodara Cedar: $20 / foot.

And now the same information in a simple table:

This table is still boring and not really easy to read, so little flair to make it more readable by you add some color, borders, and other color and weight of the font of the text.

 

The point in this exercise, is obviously that easily, you can do this with Publisher, make your catalogs, newsletters, flyers, easier and more appealing to read coupons, and what you need to communicate. In Publisher 2003 and 2007, you select the table or cells in the table and right mouse button, the format table dialog box get to change the fill and border lines.

In Publisher 2010 you can format still tables in this way, but we have shown nowdesign , which on the Ribbon the table toolstab, is when you create or select a table. This tab has a gallery of predefined table formats. If you hover over each gallery selection, you see a preview of what your table looks like when you choose this format.

--Bob deLaubenfels

View the original article here

Sorting and filtering grade book data by using Excel tables (video)

Translate Request has too much data
Parameter name: request
Translate Request has too much data
Parameter name: request
a.stbar.chicklet img {border:0;height:16px;width:16px;margin-right:3px;vertical-align:middle;}a.stbar.chicklet {height:16px;line-height:16px;}Office in Education - Sort and filter grade book data using Excel tables (video) JoinSign in      The Microsoft Office Blog About RSS Atom


Home Blogs


Chris Bryant

Crabby Office Lady

Microsoft Access

Microsoft Excel

Microsoft OneNote

Microsoft Outlook

Microsoft PowerPoint

Microsoft Publisher

Microsoft Word

Office Casual

Office Comics

Office in Education

Office Show

Office VP

Templates and Images

The Microsoft Office Blog




Office.com Home » Office in Education » Sort and filter grade book data using Excel tables (video) Home Blogs Files

Office in Education

News, tips, and tricks for students and teachers who use Microsoft Office

 

 

Sort and filter grade book data using Excel tables (video) Matt Shelton 16 Mar 2011 8:22 AM Comments 0

If you find yourself banging your head on your desk when it comes time to sort and filter student data in your grade book, Excel tables can make your life less stressful. Tables let you sort student test scores (for example, from lowest to highest), calculate average scores on assignments, and add special formatting to your spreadsheet. Converting your existing grade book into a formatted table is quick and easy. You supply the student data, and Excel does the heavy lifting.

This video will get you started. If you want to get more in-depth, there's an entire training course devoted to Excel tables.

If you want to learn more about Excel, take a look at the Microsoft Excel blog.

--Matt Shelton

0 Comments education, teachers, Excel ShareThis

 

You must sign in to leave a comment. Sign in or join now.

© 2010 Microsoft Corporation. All rights reserved. Legal | Trademarks | Privacy Statement

View the original article here

She asked pivot tables (video)

So many Office customers questions "Pivot table", that we have collected the best answers in this blog post. Most likely, you are on the search for information about creating a PivotTable report, which help to summarize and analyze your data. Or you already have your data in a PivotTable report and are looking for information about how you swing it.

Example of a PivotTable report

Following a three step process insert a PivotTable report based on your worksheet data, you will learn in Quick start: create a PivotTable report.

To the full scoop on PivotTables and PivotCharts), or to create a PivotTable based on an external data source, you should instead the instructions under create or delete a PivotTable or PivotChart report follow.

Because pivot tables are not easy to understand, the following video can be useful.

Are you new to pivot tables? In this case I really recommend that you popular with this training written by my colleague, Judi Hurlock, PivotTable I: get started with PivotTable reports in Excel 2007start. It helped me definitely when I started.

If you are using an earlier version of Excel, you can also this article Pivot, Swivel, and role of Crabby Office Lady, which enjoy the flexible offers an interesting overview of PivotTables little contortionists of the data world!

Excel is the Office application for detailed analysis of data use, but if you keep your data in an Access database, you can pan it there also. The article create or delete a PivotTable or PivotChart report should facilitate entry.

After you create a PivotTable report, it is useful, that you want to pivot the data to view it from different angles. Unfortunately, in order to better the actual features correspond to the "PivotTable data with this", we have another article title for a Weile--we it "change the layout of a PivotTable report" which from made to find it hard if you were looking for information about pivotieren data used.

But now it is again as Pivot data in a PivotTable report, to find which should be in the search for it!

I hope this provides answers to your questions about pivot table. If there are other ideas out there, or you have a good tip about the use of pivot tables, we would look forward to hearing from you!

-Frederique Klitgaard

View the original article here