Resources For IT Professionals
Get this Tag RSS feed
Popular Tags

Browse by Tags

 >  TechNet Articles  >  All Tags  >  Excel
Tagged Content List

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

    Table of Contents Introduction BizTalk Solution Approach What is the best excel API to be used? How to Prepare Excel template file? How to configure the excel processor custom pipeline? Conclusion See Also Introduction As a service provider that we provide a service to multiple customers and channels...
    on20 Sep 2013

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

    Environment SPS 2003 Office 2003 Issue If I click an Excel file in SharePoint, it opens read-only in Excel, as expected. If I use the drop down and choose Edit in Microsoft Office Excel, then the file tries to open in Word instead of Excel - which does not work, of course. If I close...
    on19 Sep 2013

  • Wiki Page: Excel 2013: New Features

    Table of Contents Top features to explore Get started quickly Instant data analysis Fill out an entire column of data in a flash Create the right chart for your data Filter table data by using slicers One workbook, one window New Excel functions Save and share files online Embed worksheet data...
    on19 Sep 2013

  • Wiki Page: SharePoint 2010: Importing Data from an Excel File into a SharePoint List Using PowerShell

    There are several different ways to import data from a spreadsheet into a SharePoint list. Depending on your requirements, you can copy data into SharePoint lists using the DataSheet view, for example. However, there are some circumstances where this won't work (i.e. lack of support for certain...
    on18 Sep 2013

  • Wiki Page: SharePoint 2007: Import and Export Data from a SharePoint Page (Which Is Not a List or Library) to Excel

    To export a data from a page (not Document Library / List) to Excel Open MS Excel 2007 Go to Data Tab Select From Web option Put in the URL with http://URL /_layouts/storman.aspx > Click GO It will display the Storage Space Allocation page in the pop up window...
    on18 Sep 2013

  • Wiki Page: Managing Excel database file size and speed (th-TH)

    ความอ้วนอุ้ยอ้ายที่มาจากตารางฐานข้อมูล ผู้ใช้ Excel ควรลองสร้างแฟ้มที่มีตารางขนาดใหญ่ เพื่อบันทึกค่าลงไปในตารางแล้วจัดเก็บแฟ้มเพื่อตรวจสอบขนาดของแฟ้มว่ามีขนาดแตกต่างกันอย่างไร เริ่มจากกดปุ่ม F5 เพื่อเลือกพื้นที่เซลล์ตั้งแต่ A1:Z10000 (หรือขนาดตารางอื่นๆตามใจ) จากนั้นทดลองพิมพ์เลข 1 แล้วกดปุ่ม Ctrl...
    on16 Sep 2013

  • Wiki Page: VBScript to Read and Update an Excel Spreadsheet with Computer Description from Active Directory

    This article explains how to use a VBScript application to read a single-column Excel spreadsheet containing a list of computers, check that list against Active Directory (AD), and then update the spreadsheet with the corresponding computer's AD Description field, if present. In the event...
    on10 Sep 2013

  • Wiki Page: PowerShell: Generate Real Excel XLSX Files without Excel

    Table of Contents Problem Exploration The Excel XLSX file format .NET classes to create real Excel XLSX file from scratch Anatomy of a minimal Excel XLSX package file Minimal package structure Minimal package parts Required is the main file: [Content_Types].xml Required the document “start part”: workbook...
    on7 Sep 2013

  • Wiki Page: HDInsight Services For Windows

    This article is the main portal for technical information about HDInsight Services for Windows and related Microsoft technologies. It provides a brief overview of Apache Hadoop, as well as information for the HDInsight Services provided by Microsoft for deployment on both Windows and Windows Azure...
    on3 Sep 2013

  • Wiki Page: PowerPivot Overview

    Microsoft’s Analysis Services product team (in the SQL Server division) has developed a new product that provides self-service BI (Business Intelligence) functionality for users of Microsoft Office. This product is generally referred to as PowerPivot , and it consists of both a client-side component...
    on29 Aug 2013

  • Wiki Page: Keys for using new sheet or new workbook for Excel database (th-TH)

    แม้ตารางฐานข้อมูลเป็นข้อมูลส่วนแรกที่ต้องสร้างลงไปในแฟ้มก็ตาม แต่ตารางที่ต้องคิดถึงก่อนคือตารางรายงานว่าต้องการแสดงคำตอบออกมาแบบใดและตารางคำนวณซึ่งต้องหาทางสร้างสูตรคำนวณให้ง่ายและสะดวกในการย้อนกลับมาแก้ไข ดังนั้นจึงต้องออกแบบตารางฐานข้อมูลให้สอดคล้องกับตารางส่วนอื่นๆเพื่อช่วยทำให้ไม่ต้องใช้สูตรยากๆในการด...
    on24 Aug 2013

  • Wiki Page: Truth or Fact in Excel Database (th-TH)

    แม้คนไทยอ่านหนังสือเป็นกันแทบทุกคนแต่พบว่าคนไทยอ่านหนังสือน้อยมาก ในปีหนึ่งอ่านกันไม่กี่บรรทัด เมื่ออยากจะเรียนรู้หรือหาคำตอบที่ตนสงสัย แทนที่จะใช้เวลาค้นคว้าหาหนังสือที่มีเรื่องราวถูกต้องมาอ่าน กลับชอบดูทีวีหรือฟังวิทยุ หรืออ่านข้อความสั้นๆบนมือถือที่เขียนส่งกันมาตามภาษาพูด จนทำให้คนไทยรุ่นใหม่เข...
    on24 Aug 2013

  • Wiki Page: [VIDEO] Inteligencia de Negocios con PowerView (es-ES)

    Este es un video generado por Eduardo Castro MVP en Sql Server. Se presenta las principales herramientas de inteligencias de negocios que Microsoft provee, así como las capacidades de autoservicio de inteligencias de negocio por medio de PowerView y Power Pivot. Puedes consultar más recursos...
    on24 Aug 2013

  • Wiki Page: [VIDEO] Autoservicio de Inteligencia de Negocios SQL Server 2012 (es-ES)

    Este es un video generado por Eduardo Castro MVP en Sql Server. Se presenta las diferentes formas de poder configurar Autoservicio de Inteligencia de negocios en Sql Server 2012 y las principales herramientas que Microsoft provee para su implementación. Puedes consultar más recursos de tecnología...
    on24 Aug 2013

  • Wiki Page: [VIDEO] Minería de datos con SQL 2012 y Excel (es-ES)

    Este es un video generado por Eduardo Castro MVP en Sql Server.Se desarrolla las capacidades que ofrecen Sql Server 2012 y Excel para la implementación de Minería de Datos. Agenda Fundamentos de Minería de datos. Demostración. Serie de Recursos para Minería de Datos. Puedes consultar...
    on24 Aug 2013

  • Wiki Page: SharePoint 2013: How to Export Excel Sheet to SharePoint List

    Table of Contents Introduction Problem Solutions 1. From Excel Sheet 2. Using Import SpreadSheet App Introduction In many organizations the management people in any department use Excel to maintain their records, data, history etc. And nowadays SharePoint based applications are often used to share...
    on16 Aug 2013

  • Wiki Page: SharePoint 2013: Useful Links for Excel Services 2013

    Here are some usefull links for Excel Services 2013 for SharePoint 2013; If you find any other please update it! Excel Services in SharePoint 2013 http://msdn.microsoft.com/en-us/library/jj164076(v=office.15).aspx What's new in Excel Services for developers http...
    on14 Aug 2013

  • Wiki Page: Power View

    This article includes a list of Power View articles on TechNet Wiki: Power View Overview SQL Server Samples Readme Alphabetical List: Demo Transcript: Exploring Self-Service Reporting with SQL Server 2012 Power View Power View Report to Hadoop on Azure Hive Sample Presentation...
    on13 Aug 2013

  • Wiki Page: DAX Resource Center

    Table of Contents You can contribute! Introduction to DAX Microsoft DAX Documentation Most Valuable Resources Samples DAX formulas in measures DAX functions Credits Welcome to the DAX Resource Center Wiki - your one stop shop for all things DAX This Wiki includes articles, whitepapers, videos...
    on13 Aug 2013

  • Wiki Page: SharePoint 2010: Cannot Open Excel Files

    Issue: Users cannot open excel files in SharePoint 2010 from the Library and get an error "This workbook cannot be opened because it is not stored in an Excel Services Application trusted location. To create an Excel Services Application trusted location, contact your system administrator...
    on11 Aug 2013

  • Wiki Page: Analytics for Twitter: Known Issues

    This Wiki article documents some known issues with version 1.3 of Analytics for Twitter. Click here to download the latest version of Analytics for Twitter. Analytics for Twitter is being refreshed for Office 2013. For updates & status please visit the Analytics for Twitter 2013...
    on8 Aug 2013

  • Wiki Page: Connect Microsoft Excel to Windows Azure SQL Database

    If you have existing applications in Microsoft Excel that need access to online data or your users are familiar with Excel, you can connect to Windows Azure SQL Database to populate Excel spreadsheets. This article will go through the step by step instructions for connection Microsoft Excel 2010 to a...
    on7 Aug 2013

  • Wiki Page: Custom Calculations for Invoice & Returns Using a PowerPivot DAX Formula

    This is from the thread in the SQL Server PowerPivot for Excel forum. Table of Contents Problem Description Solution Step 1 Step 2 Step 3 Conclusion Problem Description Here's the sample data: STATUS WEEK SALES CUSTOMER INVOICE W01 $150...
    on6 Aug 2013

  • Wiki Page: Create Excel Report for Visual Studio Ultimate 2010 Edition

    The following are simple steps to create Excel report for 'Visual Studio Ultimate 2010' Edition. (1) Install & Configure SQL Server 2008/2012 (2) Create System DSN by selecting load testing database where you want to store 'result data' (3) Configure 'SQL connection string'...
    on1 Aug 2013

  • Wiki Page: How to Use PowerShell to Export all MPRs into a Gridview (or Excel) for Documentation

    FIM ScriptBox Item Summary This powershell script was designed to query for all MPR's and place them in the Powershell GridView to easily search on things such as Workflows by name. It was designed to easily document existing MPR's and to import them into Excel for Grouping and documentation...
    on1 Aug 2013
Page 1 of 8 (188 items) 12345»
Can't find it? Write it!

Post an Article