» Simultaneous Scrolling
22 hours ago by ExcelTips Daily Nuggets from allen@sharonparq.com
If you have two worksheets displayed at the same time, you might want those worksheets to remain visually “in sync” with each other. Here’s a couple of small macros you can use to scroll the worksheets simultaneously. Read this ExcelTip: Simultaneous Scrolling Microsoft Excel Tips - Learn Excel Faster!

» 5 Rules for Making Better Charts (and one fun chart)
1 day ago by Chandoo.org - Learn Excel & Charting Online from Chandoo
Jeff Weir, an alert reader of this blog points me this chart showcasing voice-over artist's for various Simpson's characters. I am a hard-core Simpon's fan, so I naturally wasted quarter-hour looking at the chart. That is when I realize this chart is not only fun, it also teaches 5 valuable lessons on making better charts. Read the rest of this post to find out the five rules.

» Combine Cells in Excel Without Concatenate
1 day ago by Contextures Blog from Debra Dalgleish
Good news, if you're spelling challenged -- or too lazy to type long words. You can combine cell values in Excel, without using the CONCATENATE function. Keep reading, to learn the easy way to combine cells, and add some fancy formatting to the dates and numbers. Use the & Operator Yes, instead of using CONCATENATE, you [...]

» Dividing Values
1 day ago by ExcelTips Daily Nuggets from allen@sharonparq.com
When working with large numbers, you may need a way to quickly divide a range of those numbers by a specific value. Here’s the absolute fastest way to make the change. Read this ExcelTip: Dividing Values Microsoft Excel Tips - Learn Excel Faster!

» Pages to Print
1 day ago by Daily Dose of Excel from Dick Kusleika
In Microsoft Word’s print dialog, there’s a textbox called Pages. In it, you can specify which pages you want to print by separating individual pages and page ranges by a comma. I have a small app wherein I enter a starting serial number and an ending serial number. The output is [...]

» Introducing Excel Wedding Planner
2 days ago by Chandoo.org - Learn Excel & Charting Online from Chandoo
About a month ago, I got an email from Kevin. The crux of this email is, I am working on a wedding planner based in Excel. Do you want to collaborate? I replied to him asking for more details as I got curious about the project. Kevin sent me a work-in-progress version of his wedding planner which blew my mind. Although I have only one wedding experience and even that I hardly planned (as it is tra ...

» Sort Data by Cell Color in Excel 2007
2 days ago by About.com Spreadsheets
In addition to sorting by date, Excel's sort feature can also be used to sort data by cell color. If you have used conditional formatting to change the cell color of data that meets certain criteria then sorting by cell color allows you to group such data together. Doing so often makes it easier to find specific information or to spot trends in a large table of data. ...Read Full Post

» Getting Rid of the Office Assistant
2 days ago by ExcelTips Daily Nuggets from allen@sharonparq.com
How to rid yourself of the Office Assistant. Read this ExcelTip: Getting Rid of the Office Assistant Microsoft Excel Tips - Learn Excel Faster!

» Good Row Bad Row
3 days ago by Daily Dose of Excel from Rob van Gelder
In the office, I sometimes deal with a table of values. In that table, there are good rows, and bad rows. I want to quickly put the good rows to the top of the table, and leave the bad rows at the bottom of the table. So I take the first unused column, give it a rubbish [...]

» Building a Layout for Project Evaluation Model +amp; Best Practices [Part 2 of 6]
3 days ago by Chandoo.org - Learn Excel & Charting Online from Chandoo
In the second part of our tutorial we will learn how to prepare the layout of our model to do project evaluation. If you know basic referencing and formula framework in excel, you can write a model that calculates numbers. Good vs Bad financial model would be decided by the layout of the model. Before we start discussing on how to build a good layout, lets see the layout that I have in mind. ...

See all the latest posts on the Blog Toplist!