Excel and PowerBI sessions at Microsoft Ignite
Here are the sessions https://twitter.com/hashtag/Excel?src=hashExcel and https://twitter.com/hashtag/BI?src=hashBI experts would really like at https://twitter.com/hashtag/MSIgnite?src=hashMSIgnite. https://aka.ms/microsoftbiaka.ms/microsoftbi https://aka.ms/microsoftbi%20Excel Community: Simplifying Spaces and Labels
Hi all, As you may have noticed already, we as the Excel Team have done a bit of "spring/summer cleaning" for the community. We have received feedback that the number of "spaces" was simply too many at nine, so we have pared things down. Now, there are three community spaces: Excel: this will be the primary place for posting content, as many of the old spaces have been migrated as labels will find a good home here BI and Data Analysis: this will be a good place for posting about tasks and questions that cut across Excel, Power BI, and other topics in this realm Resources and Community: this will increasingly become a place for folks to share sample files and templates with each other Q: What happened to the other spaces that used to exist? A: They have since been rolled up as "Labels", which you can find in the "More Resources" sidebar under "Labels" of any of the three spaces mentioned above. Look for these on the right side: Please let us know if you have any other questions. Thanks for reading!
Tabs in Excel Online worksheet move unexpectedly
We use a shared Excel Online worksheet that is concurrently accessed by approx. 50 users. The tabs are all named by date and we keep about 3 months of dates available at any time. Periodically, the current date's tab will move for no reason to somewhere random (could be in an earlier or later date tab position). The user's get confused when they are trying to find the current date and have to hunt through all the tabs to find it. We then have to manually drag it back to its correct place in the tab timeline. No one can recreate the problem. Is there a setting we can turn on to activate tab locking? Or has there been a problem reported in the past that a fix exists for? Thanks in advance for your help....Have an Excel question?
Ask the Excel team anything. Get your questions ready for the Excel team! Join our Reddit AMA this Thurs. November 17th at 12pm EST. https://www.reddit.com/r/excel/comments/5aonww/microsoft_excel_product_team_ama_november_17th/ Related Excel Resources: Besides this community we also have a large set of related resources for Excel. From training videos to Hands on labs, from support to feature request. Here are the top links for Excel: Excel Basics Guided Learning: https://support.office.com/en-us/article/Excel-training-9bc05390-e94c-46af-a5b3-d7c22f6990bb?ui=en-US&rs=en-US&ad=US https://support.office.com/en-us/excel https://www.youtube.com/user/officevideos/search?query=excel Excel Intermediate-Advanced Guided Learning: https://www.edx.org/course/introduction-data-analysis-using-excel-microsoft-dat205x-0 at edx.org https://www.edx.org/course/analyzing-visualizing-data-excel-microsoft-dat206x-3 at edx.org https://technet.microsoft.com/en-us/virtuallabs https://vlabs.holsystems.com/vlabs/technet?eng=VLabs&auth=none&src=vlabs&altadd=true&labid=26669&lod=true Hands On Labs https://vlabs.holsystems.com/vlabs/technet?eng=VLabs&auth=none&src=vlabs&altadd=true&labid=26670&lod=true Hands On Labs https://vlabs.holsystems.com/vlabs/technet?eng=VLabs&auth=none&src=vlabs&altadd=true&labid=26671&lod=true Hands On Labs Support Documentation: https://support.office.com/en-us/excel https://support.office.com/en-us/article/What-s-new-in-Excel-2016-for-Windows-5fdb9208-ff33-45b6-9e08-1f5cdb3a6c73 Product and bug support: https://answers.microsoft.com/en-us/msoffice/forum/msoffice_excel Community: Excel Community Request a Feature: https://excel.uservoice.com/ Blog: https://blogs.office.com/excel Demo Files: https://docs.com/ExcelDemos https://products.office.com/en-us/try https://powerbi.microsoft.com/en-us/get-started/ On Demand Excel session from Microsoft Ignite: Excel sessions at Microsoft Ignite 2016
Using a sheet as a dynamic master template for other sheets
We are running multiple experiments and saving the data for each in a seperate sheet. However these experiments are works in progress and we are continually updating the types of data we capture and the general format of the sheet. It would be ideal to have a master sheet that serves as a template and will update the other sheets without otherwise disturbing their seperate data. This seems like a reasonably general scenario, so I am hopeful it has a sane solution; but other approaches to achieve the same capability are welcome. Thanks in advance, JohnCombine data from 2 columns into 1 column
I want to do this, but with 2 columns of data. We have a sheet with area codes in one field and phone numbers in another. I need the 2 pieces of data in one field for a list of 500 phone numbers. Do I have to do them one at a time???? Combine data with the Ampersand symbol (&) Select the cell where you want to put the combined data. Type = and select the first cell you want to combine. Type & and use quotation marks with a space enclosed. Select the next cell you want to combine and press enter. An example formula might be =A2&" "&B2.
