We’ve noticed some of you searching for help using “$” — a dollar sign. In Excel, a dollar sign can denote a currency format, but it has another common use: indicating absolute cell references in formulas. In this post, we’ll talk a bit about both uses of the dollar sign.
Earlier in the year I worked with Beth Melton, an Excel MVP, to create a super easy and visual gradebook template in Excel 2010. It’s built for teachers with little to no Microsoft Excel experience. In fact, all of the grade calculation formulas are taken care of for you.
Have you ever wanted to add a horizontal or vertical line to your chart to indicate a key value, sales threshold, important date, or the average of your data? Are you looking to impress managers and convince clients with your superb charts?
Ask most of your friends how they’re doing, and they’ll probably tell you how hectic their lives are. You may feel that way too. Sometimes just thinking about balancing work and family can be exhausting. A lot of you use and love Excel at work.
In Excel there are tables and PivotTables. You may wonder why you’d need to create a table when the whole worksheet already looks like one. And you’ve heard about PivotTables and how complex they are.
Sometimes workbooks can be very large and hard to navigate. Only so many tabs fit across the bottom of the screen, and it’s hard to know how long each worksheet is. Excel doesn’t have a built-in way to add a table of contents to a workbook; however, there is a way!
Going, going, gone! Yes, it’s true that the Chart Wizard was removed from the product when we shipped Excel 2007, and we didn’t bring it back in Excel 2010. For those of you upgrading from Excel 97-2003, this may come as a big shock.
Today’s blog post is brought to you by Gary Willoughby. Gary is a writer on Office.com who has created and edited content about Excel, Access, and Project.
This blog post is brought to you by Dan Battagin a Lead Program Manager on the Excel team. OK, so I’m going to talk a bit about a relatively unknown feature in Excel: XML data import.
This week’s post is written by Amy Miller. Amy is a writer for Office.com. For many of us, our kids are now back in school, and the reality of packed lunches, homework assignments, and hectic schedules are a new reality. If you’re a teacher, your life just got extra busy too.
I tell you, I learn new things—sometimes even elementary things, that even typing monkeys already know—about Office programs every day and today I’m offering the newest one. I’m going to make this short and sweet today.
