How to Change Multiple Tabs in Microsoft Excel
(Elizabeth McMurray) Have you ever made changes to a tab in a Microsoft Excel workbook? If so, perhaps you would like to make changes to multiple tabs at once. There are a few ways you can make changes to multiple Excel tabs and this saves you time from having to edit each tab.
|
Article
|
9/4/2010
|
Understanding Default Insert Date Formatting
(Allen Wyatt) Insert a date into Word, and you are presented with a variety of formats you can choose from for that date. The default option is controlled by the settings you've chosen in Windows, not in Word. This tip explains what is going on with this date formatting.
|
Article
|
9/4/2010
|
Chart Styles in PowerPoint 2010
(Geetesh Bajaj) Long time PowerPoint users will remember the difficulties of charting -- it was so painful, time-consuming, and repetitive a task changing the fills of all the series one after the other -- and if your presentation had more than one chart slide, then you also had to ensure that all charts looked the same.
|
Article
|
9/4/2010
|
Project Server 2010: Copying custom Project site templates across instances
(Brian Smith) Interesting question came in today via the blog on my previous customization topic at http://blogs.msdn.com/b/brismith/archive/2010/03/15/customizing-the-project-site-in-project-server-2010.aspx and thought it worth a broader response, as it wasn’t something I had really thought about…
|
Article
|
9/4/2010
|
Data Analysis with Microsoft Access
(Andrew Comeau) Most of the articles I've written on Microsoft Access have been about designing database applications that are meant for regular use. One of the strengths of Access, however, is its ability to import and link to data from different sources. Excel does this too but with Access you can go on to query and report on the data in ways that Excel doesn't readily provide. This can come in handy as part of an application but it's also useful for quick analysis of new information.
|
Article
|
9/4/2010
|
How to find blank records using Excel's Advanced Filter
(Susan Harkins) A few weeks ago, I showed you how to use And and Or operators with Excel’s Advanced Filter feature. The examples I used searched for literal values, but what if you’re searching for a literal value in one field and/or empty cells in another. You’d still use the And and Or operators in the same way, only the criteria to find blank cells would change.
|
Article
|
9/5/2010
|
New Themes!
(Christopher Maloney) Our friends over on the Microsoft Office 2010 Engineering blog recently announced some great new features in the Excel, Word, and PowerPoint Web Apps. Among the new goodies are some brand new themes that you’ll find in the Select Theme dialog when you create a new presentation on SkyDrive. We’ve also re-organized the gallery in a way that we believe will better suit your needs:
|
Article
|
9/5/2010
|
Outlook’s alternative to Gmail’s Priority Inbox
Google’s Gmail service continues to innovate with the addition of a Priority Inbox feature. This feature (being gradually deployed to all Gmail users) puts ‘important’ emails into a special view above the standard Inbox.
|
Article
|
9/5/2010
|
Vertical alignment of the text in Microsoft Word 2007
(Mike Smith) I created cover page of my document and I want title to be centered vertically.
|
Article
|
9/5/2010
|
MS Access: Set up a text box to display the difference between two dates (display value of 1 if dates are the same) in Access 2003/XP/2000/97
In an Access 2003/XP/2000/97 Form or Report, I'd like to calculate/display the difference between 2 date fields (From_Date and To_Date). I want to display the number of days between 'From_Date' and 'To_Date', and if the dates are the same date, I'd like to display the result as 1.
|
Article
|
9/5/2010
|
Fresh and Engaging PowerPoint Presentations
(Debasis Das) PowerPoint presentations get very boring and uninteresting quite easily unless we pay attention to some basic issues. We need to create slides with a fresh design. Consider graphics, images, and color schemes as they apply to a good design. What remains is to communicating effectively!
|
Article
|
9/6/2010
|
Two-Level Axis Labels
(Allen Wyatt) Need a chart that uses two lines for axis labels? It's easy to do if you know how to set up your data in the worksheet, before creating the chart.
|
Article
|
9/6/2010
|
Project Server 2010: OLAP–where are my Custom Field Dimensions and Measures?
(Brian Smith) This question comes up reasonably frequently – I have added dimensions and measures to my cube but do not see them. Where are they?
|
Article
|
9/6/2010
|
Record Level Security for Access Database
Record Level Security Alternative: Row level data security and tracking can be a daunting task in a Microsoft Access database unless you know our simple tricks to simplify row-level security
|
Article
|
9/6/2010
|
Create forms that users complete in Word
You can create a form in Microsoft Word by starting with a template and adding content controls, including check boxes, text boxes, date pickers, and drop-down lists. Other people can use Word to fill out the form on their computer. In an advanced scenario, any content controls that you add to a form can also be linked to data.
|
Article
|
9/6/2010
|
Quick keyboard shortcuts for the Access Navigation Pane
(Susan Harkins) Opening an object from the new Navigation Pane in Access 2007 and 2010 is easy enough. A double-click opens the object view. To open an object in Design view, right-click it in the Navigation Pane and choose Design View. If the object’s already open, click View in the Views group to switch back and forth between available views.
|
Article
|
9/7/2010
|
PowerPivot VBA Macro Mania!
I’ve got some Excel VBA macros that you may find useful in your work on PowerPivot. Been saving these up for awhile now, and I think there are now enough to warrant a post.
|
Article
|
9/7/2010
|
Add Rank to PivotTable
(Mike Alexander) Sandra asks:
"Any way to add a rank to a pivot table"?
|
Article
|
9/7/2010
|
How to Create PowerPoint Handouts
(Aseem Kishore) Although PowerPoint is electronic slide creation software, printable handouts serve an important role both for the presenter and an audience. In this article, we’ll discuss your options for creating great PowerPoint handouts and purpose behind doing so in the first place.
|
Article
|
9/7/2010
|
Powerpoint 2007 And 2010: Make the Slide Fit The Information
(April) Have you ever put together a PowerPoint presentation where it seems that the slides have way too much unused space on the left and right sides?
|
Article
|
9/7/2010
|
Use OneNote to Make Memorizing Information Easier
(Matthew Guay) Whether you’re just getting started in the new school year or have been out of college for years, most of us have to regularly remember new information and often teach it to others. Here’s a neat way you can use OneNote to help you memorize information with digital flashcards.
|
Article
|
9/7/2010
|
SharePoint: Programmatically Creating InfoPath Form Instance Documents Part 2 of 2
(Phil Harding) Continuing on from part 1 of this 2 part series, we discovered the hows and whys of creating InfoPath form instance documents.
|
Article
|
9/7/2010
|
How do I Learn Access?
(Glenn Lloyd) The question came as a private message, actually phrased, “How can my employee learn Access?” It seems that as part of her duties, the employee was tasked with taking over an Access database created by another employee. Regardless of the circumstances this is an excellent question. Here are some thoughts on the subject.
|
Article
|
9/7/2010
|
Scanning into Word 2007/2010
(Graham Mayor) There have been numerous complaints from new users of Word 2007/2010 that the tool that allows documents to be scanned as images, directly into Word, appears to be missing in this version.
|
Article
|
9/7/2010
|
Turn Off Insert In Word
By default, insert is turned on in Microsoft Word. This means that if you start typing in the middle of a sentence, the text you type is inserted wheree the cursor is and it pushes the rest of the sentence to the right. This is how you’d expect Word to work, so it makes sense that this is the default. However, sometimes you need to turn insert off in Word. And this is where it gets confusing.
|
Article
|
9/7/2010
|
Naming Conventions for MS Access Columns
(Debasis Das) MS Access projects should be done systematically. All the entities used in programming and the database tables need to be named meaningfully. Since MS Access does not impose any discipline, things can become chaotic unless you take care right from start. Follow conventions to avoid problems.
|
Article
|
9/8/2010
|
Selective Undo
(Allen Wyatt) Ever wonder why you can't undo just a single edit you made a few minutes earlier? The short answer is that it could make your document unstable or unusable, as described in this tip.
|
Article
|
9/8/2010
|
Format Chart Legend in PowerPoint 2010
(Geetesh Bajaj) Charts in PowerPoint can be customized by changing the appearance of various chart elements. The legend is also a chart element and typically it is a box or area that codes via color or pattern all the series in a chart. Look at Figure 1 that shows a default chart created in PowerPoint 2010. The legend is the box that captions the series Series 1, Series 2, and Series 3 and identifies them with different colors so that you can follow which series each of the columns in that chart represent.
|
Article
|
9/8/2010
|
Excel VBA: Run Macro on Specific Pivot Tables
(Debra Dalgleish) Last week, I posted Bob Ryan's Excel macro for formatting a pivot table in Classic style. Bob's macro formats the first pivot table indexed on the active sheet.
|
Article
|
9/8/2010
|
How to Create and Edit Sparklines in Excel 2010
(Gilberto J Perera) If you’ve ever tried making sense of a lot of trend data in Excel you’ve usually found that plotting the data using a line chart or bar graph helps you make sense of it all. However what happens when you have more than one data set and all you need is a quick preview? Rather than generating a line chart for each data set or plotting all of the data sets with one chart you can use one Excel’s newest features, a Sparkline. Sparklines are tiny charts in a worksheet cell that provide you with a visual representation of data in a worksheet.
|
Article
|
9/8/2010
|
|
