You can use your favorite social network to register or link an existing account:
Or use your email address to register without a social network:
Sign in with these social networks:
Or enter your username and password
Forgot your password?
Yes, please link my existing account with for quick, secure access.
No, I would like to create a new account with my profile information.
Lots of Microsoft Excel blogs expect you to know all the ins and outs of PivotTables and formulas, conditional formatting and macros. This blog is for two groups of people: folks who are fairly new to Excel and would like to advance from "newbie" to "intermediate" expertise, and folks who just want the basics.
What does that look like in real life? Maybe you have to use Excel spreadsheets at work to present data to your team, but you don't want to give up your whole lunch hour to learn about some Excel feature that might make your spreadsheet easier to read. After all, you have some tasty leftovers in the fridge for lunch, and the line at the microwave gets long.
Or perhaps you're a whiz at summing numbers and sorting lists in your spreadsheets, but wouldn't mind learning a few new tips and tricks to save some time, like how to quickly clean up that data you just imported.
Oh, and don't forget that guy at the bar listening to his buddies talk about VLOOKUP and thinking to himself, what the heck is that? If that's you, you might want to think about finding some new buddies, but you could also subscribe to this blog to keep up with the patter.
I should note that this blog is also different from the others because it's got four bloggers behind it, not one. I'm Amy Miller, and I write Help content for Excel, along with Gary Willoughby, Frederique Klitgaard, and Anneliese Wirth. We're our own highly functioning, dysfunctional family. Our own mini Brady Bunch, if you will. So, look for the first set of blog posts from all of us over the coming weeks. Here's to our new blog, created just for you!
-- Amy Miller
I am so inexperienced with Excel and need a "dumb" question answered. I am typing a membership list in Excel and want it to print out WITH THE LINES....what do I do to get the lines to print?????
Hi Betty, not a dumb question at all! Check out this article, and see if it answers your question: http://bit.ly/9YADUt
I have problems copying data from one excel spreadsheet to a new spreadsheet. I highlight what I would like to copy and go to right click and past into the new spreadsheet and nothing appears. After a period of time I receive the message "too many different formats". Can someone please tell me what that means and why I cannot copy from one excel spreadhseet to another? Also, why do I keep getting that error message and how do I correct it?
Hi Rick, I did a little looking. According to Microsoft Support, this happens when "more than approximately 4,000 different combinations of cell formats" appear in your workbook. Have you tried copying and pasting just the values (not the formatting)? Here's a link to the Microsoft Support article: support.microsoft.com/.../213904 .
I have a question about Excel. I was shown how to make a cell flash or the border become antimated if it meets certain conditions but have sense forgotten. Could someone please help me with this? Thanks.
can someone help with this question, Im trying to write a formula that if a target is below a certain percentage then take 30% of a value and minus it from that value, however if it is greater than a certain percentage then take 30% of a value and add it to that value.
I want to do a lookup on a range based on multiple criteria... I.E. if "this" and "that" match then return the "other"
Need to find how to do a array lookup where the match could be in column A or B and the return will be column C.
Also is this (blog) taking over for what use to be the user community area, it had alot of good knowlegde/ solutions
Looking forward to it.
Nedd help to share excel work book wchich can be updated simulteniously by many(step by step)
how to share excel work book which can be updated/edited silulteniously by members