Welcome to TechNet Blogs Sign in | Join | Help

Browse by Tags

All Tags » excel   (RSS)
Thursday, September 17, 2009 7:32 PM

Previewing Office Online Web Apps…”Impressive”

Techcrunch has a really good preview of our new browser-based version of Word, PowerPoint, Excel, and Onenote.  At the moment it is being rolled out for free to some Live Skydrive users.  The public beta is happening in early 2010 but if you’re
Posted by Viral Tarpara | 0 Comments
Friday, September 04, 2009 6:55 PM

Office 2010 Tips - Create Super PivotTables in Excel with “Slicer”

Zero in on the right data points, faster. Excel 2010 delivers new and exciting slice-and-dice capabilities. The Slicer feature provides you with a rich visualization of your PivotTable view so you can dynamically segment and filter the data to display
Posted by Viral Tarpara | 0 Comments
Filed under: , , , ,
Tuesday, September 01, 2009 11:54 AM

Office 2010 Tips - Faster search in Excel Tables and PivotTables

Faster search in Excel Tables and PivotTables Microsoft Excel 2010 gives you new and faster searches in Tables, PivotTables, and AutoFilters with a streamlined way to look through large amounts of data and create new filters. So even if you have a report
Posted by Viral Tarpara | 0 Comments
Friday, August 28, 2009 4:31 PM

Office 2010 Tips – Edit Your Pictures with Photo Filters in Office

Create eye-catching visual effects in a flash Throughout Microsoft Office 2010, you’ll find new and popular tools to create high impact visuals to make your work really pop.  And they take just moments to use.  Pictures speak a thousand words
Posted by Viral Tarpara | 0 Comments
Thursday, August 20, 2009 2:20 PM

Office 2010 Tips & Tricks – Visual Trending in Excel

Share and Analyze Data Faster Use Excel 2010 as your Business Intelligence tool. New features like Sparklines and Data Bars help you present and compare trends in seconds. Whether sorting through sales revenue results or your favorite team’s last few
Posted by Viral Tarpara | 0 Comments
Wednesday, May 13, 2009 2:11 PM

Want to Preview Office 2010?

It’s that time again where Microsoft is close to showing off the latest and greatest productivity software!  There are so many things in Office 2010 I want to tell you about but can’t; however, I encourage you all to register to gain access to the
Posted by Viral Tarpara | 0 Comments
Wednesday, April 29, 2009 6:58 PM

The Only Office 2007 SP2 Blog Post You Need to Read

Credit goes to Gray Knowlton for writing this very comprehensive post on the service pack release.  Notable features include: ODF 1.1 support Saving in PDF and XPS File Format Converter Improved Outlook Performance (back ported from Outlook 14) Better
Posted by Viral Tarpara | 0 Comments
Tuesday, March 03, 2009 1:40 PM

Tip of the Day – Excel: Fill in Blanks in the Spreadsheets the Easy Way

Fill In the Blanks in Spreadsheets the Easy Way Select all the rows in your Microsoft Office Excel spreadsheet data set. On the Home tab, in the Editing section, click Find & Select, click Go To, click Special, click Blanks, and then click OK. Click
Posted by Viral Tarpara | 0 Comments
Filed under: , ,
Wednesday, December 10, 2008 2:38 PM

Excel Junkies Unite for a Day of Tea, Coffee, and Some Exciting Pivot Tables

Mark you calendars for April - UK Excel User Group Meeting Wednesday 1 st April 2009 and Thursday 2 nd April 2009 Microsoft London (Cardinal Place) 100 Victoria Street London SW1E 5JL Tel: 0870 60 10 100 An exciting opportunity to see presentations by
Posted by Viral Tarpara | 1 Comments
Monday, October 13, 2008 10:25 PM

Tip of the Day – Excel 2007: How to Add a Watermark to a Spreadsheet

Watermarks are very useful when documents need to be printed out in a secure manner.  Watermarks can describe confidentiality, intended recipients, and even the quality of the document, like a draft, so that the reader is fully aware of how the document
Posted by Viral Tarpara | 0 Comments
Filed under: , ,
Friday, October 03, 2008 12:44 PM

Tip of the Day – Visio 2007: Creating Rich Diagrams that are Dynamic from Excel Data

Generate a PivotDiagram from Excel Data In Microsoft Office Visio Professional 2007, you can now generate a PivotDiagram from data such as a Microsoft Office Excel worksheet. A PivotDiagram has very similar functionality to an Excel PivotTable, but it
Posted by Viral Tarpara | 0 Comments
Filed under: , , ,
Tuesday, September 02, 2008 2:31 PM

Tip of the Day - Excel 2007: Quickly Changing Gridlines Colors

Changing Gridline Colors You can change the look of your worksheet. With a Microsoft Office Excel worksheet open, click the Office button, click Excel Options , and then click Advanced . Under Display options for this worksheet , select the gridline color
Posted by Viral Tarpara | 0 Comments
Filed under: , ,
Tuesday, August 26, 2008 1:29 PM

Tip of the Day - Excel 2007: Quickly Replicate Cells

Fill a Selected Range with the Same Data Need to enter the same data in a range of cells? Here’s how: Select a range of cells. Type in some data. Use the fill function in Microsoft Office Excel—press CTRL+ENTER , and the range selected will
Posted by Viral Tarpara | 0 Comments
Filed under: , ,
Monday, August 25, 2008 1:22 PM

Tip of the Day - Excel 2007: How to Print a Portion of a Spreadsheet

Setting the Print Area in Microsoft Office Excel Have you ever wanted to print only certain rows or columns from a spreadsheet? Here’s how: With a spreadsheet open, select all the rows or columns that you want to print. On the Page Layou t tab,
Posted by Viral Tarpara | 0 Comments
Filed under: , ,
Sunday, August 24, 2008 1:01 PM

Tip of the Day - Excel 2007: Create a Linear Series of Values

Create a Linear Series of Values in Excel Here’s how to use Auto Fill to create a series of values: Create the initial series. In a Microsoft Office Excel workbook, type 1 in the A1 cell and 2 in the A2 cell. Select cells A1 and A2. Click the Auto Fill
Posted by Viral Tarpara | 0 Comments
Filed under: , ,
 
Page view tracker