Recent Posts

Excel

Count values that meet a condition with the COUNTIF function

Update: See near the bottom of this post for the latest Office how-tos on embedding Excel and PowerPoint files on web pages. You probably know how to use the COUNT function to count cells that contain a value. But what if you want to count only the cells that meet a condition, such as being greater than or equal to a number or date you specify, or that matches text?…

Excel

Get data into Excel by importing it

If you need to get existing data into Excel, I can guarantee you the last thing you’d ever want to do is retype it. And copying from another program or from the web and pasting directly into a cell in a workbook might leave you with nightmarish looking results. Luckily for you, there’s a much better way to get that data into Excel. Importing! Read on to learn about the Excel Text…

Excel

Why not use Excel as your calculator?

By now, you’ve gotten used to using digital calculators, such as the one in Windows or in your phone, and you know their limitations. For example, say you want to calculate mortgage interest or your grade point average — help! This is when you can switch to Excel, a vast improvement over a simple calculator. In this post, Gary Willoughby introduces you to the concept of using Excel to do simple…

Excel

Your call: What would you like us to post about on the Excel blog?

We know you’re pressed for time, and you want what you read to be worth the effort. Our question to you is this: What kind of blog post about Excel works best for you? Do great tips help you work smarter? Maybe code examples unlock your creative side? Or do guest posts from Excel MVPs hit home? Take this poll, and be heard. 

Excel

College students learn about SkyDrive and embedding workbooks

Last month on a visit with business students at the University of Washington, everyone’s ears perked up when I led them in a hands-on exercise that showed how you can work on a spreadsheet in your web browser without having Excel installed on your computer….in fact, multiple people could  work on the same file at the same time! We were working in the Excel Web App in a file stored on SkyDrive on Live.com.  Here’s…

Excel

Easy budget management with Excel

In today’s economy, smart money management is a necessary skill. Whether managing the family budget, planning college expenses, or budgeting for your upcoming wedding, Microsoft Excel can help you track the latest numbers, even while on the go with Excel Mobile 2010 on your Windows Phone 7 or the Excel Web App. Keep reading to learn more about managing your budget in Excel. This is post #8 in the Ten…

Excel

Make your data pop with conditional formatting

You’ve got your numbers wrangled and organized just right, but they still don’t jump out at the people who look at your worksheet. You want to give them the big picture at a quick glance. This is where conditional formatting can come to your rescue. The embedded worksheet in this post will show you three great examples of conditional formatting. Keep reading to learn more!

Excel

Format column sparkline charts using the date axis and cell merging

Sparkline charts are great, but there may be times they need a little visual massaging to maximize their usefulness. Consider this scenario: You have a system for which you want to track downtime over the course of a year and (fortunately) it had downtime events in only four of twelve months. Here’s how to use and format sparkline charts to show this data effectively.