Resources

3 Resources for

data source and microsoft excel

  • Subscribe to this listing via:
  • RSS
  • Email

BNET Resources

Synchronize Excel Reports With A Single Data Source
The analysts needed to take existing year-end financial reports and summarize, group, and chart the data in various ways to present to their organizations' business decision makers. Data analysts rely on Microsoft Excel to connect to, display, and format data. However, copying and pasting data between cell ranges or between...
Tags: Data Source, Analyst, Microsoft Corp., Microsoft Excel, Microsoft Office, Productivity, Office Suites, Software
White papers
Connect To (Import) External Data
The main benefit of connecting to external data is that you can periodically analyze this data in Microsoft Office Excel without repeatedly copying the data, which is an operation that can be time-consuming and error-prone. After connecting to external data, you can also automatically refresh or update your Excel workbooks...
Tags: Data Source, Microsoft Corp., Microsoft Excel, Microsoft Office, Office Suites, Software
White papers
Refresh External Data In Excel Services
Data in a Microsoft Office Excel workbook that has been displayed in Excel Services can come from two different locations. The data may be stored directly in the workbook, or it may be stored in an external data source, such as in a database or in an Online Analytical Processing...
Tags: Data Source, OLAP, Microsoft Corp., Microsoft Excel, Data Mining, Microsoft Office, Databases, Office Suites, Software, Enterprise Software, Data Management
White papers

Additional Resources

VisiCalc turns 30 and SocialCalc turns 1.0
According to my notebook from 1979, 30 years ago today Dan Fylstra, head of Personal Software, our Bay Area publisher, told me that he had the first production VisiCalc packages in hand. I received mine the next day Saturday delivery. So today, for argument's sake, is the 30th anniversary of...
Tags: Spreadsheet, VisiCalc
News items 2009-10-19
Microsoft's Week: Azure and Office 2010 Show the Cloud Will Dominate
Microsoft rolled out the beta of Office 2010 and other productivity software, and made some key announcements about its Windows Azure cloud platform, during the Professional Developers Conference in Los Angeles this week. Even as Microsoft moves to embrace the cloud, the release of Google Chrome OS to open source...
Tags: Microsoft Windows, Microsoft Office, Microsoft Corp.
News items 2009-11-22
Four Ways To Publish External Data Ranges To The Web
An external data range is data from a separate source, such as a Microsoft Access or SQL Server database, that you've brought into Microsoft Excel. You can format the data in Excel and add formulas in adjacent columns to perform calculations on the data. You can publish an external data...
Tags: Web, Microsoft SQL Server, Microsoft Corp., Microsoft Excel, Channel Management, Microsoft Office, Databases, Enterprise Software, Office Suites, Software, Marketing, Data Management
White papers
Who is a Candidate for Desktop Linux?
I personally do not fall into the group of people that can easily migrate away from Windows, but that doesn't mean you or someone you know can't make the switch. As I said in earlier post last month, the work that I do in my professional life requires that I...
Tags: Linux
News items 2009-10-11
DAQ control, access.(Products & software)
DT Measure Foundry 4.0 integrates the live measurement capabilities of DT Measure Foundry with access to MatLab from The MathWorks and Microsoft Excel for a math processing and post-analysis solution. Users can create complex test and measurement applications that access and control data acquisition functions by...
Tags: The Mathworks Inc.
Research articles 2003-08-01
Inside Google's Android and Apple's iPhone OS as business models
By Prince McLeanPublished: 12:00 PM EST Related AppleInsider articles:Inside Google's Android and Apple's iPhone OS...Droid arrives on Verizon Nov. 6 with Google...Droid arrives on Verizon Nov. 6 with Google...Inside Mac OS X Snow Leopard: Exchange SupportDell's iPhone Killer rejected by carriers as...Google's Android offers a free software alternative to smartphone...
Tags: Apple Inc., Apple iPhone, Google Android
News items 2009-11-10
Learn Handy Microsoft Office Tips with BizHacks Videos
While you're off playing with your kids, watching your TiVo, and taking your dog for walks in the woods, I'm here at Business Hacks headquarters recording video tutorials about how to become more efficient using Microsoft Office. Each three-minute video is packed with handy tips and tricks. But don't take...
Tags: Video, Microsoft Corp., Corporate Communications, Microsoft Office, Microsoft Excel, Marketing, Office Suites, Software, Dave Johnson
Blog posts 2009-06-25
Microsoft Office Master Tips: Quickly Copy, Move, and Fill Cells in Excel
I was watching someone work in Excel recently. She needed to copy into every cell in a 200 cell-long column, and she did it in just about the most time-consuming manner humanly possible, with long trips to the ribbon for the copy and paste buttons. There's a...
Tags: Video, Microsoft Corp., Cell, Microsoft Excel, Microsoft Office, Corporate Communications, Office Suites, Software, Marketing, Dave Johnson
Blog posts 2009-09-04
Use Microsoft Query To Retrieve External Data
You can use Microsoft Query to retrieve data from external sources. By using Microsoft Query to retrieve data from your corporate databases and files, you don't have to retype the data that you want to analyze in Excel. You can also refresh your Excel reports and summaries automatically from the...
Tags: Microsoft Corp., Microsoft Excel, Storage, Databases, Microsoft Office, Office Suites, Software, Hardware, Enterprise Software, Data Management
White papers
Windows 7 Beta 1: Ribbonized For Your Pleasure
The Windows 7 Operating System has improvements over Windows Vista which include more granular tuning of User Account Control UAC security prompts, a reduced memory footprint and improved performance on less powerful systems. But will the "Ribbonization" of the new user interface created by Steven Sinofsky's design team put users...
News items 2009-08-07
Simba Technologies Releases Updated OLE DB for OLAP (ODBO) to XML for Analysis (XMLA) Bridge
Simba Technologies Inc., the industry leader in data connectivity solutions, announced today the release of SimbaO2X Version 2.5. SimbaO2X is the de facto solution for connecting OLE DB for OLAP ODBO applications, such as Microsoft Excel Pivot Tables, to XML for Analysis XMLA data sources from multiple vendors. SimbaO2X is...
Tags: analysis, Microsoft Corp., Microsoft Excel, OLAP, XML
Research articles 2007-03-20
Guy Vs. Guy: The Real Story About Web Apps
Welcome to Guy Vs. Guy! In this new feature, Rick and Dave square off on the business and technology issues of the day. First up: Web apps. Wave of the future, or certain disaster for unwitting enterprises? Rick: This argument is over before it even begins. We're...
Tags: Google Inc., Document, Google Docs, Web Application, Rick, Dave, Cloud Computing, Rick Broida
Blog posts 2009-01-12
Google reveals Chrome operating system as rumours of Google-branded phone spread
The announcement comes as rumours have spread across the internet regarding the release of a Google-branded phone to be introduced next year, which will reportedly run on an updated version of the company's mobile Android operating system. Google vice president of product management Sundar Pichai announced the development of the...
Tags: Google Inc., Operating System, Phone, Rumour
News items 2009-11-19
  • << Previous
  • page 1 of 1
  • Next >>
advertisement
advertisement
Click Here