Introduction

This article lists the existing TechNet Wiki articles and references about Microsoft Excel.

If you find a good TechNet Wiki article about Excel, please feel free to add it to this article.

↑ Return to Top

Versions

Excel 2013

• Excel 2013: New Features
• Power Pivot in Excel 2013: Troubleshooting - Problems When Reloading and Reading Data

Excel Services

• Excel Services Issue in SharePoint 2013/2010
• Error communicating with Excel Services Application - Event IDs 5231, 5239, 5240 
• Unable to Download Excel Services Chart
• SharePoint 2013: Useful Links for Excel Services 2013

Excel 2003

• Excel 2003 Files Trying to Open in Word 2003 When Using SharePoint 2003

↑ Return to Top

General Articles

• Excel: Import tables from web
• Power Pivot Overview
• Wiki: 
  • How To Import an Microsoft Excel Spreadsheet Into a Wiki Article
  • Wiki: How to Add and Format Tables in TechNet Wiki
  • Wiki: How to Paste a Table from Microsoft Excel into TechNet Wiki
• Best Practices for Using the HPC Macros to Run Excel Workbooks on a Cluster
• Windows HPC and Microsoft Excel: Resources for Building Cluster-Ready Workbooks
• Best Practices for Using the HPC Macros to Run Excel Workbooks on a Cluster
• Sparklines: Excel Trick To Easily Spot Trends In Your Dataset
• EXCEL: You know how to use the "INDEX"?
• Excel: Can you use the "IF"?
• EXCEL: You know what it is and how to use the "Data Validation"?
• How to filter a report using a list of comma-separated strings
• EXCEL: How to stand out in a table, automatically, the highest and lowest values?
• Excel - You know how to use "Form Controls"?

↑ Return to Top

Business Intelligence Articles

Power BI:

• Power BI

Power Pivot:

• Power Pivot Overview
• PowerPivot: Install the PowerPivot Add-In for Excel
• PowerPivot Help
• Power Pivot in Excel 2013: Troubleshooting - Problems When Reloading and Reading Data
• DAX Resource Center
• Power BI: DAX: Operator Reference
• Connect Excel PowerPivot to Hive on Azure via HiveODBC
• Query Power Pivot DMVs with VBA
• PowerPivot: Import Data from a SQL Server Database (Video)
• Use PowerPivot to Access Hive on Windows Azure (video)
• PowerPivot: Create a PivotChart from PowerPivot Data (video)
• How to Connect Excel PowerPivot to Hive on Azure via HiveODBC
• PowerPivot and Azure on Cloud 
• PowerPivot Error: "You are attempting to access PowerPivot data that was added using a newer version of PowerPivot"
• How to Use the SQL Server Data Mining Add-ins with PowerPivot for Excel
• PowerPivot: Grouping By Dates (Months, Quarters, Years, etc.) in PivotTables
• Custom Calculations for Invoice & Returns Using a PowerPivot DAX Formula
• PowerPivot: Import Linked Data from Excel (video)

Power Query:

• Power Query
• Power Query: Tell Your Story from Your Facebook Data
• A Practical Example of How to Apply Power Query Data Transformations to Structured and Unstructured 
• Power Query: Supported Data Sources
• Quick Ramp-up with Data Explorer for Excel

Power View:

• Power View
• Power View Overview
• Demo Transcript: Exploring Self-Service Reporting with SQL Server 2012 Power View
• Power View Report to Hadoop on Azure Hive Sample
• Presentation Transcript: Exploring SQL Server 2012 Power View
• Set Up a VM Test Server for Power View and PowerPivot
• SQL Server 2012 with Power View for Multidimensional Models
• Tutorial: Configure Tabular Model Reporting Properties for Power View
• Understanding Multidimensional Model Objects in Power View  
• Calendar Analytics for PowerPivot: Known Issues 2

Power Map:

• Power Map

MDX:

• Custom MDX Query for Excel Filters
• Populate Excel Table with Custom MDX Query & PivotTable Filters

SSIS:

• SSIS: Excel 2007
• SSIS: How to Use Dynamic Excel Files with Dynamic Sheet Names

SSRS:

