| MS Office News & RSS Feeds |
AdvancedFilter- AdvancedFilter Method
- AdvancedFilter Method [Excel 2007 Developer Reference]
- AdvancedFilter Method
- AdvancedFilter Method [Excel 2003 VBA Language Reference]
- Excel AdvancedFilter - MSDN Forums
- NamedRange.AdvancedFilter Method (Microsoft.Office.Tools.Excel)
- NamedRange.AdvancedFilter Method (2003 System) (Microsoft.Office ...
- NamedRange.AdvancedFilter Method (2007 System) (2007 System)
- MSDN .NET Base Class Library custom AdvancedFilter for System ...
- AutoFilter Method [Excel 2007 Developer Reference]
- AutoFilter Method [Excel 2003 VBA Language Reference]
- PasteSpecial Method [Excel 2007 Developer Reference]
- AddComment Method [Excel 2007 Developer Reference]
- ListNames Method [Excel 2007 Developer Reference]
- ClearComments Method [Excel 2007 Developer Reference]
- ApplyOutlineStyles Method [Excel 2007 Developer Reference]
- ShowAllData Method [Excel 2007 Developer Reference]
- Clear Method [Excel 2007 Developer Reference]
- FunctionWizard Method [Excel 2007 Developer Reference]
- search
Array Formulas- XL2000: Cannot Paste Array Formula in Its Original Cell
- XL97: Cannot Paste Array Formula in Its Original Cell
- XL98: Cannot Paste Array Formula in Its Original Cell
- XL97: Page Fault Pasting Array Formula Between Workbooks
- XL97: Array Formula Using Merged Cells Is Calculated Incorrectly
- When to use a SUM(IF()) array formula
- No calculation occurs when an array formula includes a large range in ...
- You cannot share an Excel workbook that contains an array formula that ...
- Formula to Count the Number of Rows in Which an Item Appears
- XL2000: Formula to Count the Number of Rows in Which an Item Appears
- Run-time error using FormulaArray property
- XL97: Run-Time Error Using FormulaArray Property
- Description of the limitations for working with arrays in Excel
- Maximum array size in Excel for Mac
- XL2000: Formula to Sum Digits of a Number
- XL: Some Worksheet Functions Do Not Allow Array Constants
- XL98: Formula Is Not Recalculated After Paste Special Operation
- XL97: Formula Is Not Recalculated After Paste Special Operation
- XL98: Some Worksheet Functions Do Not Allow Array Constants
- Description of the formula to sum digits of a number in Excel for Mac
AutoFilters- AutoFilter Method
- AutoFilter Property
- AutoFilter Method [Excel 2007 Developer Reference]
- AutoFilter Property [Excel 2007 Developer Reference]
- AutoFilter Property
- AutoFilter Object [Excel 2007 Developer Reference]
- AutoFilter Status Bar Message Shows "Filter Mode"
- PRJ98: AutoFilter Shows Wrong Tasks Using Next Month AutoFilter
- AutoFilter Object
- XL2000: Recorded AutoFilter Macro Does Not Filter Dates Correctly
- AutoFilter Method
- AutoFilter Object
- Custom AutoFilter Won't Filter Numbers Formatted as Text
- XL97: Recorded AutoFilter Macro Does Not Filter Dates Correctly
- XL: AutoFilter List Hides Rows Even After Information Cleared
- XL: How to Display Top 10 Records with a Macro
- XL2000: Recorded AutoFilter Macro Does Not Filter Dates That Meet ...
- AutoFilter Property
- XL97: How to Remove Individual AutoFilter Drop-Down Lists
- XL98: AutoFilter List Hides Rows Even After Information Cleared
Conditional Formatting- XL2000: Conditional Formatting Applies Only to the First Character in ...
- XL97: Conditional Formatting Not Saved When Saving as HTML
Countif Functions- XL2000: SUMIF and COUNTIF Functions Return Incorrect Results When Used ...
- COUNTIF/SUMIF Wrong If Cell Has Single Apostrophes
- SUMIF, COUNTIF, COUNTBLANK Return #VALUE! Error
- XL: Some Worksheet Functions Do Not Allow Array Constants
- XL98: Some Worksheet Functions Do Not Allow Array Constants
- XL98: SUMIF, COUNTIF, COUNTBLANK Return #VALUE! Error
- XL98: COUNTIF Returns Incorrect Value When It Refers to Blank Cells
- XL2000: COUNTIF Returns Incorrect Value When It Refers to Blank Cells
- XL97: SUMIF, COUNTIF, COUNTBLANK Return #VALUE! Error
- XL97: COUNTIF Returns Incorrect Value When It Refers to Blank Cells
- XL2000: Calculation Differences Between the Office Spreadsheet and ...
- Excel 2004 for Mac Solution Center
- Excel 2004 for Mac Solution Center
- How to count the occurrences of a number or text in a range in Excel ...
- Excel 2004 for Mac Solution Center
- Excel 2004 for Mac Solution Center
- Errors Saving File to Earlier Formats
- Excel 2004 for Mac Solution Center
- Excel 2004 for Mac Solution Center
- XL2000: Errors Saving File to Earlier Formats
Custom Functions- How to use custom functions with the Spreadsheet component
- Methods to Use Custom Functions with Varying Arguments
- XL97: Calculation Problems with Arrays in Custom Functions
- Description of limitations of custom functions in Excel
- Evaluate Method Affects Volatility of Custom Functions
- XL2000: Methods to Use Custom Functions with Varying Arguments
- XL: How to Use a Custom Function in Another Workbook
- XL2000: How to Use a Custom Function in Another Workbook
- XL2000: Calculation Problems When Custom Function Creates a Defined ...
- HOW TO: Create Functions to Calculate Light Years in Excel 2000
- XL2000: How to Display a Custom Function in Step 2 of the Function ...
- XL98: How to Display Custom Function in Function Wizard Step 2
- XL97: ROW And COLUMN Functions Are Not Recalculated
- XL97: How to Display Custom Function in Function Wizard Step 2
- XL2000: Cannot See User-Defined Function in the Paste Function Dialog ...
- XL98: Using Calculate Method May Not Calculate Certain Formulas
- XL2000: How to Add a New Category to Function Category List
- XL2000: Recalculation of UDFs and XLLs Gives Unexpected Results That ...
- XL2000: Syntax Errors When Calculating Functions or Opening a Workbook
- PRB: Automation Add-In Function Binds to Excel Built-In Function with ...
Database Functions- Multiple Databases and Criteria in Database Functions
- XL97: DFunctions Return Errors When Database Has Too Many Rows
- XL98: Dfunction Incorrectly Returns Zero
- ACC: VBA Functions Break in Database with Missing References
- How to use Microsoft Excel data tables to analyze information in a ...
- ACC2000: VBA Functions Break in Database with Missing References
- XL: Some Worksheet Functions Do Not Allow Array Constants
- XL98: Some Worksheet Functions Do Not Allow Array Constants
- Visual Basic for Applications (VBA) functions break in a database with ...
- XL98: Overview of ODBC Add-in Functions and Arguments
- Excel statistical functions: DVAR, DVARP, DSTDEV, and DSTDEVP
- XL98: Advanced Filter Does Not Detect Additions to List
- XL: Overview of ODBC Add-in Functions and Arguments
- Advanced Filter Does Not Detect Additions to List
- AppNote XE0210: Creating and Using Tables
- XL2000: Calculation Differences Between the Office Spreadsheet and ...
- Description of ODBC add-in functions and arguments in Excel 2000
- XL98: Cannot Use Scalar Functions in Microsoft Query
- XL7: Template Wizard Functions Show Up in Function Wizard
- Macro Examples Using XLODBC Functions
Date Time Functions- Excel 2004 for Mac Solution Center
- How to use dates and times in Excel
- Excel 2004 for Mac Solution Center
- Excel 2004 for Mac Solution Center
- XL: How to Display the Current Date and Time with Text
- Excel 2003 Solution Center
- How to use dates and times in Excel for Mac
- Excel 2004 for Mac Solution Center
- Implementing Week-Numbering Systems and Date/Time Representations in ...
- XL2000: Wrong Date Returned When You Enter Month and Digits
- The Last Modified date and time value is automatically updated when ...
- XL2002: FRN: Solver.xla Is Missing the VBA Functions
- Excel 2004 for Mac Solution Center
- Not all Excel worksheet functions are supported as methods of the ...
- Calling User-Defined Functions from DLLs
- DateValue Function Doesn't Accept Date Literals
- Not All Worksheet Functions Supported as Application
- Works: Spreadsheet Functions Imported from Excel 2000 to Works
- XL2000: Drawings in Files That Are Created in Versions of Excel Before ...
- Macro Examples Using XLODBC Functions
David Gainers Blog- Building an Asset Tracking Application in Excel Services – Part 3b of 5
- Community Clips
- Building an Asset Tracking Application in Excel Services – Part 3a of 5
- Building an Asset Tracking Application in Excel Services – Part 2 of 5
- VBA Focus Group at TechEd
- Building an Asset Tracking Application in Excel Services – Part 1 of 5
- Ten Tips for Using Excel Services
- New Technical Article on Excel Services
- PivotTables: Calculated Items
- Append Multiple Text Files into a Worksheet without Code
- Improving Sheet Selection
- Building the Excel Media Player – Part 3
- Building the Excel Media Player – Part 2
- Building the Excel Media Player – Part 1
- Understanding Floating Point Precision, aka
Downloads- Sample: Using MAPI to Create Outlook 2007 Items
- Sample: Integrating Web Services into Your Office Business Applications
- Integrating Virtual Earth Maps and Excel 2007 Using Visual Studio 2005 Tools for Office Second Edition
- Open XML Format SDK April CTP
- Office Protocol Documentation
- Exchange 2007: Exchange Protocol Documentation
- SharePoint Products and Technologies Protocol Documentation
- Office Business Applications Sample Application Kit for SAP 2.0
- Windows SharePoint Service 3.0 (version 1.3)
- 2007 Office System Document: Open XML Developer Map
- Sample: 2007 Office System Business Application: Sales Proposal Document Management
- Sample: 2007 Office System Business Application: Customer Service Request Management
- 2007 Microsoft Office Interactive Developer Map 2.0
- Download: Project 2007 SDK (Dec 07 refresh)
Excel 2007 Solution Center- Description of the 2007 Office hotfix package: February 14, 2008
- When you minimize Word 2007 or Excel 2007 on a remote computer that is running Windows Server 2003 Service Pack 2, the minimized window is missing items
- Description of the Excel 2007 hotfix package: December 13, 2007
- How to contact a Microsoft Product Activation Center
- Description of the Excel 2007 hotfix package: February 18, 2008
- Description of the Excel 2007 hotfix package: March 25, 2008
- When you import an event log file into Excel 2007 on a Windows Server 2008-based computer, event logs are not readable
- How to obtain the latest service pack for the 2007 Office suite
- Description of the Excel 2007 hotfix package: February 18, 2008
- Description of the Excel 2007 hotfix package: March 21, 2008
- Description of the Excel 2007 hotfix package: March 13, 2008
Excel Counting Functions- Excel 2004 for Mac Solution Center
- Excel 2004 for Mac Solution Center
- Calling into Excel from the DLL/XLL
- Excel 2004 for Mac Solution Center
- Excel 2004 for Mac Solution Center
- Improving Performance in Excel 2007
- Excel 2004 for Mac Solution Center
- Excel 2004 for Mac Solution Center
- Excel 2004 for Mac Solution Center
- XL2000: COUNTIF Returns Incorrect Value When It Refers to Blank Cells
- XL98: COUNTIF Returns Incorrect Value When It Refers to Blank Cells
- Office Automation Using Visual C++
- XL97: COUNTIF Returns Incorrect Value When It Refers to Blank Cells
- OddLYield Method [Excel 2007 Developer Reference]
- Using Visual C++ to automate Office
- Search Method [Excel 2007 Developer Reference]
Excel Statistical Functions- Excel statistical functions: VARP
- Excel statistical functions: NORMINV
- Excel statistical functions: LOGNORMDIST
- Excel statistical functions: LOGEST
- Excel Statistical Functions: NORMSINV
- Excel Statistical Functions: POISSON
- Excel statistical functions: STDEVP
- Excel statistical functions: NEGBINOMDIST
- Excel statistical functions: GROWTH
- Excel statistical functions: CRITBINOM
- Excel statistical functions: TREND
- Excel statistical functions: VAR
- Excel statistical functions: SLOPE
- Excel statistical functions: FINV
- Excel statistical functions: VAR and VARP improvements and data ...
- Excel statistical functions: BINOMDIST
- Excel statistical functions: INTERCEPT
- Excel Statistical Functions: HYPGEOMDIST
- Excel statistical functions: STEYX
- Excel statistical functions: LOGINV
Excel OR Spreadsheet OR Googledocs OR "Google docs " - Google News - SPORTS BRIEFS - Coshocton Tribune
- Felmy endures long rides for shot - Danville News
- Sports Recap - TV Sports Daily
- General Manager - ArabianBusiness.com
- Let's run risk of kids having fun - Sunday Sun
- Michael Arace commentary: Man of science, Schoeni throws himself ... - Columbus Dispatch
- Business calendar - Jackson Sun
- China's gymnasts tipped to excel before home crowd - Macau Daily Times
- Who Has Stolen the Old Jerry Yang? (But No Need to Return Him!) - All Things D Blogs
- Human Resources MENASHA Innovative Packaging - Quad City Times
Featured On MSDN- Create and Customize Reports for Visual Studio Team Foundation Server
- Code Review: Find and Fix Vulnerabilities Before Your Application Ships
- Manipulate Excel 2007 and PowerPoint 2007 Files with the Open XML Object Model
- Take Advantage of the Security Features in Windows Vista
- Best Practices: Common Coding Issues When Using the SharePoint Object Model
- Extend Windows PowerShell with Custom Commands
- Get a 90-Day Trial of Visual Studio 2008
- Build Applications for Facebook with the .NET Compact Framework
- Encapsulate Silverlight with ASP.NET Controls
- HTTP Programming with WCF and the .NET Framework 3.5
- Working with Code in Windows SharePoint Services 3.0 (Part 2 of 2)
- New to development? Visit the Beginner Developer Learning Center
- Build Office-Based Solutions Using WPF, WCF, and LINQ
- Have You Tried Silverlight Yet?
- Microsoft Foundation Class (MFC) Beta Now Available
Featured Resources- Deliver Modular Workflow Functionality in SharePoint Server 2007 (Part 1 of 2)
- Deliver Modular Workflow Functionality in SharePoint Server 2007 (Part 2 of 2)
- Use MAPI to Create Outlook 2007 Items
- Silverlight Web Parts Developed in ASP.NET for MOSS 2007
- Use the Visual Studio Tools for the Office System Power Tools Version 1.0.0.0
- Edit Business Data Using Business Data Catalog Actions and InfoPath Forms Services
- Deploy Visual Studio Tools for the Office System 3.0 Solutions for the 2007 Microsoft Office System Using Windows Installer (Part 1 of 2)
- Deploy Visual Studio Tools for the Office System 3.0 Solutions for the 2007 Microsoft Office System Using Windows Installer (Part 2 of 2)
- Introduction to SharePoint Products and Technologies for the Professional .NET Developer
- Book Excerpt: Managing Complex Business Processes with Custom SharePoint Workflow
- Build and Distribute Workflows in SharePoint Products and Technologies for Use in Customer and Partner Environments
- Book Excerpt: Integrating Web Services into Your Office Business Applications
- Understand the Report Center and Dashboards in SharePoint Server 2007
- Ten Tips for Using SharePoint Server 2007 with Excel Services
- Develop Workflow Solutions with SharePoint Server 2007 and Windows Workflow Foundation
- Book Excerpt: Searching Outlook Data
- Book Excerpt: Address Books and Recipients
- Book Excerpt: Outlook as a Platform
- Book Excerpt: Creating Form Regions
- Integrate Virtual Earth Maps and Excel 2007 Using Visual Studio 2005 Tools for Office Second Edition (Part 2 of 2)
Financial Functions- Basis Argument for Financial Functions
- XL97: Financial Functions Return #NUM! If Dates After Year 2078
- XL98: Basis Argument for Financial Functions
- XL2000: Some Financial Functions May Return Incorrect Results with ...
- XL2000: Basis Argument for Financial Functions
- XL: Adjusting the Period of Financial Functions
- Algorithms Used in the ATP Functions
- XL: Examples of Interest Calculations Outside the United States
- XL2000: Algorithms Used in the ATP Functions
- XL97: How to Use the EFFECT and NOMINAL Functions to Calculate Loan or ...
- XL98: Using NPV() or Solver to Find Guess for IRR()
- XL2000: Overview and History of Excel 2000 Updates
- Ispmt Method [Excel 2007 Developer Reference]
- OFFAUTMN.exe discusses Office 97 and 2000 Automation and provides ...
- How to set up and use the RTD function in Excel
- Npv Method [Excel 2007 Developer Reference]
- Developing Add-ins (XLLs) in Excel 2007
- xlfRegister (Form 1)
- XL2000: ODDFYIELD Returns #NUM with Online Help Example
- XL: How to Find Technical Information About Microsoft Excel
How Do I Videos- Build State Machine Document Approval Workflows for SharePoint Server 2007 Using Visual Studio 2008
- Build an Expense Report Approval Workflow for SharePoint Server 2007 Using VS 2008
- Configure and Deploy Workflows to SharePoint Server 2007 Using a Solution Package
- Create Custom Workflow Activities for SharePoint Server 2007 Using Visual Studio 2008
- Update Document Information Panels for Content Type Changes in SharePoint Server 2007
- Create Custom Routers in SharePoint Server 2007
- Create a Custom Expiration Formula Based On Metadata in SharePoint Server 2007 (Part 2 of 2)
- Create a Custom Expiration Formula Based On Metadata in SharePoint Server 2007 (Part 1 of 2)
- Configure Multiple Authentication Mechanisms with Alternate Access Mappings in Windows SharePoint Services 3.0
- Automate Solution Package Creation for Windows SharePoint Services Using MSBuild
- Create Document Libraries from List Items in Windows SharePoint Services 3.0
- Batch Update List Items in Windows SharePoint Services 3.0
- Use Secondary Lists to Maintain Relationships in SharePoint Server 2007
- Use Custom Fields to Display Relationships in SharePoint Server 2007
- Use Metadata Tags to Route Documents to SharePoint Document Libraries
- Display Search Results In Grid Views in SharePoint Server 2007
- Generate Unique IDs in Windows SharePoint Services 3.0
- Deploy ASP.NET Web Applications in the Windows SharePoint Services 3.0 _layouts Folder
- Use Smart Clients to Communicate with Windows SharePoint Services Workflows
- Customize Page Editing Toolbar Components in SharePoint Server 2007
How do I....- How Do I: Create a Splash Screen in an MFC Application?
- How Do I: Associate an Application with the Hardware Buttons on a Windows Mobile Device?
- How Do I: Use LINQ To SharePoint to Retrieve SharePoint Data?
- How Do I: Add Code Snippets to My Language Service?
- How Do I: Analyze Work Items Using Microsoft Excel?
- How Do I: Learn the Principles Object-Oriented Programming?
- How Do I: Add User Defined States?
- How Do I: Enable an Office Application Add-In using a VSTO Add-in?
- How Do I: Add Intellisense to a Language Service?
- How Do I: Perform Code Analysis in a Visual C++ Project?
- How Do I: Implement CScrollView in an Application?
- How Do I: Use the GPS Intermediate Driver to Retrieve Location Information?
- How Do I: Work With Other Combo Box Types?
- How Do I: Create and Run Unit Tests in Visual C++?
- How Do I: Change the Mouse Cursor in an Microsoft Foundation Class Application?
- How Do I: Run Smart Device Unit Tests from a Command Prompt?
- How Do I: Attach to and Automate a Running Instance of Another Application?
- How Do I: Create Custom Project Templates Using Visual Studio 2008?
- How Do I: Use the Checksum and ExpectedSchema Database Test Conditions?
- How Do I: Use Hyperlinks for Navigation Inside Excel?
Just Published- .NET Rocks! - Live from the Canadian Vista Launch Events!
- Download: SharePoint Server 2007 Videos: Enterprise Search Deep Dive Labs
- Guide to InfoPath 2007 Developer Documentation
- Extending SQL Server Reporting Services with SQL CLR Table-Valued Functions
- Visual Studio 2005 Tools for Office Sample: Deploying Visual Studio 2005 Tools for Office Solutions Using Windows Installer
- Deploying Visual Studio 2005 Tools for Office Solutions Using Windows Installer (Part 1 of 2)
- Visual How to: Use Office Open XML File Formats to Retrieve a List of Excel 2007 Worksheets
- Visual How to: Office Open XML Formats: Retrieving Excel 2007 Cell Values
- Sample: 2007 Office Sample: Setting Up a Development Environment
- Setting Up a Development Environment for the 2007 Microsoft Office System
- OfficeTalk: Conditional Formatting: Adding Customized Rules to Excel 2007
- Free Windows Vista Ultimate for All MIX07 Attendees
- .NET Rocks! - Ted Neward on Interoperability
- Tutorial 12: Using TemplateFields in the GridView Control (VB)
- Feature Changes in ASP.NET 2.0
- Download: 2007 Office Sample: Visual Studio Visual Basic Code Snippets for the Office Fluent UI
- Tutorial 17: Examining the Events Associated with Inserting, Updating, and Deleting (VB)
- Win Cool Home Music Gear with MSDN Flash
Logical Functions- XL97: Page Fault Using Formula Containing Boolean Functions
- XL97: New A Functions in Microsoft Excel 97
- How to use a logical AND or OR in a SUM+IF statement in Excel
- XL98: New A Functions in Microsoft Excel 98 Macintosh Edition
- How to use A functions in Excel
- Description of ODBC add-in functions and arguments in Excel 2000
- XL: Overview of ODBC Add-in Functions and Arguments
- XL98: Results Do Not Change After Toggling Transition Formula ...
- XL97: Results Do Not Change After Toggling Transition Formula ...
- Excel 2004 for Mac Solution Center
- When to use a SUM(IF()) array formula
- Excel statistical functions: BINOMDIST
- Excel Statistical Functions: POISSON
- Excel statistical functions: TREND
- How to Use VLOOKUP or HLOOKUP to find an exact match
- Excel statistical functions: GROWTH
- Excel statistical functions: LOGEST
- SQL.REQUEST and SQLREQUEST Function Syntax Differences
- XL98: Range_Lookup Argument in VLOOKUP() Finds Exact Match
- How to find data in an Excel table
Lookup Functions- XL97: Linked Files with Lookup Functions Updated Much More Slowly Than ...
- XL2000: Linked Files with Lookup Functions Updated Much More Slowly ...
- XL98: Range_Lookup Argument in VLOOKUP() Finds Exact Match
- XL: How to Perform a Case-Sensitive Lookup
- How to Perform a Case-Sensitive Lookup
- XL97: Range_Lookup Argument in VLOOKUP() Finds Exact Match
- How to Use VLOOKUP or HLOOKUP to find an exact match
- XL98: Incorrect LOOKUP() Results with Formula in Lookup_Vector
- XL98: Returning the First or Last Match in an Array
- XL98: Unexpected Results with Mixed Text and Numbers in Lookup Table
- Unexpected Results with Mixed Text and Numbers in Lookup Table
- HLOOKUP, VLOOKUP, LOOKUP return incorrect values in Excel
- XL: How to Return the First or Last Match in an Array
- How to use the LOOKUP function with unsorted data in Excel
- Excel 2004 for Mac Solution Center
- HOW TO: Use the Excel Lookup Wizard (Lookup.xla) in Excel 2000
- The VLOOKUP and HLOOKUP functions fail to find a number in a list in ...
- How to find data in an Excel table
- XL: Unexpected Results with Mixed Text and Numbers in Lookup Table
- XL: Using the Lookup Wizard for Microsoft Excel (Lookup.xla)
MSDN Blog- Shift-FileIndex
- Clearing up confusion
- How To: Call Java EE Web Service from Silverlight Client
- VSTSDB 2008 GDR July CTP is now available
MSDN Podcasts- Microsoft Office System Webcast Audio: Tips and Tricks for Office 2008 for Mac: Incredible Documents Made Simple (Level 200)
- Momentum Webcast Audio: Assessment and Deployment Best Practices for Windows Vista
- Momentum Webcast Audio: Can Process Improvement and Application Lifecycle Management Really Improve Your Business?
- Momentum Webcast Audio: Moving Forward with Windows Vista SP1
- MSDN Webcast Audio: geekSpeak: Advanced ASP.NET Development with Michele Leroux Bustamante (Level 200)
- MSDN Webcast Audio: geekSpeak: Tame Your Software Dependencies with James Kovacs (Level 200)
- MSDN Webcast Audio: geekSpeak: LINQ Migration Strategies with Jim Wooley (Level 200)
- MSDN Webcast Audio: geekSpeak: All About Team Build 2008 with Steven Borg (Level 200)
- MSDN Webcast Audio: geekSpeak: Inside LINQ to XML with Paul Sheriff (Level 200)
- MSDN Webcast Audio: geekSpeak: SQL Server Compact Edition Tips and Tricks with Jim Wilson (Level 200)
- MSDN Webcast Audio: geekSpeak: WCF Strategies for Windows Mobile with Jim Wilson (Level 200)
- MSDN Webcast Audio: geekSpeak: Asynchronous Programming Demystified with Gerald Walsh (Level 200)
- MSDN Webcast Audio: geekSpeak: Contextual Collaboration Using Unified Communications with George Durzi (Level 200)
- MSDN Webcast Audio: geekSpeak: Connecting Microsoft Silverlight with Pete Brown (Level 200)
- MSDN Webcast Audio: geekSpeak: T-SQL Tips and Tricks in SQL Server 2008 with Andrew Karcher (Level 200)
- MSDN Webcast Audio: geekSpeak: Spatial Data in SQL Server 2008 with Denny Cherry (Level 200)
- MSDN Webcast Audio: geekSpeak: Workflow Services in .NET 3.5 with Jon Flanders (Level 200)
- MSDN Webcast Audio: Demystifying Office Business Applications for the Business Analyst (Level 100)
- MSDN Webcast Audio: Demystifying Office Business Applications for the Developer (Level 200)
- MSDN Webcast Audio: Integrating SAP Software with Microsoft Office Programs and SharePoint Server (Level 300)
New Functions- What's New in the C API for Excel 2007
- Developing Add-ins (XLLs) in Excel 2007
- Language-Specific Properties, Methods, and Functions [Excel 2007 ...
- Excel 2007 XLL SDK API Function Reference
- Programming with the C API in Excel 2007
- New Members and Constants [Excel 2007 Developer Reference]
- Improving Performance in Excel 2007
- Multithreaded Recalculation in Excel 2007
- Creating XLLs and DLLs that Call Back into Excel
- Excel statistical functions: TREND
- Developing Excel 2007 XLLs
- Excel 2007
- Multithreading and Memory Contention in Excel 2007
- Excel statistical functions: GROWTH
- Calling into Excel from the DLL/XLL
- Excel Developer Portal
- Getting Started with the Excel 2007 XLL SDK
- Welcome to the Excel 2007 XLL Software Development Kit
- Description of the AutoRecover functions in Excel
- Differences between the Excel statistical functions STDEVPA and STDEVP
Office Headlines- How Do I: Build State Machine Document Approval Workflows for SharePoint Server 2007 Using Visual Studio 2008
- Sample: Using MAPI to Create Outlook 2007 Items
- Deliver Modular Workflow Functionality in SharePoint Server 2007 (Part 1 of 2)
- Deliver Modular Workflow Functionality in SharePoint Server 2007 (Part 2 of 2)
- Use MAPI to Create Outlook 2007 Items
- Video: Building State Machine Document Approval Workflows for SharePoint Server 2007 Using VS 2008
- Silverlight Web Parts Developed in ASP.NET for MOSS 2007
- How Do I: Build an Expense Report Approval Workflow for SharePoint Server 2007 Using VS 2008
- How Do I: Configure and Deploy Workflows to SharePoint Server 2007 Using a Solution Package
- How Do I: Create Custom Workflow Activities for SharePoint Server 2007 Using Visual Studio 2008
- Video: Building an Expense Report Approval Workflow for SharePoint Server 2007 Using VS 2008
- Video: Configuring and Deploying a Workflow to SharePoint Server 2007 Using a Solution Package
- Video: Creating a Custom Workflow Activity for SharePoint Server 2007 Using Visual Studio 2008
- Use the Visual Studio Tools for the Office System Power Tools Version 1.0.0.0
- Edit Business Data Using Business Data Catalog Actions and InfoPath Forms Services
- Deploy Visual Studio Tools for the Office System 3.0 Solutions for the 2007 Microsoft Office System Using Windows Installer (Part 1 of 2)
- Deploy Visual Studio Tools for the Office System 3.0 Solutions for the 2007 Microsoft Office System Using Windows Installer (Part 2 of 2)
- Introduction to SharePoint Products and Technologies for the Professional .NET Developer
- Book Excerpt: Managing Complex Business Processes with Custom SharePoint Workflow
- Build and Distribute Workflows in SharePoint Products and Technologies for Use in Customer and Partner Environments
PivotTables- Microsoft Excel : PivotTables
- Microsoft Excel
- Microsoft Excel : PivotTables: Calculated Items
- Microsoft Excel : PivotTables – overview of improvements in Excel 12
- Microsoft Excel : PivotTables 11: Key Performance Indicators, Actions ...
- Microsoft Excel : PivotTables V: Context menus
- Microsoft Excel : PivotTables VI: – Sorting and filtering
- Microsoft Excel : PivotTables 9: Great support for SQL Server Analysis ...
- Microsoft Excel : Common Questions Around Excel 2007 OLAP PivotTables
- Microsoft Excel : PivotTables X: Server formatting, translations ...
- Microsoft Excel : PivotTables VIII:
Sumif Functions- XL2000: SUMIF and COUNTIF Functions Return Incorrect Results When Used ...
- COUNTIF/SUMIF Wrong If Cell Has Single Apostrophes
- SUMIF, COUNTIF, COUNTBLANK Return #VALUE! Error
- SUMIF() Function Fails If Sum_Range Contains Links to Text
- XL: Some Worksheet Functions Do Not Allow Array Constants
- XL98: Some Worksheet Functions Do Not Allow Array Constants
- XL98: SUMIF, COUNTIF, COUNTBLANK Return #VALUE! Error
- When to use a SUM(IF()) array formula
- XL98: SUMIF() Function Fails If Sum_Range Contains Links to Text
- XL97: SUMIF, COUNTIF, COUNTBLANK Return #VALUE! Error
- XL2000: Calculating Worksheet with Hidden Data Results in Zeroes
- XL98: Using "Most Recently Used" Category for Functions
- XL2000: Calculation Differences Between the Office Spreadsheet and ...
- HOW TO: Use the "Most Recently Used" Category in the Function Wizard ...
- List of Worksheet Functions Available to Visual Basic [Excel 2007 ...
- Errors Saving File to Earlier Formats
- Using "Most Recently Used" Category in Function Wizard
- XL2000: Errors Saving File to Earlier Formats
- Excel 2004 for Mac Solution Center
- Improving Performance in Excel 2007
Sumproduct- SumProduct Method [Excel 2007 Developer Reference]
- How to calculate weighted averages in Excel 2000
- VBA to replace in sheet SUMPRODUCT function? - MSDN Forums
- Calculating Weighted Averages
- XL98: Calculating Weighted Averages
- Microsoft Excel : Understanding Floating Point Precision, aka
Text Functions- How to change the case of text in Excel
- MACXL: How to Change the Case of Text
- Works: Spreadsheet Functions Imported from Excel 2000 to Works
- HOW TO: Use Functions in Formulas in Excel 2000
- XL97: New A Functions in Microsoft Excel 97
- XL98: New A Functions in Microsoft Excel 98 Macintosh Edition
- How to use A functions in Excel
- XL97: ROW And COLUMN Functions Are Not Recalculated
- Functions Are Not Saved in Lotus 1-2-3 Format
- How to use the left, right, mid, and len functions in Visual Basic for ...
- XL98: Results Do Not Change After Toggling Transition Formula ...
- How to Find Secant, Cosecant, or Cotangent of an Angle
- XL98: Unexpected Results with Mixed Text and Numbers in Lookup Table
- XL97: Results Do Not Change After Toggling Transition Formula ...
- TEXT(MONTH(NOW()),"mmm") Always Returns "Jan"
- XL97: Page Fault Using Formula Containing Boolean Functions
- How to convert text to numbers in Excel 2002 and in Excel 2003
- Function to compute average without high and low values
- Sample macro code to change the case of text in Excel
- Differences between the Excel statistical functions STDEVPA and STDEVP
Vitual Labs- MSDN Virtual Lab: A SharePoint Developer Introduction - Web Parts - C#
- MSDN Virtual Lab: Building InfoPath Forms that run as both Rich Client and Browser Applications
- MSDN Virtual Lab: Creating Workflows for Microsoft Windows SharePoint Services 3.0
- MSDN Virtual Lab: First Look at Microsoft Office 2007
- MSDN Virtual Lab: Getting Started with the Business Data Catalog in Microsoft Office SharePoint Server 2007
- MSDN Virtual Lab: Introducing Content Types for Microsoft Windows SharePoint Services 3.0
- MSDN Virtual Lab: Microsoft Office SharePoint Server 2007 Enterprise Features Administration
- MSDN Virtual Lab: Microsoft Office SharePoint Server 2007 Records Management Deployment and Configuration
- MSDN Virtual Lab: Microsoft Windows SharePoint Services Installation and Configuration
- MSDN Virtual Lab: Microsoft® Office SharePoint® Server 2007 Installation and Configuration
- MSDN Virtual Lab: New Microsoft Office Outlook 2007 Programmability
- MSDN Virtual Lab: Programmatic Manipulation of the Microsoft Office Open XML Formats
- MSDN Virtual Lab: Understanding the 2007 Microsoft Office System User Experience and Interface Design
- MSDN Virtual Lab: Using the Microsoft SQL Server 2005 Data Mining Add-Ins for the 2007 Microsoft Office System
- MSDN Virtual Lab: What's New in Microsoft Office SharePoint Server 2007 Feature Walkthrough
- MSDN Virtual Lab: What's New in Microsoft Windows SharePoint Services 3.0 Feature Walkthrough
- TechNet Labcast On-Demand: Understanding the 2007 Microsoft Office System User Experience and Interface Design
- TechNet Virtual Lab: 2007 Microsoft Office System for Professional Services - Client Acceptance
- TechNet Virtual Lab: 2007 Microsoft Office System for Professional Services - Integrated Workspaces
- TechNet Virtual Lab: 2007 Microsoft Office System for Professional Services - Project Planning and Initiation
|
|
July 20th
|
- Excel & Spreadsheet News
Global Software's Worldwide Channel Partner Team Strengthens with ...
Carolina Newswire (press rele ... [Jul 20th, 2007] (News)
|
|
|
Select a Date:
|
|