Mar 16
How To Use Slicers To Edit PivotTable Data in Microsoft Excel Tutorial
Microsoft Excel 2010 – Using slicers to filter PivotTable data
Slicers are visual controls that let you quickly filter data in a PivotTable in an interactive, intuitive way. If you insert a slicer, you can use buttons to quickly segment and filter the data to display just what you need. In addition, when you apply more than one filter to your PivotTable, you no longer have to open a list to see which filters are applied to the data. Instead, it is shown there on the screen in the slicer. You can make slicers match your workbook formatting and easily reuse them in other PivotTables, PivotCharts, and cube functions. Mar 15
How To Use SparkLines to Show Data Trends in Microsoft Excel 2010 Tutorial
Excel 2010: Using sparklines to show data trends
New in Microsoft Excel 2010, a sparkline is a tiny chart in a worksheet cell that provides a visual representation of data. Use sparklines to show trends in a series of values, such as seasonal increases or decreases, economic cycles, or to highlight maximum and minimum values. Mar 13
Microsoft Visual Studio 11 – Join the Beta
If you are in the business of application development, you are no doubt already familiar with the purpose and functions of the Microsoft Visual Studio software. For those of you who are just being introduced to the application, however, Microsoft Visual Studio is a compiled set of development utilities and other technologies that aid developers in building powerful, high-quality applications.
Mar 08
Create Visually Compelling Workbooks in Excel 2010
Mar 02
12 Time-Saving Tips in Microsoft Excel 2010
Excel 2010 – 12 Time Saving Tips
1. Add content or formatting to multiple sheets at once
You can add content or apply formatting to two or more of the sheets on a multisheet worksheet by “grouping” the sheets together. When you group multiple sheets, any content or formatting that you add to one sheet also gets added to all the other sheets, so you can add a row of headers to one sheet and have it automatically appear on all the sheets that are grouped together with it. To group all the sheets in a worksheet, right-click on any of the tabs in the lower left of the window, and click Select All Sheets. If you only want to select two or more individual sheets, hold down the Ctrl key and click on the tabs of the sheets that you want to format or edit at the same time. When two or more sheets are grouped, Excel adds the word “[Group]” (in square brackets) after the sheet’s name in the title bar. Mar 02
How to Set Up a New Email in Microsoft Outlook Tutorial
Outlook 2010 – Create New Email Account
Microsoft Outlook 2010 supports Microsoft Exchange, POP3 and IMAP accounts. Your Internet service provider (ISP) or email administrator can give you the configuration information that you must have to set up your email account in Outlook.Email accounts are contained in a profile. A profile is made up of accounts, data files and settings that specify where your email messages are saved. A new profile is created automatically when you run Outlook for the first time.
Mar 01
How to Create a Database in Microsoft Access 2010 Tutorial
How to Create a Database in Microsoft Access 2010
This is a basic tutorial on how to create a new database in Microsoft Access 2010. By the end of this tutorial, you would have learned how to create a complete and simple relational database with tables and relationships. Feb 29
How to Create and Publish a Web Database in Microsoft Access Tutorial
How to Create and Publish a Web Database in Microsoft Access 2010
Microsoft Access 2010 offers many new features and improvements. The improved integration with SharePoint Server 2010 via Access Services allows for Access 2010 databases to be published to SharePoint, which enables multiple users to interact with the database application from any standards-compliant Web browser.This tutorial shows how to create an Access 2010 Web database, publish the database to SharePoint Server 2010, and use the new Web interface to work with the database solution via the Web browser.