• SSRS 2008 R2 Atom Data Feeds for PowerPivot

Analytics for Twitter:

• Analytics for Twitter 2013
• Analytics for Twitter: Known Issues

Other:

• Analytics for Facebook 2013
• Analytics for LinkedIn 2013

↑ Return to Top

Developer Articles

ASP.NET MVC:

• ASP.NET MVC5 - AngularJS, Create XLS file using ExcelPackage
• ASP.NET MVC: Upload & Read Excel File

VBA:

• VBA & VBS Portal
• VBScript to Read and Update an Excel Spreadsheet with Computer Description from Active Directory
• Automating a Data Paging using VBA on Excel
• Is RecordCount property is always returning -1 for your RecordSet Object?

PowerShell:

• PowerShell: Generate Real Excel XLSX Files without Excel
• How to Use PowerShell to Export all MPRs into a Gridview (or Excel) for Documentation
• Analyze Twitter data with Hive in Azure HDInsight
• Comparing File Names in a directory with the list in Excel File
• Create Excel Report for Visual Studio Ultimate 2010 Edition

↑ Return to Top

Troubleshooting Articles

• Excel Services Issue in SharePoint 2013/2010
• Error communicating with Excel Services Application - Event IDs 5231, 5239, 5240 
• Power Pivot in Excel 2013: Troubleshooting - Problems When Reloading and Reading Data
• Excel Troubleshooting: “Excel cannot complete this task with available resources"
• Excel cannot connect to the SharePoint list
• Unable to Download Excel Services Chart
• Cannot open the excel files in SharePoint 
• SharePoint 2010: Cannot Open Excel Files
• Get data from SQL server using VSTO into Excel
• Excel 2003 Files Trying to Open in Word 2003 When Using SharePoint 2003
• Excel File Opens with “Unable to Load Workbook” in Browser

↑ Return to Top

Technology Related Articles

SharePoint

• Export to excel in SharePoint - Change list/view or Point to another list/view
• SharePoint 2010: How to Import an Excel Sheet to a New SharePoint List
• Excel Services Issue in SharePoint 2013/2010
• Excel cannot connect to the SharePoint list
• Cannot open the excel files in SharePoint   
• SharePoint 2013: Useful Links for Excel Services 2013
• SharePoint 2007: Import and Export Data from a SharePoint Page (Which Is Not a List or Library) to Excel
• SharePoint 2013: How to Export Excel Sheet to SharePoint List
• SharePoint 2010: Cannot Open Excel Files
• Excel 2003 Files Trying to Open in Word 2003 When Using SharePoint 2003
• SharePoint 2010: Import Data from Excel into a List using PowerShell
• SharePoint 2010: How to Export SharePoint List to Excel Sheet as Records and Charts
• SharePoint 2010: How to Get Trusted File Location for Excel Files to Work with XLS Files

Azure:

• Analyze Twitter data with Hive in Azure HDInsight
• Connect Excel PowerPivot to Hive on Azure via HiveODBC
• Connect Microsoft Excel to Windows Azure SQL Database
• How to Connect Excel to Hadoop on Azure via HiveODBC
• How to Connect Excel PowerPivot to Hive on Azure via HiveODBC
• Use Excel Hive Add-in to Access Hive on Windows Azure (video)
• Use PowerPivot to Access Hive on Windows Azure (video)
• PowerPivot and Azure on Cloud

BizTalk Server:

• BizTalk Server: Receive and Send Excel Files from Existing Templates

Active Directory:

• VBScript to Read and Update an Excel Spreadsheet with Computer Description from Active Directory
• Extract Members of an AD Group to Excel

Outlook:

• Import contacts to Outlook via excel & vCard

SQL Server: 

• Importing an Excel Spreadsheet into a SQL Server Database
• Connect Microsoft Excel to Windows Azure SQL Database
• How to Use the SQL Server Data Mining Add-ins with PowerPivot for Excel
• PowerPivot: Import Data from a SQL Server Database (Video)
• Get data from SQL server using VSTO into Excel

↑ Return to Top

See Also

Read suggested related topics:

• Portal of TechNet Wiki Portals
• VBA & VBS Portal

↑ Return to Top