Resources For IT Professionals
Get this Tag RSS feed
Popular Tags

Browse by Tags

 >  TechNet Articles  >  All Tags  >  excel 2013
Tagged Content List

  • Wiki Page: Power BI Learning Resources

    This article provides links to various resources for Power BI for Office 365. Power BI for Office 365 is a complete self-service BI solution for your data on premises or in the cloud, enabling new data discovery, analysis, and collaboration in Excel and Office 365. The preview of Power BI is available...
    on20 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: PowerPivot troubleshooting: "SQL statement is not valid. There are no columns detected in the statement"

    From Kate Baroni, Senior Database Administrator at Microsoft: "I recently added one column to an existing and working powerpivot model (Excel 2013) and started receiving the error ‘SQL statement is not valid. There are no columns detected in the statement’. The SQL logic already included a statement...
    on19 Sep 2013

  • Wiki Page: Renaming an excel table with imported data

    When you import data from some external location into Excel, you might face issue in renaming the table, as the table name in 'Design' > 'Table Name' might appear to be locked. This is due to the reason, that the data is still connected with its original source, and it you might...
    on31 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: Merubah Lokasi Penyimpanan File Default pada Office 2013 (id-ID)

    Aplikasi Office 2013 terintegrasi secara penuh dengan layanan penyimpanan online dari Microsoft yaitu SkyDrive , sehingga jika Anda hendak menyimpan file atau dokumen yang Anda buat maka lokasi penyimpanan default yang dipilih oleh Office 2013 adalah SkyDrive tersebut. Jika memang semua data...
    on28 Jul 2013

  • Wiki Page: Excel 2013 වෙත හඳුන්වා දී ඇති Flash Fill පහසුකම (si-LK)

    එක්සෙල් වැඩපොතක බොහෝවිට වැඩකරන අතරවාරයේ එක් column එකක ඇති දත්තයක් පදනම් කොටගෙන වෙනත් column එකකට රටාවකට අනුකූලව දත්ත ඇතුළත් කිරීමට ඇතැම්ව්ට සිදුවනු ඇත. උදාහරණයක් ලෙස A නමින් යුත් Column එකෙහි සම්පූර්ණ නාමය ඇතුළත් කොට ඇත්නම් හා D නමින් යුත් Column එක වෙත සම්පූර්ණ නාමය නොව ඉන් කොටසක් පමණක් පිටපත්...
    on9 Jul 2013

  • Wiki Page: Menonaktifkan Tampilan Awal Office 2013 (id-ID)

    Berbeda dengan Microsoft Office versi sebelumnya, beberapa aplikasi utama pada Office 2013 saat pertama kali dijalankan secara default akan menjalankan sebuah tampilan awal yang berisikan template-template pilihan yang disediakan oleh Office. Jika Anda tidak terbiasa dengan tampilan ini dan ingin...
    on28 Jun 2013

  • Wiki Page: Menggunakan Flash Fill Pada Microsoft Excel 2013 (id-ID)

    Bagaimana Menggunakan Flash Fill Microsoft Excel 2013 mempunyai fitur baru yang cukup bermanfaat. Yaitu fasilitas Flash Fill. Fitur ini digunakan untuk mengisi sel pada Excel secara otomatis berdasar pola tertentu dari sel lain. Fitur ini mempermudah pengguna sehingga tidak perlu membuat formula...
    on20 Dec 2012

  • Wiki Page: PowerPivot data model error - "This PivotTable was created in a later version of Excel and can't be updated in this version."

    If you're a data analyst using PowerPivot to create data models in Excel, you might run into the following error if you share workbooks with colleagues who are using earlier versions of Excel. In its entirety, the error reads as: "This PivotTable was created in a later version of Excel...
    on6 Nov 2012
Page 1 of 1 (11 items)
Can't find it? Write it!

Post an Article